As work on WarpSQL (Shard-Query 3) progresses, it has outgrown MySQL proxy. MySQL proxy is a very useful tool, but it requires LUA scripting, and it is an external daemon that needs to be maintained. The MySQL proxy module for Shard-Query works well, but to make WarpSQL into a real distributed transaction coordinator, moving the proxy logic inside of the server makes more sense.
The main benefit of MySQL proxy is that it allows a script to “inject” queries between the client and server, intercepting the results and possibly sending back new results to the client. I would like similar functionality, but inside of the server.
For example, I would like to implement new SHOW commands, and these commands do not need to be implemented as actual MySQL SHOW commands under the covers.
For example, for this blog post I made a new example command called “SHOW PASSWORD”
…[Read more]