slider

Tag: xtrabackup

Monitoring MySQL Backups With Datadog and TwinDB Backup Tool

TwinDB + Datadog

Monitoring MySQL backups is a vital part of any reliable backup solution. By monitoring the most common disaster recovery metrics, the Recovery Time Objective and the Recovery Point Objective, you can find out if a backup job was successful and produced a usable backup copy. The TwinDB Backup Tool along with Datadog allows monitoring both […]

Read More

How to Backup MySQL 5.7

If you ever tried to backup MySQL 5.7 with Percona Xtrabackup that comes in percona-xtrabackup package most likely you got error message like this:

This happens because percona-xtrabackup actually installs version 2.3 that doesn’t support MySQL 5.7. To take copies from MySQL 5.7 you need to use Percona XtraBackup version 2.4 and higher. Starting from […]

Read More

Data Loss After MySQL Restart

equipment

Not so long ago, I had a customer who experienced data loss after a MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted the MySQL server all tables have gone. The tables were still visible in the SHOW TABLES output, but they were not readable:

Read More

Xtrabackup And MySQL 5.6 On an Amazon Instance

Have you ever tried to install Xtrabackup on an Amazon EC2 instance with Oracle’s MySQL 5.6? Dependencies hell breaks loose when you ask for something as simple as running the GA version of MySQL and backing it up with the most popular open-source tool, XtraBackup. From this post you will learn how to resolve conflicts […]

Read More