Earlier this month, an announcement about STATEMENT based binary logging would be the default starting with MySQL version 5.1.29. I've always preached that backwards compatibility was key to new releases. In this case, lessons were not learned until close to final GA date.

I would like to point out that for 90% of customer cases, STATEMENT based replication will work fine as advertised. But I'd like to point out some use cases where STATEMENT based replication will be at best spotty (at least it is in 5.1.28).

If you primarily use InnoDB as your storage engine you will want to pay close attention to your transaction isolation level. There is a minimum requirement that READ COMMITED level be used, otherwise statement based replication can not be used.

Partitioning + InnoDB + STATEMENT-based binlog also has its problems. We …

Since the day one when I joined Scribd, I was thinking about the fact that 90+% of our traffic is going to the document view pages, which is a single action in our documents controller. I was wondering how could we improve this action responsiveness and make our users happier.

Few times I was creating a git branches and hacking this action trying to implement some sort of page-level caching to make things faster. But all the time results weren’t as good as I’d like them to be. So, branches were sitting there and waiting for a better idea.

Few months ago my good friend has joined Scribd and we’ve started thinking on this problem together. As the result of our brainstorming we’ve managed to figure out what were the problems preventing us from doing efficient caching: …

Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for:

• Backup of binary logs in real time
• High availability, to switch master load to slave with mirrored binary logs

By request of our friends EngineYard we extracted this patch from Google's patchset and going to include in our next releases. Actually our patch contains features for both MirroredBinlogs and FastMasterPromotion patches, as second provides feature to make slave as master in case of main master failure.

At …

Given that I don’t speak Italian, it may seem a bit strange that I just started an Italian language blog on http://blogs.arno.fi/dolce_vita/:

But I do have a point with my blog. Let me quote Google Translate’s automatic translation of some of my “writings” — deliberately doing so without making any improvements on the automatic translation:

Why this blog?

“Of all the languages that I do not speak, I speak Italian the best.”

This is my motto when it comes to speaking Italian. Moreover, Italy is my favorite …

Ideas welcome!

General idea... base: Delta symbol (with thicker line on right hand side - a delta it's not a regular triangle), plus one or more of the following:

• something depicting deltas: incremental small changes;
• something depicting a river delta: where streams come together before flowing into ocean;
• something depicting community: people working together, participating, communicating.

If you can draw even a little bit, rough scribbles are most welcome! We have a good artist who can turn that into magic. And, you don't have to go with the above... come up with something else suitable!

See also https://bugs.launchpad.net/ourdelta/+bug/284161 where we're tracking this; you will find other suggestions from people, including ideas that have been dismissed for visual or other …

Ideas welcome!

General idea… base: Delta symbol (with thicker line on right hand side - a delta it’s not a regular triangle), plus one or more of the following:

• something depicting deltas: incremental small changes;
• something depicting a river delta: where streams come together before flowing into ocean;
• something depicting community: people working together, participating, communicating.

If you can draw even a little bit, rough scribbles are most welcome! We have a good artist who can turn that into magic. And, you don’t have to go with the above… come up with something else suitable!

See also https://bugs.launchpad.net/ourdelta/+bug/284161 where we’re tracking this; you will find other suggestions from people, including ideas that have been dismissed for visual or other …

After my awful Drunken-Blogging experiment, i’m gonna try to write a real post.

This Thursday, Koke and me attended the MySQL Conference at London. Talks were customer oriented, that’s great for me as I’m used to a developer vision of MySQL, and i’ll have to talk to customers in training sessions.

There was some things that everyone was repeating on every talk. Replication, backup, high availability and sacalbility. I’m sure that I’ll be asked about those things while training.

Another interesting thing to know were the MySQL release plans. It’s supposed that 5.1 will be released at the end of this year, and 6.0 at the end of the next. Falcon will be the new storage engine included in 6.0, it’s …

Yet another release, just days after 4.009. The release is for a fix to dbd_bind_ph(), thanks to bug report and patch from Neil Katin, that was causing a core dump.

The files:

file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.010.tar.gz
size: 125211 bytes
md5: a63c9f73afef70b6c80d899424b003e9

CPAN:

http://search.cpan.org/~capttofu/DBD-mysql-4.010/

Thanks to Neil for this fix!

Whoops, I've gone a little AWOL from the various OSS/Danga/MySQL/Drizzle/etc communities. Well, rest assured I'm down but not out!

I will be attending, and (might? should?) be speaking about DPM and database protocols at the Open SQL Camp in VA mid-november. As well as submitting papers for the next years' round of conferences.

One of my many obsessions is Brian's Drizzle project. Due to time constraints I've been unable to contribute significant code so far, but I did chip in for an awesomely appropriate domain name. Not going to say how much I sent in, but mike was cool enough to front the whole cost, so if you like drizzle please pitch in what you can!

GreenSQL is a database firewall used to protect database from SQL injection attacks. New release fixes a number of critical bugs. We recommend all users to update.

This release includes a number of pre-build packages of popular operating systems.
We supply packages for: CentOS, openSUSE, Fedora, Ubuntu, Debian.

List of changes:
1. Code optimization.
2. A number of risk matrix calculation bugs were fixed.
3. New MySQL patterns added.
4. Minor management bugs fixes.

Together with the new release, we prepared performance test for the new version. You can access the results online here:
http://www.greensql.net/publications/greensql-performance-test

In addition to greensq-fw application we released new version of greensql-console management tool. New version contains a number bug …