rpalacios_79340
Mar 26, 2010Altostratus
Load Balancing Method
Hello Guys,
I've been presented with an odd request at work. Let me start of by providing some basic description of our environment. We have two datacenters. Our primary DC is here in Santa Ana and our disaster recovery site is in Dallas.
Request:
The request I have to put two mysql servers behind the F5 in both DC's. That is simple enough, right? The catch is that what they would like to do is have the primary mysql server (Santa Ana) get all of the traffic unless it's unavailable and both sites would be configured so that the same mysql server gets all of the traffic from both sites.
I think what they are looking for is multi-site processing. They actually don't want it to do load balance, they want to use it to force both sites to use the same mysql server but still be able to failover if the sql server at one site fails.
Question:
The question I have is besides having 1 member of the mysql pool disabled at each site, is there another way to accomplish this request? iRules?
-rp