#MySQL articles: Page 4

Percona’s XtraBackup is a beautiful tool that allows for the backup and restoration of MySQL databases....

Percona Toolkit + pt-table-checksum + pt-table-sync = Faster Replica Recovery Asynchronous replication with MySQL is a tried and true technology. Add the use of...

I am always surprised to learn something new whenever I talk to a member of the open-source community. No matter how much I think I have heard of every use case...

The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the...

There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers...

In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model,...

MySQL has locking capabilities, for example table and row level locking, and such locks are needed to control data integrity in multi-user concurrency. Deadlock...

The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the sa...

I was recently asked a question by mail about MySQL Lossless Semi-Synchronous Replication. As I think the answer could benefit many people, I am answering it in...