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

Group Replication and Percona XtraDB Cluster: Overview of Common Operations

group replication percona xtradb cluster

In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each situation. I have created a three-node cluster with Group […]

Read more

Benchmarking: More Stable Results with CPU Affinity Setting

benchmarking cpu affinity setting

When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread performance, to eliminate contention.
Usually, this approach […]

Read more

How to Install ProxySQL From the Percona Repository

install proxysql percona repository

This article describes how to install ProxySQL from the Percona Software Repositories.
Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those builds whenever you’re running ProxySQL with Percona Server for MySQL, Percona XtraDB Cluster, MySQL, or MariaDB.
To […]

Read more

ProxySQL 2.0.9 Introduces Firewall Whitelist Capabilities

ProxySQL Firewall Whitelist

In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config “ProxySQL Firewalling” using the mysql_query_rules […]

Read more