mysql replication?

Question

MySQL

How to choose the type of replication, synchronous or asynchronous?

Answer 1

mysql is not capable of full-fledged synchronous replication, there is semi-synchronous replication, read here https://dev.mysql.com/doc/refman/5.7/en/replicatio...

Answer 2

Looking for what you need replication.
The synchronous type will keep the slaves up to date and if the master falls, you can (almost) switch to the slave without losing data.
In the case of the asynchronous type, the data on the slave will not immediately become relevant. Convenient for storing a copy of the data "just in case", but not for scaling.