Create a MySQL sync cluster

Create a cluster

Control panel

1. In the Control panel, from the top menu, click Products and select Managed Databases.

2. Click Create cluster.

3. Enter the cluster name.

4. Select a location. Once created, the location cannot be changed.

5. Select DBMS — MySQL.

6. Select the version MySQL sync 8. You will not be able to change the version after creation.

7. Select the configuration line and specify the number of vCPUs, RAM size, and disk size.

   After creating the cluster, you can change the node configuration to scale the cluster.

8. Optional: to configure cluster fault tolerance, in the Fault Tolerance block, specify the number of nodes in the cluster. The first node is the master node, and the others are replicas. For a multi-node cluster, the SLA applies — we guarantee 99.95% write availability and 99.99% read availability.

9. Optional: to access cluster logs, enable logging. Logging consumes some of the cluster's computing resources.

   10.1. Check the Collect technical cluster logs to the log service checkbox.

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

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

10. Select or create a subnet:

    • a private subnet — a subnet without internet access. You can connect a static public IP address;
    • or a public subnet — all addresses in the public subnet are accessible from the internet.

    Addresses are assigned to each node in the cluster. Ensure that the number of addresses in the subnet is not less than the number of nodes in the cluster. If you plan to increase the number of replicas after creating the cluster, choose a subnet that has a reserve of free addresses. The subnet cannot be changed after the cluster is created.

    You can limit the list of addresses from which access to the database cluster will be allowed.

11. Optional: in a private subnet, you can connect a public IP address to a cluster node:

    • if you selected an existing private subnet — select the Public access to cluster nodes checkbox, and then the checkbox for the node to which you want to grant public access. The private subnet must meet the requirements;
    • if you are creating a new private subnet — connect a public IP address after creating the cluster.

12. Optional: 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. With traffic filtering disabled, all traffic will be allowed.

13. Optional: to view default DBMS settings or change them, click Edit. We recommend changing setting values only when necessary — incorrectly chosen values can reduce cluster performance.

14. Check the cluster price.

15. Click Create cluster. The cluster will be ready for use when it enters the ACTIVE status.

Terraform

Use the Create MySQL sync cluster guide in the Terraform documentation.

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.