mysql proxy 0.8.2
mysql :5.5.17
测试proxy最大连接设置为2时,3个连接执行SQL,连接共用,连接切换
服务器情况:
mysql server : host vms-005
mysql proxy: host vms-004
配置:
mysql proxy 连接池: min=1 max=2,只设置读写库proxy-backend-addresses,未设置只读slave
database两个:db1 & db2
测试1连接切换:
连接1 & 连接2
1、连接1登录
mysql -h192.168.110.90 -uops -p -Ddb1
MYSQL观察:
mysql> select * from
information_schema.processlist where user='ops';
+--------+------+----------------------+------+---------+------+-------+------+
| ID | USER | HOST | DB | COMMAND | TIME |
STATE | INFO |
+--------+------+----------------------+------+---------+------+-------+------+
| 503433
| ops |
192.168.110.90:54247 | db1
|
Sleep | 3 | | NULL |
+--------+------+----------------------+------+---------+------+-------+------+
1 row in set (0.00 sec)
2、连接2登录
mysql -h192.168.110.90 -P3306 -uops -p -Ddb2
MYSQL观察: 看到连接2把连接1的db修改
mysql> select * from information_schema.processlist where
user='ops';
+--------+------+----------------------+------+---------+------+-------+------+
| ID | USER | HOST | DB | COMMAND | TIME |
STATE | INFO |
+--------+------+----------------------+------+---------+------+-------+------+
| 503441 | ops | 192.168.110.90:54255 | db2 | Sleep | 3
| | NULL |
| 503433 | ops | 192.168.110.90:54247 | db2
| Sleep | 3 | | NULL |
+--------+------+----------------------+------+---