Mysql-Proxy: Mysql Steps Up, Again

While it isn’t exactly new news, it was news to me, and it might be news to you, for those who care.

The Mysql dev team has released a new tool called mysql-proxy. While not very interesting sounding and certainly not “sexy” what it does and will do for Mysql may just make larger enterprises step up and realize that this little database system is for real.

So, what’s all the hubbub, bub? mysql-proxy is just that, a proxy system for mysql. Aside from doing crazy things like query re-writing (via the built-in Lua scripting) what’s probably the most interesting feature is the ability to load balance mysql servers.

Real load balancing, not master/slaving, having the slave poll the master’s binary log, this is real load balancing. I’ve written a start/stop script for mysql-proxy that initiates load balancing between n-number of mysql servers, which is available here.

Mysql-proxy is still very new, very experimental and does need some attention, but the primary developer behind this is the same man who wrote lighthttpd, so it’ll get there in due time. Keep an eye out for this.