1.基于GIT 主从复制
配置文件变量说明:
log_bin=mysql-bin #开启二进制文件 binlog-do-db=testbin # 需要同步的数据库 binlog-format=ROW gtid-mode=on enforce-gtid-consistency=true log_slave_updates=on [client] port=3306 default-character-set=utf8
传统基于二进制文件复制
change master to MASTER_HOST=‘192.168.1.109‘, master_user=‘testbin‘, master_password=‘testbin‘,master_log_file=‘mysql-bin.000004‘, MASTER_LOG_POS=1668;
基于GTI模式的复制
change master to MASTER_HOST=‘192.168.1.109‘, master_user=‘testbin‘, master_password=‘testbin‘,MASTER_AUTO_POSITION=1;
查询从库状态:
SHOW SLAVE STATUS
用户创建及其权限赋予:
mysql> CREATE USER ‘test‘@‘%‘ IDENTIFIED BY ‘123456‘;
mysql> GRANT REPLICATION SLAVE ON *.* TO ‘test‘@‘%‘;
开启同步:
start slave
停止同步:
stop slave
资料:
https://blog.csdn.net/weixin_28985877/article/details/113424316
https://www.cnblogs.com/polestar/p/5651870.html