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 used in the MySQL sync database cluster

Create a cluster

How to create a cluster and MySQL sync databases

Cluster Limitations

MySQL sync cluster limitations with replicas

MySQL sync settings

How to change MySQL sync settings

User Management

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

Connect to a cluster

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

Monitoring cluster, nodes and databases

How to monitor cluster, node and database status, how to export metrics in Prometheus format

View slow query logs

How to view slow cluster database query logs and download them

Backups

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

Scale the cluster

How to change the cluster node 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 the cluster

How to restrict access to the cluster from certain addresses for security

Public IP address

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

Create a network with a dedicated server

How to create a network with 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

MySQL sync is an open source solution for MySQL. Powered by Percona Server for MySQL with XtraDB storage subsystem