Benchmark Results as Fancy Images
I got feedback from "the guys" that my benchmark figures are dull to read and we need fancy diagrams showing how Galera scales. So, I played with gnuplot to get something to begin with.
Here is first an overview of how Galera cluster with 1-4 nodes compares with native MySQL when running different R/W ratio loads. There is a curve for each R/W load test showing how performance against native MySQL changes when cluster size grows

Then, I have individual graphs for each R/W load. Plain MySQL performance is shown as a horizontal line and Galera performance with 1-4 nodes cluster sizes are plotted to show the scaling. The y-axis metrics is transactions/sec.
R/W ratio: 100/0

R/W ratio: 90/10

R/W ratio: 70/30

R/W ratio: 50/50

R/W ratio: 30/70

R/W ratio: 0/100

I'm currently running more benchmarks, .e.g. with vsbes group communication backend and row based replication. I hope, I can publish more results during next week.
In engineering front, the MySQL integraton is now ported to latest MySQL 5.1.26rc release. And, in Galera library, we have several optimizations (triggered by benchmark tests) and new flow control feature, which keeps cluster node progress balanced.
- seppo's blog
- Kirjaudu·tai·rekisteröidy·kirjoittaaksesi kommentteja
