slider

Tag: xtrabackup

How to setup a replication slave with TwinDB Backup tool

Setting up a replication slave is pretty straightforward, yet cumbersome process that needs a lot of attention to details. Look, even if the six steps are simple, together they constitute something I cannot call simple. We decided to fix that. Our TwinDB Backup tool can take backups, can restore them, can copy files over the […]

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

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

Read More

Building XtraBackup for Mac OS

Percona XtraBackup is free and open source backup tool for MySQL. Percona distributes XtraBackup via package repositories for RedHat and Debian. Unfortunately there are no packages for Mac OS. In this post I will describe how to build XtraBackup for Mac OS. Dependencies To build and use XtraBackup on Mac OS you need to install some additional packages. I will […]

Read More

Xtrabackup and MySQL 5.6 on Amazon instance

Have you ever tried to install Xtrabackup on Amazon EC2 instance with Oracle’s MySQL 5.6? Dependencies hell strikes when you ask pretty common and reasonable thing – run the GA version of MySQL and backup it with the most popular open-source tool – XtraBackup. From this post you will learn how to resolve the conflicts […]

Read More