MySQL Proxy: 0.7.0 released

April 11th, 2009

MySQL Proxy 0.7.0 is finally released:

The full ChangeLog is a bit longer as 0.7.0 was more than a year in the works. To make it short: it is faster, better and more flexible.

Binaries will be release at http://dev.mysql.com/downloads/mysql-proxy/index.html shortly.

For everyone who just wants to update from 0.6.1 to 0.7.0 you should just see a major speed improvement.

  • A bug in the connect()-phase that caused to leave the Naggle-algorithm enabled caused a unneccesary high latency.
  • We also changed the buffering of result-sets to only buffer them if the scripts really ask for them with resultset_is_needed = true, see the examples.

Please keep in mind that 0.7.0 isn't a drop-in replacement for 0.6.1. We changed a few objects inside the lua layer which need some small changes to your Lua scripts:

  • proxy.backends.* is now proxy.global.backends.*
  • proxy.connection.client.address is now proxy.connection.client.src.address full description
  • the resultset is only available in the resultset handler if proxy.queries:append(id, packet, { resultset_is_needed = true })

Our focus for the way to 1.0 will be around threading to remove this scalability bottleneck. A first code-drop is already available at launchpad: threaded-io

Posted by jan Filed in mysql

4 Responses to “MySQL Proxy: 0.7.0 released”

  1. Xaprb Says:
    April 11th, 2009 at 09:41 PM Hooray! This is wonderful work.
  2. ant Says:
    April 12th, 2009 at 01:56 AM Great news! Now, i'm debuging mysql-proxy.rev646 for rw-splitting, it seems that it's not completed... 'set names utf8' has not sent to every backends, which will cause client side unicode encoding error.
  3. till Says:
    April 27th, 2009 at 10:30 AM How come this hasn't been promoted to the official download section yet? Any heads up on the status?
  4. Pedram Says:
    May 8th, 2009 at 07:18 AM Is there an up to date example of read write splitting, that's complete enough to be suitable for actual usage? If so do let me know, 0.70 is the only one that works right with PHP 4, but r/w splits not working as intended seems to still be the case... (has this been addressed or disregarded?) http://blog.mozilla.com/mark/2008/02/25/mysql-proxy-so-promising-but-not-quite-there/ An update would be appreciated...

Sorry, comments are closed for this article.