I've been doing a bit of research, and I would love to use mysql-proxy in production, because
- It supports sockets
- It supports read-write splitting
My other option is to use HAProxy and change all the configuration files to use TCP/IP rather than sockets.
I see that mysql-proxy is STILL in alpha, however there seems to be lots of development on it and it has been around for quite a while.
Can anyone recommend mysql-proxy in production in a high volume environment? Or should I just give up on this idea?