MySQL 配置一主多从方法

1、确保每台机器mysql正常运行ansible mysql -m shell -a 'ps -ef|grep mysql' -k

3、master上操作CREATE USER 'repl'@'192.168.122.%' IDENTIFIED BY '123456';GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.122.%';FLUSH PRIVILEGES;

5、三台从库上执行change master to master_host='192.168.122.114', master_user='repl', master_password='123456', master_log_file='mysql-bin.000004', master_log_pos=771;

7、三台从库执行show slave status\G;

9、三台从库分别测试show databases;