连接oneproxy成功之后查询表的时候出现报错
ERROR 2103 (HY000): Lost connection to MySQL server during query or no managed connection avaiable!
日志也没报错。管理端口也能进。就是通过连接用户等陆oneproxy执行语句时,出现以下error
Lost connection to MySQL server during query or no managed connection avaiable!
问题描述:
做好oneproxy之后,通过3307端口连入oneproxy mysql -utest -ptest -P3307 -h192.168.91.128
mysql> show databases;
+----------+
| Database |
+----------+
| B |
| A |
+----------+
2 rows in set (0.00 sec)
mysql> use B
mysql> show tables;
ERROR 2103 (HY000): Lost connection to MySQL server during query or no managed connection avaiable!
---或者insert into 也报错
解决方法:
进入oneproxy管理端 mysql -uadmin -h192.168.91.128 -P4041 -pOneProxy
set master '192.168.91.129:3306';
set master '192.168.91.130:3306';
set gaccess A:master-only; ---可以不加
set gaccess B:master-only; ---可以不加
回到oneproxy后台 mysql -utest -ptest -P3307 -h192.168.91.128,测试通过,可以正常查询和操作表。