|
ws in set (0.00 sec)
[read_query] 192.168.1.11:57893
current backend = 0
client default db = larrydb
client username = larry
query = select * from user
sending to backend : 192.168.1.18:3306
is_slave : false
server default db: larrydb
server username : larry
in_trans : false
in_calc_found : false
COM_QUERY : true
serv08主服务器查看数据，可以查询到，说明主服务器可以写
mysql> select * from larrydb.user;
+------+----------+
| id | name |
+------+----------+
| 1 | larrywen |
| 2 | wentasy |
| 5 | test |
+------+----------+
3 rows in set (0.00 sec)
serv09从服务器查询数据，发现不可查询到，说明从服务器只读
mysql> mysql> select * from larrydb.user;
+------+----------+
| id | name |
+------+----------+
| 1 | larrywen |
| 2 | wentasy |
| 3 | jsutdb |
| 4 | db |
+------+----------+
4 rows in set (0.00 sec)
第十一步，开启slave。发现数据同步成功。
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from larrydb.user;
+------+----------+
| id | name |
+------+----------+
| 1 | larrywen |
| 2 | wentasy |
| 3 | jsutdb |
| 4 | db |
| 5 | test |
+------+----------+
5 rows in set (0.00 sec)
|