关于mysql-proxy问题

czxin788

最近，我用了mysql-proxy对mysql数据库进行了读写分离，但是发现mysql-prxoy不稳定，每过一天都会发生前端zabbix连接mysql数据库有问题。

我们的架构是zabbix web和mysql数据库。我用一台mysql数据库做为写，两台mysql数据库做为读。


我的mysqld-prxoy是这么连接的：

/usr/local/proxy/libexec/mysql-proxy -P 10.72.23.91:3306 -b 10.72.23.87:3307 -r 10.72.23.88:3307 -r 10.72.23.89:3307 -s /usr/local/proxy/share/doc/mysql-proxy/rw-splitting.lua




     日志报错情况：

Error in query [BEGIN] [Lost connection to MySQL server during query]Error in query [SELECT   t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND (r.groupid BETWEEN '64' AND '74' OR r.groupid IN ('19','20','30','33','47','48','49','52','53','62','82','83','98','99')) WHERE t.triggerid=f.triggerid  AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND t.triggerid='16445' AND t.flags IN ('0','4')] [MySQL server has gone away]Error in query [SELECT   e.* FROM events e WHERE 1=0 AND e.object='0' AND e.source='0' AND e.eventid<='565870' ORDER BY e.clock DESC,e.eventid DESC LIMIT 20 OFFSET 0] [MySQL server has gone away]Error in query [ROLLBACK] [MySQL server has gone away]Error in query [BEGIN] [MySQL server has gone away]Error in query [SELECT   t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND (r.groupid BETWEEN '64' AND '74' OR r.groupid IN ('19','20','30','33','47','48','49','52','53','62','82','83','98','99')) WHERE t.triggerid=f.triggerid  AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND t.triggerid='14310' AND t.flags IN ('0','4')] [MySQL server has gone away]Error in query [SELECT   e.* FROM events e WHERE 1=0 AND e.object='0' AND e.source='0' AND e.eventid<='565858' ORDER BY e.clock DESC,e.eventid DESC LIMIT 20 OFFSET 0] [MySQL server has gone away]Error in query [ROLLBACK] [MySQL server has gone away]Error in query [BEGIN] [MySQL server has gone away]Error in query [SELECT   t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND (r.groupid BETWEEN '64' AND '74' OR r.groupid IN ('19','20','30','33','47','48','49','52','53','62','82','83','98','99')) WHERE t.triggerid=f.triggerid  AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND t.triggerid='18432' AND t.flags IN ('0','4')] [MySQL server has gone away]Error in query [SELECT   e.* FROM events e WHERE 1=0 AND e.object='0' AND e.source='0' AND e.eventid<='565860' ORDER BY e.clock DESC,e.eventid DESC LIMIT 20 OFFSET 0] [MySQL server has gone away]