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, [Read more...]