Forum Discussion
ryanc_76025
Altocumulus
Jan 10, 2012MySQL read/write Proxy
Folks,
Last month, I posted an iRule that will split MySQL reads and writes and direct them to your slave and master servers respectively. Find the relevant links below and feel free to dis...
david_20671
Nimbostratus
Feb 25, 2012This iRule is pretty bad ass. Thanks for posting it. I'm going to dig through it and try new things with it for the next couple weeks. What I need to do, specifically, is split all reads/writes to a master/master configuration based on a unique key in the WHERE clause on every SELECT query and a specific SET on INSERTS and UPDATEs. I basically want to put odd ids on one server, and even ids on the other. If either server goes down, they all need to go to he one that's up. Any help is appreciated. I'll let you know how it goes…
-david
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)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
