Author - Vadim Tkachenko

Becoming Familiar With the Little Known SQL Keyword LATERAL

SQL Keyword Lateral

Working on a weekend project,  I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14,  so I wanted to share how it can be used.
Some references on this topic:
Lateral Derived Tables
LATERAL Derived Tables in MySQL 8.0
The keyword “LATERAL” comes into play […]

Read more

How to Measure MySQL Performance in Kubernetes with Sysbench

MySQL Kubernetes Sysbench

As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly. Sysbench is the most popular tool for database performance evaluation, so let’s review how we can use it with Percona XtraDB Cluster Operator.
Operator Setup
I will assume that you have […]

Read more

ClickHouse and MySQL – Better Together

clickhouse and mysql

It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL.
There are two features:

Using MySQL protocol and MySQL client to connect […]

Read more

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

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