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问题,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。