Forum Discussion
Load Balancing Method Recommendations for MySQL?
Generally speaking, it's usually not a good idea to simply load balance SQL services. Assuming they're all storing the same data, you'll run into issues with replication if you're writing to different DBs frequently. You might want to consider setting up the servers in a priority group configuration. Give each server node a different priority value. The highest priority group will receive all requests until it fails, moving to the next priority group, and so on. You also want to put a decent monitor on the servers so that the LTM actually knows when a service has failed.
Recent Discussions
Related Content
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com