A couple of weeks ago I wrote a lua script to use with the MySQL Proxy
that transforms the Proxy into a key=>value lookup
dictionary.
But I couldn't just stop there. So I decided to add replication
to it :).
The basic idea is that you have one proxy that acts like a
master, it can handle all write/read operations. Once it receives
a write query, it will send that query to the slave proxy
instances, and after the last slave gets the query, the master
will return a confirmation to the mysql client.
And of course, you send your read queries to the slave proxy
instances.
Show me the code.
It is available on the …
Showing entries 1 to 1
May
27
2009
Showing entries 1 to 1