MySQL Cluster and Load Balancing - David Thompson - com.mysql.lists.cluster

2 messages in com.mysql.lists.clusterMySQL Cluster and Load Balancing

From	Sent On	Attachments
David Thompson	25 Apr 2005 06:08
Chad Martin	26 Apr 2005 17:54

Subject:	MySQL Cluster and Load Balancing
From:	David Thompson (dav...@sportev.com)
Date:	04/25/2005 06:08:12 AM
List:	com.mysql.lists.cluster

Hello:

I am running a mysql cluster with MySQL version 4.1.11 on a set of 4 clustered boxes .. which is all running fine.

I would like to load balance the 2 mysqld boxes on a virtual IP address which I have done successfully in that I can connect via mysql client to the virtual IP port 3306 using ldirectord and access either machine and successfully run queries to the ndbd data.

However, the MySQLD servers need to also accept connections from a tomcat cluster running mysql-connector-java-3.1.8 .. and I have not been successful in implementing this.

I am not sure what the problem is because the tomcat cluster can connect to both of the real mysqld servers in the mysql-cluster via port 3306, but when change the connection settings to connect to the virtual IP via 3306 it cannot connect.

And also as I have stated above, I can connect via mysql client to the cluster and run queries... so I am not sure why the mysql-connector-java is having problems.

I greatly appreciate any advice anyone can give.

Cheers,

David