在ab 结构的基础上，在做b2的时候，
1、
b2 的配置文件中加上
erver_id = 3
relay_log = /var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-bin.index
重启b2的mysql服务
2、
在a 上给b2创建一个用户
mysql>GRANT replication slave ON *.* TO 'kyo'@'%' identified by '123';
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
3、
在b2上删除原有的数据库，重启服务
cd /var/lib/mysql
rm -fr *
service mysqld restart
4、将b1的数据导入b2
b1:
mysqldump -A -x > /tmp/full.sql
scp /tmp/full.sql root@salveip:/tmp/
b2:
mysql < /tmp/full.sql
5、查看a的at值
mysql>show master status;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| binlog.000003 | 295 | | |
6、给b2上开启slave
mysql> change master to master_host='192.168.18.81', master_port=3306, master_user='kyo', master_password='123', master_log_file='binlog.000003',master_log_pos=295;
mysql> start slave;
7、查看b2 上的slave的状态
mysql> show slave status \G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
