MySQL Forums
Forum List  »  Router & Proxy

Improved RW-Splitting with routine consideration
Posted by: Van Stokes
Date: October 05, 2011 12:42PM


I don't know if anyone else could use this code but if you can you are welcomed to it.

I modified the stock rw-splitting routine to be a little smarter to consider routines. If routines have a characteristic of READS SQL DATA then a read-only backend will be chosen. We use a lot of procedures that are read only and didn't want those calls to always be forwarded to the master server. I'm not an expert with LUA or MySQL Proxy so I am sure this could be improved.

Options: ReplyQuote

Written By
Improved RW-Splitting with routine consideration
October 05, 2011 12:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.