Currently I’m loading 100 TPCC warehouses in a 2-node galera
cluster that I got up and running in maybe 5 minutes. Kudos
to the Codership guys for making it super easy to download a
single tgz and get evaluating quickly.
Galera, for those not in the know, is a “cluster of mysql
instances”. Unlike MySQL
Cluster, which is really just a storage engine of clustered
data storage nodes. Galera is hacked into both the main
MySQL engine and Innodb (which is the only storage engine it
supports). Galera is fully synchronous, so commits on any
MySQL node are applied everywhere in the cluster, at commit (and
before the client can proceed). Writes are actually
scalable in Galera, to a point, by adding more data nodes because
the replication between nodes is RBR, hence each data node
doesn’t have to assume the CPU expense of processing the SQL …
[Read more]