MySQL Proxy: 0.7.0 and the way ahead

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 ...
more ...



MySQL Proxy: merging resultsets

From time to time we get the question how to split a query into a several smaller queries and unifying the result-set before we send it back to the client.

As the client only expects to get one result-set, we have to merge the result-sets from the server into one ...

more ...


MySQL Proxy: replicating into memcache

If you use replication with MySQL and memcache at the same time you have the problem to make sure that the memcached and the slave are in sync. If you announce the memcached to mark a entry as dirty and let it update the value from the slave BEFORE it ...

more ...

MySQL Proxy: COMMIT obfuscator

This is an idea I came across at the MySQL UC last week: How many applications handle failing COMMITs correctly ? And how can we test it ?

COMMITs can fail. The most simple case are deadlocks. The sad side of deadlocks is that they only happen under real load when you ...

more ...

MySQL Proxy: rollbacked transactions

If you use a transactional storage engine in MySQL like InnoDB some of your transaction may be terminated by the storage engine because of deadlocks. Sadly it is a bit tricky to see what has led to the deadlock. SHOW ENGINE INNODB STATUS gives only a very minimal look into ...

more ...

MySQL UC: getting started

MySQL UC is coming up in a few days and I already flew in today (friday).

What a lucky day. Not only it is nice and warm today in San Francisco, no, I also got upgrade to Business to could sleep every well in those cozy seats. The 747 was ...

more ...