MySQL主从复制实现基于日志点的复制

实现基于日志点的复制
1：在Master端建立复制用户
2：备份Master端数据，并在Slave端恢复
3：使用Change master命令配置复制


select user,host from msql.user;
create user 'dba'@'192.168.1.%' identified by '123456';
grant replication salve on *.* to 'dba'@'192.168.0.%';
create database dba;
create table t(id int,cq varchar(10),primary key(id));
insert into t(1,'aa'),(2,'bb'),(3,'cc');
 
mysqldump --single-tracsaction --master-data=2 --triggers --routlines --all-databases -uroot -p>all.sql
scp all.sql root@192.168.3.从上复制目录下: /tmp


salve下


mysql -uroot -p < all.sql


mysql -uroot -p登陆从


use dba
change master to master_host='192.168....',master_user='dba',master_password='123456',master_log_file='mysql-bin.00004',master_log_pos=1687;


show slave;


show slave status;


iptables -L


show slave status \G;


select * from replication_applier_status;