Differences between MySQL sync and MySQL semi-sync

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

	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 with only two replicas	You 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 cluster	Port 6033 is used to connect to ProxySQL	Port 3306 is used to connect to the cluster