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.
We'll have look at how Galera can scale out Sysbench OLTP complex 60 million rows workload in EC2. This is a first proper benchmark for 0.8 series and also the first benchmark of MariaDB/Galera port, so I'll start modest, just to see how it goes. I chose m1.large instances with 7.8Gb of RAM for server nodes and c1.xlarge instance for a client - I don't want the client to be a bottleneck.
For comparison I have also measured performance of a stock
standalone MariaDB 5.1.55 server. I used the standard my.cnf that
comes with MariaDB Debian package with the following
Galera nodes also add