Skip to main content

Create a MySQL sync cluster

Last update:

Create a cluster

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.

  2. Click Create cluster.

  3. Enter a cluster name.

  4. Select a location. The location cannot be changed after the cluster is created.

  5. Select a DBMS — MySQL sync.

  6. Select a version MySQL sync. The version cannot be changed after the cluster is created.

  7. Fill in the blocks:

  8. Check the Managed Database cluster price.

  9. Click Create cluster.

Node configuration

  1. Select a configuration line.

  2. If you selected a line with custom configurations, select the disk type, specify the number of vCPUs, RAM size, and disk size.

  3. If you selected a line with fixed configurations, select a configuration.

After the cluster is created, you can change the node configuration — scale the cluster.

Optional: Fault tolerance

To provide fault tolerance for the cluster, add replicas — full copies of the master node. To do this, specify the number of nodes in the cluster. The first node is the master node, and the others are replicas. Replicas are only available for read operations (SELECT).

For a multi-node cluster, the SLA applies — we guarantee a write availability of 99.95% and a read availability of 99.99%.

Optional: Logging

To have access to cluster logs, enable logging. Logging uses some of the cluster's computing resources.

  1. Check the Collect technical cluster logs to the logging service checkbox.

  2. Select a log group or create a new one.

  3. If you selected a new group, enter its name.

Network

The MySQL sync cluster can be added to a new or existing subnet. A subnet can be:

  1. To add an existing private subnet:

    1.1. In the Subnet field, select an existing subnet. The number of addresses in the selected subnet must be at least the number of nodes in the cluster. The subnet cannot be changed after the cluster is created.

    1.2. Optional: to make cluster nodes accessible from the internet, select the Public access to cluster nodes checkbox, and then the checkbox for the node that you want to provide public access to. The private subnet must meet the requirements. If the subnet does not meet the requirements, you can connect a public IP address after the cluster is created.

  2. To add a new private subnet:

    2.1. In the Subnet field, select New private subnet. The number of addresses in the subnet must be at least the number of nodes in the cluster. The subnet cannot be changed after the cluster is created.

    2.2. Optional: change the subnet CIDR.

    2.3. Optional: change the network in which the subnet will be created — you can select an existing network or create a new one. The network cannot be changed after the cluster is created.

Optional: Security

Select security groups to filter incoming and outgoing cluster traffic.

If the Security block is missing, traffic filtering (port security) is disabled in the cluster network. If traffic filtering is disabled, all traffic will be allowed.

Optional: DBMS settings

To view the default DBMS settings or change them, click Change. We recommend changing setting values only if necessary — incorrectly chosen values can lead to cluster failure or performance degradation.

Create a database

After creating a database, you can grant users access to it.

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Databases tab.
  4. Click Create Database.
  5. Enter a database name.
  6. Click Create.