mysql-proxy session问题

Auth: Jin

Date: 20140328

问题：

基于openx 的广告系统，将数据从单点，迁移到mmm集群，使用proxy访问

报错如下

MDB2 Error: Array

_doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE MDB2_STATEMENT_mysql_231aaea2d6a8cace7c73797d81dc6ea8 USING @0]
[Native code: 1243]
[Native message: Unknown prepared statement handler (MDB2_STATEMENT_mysql_231aaea2d6a8cace7c73797d81dc6ea8) given to EXECUTE]

: Could not execute statement]
/data/httpd/htdocs/ad/var/debug.log:[Last executed query: EXECUTE MDB2_STATEMENT_mysql_a0846690c52c0e64d42b7421fcd3e983 USING @0]
/data/httpd/htdocs/ad/var/debug.log:[Native message: Unknown prepared statement handler (MDB2_STATEMENT_mysql_a0846690c52c0e64d42b7421fcd3e983) given to EXECUTE]
/data/httpd/htdocs/ad/var/debug.log:Mar 28 04:29:16 +0000 OX [ error] PEAR :: MDB2 Error: Array : _doQuery: [Error message: Could not execute statement]

1、配置指向原来的单点正常

2、配置指向mmm的master正常

3.·判断为通过proxy 产生问题

最开始根据报错提示以为是权限问题，全部权限添加确认一次，还一样

根据报错里面那么串字符，感觉是session

/data/httpd/htdocs/ad/lib/pear/MDB2.ph

问题：session之能保持到一个ip,无法穿插

解决：指向writer的vip

mysql-proxy session问题,布布扣,bubuko.com

mysql-proxy session问题

原文：http://www.cnblogs.com/diege/p/3630467.html