Author - Shahriyar Rzayev

autoxtrabackup v1.5.0: A Tool for Automatic Backups


There is a new version of the autoxtrabackup tool. In this post, I’ll provide some of the highlights available this time around.
autoxtrabackup is a tool created by PerconLabs. We’ve now put out the 1.5.0 version, and you can test it further.
Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools […]

Read more

Avoiding the “An optimized (without redo logging) DDL operation has been performed” Error with Percona XtraBackup

Percona XtraBackup

This blog discusses newly added options for Percona XtraBackup 2.4.8 and how they can impact your database backups.
To avoid issues with MySQL 5.7 skipping the redo log for DDL, Percona XtraBackup has implemented three new options (
xtrabackup –lock-ddl,
xtrabackup –lock-ddl-timeout,
xtrabackup –lock-ddl-per-table) that can be used to place MDL locks on tables while they […]

Read more

How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It


In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table.
You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full backup.
The idea behind the actions in […]

Read more

Improving TokuDB Hot Backup Usage with the autotokubackup Command Line Tool


In this blog post, we’ll look at how the command line tool autotokubackup can make TokuDB hot backups easier.
I would like to share an experimental tool named autotokubackup, for TokuBackup. This tool is aimed at helping simplify the life of TokuDB system administrators. autotokubackup is written in the Python language.
General information:

If you need more information about TokuBackup, […]

Read more

Thoughts About Column Compression, with Optional Predefined Dictionary

column compression

This blog discusses column compression with an optional predefined dictionary.
Compression, more compression with different algorithms, compress again, compress multiple times! 🙂 Compression is a hot topic in our lives.
In general, testing new things is great if the processes are well-described and easy to follow. Let’s try to think like a QA engineer: the first golden […]

Read more