Skip to main content

Create a MySQL semi-sync cluster

Create a cluster

  1. In the Control Panel, in the top menu, click Products and select Cloud Databases.

  2. Click Create cluster.

  3. Enter a cluster name.

  4. Select a location. You cannot change the location after the cluster is created.

  5. Select a DBMS — MySQL semi-sync.

  6. Select the MySQL semi-sync version. You cannot change the version 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 creating the cluster, you can change the node configuration — scale the cluster.

Optional: Fault tolerance

To ensure cluster fault tolerance, 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, the rest are replicas. Replicas are read-only (SELECT).

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

Optional: Logging

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

  1. Select the Collect technical cluster logs to log service checkbox.

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

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

Network

A MySQL semi-sync cluster can be connected:

You can create a new subnet or add the cluster to an existing one.

  1. To add a cluster to an existing private subnet:

    1.1. In the Subnet field, select an existing subnet. The number of addresses in the selected subnet must not be less than the number of nodes in the cluster. You cannot change the subnet after the cluster is created.

    1.2. Optional: to make cluster nodes accessible from the internet, in the Public access to cluster nodes section, select the checkbox for the node to which you want to attach a public floating IP address. The Public access to cluster nodes section is available if the private subnet meets the requirements. If the subnet does not meet the requirements, you can attach a public floating IP address after the cluster is created.

  2. To create a new private subnet:

    2.1. In the Subnet field, select New private subnet. The number of addresses in the subnet must not be less than the number of nodes in the cluster. You cannot change the subnet after the cluster is created.

    2.2. Optional: change the subnet CIDR.

    2.3. Optional: change the network where the subnet will be created — you can select an existing network or create a new one. You cannot change the network after creating the cluster.

Optional: Security

Select security groups to filter inbound and outbound cluster traffic.

If the Security section 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 default values of the DBMS settings or edit them, click Edit. We recommend changing setting values only if necessary — incorrectly configured values can lead to cluster failure or degraded performance.

Create a database

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

  1. In the control panel, in the top menu, click Products and select Cloud 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.