benchmark

Scaling-out OLTP load on Amazon EC2 revisited.

Submitted by alex on April 7, 2011 - 23:10
in

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.

TPC-C like Benchmarks of Galera and Stock MySQL Replication

Submitted by alex on October 18, 2011 - 18:14
in

Vadim Tkachenko of Percona benchmarks Galera versus standalone Percona Server and stock MySQL replication using tpcc-mysql.

More Galera benchmarks

Submitted by alex on August 18, 2011 - 21:11
in

In a series of posts Henrik Ingo explores various aspects of Galera performance, venturing where no one dared before. I think some of the results are record-breaking, some are puzzling, and some give developers good food for thought.

  • Benchmarking Galera disk-bound workload
  • More Galera lessons...

    • A quick look at MySQL/Galera vs. MySQL semi-sync

    Submitted by alex on July 7, 2011 - 17:52
    in

    Erkan Yanar takes a quick look at MySQL/Galera vs. MySQL semi-sync performance:

    Full article here (in German).

    Synchronous Replication Loves You Again

    Submitted by alex on April 9, 2011 - 22:51
    in

    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:

    Synchronous Replication Loves You

    Submitted by alex on January 3, 2010 - 22:46
    in

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

    Sysbench Synchrones Transatlantiques

    SysBench on EC2: Size Matters

    Submitted by alex on May 15, 2009 - 01:04
    in

    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.

    Scaling Drupal stack with Galera: part 2, The Mystery of a Failed Login

    Submitted by alex on April 19, 2009 - 16:31
    in

    This is the second part in in the series of posts about scaling Drupal stack. The first part can be found here.

    GLB has been fixed to support unlimited connections and now I can benchmark Drupal stack cluster on large EC2 instances. What I'm looking for here mainly is how much Galera synchronization overhead affects performance here. With small instances everything was pretty much clear: single core hindered by Xen was an easy traget, and scalability was predictably linear. Large instance is dual core, and Xen interference is minimal, Galera synchronization and serialization effect must be more pronounced. How desperately bad is it?

    Scaling Drupal stack with Galera: part 1

    Submitted by alex on April 11, 2009 - 14:17
    in

    Drupal is a widely used content management system written in PHP that uses SQL server as a storage backend. Although Drupal can work with PostgreSQL, Apache/Drupal/MySQL stack is the usual production configuration.

    A number of strategies were developed to scale Drupal performance through clustering, see excellent series of articles by John Quinn. Naturally all of them were capped by the SQL server component. Perhaps Galera is the "holy grail" of Drupal scaling-out?

    Yes! It works on Amazon EC2(TM): The Return of DBT2

    Submitted by alex on December 24, 2008 - 04:53
    in

    As you might already know, DBT2 is an OLTP benchmark similar (but not equivalent) to venerable TPC-C. A couple of months ago I tried it with Galera on Amazon EC2 to see how Galera performed in a non-LAN environment. It did quite well, especially in high availability regard. Since then Galera saw a whole lot of bugfixes and improvements, so the time has come to try it once again. This time it will be 'large' AWS instances, almost 8 gigs of RAM and two CPU cores, you know, Big Iron or something.

    How would Galera perform in this setup?

    Syndicate content