MySQL sync

Differences between MySQL sync and MySQL semi-sync

Differences between MySQL sync and MySQL semi-sync DBMS

Versions and configurations

Available MySQL sync versions, fixed and arbitrary cluster node configurations

Disks

Basic information about the disks that are used in the MySQL sync database cluster

Create a cluster

How to create a MySQL sync cluster and databases

Cluster constraints

MySQL sync cluster constraints with replicas

Settings

How to change MySQL sync settings

Managing users

How to create a user, change their password, configure database access and work with privileges

Connect to a cluster

How to connect to a cluster with or without SSL certificate in console and from different programming languages

Monitoring cluster, nodes and databases

How to monitor cluster, nodes and databases, how to export metrics in Prometheus format

Cluster Logs

How to enable cluster logging, how to get logs and how to disable cluster logging

Backups

Backup schedule, backup retention period and how to restore a cluster from backup

Scale cluster

How to change the node cluster configuration

Cluster fault tolerance

The role of master node and replicas in a cluster, how to change the number of replicas

Configure network access to a cluster

How to determine the list of allowed IP addresses, basic information about security groups in a database cluster and how to assign a security group

Public IP address

How to connect a public IP address to a MySQL sync cluster node

Link a cluster to a dedicated server

How to link a cluster to a dedicated server

Migration to cloud databases

How to migrate MySQL database to cloud databases

Using ALTER TABLE

How to use the pt-online-schema-change utility instead of ALTER TABLE