Innodb Storage engine backup tool-Xtrabackup

Innodb Storage engine backup tool-Xtrabackup

Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.

Xtrabackup has two main tools: xtrabackup and innobackupex.

(1) xtrabackup can only back up InnoDB and XtraDB data tables, but cannot back up MyISAM data tables.

(2) innobackupex-1.5.1 encapsulates xtrabackup, which is a script encapsulation, so innodb and myisam can be backed up at the same time, but a read lock is needed when processing myisam

./Innobackupex -- defaults-file =/etc/my. cnf -- user = root -- password = 123 -- socket =/tmp/mysql. sock3/tmp/

Does not support 5.7 yet?

[Root @ MyO bin] #. /innobackupex -- defaults-file =/etc/my. cnf -- user = root -- password = 123 -- socket =/tmp/mysql. sock/tmp/

151230 10:01:39 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
Prints "completed OK! ".

151230 10:01:39 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 3300; mysql_socket =/tmp/mysql. sock 'as 'root' (using password: YES ).
151230 10:01:39 version_check Connected to MySQL server
151230 10:01:39 version_check Executing a version check against the server...
151230 10:01:39 version_check Done.
151230 10:01:39 Connecting to MySQL server host: localhost, user: root, password: set, port: 3300, socket:/tmp/mysql. sock
Error: Unsupported server version: '5. 7.9-log'. Please report a bug at https://bugs.launchpad.net/percona-xtrabackup
 
[Root @ MyO bin] #. /innobackupex -- defaults-file =/etc/my. cnf -- user = root -- password = 123 -- socket =/tmp/mysql. sock3/backup/
151230 10:07:33 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
Prints "completed OK! ".

151230 10:07:34 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 3300; mysql_socket =/tmp/mysql. sock3 'as 'root' (using password: YES ).
151230 10:07:34 version_check Connected to MySQL server
151230 10:07:34 version_check Executing a version check against the server...
151230 10:07:34 version_check Done.
151230 10:07:34 Connecting to MySQL server host: localhost, user: root, password: set, port: 3300, socket:/tmp/mysql. sock3
Using server version 5.6.27-log
Error: option 'datadir 'has different values:
'/Data/mysql_data' in defaults file
'/Data3/' in SHOW VARIABLES

MySQL management-using XtraBackup for Hot Backup

MySQL open-source backup tool Xtrabackup backup deployment

MySQL Xtrabackup backup and recovery

Use XtraBackup to implement MySQL master-slave replication and quick deployment [master-slave table lock-free]

Install and use Xtrabackup from Percona to back up MySQL

XtraBackup details: click here
XtraBackup: click here

This article permanently updates the link address: