server1: ip:1.1.1.1
server2: ip:1.1.1.2
<1> 修改server1的配置文件vim /etc/my.cnf
[mysqld]
vim /etc/my.cnf
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log_bin=bin_log
server-id=1
#指定binlog记录的库,其他库就不记录了可以用,来分隔指定多个库
binlog-ignore-db = mysql
binlog-ignore-db = performance_schema
binlog-ignore-db = information_schema
binlog-do-db=mobi
replicate-do-db=mobi
replicate-do-table=mobi.test1
# 允许复制主服务的库的哪一张表,需要多张表就要写多行
replicate-do-table=mobi.test2
<2>修改server2的配置文件vim /etc/my.cnf
[mysqld]
vim /etc/my.cnf
datadir=/var/lib/mysql
socket