#创建主从用户dockerexec-it mysql-master \
mysql -uroot -p'Whaty@123'\-e"create user 'slave'@'%' identified by 'whaty1212';"#为主从用户授权dockerexec-it mysql-master \
mysql -uroot -p'Whaty@123'\-e"grant replication slave,replication client on *.* to 'slave'@'%';"#让配置生效dockerexec-it mysql-master \
mysql -uroot -p'Whaty@123'\-e"FLUSH PRIVILEGES;"#检查主库配置dockerexec-it mysql-master \
mysql -uroot -p'Whaty@123'\-e"show master status;"
配置主从-slaver配置
#配置主从复制dockerexec-it mysql-slaver \
mysql -uroot -p'Whaty@123'\-e"change master to master_host='192.168.108.128', master_user='slave', master_password='whaty1212', master_port=3316, master_log_file='mysql-master-bin.000004', master_log_pos=154, master_connect_retry=30;"#开启主从同步dockerexec-it mysql-slaver \
mysql -uroot -p'Whaty@123'\-e"start slave;"#查看主从状态dockerexec-it mysql-slaver \
mysql -uroot -p'Whaty@123'\-e"show slave status \G;"
验证服务
创建数据库
dockerexec-it mysql-master \
mysql -uroot -p'Whaty@123'\-e"create database test;"
查看同步
dockerexec-it mysql-slaver \
mysql -uroot -p'Whaty@123'\-e"show databases;"