MySQL复制全解析 Part 2 一步步搭建基于二进制文件位置的MySQL复制

[mysqld] 
server-id = 11121429
binlog_format = row
log_bin = /datalog/mysql/binlog/mysql-bin.log
expire_logs_days = 14

[mysqld] 
server-id = 11121430
binlog_format = row
log_bin = /datalog/mysql/binlog/mysql-bin.log
expire_logs_days = 14
read_only=1

vim /data/mysql/data/auto.cnf

mysql> CREATE USER 'repl'@'11.12.14.29' IDENTIFIED BY 'rpl'; 
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'11.12.14.29';
mysql> CREATE USER 'repl'@'11.12.14.30' IDENTIFIED BY 'rpl'; 
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'11.12.14.30';
mysql>flush privileges;

mysqldump -S /data/mysql/data/mysql.sock -usystem -p --all-databases --master-data=2 --set-gtid-purged=off > /tmp/dumpmaster.sql

scp /tmp/dumpmaster.sql root@11.12.14.30:/tmp

chown mysql:mysql /tmp/dumpmaster.sql

mysql -S /data/mysql/data/mysql.sock -usystem -p </tmp/dumpmaster.sql

mysql> change master to master_host='11.12.14.29', master_user='repl', master_password='rpl',master_log_file='mysql-bin.000001',master_log_pos= 10843699;


mysql > start slave;

mysql>show slave status\G

mysql>stop slave;
mysql>start slave;

mysql>stop slave sql_thread;
mysql>stop slave io_thread;

mysql>start slave io_thread;
mysql>start slave sql_thread;

mysql>reset slave;