MySQL semi-sync

Differences between MySQL sync and MySQL semi-sync

Differences between MySQL sync and MySQL semi-sync DBMSs

Versions and configurations

Available MySQL semi-sync, fixed and arbitrary cluster node configurations

Local disks

Features of local disks

Create a cluster

How to create a cluster and MySQL semi-sync databases

MySQL semi-sync settings

How to change MySQL semi-sync settings

User management

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

Connect to the cluster

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

Cluster, node and database monitoring

How to track the status of the cluster, nodes and databases, how to export metrics in Prometheus format

View logs of slow requests

How to view logs of slow queries to cluster databases and download them

Backup

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

Scale the cluster

How to change the configuration of a node cluster

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 purposes

Public IP address

How to connect a public IP address to a MySQL semi-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

MySQL semi-sync is an open source relational database management system that is easy to manage and scale. Suitable for most data handling tasks.