Skip to main content
Differences between MySQL sync and MySQL semi-sync
Last update:

Differences between MySQL sync and MySQL semi-sync

RDBMSs are available in cloud databases MySQL sync и MySQL semi-sync. The differences between them are in the table.

MySQL syncMySQL semi-sync
ReplicationMulti-master (synchronous) — all replicas need to receive data to validate the recording

Master-replica (semi-synchronous) — at least one of the replicas must receive data to confirm a record

Fault toleranceYou can create a cluster with no replicas or with only two replicasYou can create a cluster with no replicas, one replica or two replicas
Limitations

Fault-tolerant replica clusters are affected by restrictions

No restrictions
Connecting to a clusterPort 6033 is used to connect to ProxySQLPort 3306 is used to connect to the cluster