Re: MySQL_Proxy 0.6.1 lost connection
Posted by:
Tiago Cruz
Date: April 29, 2008 12:48PM
I'm seeing here, and sound like the problem was with variable "min_idle_connections"
I have one backend (master) and one read-only (slave), and after some tests here, I can see that mysql-proxy manage all connections on my master until this number of connection was >= "min_idle_connections".
When "min_idle_connections" on master was beat, so, the mysql-proxy send requests do slave, until the number of connections was <= min_idle_connections, again.
The problem was when "finish" the min_idle_connections on master and on slave... so, the proxy stop to work and begin to refuse my connections, like this error on phpBB3:
================================================================
General Error
SQL ERROR [ mysqli ]
Can't connect to MySQL server on '10.25.0.12' (111) [2003]
An sql error occurred while fetching this page. Please contact an
administrator if this problem persists.
What can I do to fix this?
Thanks
Subject
Views
Written By
Posted
7026
April 29, 2008 09:20AM
Re: MySQL_Proxy 0.6.1 lost connection
3438
April 29, 2008 12:48PM
2856
April 29, 2008 01:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.