实现基于日志点的复制

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;