alex's blog

Scaling-out OLTP load on Amazon EC2 revisited.

It's been long known that Galera optimistic replication and enterprise-size databases are a match made in heaven. Today we're going to get a little closer to testing this statement.

Wating For The Miracle

in

A short discussion with Baron at Henrik's blog has stirred my eloquence.

Baron points to a great post by Josh Berkus where Josh contemplates the database clustering issues from a novel viewpoint. The post is really insightful. But I'm going to top that (albeit not so skilfully).

Just watch me now

in

So, when I posted new benchmarks about intercontinental synchronous replication performance, I kinda was not sure if that 6000 km disaster recovery scenario was not blown out of proportions.

Synchronous Replication Loves You Again

So, the other day I posted the performance benchmarks for the multi-master MariaDB/Galera cluster. Spectacular performance. But some of you may justifiably say:

Multi-Master Arithmetics

The time has come. People keep on asking why there is a practical limit on the number of nodes in multi-master cluster and what is it exactly. So here's some no-nonsense hardcore multi-master math

Synchronous Replication Loves You

Dedicated to Fernando Pedone and other modest and courageous researchers whose work made this possible.

Sysbench Synchrones Transatlantiques

To C or not to C

in

One of the pitch lines of the Drizzle project in their rewriting of MySQL code is to rely on standard libraries and make it a full blown C++ project, implying that there's no reason to hold back.

When we started Galera we explicitly decided to do it in C. We didn't have a confidence that libstdc++ was mature enough and expected to have all sorts of problems with it.

Parallel Processing in Production Environment

in

Bank restaurant that I have visited today and believe to be one of the largest restaurants (seat-wise) in Helsinki had elevated customer self-service to unparalleled (or rather super-paralleled) heights. The single mutex (cashiers) is locked only once and only to pay for food and grab fork and knife. The rest of IO (choosing and loading food) was totally asynchronous and evenly distributed between serving tables.

SysBench on EC2: Size Matters

It been sometime since we benchmarked MySQL/Galera with sysbench, using it mostly for testing. Our recent visit to Percona Performance Conference showed that sysbench is probably most widely used tool for MySQL benchmarking in the community and besides it is the only benchmark I know that correctly measures response times. So I just gave it a shot with our 0.6 release.

Percona Performance AAR

in

So we've been there.

In my opinion the conference was a great success. Our presentation was not, but that's another story. Percona really showed what conferencing is about. Don't know about MySQL. It was behind the closed doors. Valiant guardians strictly watched that you didn't overhear a word of Sacred Knowledge. Hell, even to get to the Expo hall you had to pay $25 (that's right, you had to pay for watching advertisement) and surrender information about your private life, like your phone number and how you learned about the Expo.

Syndicate content