- server-id = 1
- log-bin=mysql-bin
- log-slave-updates
- #slave-skip-errors=all
- sync_binlog=1
- auto_increment_increment=2
- auto_increment_offset=1
- replicate_wild_ignore_table=mysql.%
- replicate_wild_ignore_table=test.%
- innodb_file_per_table=1
- binlog_format =mixed
来源: http://www.phpxs.com/code/1008361/