停S从库MySQL服务
cp -a /data/mysql /tmp
/etc/init.d/mysqld start
tar xczf mysql.tar.gz mysql
把压缩包和my.cnf
传到D库
tar xf mysql.tar.gz -C /data
修改my.cnf
然后启动MySQL
server-id = 2**3306
/etc/init.d/mysqld start
三台D库都这么做,但是要变成级联复制就要在D1上面建立同步账号
GRANT REPLICATION SLAVE ON *.* to replication@'172.30.%' identified by "shiwan1234";
flush privileges;
然后待3D库同步完毕后停掉S主库,然后等3D的Position都相同后:
>stop slave;
在要级联的D库上执行:
CHANGE MASTER TO MASTER_HOST='172.30.249.21', MASTER_USER='replication', MASTER_PASSWORD='shiwan1234',MASTER_LOG_FILE='mysql-bin.000334', MASTER_LOG_POS=478401753;
然后启动S主库,启动3D库:
`start slave`
同步完成