MySQL主从复制参考

Linux下实现Mysql的主从复制：https://blog.csdn.net/qq_52061700/article/details/126979017

mysql 主从数据不一致,提示： Slave_SQL_Running: No 的解决方法：https://www.jb51.net/article/180748.htm

MySQL数据库实现主主同步：https://blog.csdn.net/rhn_111/article/details/129764802

相关执行命令：
mysqldump -uroot -p密码 --opt -R 数据库名称> /opt/app/bak.sql; -- 主数据库备份，用来导入从数据库，保证两边数据一致

CREATE USER copyoperator IDENTIFIED WITH 'mysql_native_password'  BY '密码';

GRANT REPLICATION SLAVE ON *.* TO copyoperator;

FLUSH PRIVILEGES;

SHOW MASTER STATUS;

FLUSH TABLE WITH READ LOCK;

UNLOCK TABLES;

change master to master_host='主数据库ip地址',master_user='copyoperator',master_password='密码',master_log_file='mysql-bin.000001',master_log_pos=61391;

end