Forum Discussion

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

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

 

 

iRule:

 

 

http://devcentral.f5.com/wiki/iRules.MySQL-Proxy.ashx

 

 

iApp:

 

 

http://devcentral.f5.com/wiki/iApp....-iApp.ashx

 

 

Blog Post:

 

 

http://devcentral.f5.com/weblogs/rc...irule.aspx

 

 

application delivery
dev
devops
iRules

3 Replies

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

     

     

    Colin
  • david_20671's avatar
    david_20671
    Icon for Nimbostratus rankNimbostratus
    Feb 25, 2012
    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…

     

     

    -david