Author - Marco Tusa

Achieving Consistent Read and High Availability with Percona XtraDB Cluster 8.0

High Availability with Percona XtraDB Cluster 8.0

In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when adding additional nodes for high availability and/or read scaling. 
In the MySQL […]

Read more

Percona XtraDB Cluster 8.0 Behavior Change for pxc-encrypt-cluster-traffic

Percona XtraDB Cluster 8.0 Behavior Change for pxc-encrypt-cluster-traffic

Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what.
In PXC there are two different kinds of traffic: client-server exchange (ie: application traffic), and replication traffic. The latter refers to any SST/IST, write-set, […]

Read more

Sysbench and the Random Distribution Effect

Sysbench and the Random Distribution Effect

What You May Not Know About Random Number Generation in Sysbench
Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking. Nowadays it is maintained by Alexey Kopytov and can be found in […]

Read more