MHA实现mysql主从数据库手动切换的方法(4)
2015-04-11 00:33 来源: 锦尚中国 点击:
mysql> show slave hosts;
+-----------+------+-------+-----------+--------------------------------------+
| Server_id | Host | Port | Master_id | Slave_UUID |
+-----------+------+-------+-----------+--------------------------------------+
| 1052 | | 63306 | 1025 | e25a3e4a-39c0-11e4-80cb-00259086c4b6 |
+-----------+------+-------+-----------+--------------------------------------+
1 row in set (0.00 sec)
主库10.1.1.231上插入记录
复制代码 代码如下:
mysql> insert into test_slave_002 values(555551111,1,55555,99999,44.11,2222,91919);
Query OK, 1 row affected (0.00 sec)
从库查询记录已经存在
复制代码 代码如下:
