A database in CCX is called a “Data Store” which you have to deploy, set up, 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 clicking, the 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 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
Primary/Replicas. If you have only one active-writer node and have a secondary as your replica, then choose this configuration. It will deploy a Percona Server.
Multi-Primary. If your setup requires to have more than one active-writer node, then choose this configuration. It will deploy Percona XtraDB Cluster
Number of Nodes
Allows you to choose the number of nodes that you want to deploy.
For Primary/Replicas, you can choose from 1 primary node, 1 primary and 1 replica, or 1 primary and 2 replicas.
For MySQL Multi-Primary, you can choose from 1 primary node or 3 multi-primary nodes.
Cloud Service
Currently, CCX supports only Amazon Web Services, Safespring, and Openstack. For more information about supported cloud providers and their supported regions, please go to Cloud Providers. To choose which cloud provider you have subscribed to, 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.
Resources
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.
Tiny, 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 – 80 GiB – 10 TiB
IO1 – 80 GiB – 10 TiB
Network settings
This is the section where you have to define what type of accessibility your database nodes require. Does it have to be located on a private network, or shall be accessed 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.
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
You can only pick one zone available in the region.
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 zone assigned whether it is a single zone or on a multi-zone location.
Shows also the availability zone to which your database nodes shall be located
