使用MySQL Proxy告终读写离别的操作实例(1)(2)
4、下来我们来看试探收获。 我们用几台客户端开启4个连接。 [root@localhost~]#/usr/local/mysql/bin/mysql-ut_girl_user-p123456-P4040-h192.168.0.234-Dt_girl 我这边曾经启用了好
4、下来我们来看试探收获。
我们用几台客户端开启4个连接。
- [root@localhost ~]# /usr/local/mysql/bin/mysql -ut_girl_user -p123456 -P4040 -h192.168.0.234 -Dt_girl
我这边曾经启用了好几个客户端，这里就不贴了，号召和上面的一样。
写数据。
- mysql> insert into t(c_str) values ('wangwang');
- Query OK, 1 row affected (0.01 sec)
- mysql> show processlist;
- +----+-------------+---------------------+--------+---------+------+-------+------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +----+-------------+---------------------+--------+---------+------+-------+------------------+
- | 12 | t_girl_user | 192.168.0.234:44975 | t_girl | Sleep | 28 | | NULL |
- | 13 | t_girl_user | 192.168.0.234:44976 | t_girl | Sleep | 15 | | NULL |
- | 14 | t_girl_user | 192.168.0.234:44977 | t_girl | Sleep | 19 | | NULL |
- | 15 | t_girl_user | 192.168.0.234:44978 | t_girl | Query | 0 | NULL | show processlist |
- +----+-------------+---------------------+--------+---------+------+-------+------------------+
- 4 rows in set (0.00 sec)
- 4 rows in set (0.00 sec)
读数据（目前还是写和读都在B上）
- mysql> select * from t;
- +----+----------+
- | id | c_str |
- +----+----------+
- | 1 | B |
- | 2 | wangwang |
- +----+----------+
- 2 rows in set (0.00 sec)
再添置一个客户端连接。
- 1 row in set (0.00 sec)
- mysql> show processlist;
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- | 2 | system user | | NULL | Connect | 1842 | Has read all relay log; waiting for the slave I/O thread to update it | NULL |
- | 5 | root | localhost | t_girl | Query | 0 | NULL | show processlist |
- | 12 | t_girl_user | 192.168.0.234:44975 | t_girl | Sleep | 446 | | NULL |
- | 13 | t_girl_user | 192.168.0.234:44976 | t_girl | Sleep | 188 | | NULL |
- | 14 | t_girl_user | 192.168.0.234:44977 | t_girl | Sleep | 206 | | NULL |
- | 15 | t_girl_user | 192.168.0.234:44978 | t_girl | Sleep | 203 | | NULL |
- | 16 | t_girl_user | 192.168.0.234:44979 | t_girl | Sleep | 164 | | NULL |
- | 17 | t_girl_user | 192.168.0.234:44980 | t_girl | Sleep | 210 | | NULL |
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- 8 rows in set (0.00 sec)
目前我们来读数据。
- mysql> select * from t;
- +----+-------+
- | id | c_str |
- +----+-------+
- | 1 | C |
- +----+-------+
- 1 row in set (0.00 sec)
这个数据很显明是来自C的。
再插入一条登记
- mysql> insert into t(c_str) values ('wangwei');
- Query OK, 1 row affected (0.00 sec)
- mysql> select * from t;
- +----+-------+
- | id | c_str |
- +----+-------+
- | 1 | C |
- +----+-------+
- 1 row in set (0.00 sec)
C上的数据未曾变，还是未曾数据。
目前跑到B上看看kaibanla.com。
- mysql> show processlist;
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- | 2 | system user | | NULL | Connect | 1842 | Has read all relay log; waiting for the slave I/O thread to update it | NULL |
- | 5 | root | localhost | t_girl | Query | 0 | NULL | show processlist |
- | 12 | t_girl_user | 192.168.0.234:44975 | t_girl | Sleep | 446 | | NULL |
- | 13 | t_girl_user | 192.168.0.234:44976 | t_girl | Sleep | 188 | | NULL |
- | 14 | t_girl_user | 192.168.0.234:44977 | t_girl | Sleep | 206 | | NULL |
- | 15 | t_girl_user | 192.168.0.234:44978 | t_girl | Sleep | 203 | | NULL |
- | 16 | t_girl_user | 192.168.0.234:44979 | t_girl | Sleep | 164 | | NULL |
- | 17 | t_girl_user | 192.168.0.234:44980 | t_girl | Sleep | 210 | | NULL |
- +----+-------------+---------------------+--------+---------+------+-----------------------------------------------------------------------+------------------+
- 8 rows in set (0.00 sec)
- mysql> select * from t;
- +----+----------+
- | id | c_str |
- +----+----------+
- | 1 | B |
- | 2 | wangwang |
- | 3 | wangwei |
- +----+----------+
- 3 rows in set (0.00 sec)
数据已成功插入到B中。
关于使用MySQL Proxy告终读写离别的知识就介绍到这里，希望能对您有所帮助。
精彩图集
精彩文章