mysql8主从复制_mysql8.0.20 部署主从复制

master庫：192.168.1.25

mysql -e "reset master;"

mysql -e "create user repuser@'192.168.1.%' ; grant replication slave on *.* to repuser@'192.168.1.%';"

ALTER USER repuser@'192.168.1.%' IDENTIFIED WITH mysql_native_password BY 'OrcSdk21TbUserUi';FLUSH PRIVILEGES;

mysqldump -uroot -p'rRt&8v7Cx' -B -A -F --set-gtid-purged=OFF --master-data=2 --single-transaction --events|gzip >/opt/test_$(date +%F).sql.gz

slave库1：192.168.1.182

mysql < /opt/test_2020-05-28.sql

mysql -e "CHANGE MASTER TO MASTER_HOST='mysql-redis25',MASTER_PORT=3306,MASTER_USER='repuser',MASTER_PASSWORD='OrcSdk21TbUserUi',MASTER_AUTO_POSITION = 1;start slave;show slave status\G" |grep -i "yes"

slave库2：192.168.1.39

mysql < /opt/test_2020-05-28