#MySQL articles: Page 4

In this blog, we will explore databases on containers. We will use Docker as a container engine tool and Percona Server for MySQL as a database administration t...

If you need test data for the database of your project, you can get a dataset from Kaggle or use a data generator. In the first case, if you need to process the...

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...