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 sync	MySQL semi-sync
Replication	Multi-master (synchronous) — all replicas must receive data to confirm a record	Master-replica (semi-synchronous) — at least one replica must receive data for record confirmation
Fault tolerance	You can create a cluster with no replicas or with only two replicas	You can create a cluster with no replicas, one or two replicas
Limitations	Fault-tolerant clusters with replicas are subject to restrictions	No restrictions
Connecting to the cluster	Port 6033 is used to connect to ProxySQL	Port 3306 is used to connect to the cluster