MYSQL 主从其实配置文件有几个注意的地方
最近看到的英文的,原文:
If you omit server-id (or set it explicitly to its default value of 0), a master refuses connections from all slaves.
大体意思就是如果设置了server-id=0的话,主服务器不会在连接所有的从服务器!

如果用的存储引擎是innodb的话因该设置下面两个字段,英文:
For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should
use innodb_flush_log_at_trx_commit=1 and sync_binlog=1 in the master my.cnf file.

innodb_flush_log_at_trx_commit=1
sync_binlog=1