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

Differences between MySQL sync and MySQL semi-sync

In cloud databases, MySQL sync and MySQL semi-sync are available. The differences between them are in the table.

MySQL syncMySQL semi-sync
ReplicationMulti-master (synchronous) — all replicas must receive data to validate a record

Master-replica (semi-synchronous) — at least one replica must receive data to validate a record

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

Fault-tolerant clusters with replicas are subject to restrictions

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