Forum Discussion

Robert_Dio_1391's avatar
Robert_Dio_1391
Icon for Nimbostratus rankNimbostratus
Jan 21, 2014

Database 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

availability
management

3 Replies

Sort By
  • Kevin_Davies_40's avatar
    Kevin_Davies_40
    Icon for Nacreous rankNacreous
    Jan 21, 2014

    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.

     

  • James_Deucker_2's avatar
    James_Deucker_2
    Historic F5 Account
    Jan 21, 2014

    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.