Explanation of new features of MySQL5.6 synchronous Replication

After 5.5 semi-synchronous replication, 5.6 has optimized and improved it. Two of them are important: 1. It should be a big pleasure for O & M personnel, after the master-slave switchover, you need to find

After 5.5 semi-synchronous replication, 5.6 has optimized and improved it. Two of them are important: 1. It should be a big pleasure for O & M personnel, after the master-slave switchover, you need to find

Log-bin = mysql-bin

Binlog_format = row

Log_slave_updates

Gtid-mode = ON

Disable-gtid-unsafe-statements = ON

Note: For Hong Kong servers after MySQL5.6.10, the disable-gtid-unsafe-statements parameter is changed to enforce-gtid-consistency = ON

This article is from the blog "hechun's technical column". The server space must be retained.

, Hong Kong Space