has anyone a working rw-splitting.lua for proxy v0.8.1?

[Pascal Baumgartner]

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.