然后，同样在MYDB02主机上修改my.cnf文件，在[mysqld]字段中原基础上增加以下内容：

[root@MYDB02 mysql]# vim /etc/my.cnf
[mysqld]
#
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/mysqld.log
pid-file=/usr/local/mysql/logs/mysqld.pid

server-id = 2
log-bin=mysql-bin
relay-log = mysql-relay-bin
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%