replicate_do_table=bbp.t_csp replicate_wild_do_table=bbp%.t% replicate-do-ignore-table = mysql.user replicate-wild-ignore-table = mysql.% master--master [root@master ~]# vim /etc/my.cnf server-id = 1 log-bin = mysql-bin binlog-ignore-db = mysql,information_schema sync_binlog = 1 binlog_checksum = none binlog_format = mixed auto-increment-increment = 2 auto-increment-offset = 1 slave-skip-errors = all [root@slave ~]# vim /etc/my.cnf server-id = 2 log-bin = mysql-bin binlog-ignore-db = mysql,information_schema sync_binlog = 1 binlog_checksum = none binlog_format = mixed auto-increment-increment = 2 auto-increment-offset = 2 slave-skip-errors = all