Forum Discussion
MattB_MA_170307
Apr 30, 2015Nimbostratus
MySQL Write Master iRule
I'm trying to write an iRule to send all INSERT and UPDATE MySQL queries to a single node in a cluster- is this possible? I see that the F5 can be aware of HTTP content and route based off of that:
when HTTP_REQUEST {
if { [HTTP::uri] starts_with "/admin" } {
node 10.1.1.200 8080
} else {
pool HTTP_pool
}
}
Is there something similar for reading streams from TCP connections to non-HTTP traffic?
- samstepCirrocumulus
Hi Matt, Yes, using the MySQL Proxy iRule/iApp...
Check out: https://devcentral.f5.com/articles/f5-friday-load-balancing-mysql-with-f5-big-ip
Hope this helps,
Sam
Recent Discussions
Related Content
DevCentral Quicklinks
* 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
Discover DevCentral Connects