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

Differences between MySQL sync and MySQL semi-sync

MySQL sync and MySQL semi-sync DBMSs are available in cloud databases. The table below shows the differences between them.

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 only two replicasYou can create a cluster with no replicas, one replica or two replicas
Limitations

Fault-tolerant replica clusters are subject to limitations

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