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

On the way to

MySQL Proxy: replicating into memcache

I have another small side project:

• translating Row based log-records into Statement ones.

Our support team was asking for it since a while and it was a nice PoC that I can decode RBR events nicely.

Running MySQL 5.1 (with ...

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

In the tradition of creative names for MySQL related projects ...

<weigon_> arj... no arjen :(
<dormando> haven't seen him in a few days, huh
<weigon_> http://code.google.com/soc/2008/mysql/appinfo.html?csaid=B0E0C3111A6494AB looked like a proxy job
<weigon_> tokenize the query, replace the constants and rewrite ...

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

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

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

After seeing strange crashes in xmlFreeTextWriter() on only one platform oldag and me dove into wonders of shared linking.

<oldag> just sit right back, and you'll hear a tale
<oldag> a tale of a faitful trip
<oldag> if not for the courage of the fearless crew (oldag and jan ...

After some delay we are proud to present MySQL Proxy 0.6.1.

This is a pure bug-fix release and fixes some assert()oins and the win32 support. It was branched off in December and it took a while to clean up the windows package until it passed the tests ...

In the first article on IP to location I described the overall concept. In this edition we'll look at the implementation and how to scale the tracing to a reasonable speed.

With the examples from the last article you can also implement everything to build your own database. Before ...