Forum Discussion
NimbostratusDatabase issue with load balancing
We have a commercial mysql database server system setup with replication and automatic failover.
The issue is, there is a tool that is being used to collect form data from a web page and place it into the mysql backend. This tool is not sophisticated enough to see two database servers in a traditional F5 load balanced configuration. It ends up with data on server1 when connection goes there, and different data on server2 when a connection goes there. This is unacceptable to the business area as they want all data in one database. (sigh)
My question is:
Is there a way to put the two mysql servers in a pool serviced by a VIP, but have only one server available.
Config would be:
mysqlp1 - available mysqlmaster
mysqlp2 - unavailable mysqlslave
If mysqlp1 server goes down, the mysql failover is automatic, but I need to turn on the second box in F5 automatically too.
Is there a script or iRule or something I am missing that can achieve this?
Thank you in advance 🙂
Robert
3 Replies
Kevin_Davies_40Nacreous
In the pool, set the priority for the primary server pool member to 10. The priority for the second to 5. Then turn on priority group activation and set to less than 1. All traffic will go to the primary unless it is down.
Robert_Dio_1391Thanks for the quick reply. We will test this configuration and see what happens
Also enable Manual Resume on the pool if you want the primary to stay down until someone logs into the BIG-IP to manually enable the member again (or does it via iControl or tmsh). Most DBAs want to bring the primary online so they can bring it back into sync before it takes traffic.
