Hi all,
I am using mysql-cluster 7.0.9 for testing.
There are two SQL nodes, two Data nodes and one management node in my
mysql-cluster. And the mysql-cluster is deployed on Solaris 10 sparc
system.
I want to implement load balance for mysql-cluster.
I read the Manual of MySQL-Proxy, I find it can used to implement load
balance and failover.
I use the version 0.8.0 of mysql-proxy for testing. I install it on
Solaris 10 sparc, and the host IP is 192.168.0.1. This proxy connects to
two SQL nodes in the mysql-cluster. Their IPs of SQL nodes are
192.168.0.2 and 192.168.0.3.
I first start both SQL nodes, and start a test case program working with
jdbc connection pool.
During testing, I find mysql-proxy can implement load balance, and each
SQL node deals with almost half of all the SQL requests.
Then I shutdown one SQL node 192.168.0.2, and all the SQL requests are
sent to the other SQL node 192.168.0.3. It means the function of
failover are OK.
The problem is, if I restart the SQL node 192.168.0.2, the SQL node
192.168.0.3 still deals with all the SQL request, and no SQL requests
are sent to SQL node 192.168.0.2.
Why? Can I solve this problem by configure certain configuration item.
Or it is just a bug of mysql-proxy. I googled on the Internet, but
didn't get any help.
I expect your help.
Thanks,
Peter
