Differences between MySQL sync and MySQL semi-sync

Managed Databases support MySQL sync and MySQL semi-sync. The table below shows the differences between them.

	MySQL synchronous replication	MySQL semi-synchronous replication
Replication	Multi-master (synchronous) — requires all replicas to receive data for write confirmation	Master-replica (semi-synchronous) — requires at least one replica to receive data for write confirmation
Fault tolerance	You can create a cluster without replicas or with only two replicas	You can create a cluster without replicas, with one, or with two replicas
Limitations	Fault-tolerant clusters with replicas are subject to limitations	No limitations
Connecting to the cluster	Port 6033 is used to connect to ProxySQL	Port 3306 is used to connect to the cluster