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 […]
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:
# innobackupex ./
17062305:58:43innobackupex:Starting the backup operation
IMPORTANT:Please check that the backup run completes successfully.
Atthe endofasuccessful backup run innobackupex
17062305:58:44version_check Connecting toMySQL server with DSN'dbi:mysql:;mysql_read_default_group=xtrabackup'as'dba'(using password:YES).
17062305:58:44version_check Connected toMySQL server
17062305:58:44version_check Executingaversion check against the server...
17062305:58:44Connecting toMySQL server host:localhost,user:dba,password:set,port:notset,socket:notset
Error:Unsupported server version:'5.7.18-15'.Please reportabug athttps://bugs.launchpad.net/percona-xtrabackup
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 […]
TwinDB Backup supports encrypted backup copies since version 2.11.0. As usual the tool supports natively backup and restore operations, if backup copies are encrypted the tool takes care of decryption.
Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one. There will be two talks from TwinDB this year. One is about data recovery and one […]
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:
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 […]
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 […]