mysql_replication - MySQL的复制模式该怎么选？

Question

想给公司的MySQL服务器5.5搭建个备机，跑联机的，没打算优化源码。各位推荐下用什么复制模式比较好？semi-sync、async？哪个用的比较多

Answer 1

Semi-synchronous replication means that after the main library writes the binlog and transfers it to the slave, the return performance will decrease and the consistency will improve.
Asynchronous replication has high performance and poor consistency.
Carry it out according to your scenario.
Generally it is asynchronous. Copy