Load balancing and virtual clusters

Question

Last evening, I spent several hours in the datacenter installing our new load balancer, a CoyotePoint E350GX. I've set up 3 clusters:

nginxCluster

• 10.0.0.10

apacheCluster

• 10.0.0.20

mysqlCluster

• 10.0.0.30

Currently, there's a box in the apacheCluster, with IP 10.0.0.21. From the load balancer, I can ssh to this IP fine. There's also a box in the mysqlCluster, with IP 10.0.0.31. I can ssh to this box from the load balancer as well.

Here's the problem. If I try to connect to mysql from the apache box to the mysqlCluster IP, it fails. However, I can connect to the individual box behind mysqlCluster just fine. Any ideas? More information needed?

Answer 1

It seems that the CoyotePoint is expecting public IPs for the clusters. I haven't had a chance to test it, but that's what the technical support person suggested. I'll update this answer later if this works.