MySQL Forums
Forum List  »  Router & Proxy

has anyone a working rw-splitting.lua for proxy v0.8.1?
Posted by: Pascal Baumgartner
Date: June 07, 2011 07:44AM

where the select statements go to the proxy-read-only-backend-addresses and all other statements like drop database, insert etc. go to the proxy-backend-addresses ?

If someone can answer this with yes I'd love to get the script. let me know.

If nobody has such a lua script it would also be usefull to have a script that catches mysql errors like

ERROR 2013 (HY000): Lost connection to MySQL server during query

instead of returning this error I would like the proxy to resend the query to a backend with state up and then return the result. Like this you could just keep your apps as they are and the proxy could handle problems as long as there is at least one read/write backend available. If proxy can't handle this you need to adjust every single app...

P.S. the mysql servers are Master1/Slave2 and Master2/slave1

Edited 1 time(s). Last edit at 06/07/2011 08:38AM by Pascal Baumgartner.

Options: ReplyQuote

Written By
has anyone a working rw-splitting.lua for proxy v0.8.1?
June 07, 2011 07:44AM

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.