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 sync	MySQL semi-sync
Replication	Multi-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 tolerance	You can create a cluster with no replicas or only two replicas	You 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 cluster	Port 6033 is used to connect to ProxySQL	Port 3306 is used to connect to the cluster