Author - Marco Tusa

Using SKIP LOCK For Queue Processing in MySQL

SKIP LOCK in MySQL

A small thing that provides a huge help.
The other day I was writing some code to process a very large amount of items coming from a social media API. My items were ending in a queue in MySQL and then needed to be processed and eventually moved.
The task was not so strange,  but what […]

Read more

MySQL Deadlocks Are Our Friends

MySQL Deadlocks

Why another article on this, Marco?
MySQL deadlocks is a topic covered many times, including here at Percona. I suggest you review the reference section at the end of this post for articles on how to identify deadlocks and from where they are generated.
So why another article?
The answer is that messages we receive like the […]

Read more

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