The MySQL Proxy was split into

• a chassis which handles cmdline, service, logging, plugin loading
• a core library for the life-cycle, network handling and protocol decoding
• a lua layer wrapping around the internals
• a set of plugins: proxy, admin, debug, replicant

It also contains a few tools that reuse the ...

While developing mysql-proxy I sometimes have to step-by-step refactoring that usually result in unstable code for a while until the unit-tests are happy again.

When a unit-test fails I usually use gdb as a wrapper and let it create a stack-trace for me:

$ gdb --command=backtrace.gdb --args /path/to ...

Joining to global effort of keeping chain-letters alive I'll do my every best in answering Jay's meme.

What are the rules ?

• Link your original tagger(s), and list these rules on your blog.
• Share seven facts about yourself in the post - some random, some weird.
• Tag seven people ...

MySQL Proxy didn't got a (public) update for half a year now. But these dry times are over now.

We abonded the svn repo a long time ago and it got tricky to keep our internal repository and the external, public one in sync. The backlog of patches to ...

I was wondering for quite a while if MySQLs C-API (libmysqlclient) can really do async queries and where it is lacking support.

Scanning through the source (sql/client.c) you see:

int mysql_real_query(MYSQL *mysql, const char *query, ulong length)
{

  if (mysql_send_query(mysql,query,length))
    return 1;

  return((int) (*mysql- ...

Inspired by http://blogs.sun.com/thava/entry/dump_mysql_frm_file_header I jumped into http://forge.mysql.com/wiki/MySQL_Internals_File_Formats and tried to write a decoder for the .frm files. Sadly the internals document is missing all the interesting parts.

So it was time to get the hands dirty and get into ...

MySQL Proxy got a bunch of changes in the svn-repo over the last weeks. Most of the important changes are in and we are working on making it a good 0.7.0 release.

The important changes are:

• script cache to improve the proxy performance
• central low-level decoding + lua wrappers ...

I have a somewhat strange relation to parser since a while. Like everyone I started with writing little parsers by hand and bounced several times against yacc and flex failing to get around their very own syntax.

Then I discovered lemon and used it in lighttpd for the configuration and ...

MySQL Proxy is very flexible and can be used for many different use-cases

• Load Balancing
• Failover management
• synchonized Replication
• Caching
• Query Filtering, Rewriting, ...

What shall we implement first, where should our priority ?

Cast you vote at http://dev.mysql.com/tech-resources/quickpolls/

In the next proxy release we introduce plugins, we talked about it already in MySQL Proxy: a chassis and a mysql server. Take a look at http://svn.mysql.com/svnpublic/mysql-proxy/trunk/plugins/ and check out:

• proxy
• admin
• debug

each of them sharing the common code that is provided ...