1.准备从库
2.主库导出数据
|
1 2 3 |
#打点备份注释 [root@db01 ~]# mysqldump -uroot -p123 -A -R --triggers --master-data=2 --single-transaction > /tmp/full2.sql |
3.将数据推送至从库
|
1 2 |
[root@db01 ~]# scp /tmp/full2.sql 172.16.1.53:/tmp |
4.模拟运行的主库数据写入
|
1 2 3 |
mysql> use master; mysql> insert test values(2),(3); |
5.从库导入数据
|
1 2 |
[root@db03 ~]# mysql < /tmp/full2.sql |
6.查看主从的位置点
|
1 2 3 |
[root@db01 ~]# less /tmp/full2.sql CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=520; |
7.从库配置主从复制
|
1 2 3 4 5 6 7 8 |
change master to master_host='172.16.1.51', master_user='rep', master_password='123', master_port=3306, master_log_file='mysql-bin.000008', master_log_pos=120; |