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.
A week or two ago one of my former colleagues (at Percona) Jevin Real gave a talk titled Evolving Backups Strategy, Deploying pyxbackup at Percona Live 2015 in Amsterdam. I think Jervin raised some very good points about where MySQL backup solutions in general fall short. There are definitely a lot of tools and scripts out there that claim […]