Forum Discussion

ryanc_76025's avatar
Icon for Altocumulus rankAltocumulus
Jan 10, 2012

MySQL read/write Proxy




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 discuss an ask questions here.









Blog Post:



3 Replies

  • Colin_Walker_12's avatar
    Historic F5 Account
    This is indeed some awesome stuff. I think Tech Tip worthy, personally. Adding it to the list to bother Ryan about later. ;)



  • This 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…