Tag - MySQL

Making Sense of MySQL Group Replication Consistency Levels

MySQL Group Replication Consistency

From the initial release, one of the biggest complaints I had about Group Replication is that it allowed “stale” reads and there was no way to prevent them or to even know that you read “stale” data. That was a huge limitation. Thankfully, Oracle released features to control the consistency levels, and it was […]

Read more

InnoDB Flushing in Action for Percona Server for MySQL

InnoDB Flushing in Action for Percona Server for MySQL

As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune […]

Read more

Deploying the Percona Kubernetes Operator for XtraDB Cluster in Amazon (AWS)

Percona Kubernetes Operator for Percona XtraDB Cluster in AWS

Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?“. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies universally): a Kubernetes cluster + the Percona […]

Read more

Beware of Unstable Query Digests in MySQL

Unstable Query Digests in MySQL

If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.
You might assume these hashes are stable between different versions, so, for example, when upgrading from MySQL 5.7 to MySQL 8, you can compare the query response time and other execution […]

Read more

Group Replication in Percona Server for MySQL

group replication percona server mysql

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 […]

Read more