A database in CCX is called as “Data Store” for which you have to deploy, setup, and configure in order to use and interface with your application.
To deploy, simply hit Create data store
or hit the Create drop down button as shown below:
After clicked, panel view to choose your desired database as shown below will show up.
Select A Database
In this example, we’re picking up MySQL with supported vendor and version Percona Server 8.0 for replication. Hit Continue to proceed to Configuration as shown below.
Configuration
Configuration: Creating a MySQL 8 datastore [Summary]
Field
Description
Name
The name of this data store. This name can NOT be changed later.
Tags
Specify tags to allow filtering and searching for clusters. Each cluster can have zero or many tags to help keep the clusters organized. Note that special characters like spaces, tabs and dollar signs are not supported.
The created tags can be filtered while looking up the clusters in the CCX dashboard page, by clicking on the magnifier glass icon on the top menu.
Configuration
Multi-Master. If your setup requires to have more than one active-writer nodes, then choose this configuration. It will deploy Percona XtraDB Cluster
Master/Replicas. If you have only one active-writer node and have secondary as your replica, then choose this configuration. It will deploy a Percona Server.
Number of Nodes
Allows you to choose the number of nodes that you wanted to deploy.
For MySQL Multi-Master, you can choose from 1 master node or 3 multi-master nodes.
For Master/Replicas, you can choose from 1 master node or 1 master and 2 replicas
Cloud Service
Currently, CCX supports only Amazon Web Services and Safespring. For more information about supported cloud providers and its supported regions, please go to Cloud Providers. To choose which cloud provider you have subscribed, simply pick the Cloud service provider, then choose the region you would like to deploy your data store. After that, hit Continue.
Cloud Service: Creating a MySQL 8 datastore [Summary]
Field
Description
Cloud service provider
Choose the supported cloud providers.
Regions
Choose a region where you would want the database cluster to be deployed.
Instances
This is the section where you have to determine the resources of your database nodes to be deployed such as CPU, memory, and storage.
Instances: Creating a MySQL 8 datastore [Summary]
Field
Description
Instances
Pick your instance size with predefined CPU and memory.
Small, Medium, and Large are enabled by default
X-Large and 2X-Large are disabled and requires you to contact our Sales.
Storage
Choose the supported volume type for the selected cloud platform.
The volume size. The minimum and maximum database sizes are depending on the volume type.
GP2 – 1 GiB – 16 TiB
IO1 – 4 GiB – 16 TiB
Network settings
This is the section where you have to define what type of accessibility does your database nodes required. Does it have to be located on a private network, or shall be access publicly or open to the world provided your security such as firewall and password are setup.
Network settings: Creating a MySQL 8 datastore [Summary]
Field
Description
Network Type
Choose the networking type:
Private: All nodes will be configured with a private IP address. To connect to the data store, you need to peer with the created VPC. See VPC and VPC Peering.
Public: All instances will be deployed with public IP addresses. Access to the public IP addresses is controlled by a firewall.
Availability zone
Choose the availability zone (AZ) for every node in the cluster.
Single AZ
Allows you to assign and choose one availability zone only for which your database node will be located and deployed
Multi AZ
Allows you to assign and choose up to three availability zones. For which you can designate which AZ your database node shall be located and deployed
Select VPC
Choose the VPC of that particular region. Only available if you choose Private under the Network.
If you do not see the VPC in the drop-down, create a VPC beforehand. See VPC and VPC Peering.
Select a zone
Choose which AZ would you like to assign your database nodes for high availability
For Single AZ, you can only pick one AZ available on the region
For Multi-AZ, you can assign up to three AZ depending on the region you designate your database to be located.
Preview
Before deploying your data store, CCX will give you a preview of your desired selections and options you have configured for your data store. This is the section where it summarizes the value you have assigned to its designated sections before deployment.
Preview: Creating a MySQL 8 datastore [Summary]
Field
Description
Database
The type of database you choose. In this example, we have MySQL 8
Configuration
Summarizes the configuration you have set
Cloud Service
Shows the cloud service provider you choose and to what region your database nodes shall be deployed and located.
Instance
Summarizes the type of resources (CPU, memory, storage) of your database instances to be used for your data store
Network settings
Shows the accessibility of your data store, if it’s private or public.
Shows the kind of availability whether it is only assigned to be single zone or is it on a multi-zone location.
Shows also the availability zone to which your database nodes shall be located
Estimated cost
summarizes the cost for this type of database, setup, and configuration in a monthly basis. This gives you a heads up of what amount it shall cost you before deploying your database.
