mysql> create user 'repl'@'192.168.9.106' identified by 'Repl123!@#';
4. 为 repl 用户赋予 REPLICATION SLAVE 权限。
mysql> grant replication slave on*.* to 'repl'@'192.168.9.106';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'repl'@'%' IDENTIFIED BY 'Repl123!@#' WITH GRANT OPTION;
5. 查看用户
mysql>select user,host from mysql.user;
6.查看 master 状态
mysql> show master status;+------------------+----------+--------------+------------------+-------------------+| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+------------------+----------+--------------+------------------+-------------------+| mysql-bin.000002|154||||+------------------+----------+--------------+------------------+-------------------+1 row inset(0.00 sec)
注意:如果遇到 empty set 1.请检查一下配置是否按照示例中106的配置进行配置 2.重启一下MySQL再看看
mysql -u root -p
输入自己的密码
mysql> change master to master_host='192.168.9.106', master_user='repl',MASTER_PORT =3306,master_password='Repl123!@#',master_log_file='mysql-bin.000002',master_log_pos=154;
注意:
master_log_file 一定要对应 106(主)机器 show master status 中的 File 字段; master_log_pos 一定要对应 106(主)机器 show master status 中的 Position 154
mysql>start slave;
3. 查看状态
mysql> show slave status \G
主要看以下消息有两个YES即可 :
Slave_IO_Running:Yes
Slave_SQL_Running: Yes
mysql> grant replication slave on*.* to 'repl107'@'192.168.9.107';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'repl107'@'%' IDENTIFIED BY 'Repl123!@#' WITH GRANT OPTION;
4.刷新权限 - (192.168.9.107上操作)
Flush privileges;
5.把9.106 设置为9.107的从 - (192.168.9.106上操作)
mysql> change master to master_host='192.168.9.107', master_user='repl107',MASTER_PORT =3306,master_password='Repl123!@#',master_log_file='mysql-bin.000001',master_log_pos=964;
mysql>start slave;
mysql> show slave status \G
主要看以下消息有两个YES即可 :
Slave_IO_Running:Yes
Slave_SQL_Running: Yes