Create connection to another MySQL-Server in Lua

[Johann Reisner]

Hello,

I wonder if it is possible to create another (parallel?) connection to MySQL-erver. What I want:

I've got 3 Servers connected to Mysql-Proxy. If there is an incomming insert/update/delete I want to "lock tables" at servers a and b, process the insert (u/d) to server c, and then "unlock tables" again to servers a and b.

Please do not refer me to "R/W-Script", it doesn't work for this (I think). What I need is something like:

con=connect(server, user, pass)
con.processQuery("SELECT XX")

Is this possible? This should be like a replication over 3 or 4 Servers handled by mysql-proxy.

Oh, I tried a script from a topic like '...query on to servers..', but this only works for 2 servers (not more), because mysql-proxy is not able to manage more than 1 "...query without resultset_needed = false..." (or is there a workaround?)

Thanks a lot....

Hans

Edit: I'm running MySQL-Proxy 0.7.1 on a Karmic-Box (32bit)



Edited 2 time(s). Last edit at 01/23/2010 04:53AM by Johann Reisner.