Forum Discussion
What is the best recommendation of Database Load Balancing?
Hi,
Can you give us more details about your DB solution (oracle, Mysql, ...).
As you know the traffic used for DB can be very conssomateur, in terms of bandwidth. So if you can leave your VS in L4 ( LTM can't natively parse SQL reads and writes to implement more advanced load balancing scenarios ), the traffic does not rise in the layers and it conssome less resource.
The most important is to set a a strong monitor (oracle, PostgresSQL, Mysql, depending your solutions).
Then if you need persistance, in this case you can use "src address" or "UIE persistence" depending of your VS.
Some customer use "Priority Group Activation" and let only one node manage traffic and if an problem occur the other member take over...
YOu have multiple article that talk about this topic:
https://devcentral.f5.com/articles/monitoring-open-source-databases-with-big-ip
https://devcentral.f5.com/questions/mysql-load-balancing-using-ltm
https://www.f5.com/pdf/solution-center/f5-oracle-database.pdf
https://devcentral.f5.com/questions/best-load-balancing-method-to-load-balance-database-servers
let me know if you need more details.
regards,
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