Differences between MySQL sync and MySQL semi-sync

In Managed Databases, MySQL sync and MySQL semi-sync DBMSs are available. The differences between them are in the table.

	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	High-availability 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