wallet01(master)
[root@wallet01 ~]# mysql -uroot -pabcd.1234
mysql> show master status;
+------------------+-----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+-----------+--------------+------------------+
| mysql-bin.000003 | 251166915 | | |
+------------------+-----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> create user monitor@'192.168.1.%' identified by "maxscale";
Query OK, 0 rows affected (0.08 sec)
mysql> grant replication slave, replication client on *.* to monitor@'192.168.1.%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on maxscale_schema.* TO 'monitor'@'192.168.1.%';
Query OK, 0 rows affected (0.02 sec)
mysql> create user router@'192.168.1.%' identified by "maxscale";
Query OK, 0 rows affected (0.00 sec)
mysql> grant select on mysql.user to router@'192.168.130.%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select on mysql.db to router@'192.168.1.%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select on mysql.tables_priv to router@'192.168.1.%';
Query OK, 0 rows affected (0.01 sec)
mysql> grant show databases on *.* to router@'192.168.1.%';
Query OK, 0 rows affected (0.01 sec)
wallet02(slave)
[root@wallet02 ~]# mysql -uroot -pabcd.1234
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.201
Master_User: repl
Master_Port: 3306
&n