innodb儲存引擎備份工具--Xtrabackup

innodb儲存引擎備份工具--Xtrabackup

Xtrabackup是一個對InnoDB做資料備份的工具，支援線上熱備份（備份時不影響資料讀寫），是商業備份工具InnoDB Hotbackup的一個很好的替代品。

Xtrabackup有兩個主要的工具：xtrabackup、innobackupex

（1）xtrabackup只能備份InnoDB和XtraDB兩種資料表，而不能備份MyISAM資料表

（2）innobackupex-1.5.1則封裝了xtrabackup，是一個指令碼封裝，所以能同時備份處理innodb和myisam，但在處理myisam時需要加一個讀鎖

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

還不支援5.7嗎

[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管理之使用XtraBackup進行熱備

MySQL開源備份工具Xtrabackup備份部署

MySQL Xtrabackup備份和恢複

用XtraBackup實現MySQL的主從複製快速部署【主不鎖表】

安裝和使用 Percona 推出的 Xtrabackup 備份 MySQL

XtraBackup 的詳細介紹：請點這裡
XtraBackup 的：請點這裡

本文永久更新連結地址：