New Feature in Percona XtraDB Cluster 8.0 – Streaming Replication

Percona XtraDB Cluster Streaming ReplicationPercona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.

Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation in how big transactions are handled.

Let’s review the performance under sysbench-tpcc workload when in parallel we update a big update on a table that is even non-related to the tables in the primary workload.

Without Streaming Replication

Let’s run two workloads.

  1. sysbench-tpcc workload with 1 sec resolution
  2. In parallel run UPDATE oltp.sbtest SET k=k+1 LIMIT 1000000

Running update:

Check what is happening in sysbench-tpcc: