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 cluster 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
alterations:
max_connections=1024
innodb_buffer_pool_size=6G
…
Showing entries 1 to 1
Apr
07
2011
Showing entries 1 to 1