Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.
For this I planned to use three bare metal nodes, SSD drives, and a 10Gb network available for in-between nodes communication, but later I also added tests on three bare metal nodes with NVMe drives and 2x10Gb network cards.
To simplify deployment, I created simple ansible scripts.
Load Data
The first initial logical step is to load data into an empty cluster, so let’s do this with our sysbench-tpcc …
[Read more]