When I mention Galera replication as in my previous post on this topic, the most popular question is how does it affect performance.
Of course you may expect performance overhead, as in case with
Galera replication we add some network roundtrip and
certification process. How big is it ? In this post I am trying
to present some data from my benchmarks.
For tests I use tpcc-mysql
, datasize 600W (~60GB)
with buffer pool 52GB. Workload is run under 48 user
connections.
Hardware:
- 1st node: HP ProLiant DL380 G6
- 2nd node: Dell PowerEdge R815
- Both nodes use …