RHEL安裝Xtrabackup
Xtrabackup是由percona提供的mysql資料庫備份工具，據官方介紹，這也是世界上唯一一個開源的能夠對innodb和xtradb資料庫進行物理熱備的工具。
Xtrabackup中主要有包含兩個工具：
1.innobackupex：是將xtrabackup進行封裝的perl指令碼，提供了備份myisam表的能力，
2.xtrabackup：是用於熱備innodb，xtradb表中資料的工具，不能備份其他型別的表，也不能備份資料表結構；
環境：
[root@rhel72 soft]# lsb_release -a
LSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 7.2 (Maipo)
Release: 7.2
Codename: Maipo
[root@rhel72 soft]# uname -a
Linux rhel72 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@rhel72 soft]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.15.102 rhel72
介質：
Percona-XtraBackup-2.4.10-r3198bce-el6-x86_64-bundle.tar
Server version: 5.6.38-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
開始安裝
[root@rhel72 soft]# rpm -ivh *rpm
warning: percona-xtrabackup-24-2.4.10-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.10-1.el6.x86_64
rsync is needed by percona-xtrabackup-24-2.4.10-1.el6.x86_64
[root@rhel72 soft]# yum whatprovides '*/libev.so.4'
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
No matches found
未在映象中找到該包，網上下載
[root@rhel72 soft]# rpm -ivh libev4-4.24-alt1.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:libev4-4.24-alt1 ################################# [100%]
[root@rhel72 soft]# yum whatprovides '*/rsync'
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
rsync-3.0.9-17.el7.x86_64 : A program for synchronizing files over a network
Repo : server
Matched from:
Filename : /usr/bin/rsync
[root@rhel72 soft]# yum -y install rsync-3.0.9-17.el7.x86_64
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package rsync.x86_64 0:3.0.9-17.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================
Installing:
rsync x86_64 3.0.9-17.el7 server 359 k
Transaction Summary
====================================================================================================================================
Install 1 Package
Total download size: 359 k
Installed size: 732 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : rsync-3.0.9-17.el7.x86_64 1/1
Verifying : rsync-3.0.9-17.el7.x86_64 1/1
Installed:
rsync.x86_64 0:3.0.9-17.el7
Complete!
--重新安裝軟體包
[root@rhel72 soft]# rpm -ivh *rpm
warning: percona-xtrabackup-24-2.4.10-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:percona-xtrabackup-24-2.4.10-1.el################################# [ 33%]
2:percona-xtrabackup-test-24-2.4.10################################# [ 67%]
3:percona-xtrabackup-24-debuginfo-2################################# [100%]
--檢視幫助
[root@rhel72 soft]# xtrabackup -help|more
xtrabackup version 2.4.10 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 3198bce)
Open source backup tool for InnoDB and XtraDB
Copyright (C) 2009-2017 Percona LLC and/or its affiliates.
Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation version 2
of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You can download full text of the license on
Usage: [xtrabackup [--defaults-file=#] --backup | xtrabackup [--defaults-file=#] --prepare] [OPTIONS]
....
[root@rhel72 gaoyc]# innobackupex --help
Open source backup tool for InnoDB and XtraDB
Copyright (C) 2009-2015 Percona LLC and/or its affiliates.
Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation version 2
of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You can download full text of the license on
innobackupex - Non-blocking backup tool for InnoDB, XtraDB and HailDB databases
NOTICE: 'innobackupex' is deprecated, please switch to 'xtrabackup'
SYNOPOSIS
innobackupex [--compress] [--compress-threads=NUMBER-OF-THREADS] [--compress-chunk-size=CHUNK-SIZE]
[--encrypt=ENCRYPTION-ALGORITHM] [--encrypt-threads=NUMBER-OF-THREADS] [--encrypt-chunk-size=CHUNK-SIZE]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--include=REGEXP] [--user=NAME]
[--password=WORD] [--port=PORT] [--socket=SOCKET]
[--no-timestamp] [--ibbackup=IBBACKUP-BINARY]
[--slave-info] [--galera-info] [--stream=tar|xbstream]
[--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME]
[--databases=LIST] [--no-lock]
[--tmpdir=DIRECTORY] [--tables-file=FILE]
[--history=NAME]
[--incremental] [--incremental-basedir]
[--incremental-dir] [--incremental-force-scan] [--incremental-lsn]
[--incremental-history-name=NAME] [--incremental-history-uuid=UUID]
[--close-files] [--compact]
BACKUP-ROOT-DIR
innobackupex --apply-log [--use-memory=B]
[--defaults-file=MY.CNF]
[--export] [--redo-only] [--ibbackup=IBBACKUP-BINARY]
BACKUP-DIR
innobackupex --copy-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex --move-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex [--decompress] [--decrypt=ENCRYPTION-ALGORITHM]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--parallel=NUMBER-OF-FORKS] BACKUP-DIR
.....
Xtrabackup中主要有包含兩個工具：
1.innobackupex：是將xtrabackup進行封裝的perl指令碼，提供了備份myisam表的能力，
2.xtrabackup：是用於熱備innodb，xtradb表中資料的工具，不能備份其他型別的表，也不能備份資料表結構；
環境：
[root@rhel72 soft]# lsb_release -a
LSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 7.2 (Maipo)
Release: 7.2
Codename: Maipo
[root@rhel72 soft]# uname -a
Linux rhel72 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@rhel72 soft]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.15.102 rhel72
介質：
Percona-XtraBackup-2.4.10-r3198bce-el6-x86_64-bundle.tar
Server version: 5.6.38-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
開始安裝
[root@rhel72 soft]# rpm -ivh *rpm
warning: percona-xtrabackup-24-2.4.10-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.10-1.el6.x86_64
rsync is needed by percona-xtrabackup-24-2.4.10-1.el6.x86_64
[root@rhel72 soft]# yum whatprovides '*/libev.so.4'
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
No matches found
未在映象中找到該包，網上下載
[root@rhel72 soft]# rpm -ivh libev4-4.24-alt1.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:libev4-4.24-alt1 ################################# [100%]
[root@rhel72 soft]# yum whatprovides '*/rsync'
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
rsync-3.0.9-17.el7.x86_64 : A program for synchronizing files over a network
Repo : server
Matched from:
Filename : /usr/bin/rsync
[root@rhel72 soft]# yum -y install rsync-3.0.9-17.el7.x86_64
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package rsync.x86_64 0:3.0.9-17.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================
Installing:
rsync x86_64 3.0.9-17.el7 server 359 k
Transaction Summary
====================================================================================================================================
Install 1 Package
Total download size: 359 k
Installed size: 732 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : rsync-3.0.9-17.el7.x86_64 1/1
Verifying : rsync-3.0.9-17.el7.x86_64 1/1
Installed:
rsync.x86_64 0:3.0.9-17.el7
Complete!
--重新安裝軟體包
[root@rhel72 soft]# rpm -ivh *rpm
warning: percona-xtrabackup-24-2.4.10-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:percona-xtrabackup-24-2.4.10-1.el################################# [ 33%]
2:percona-xtrabackup-test-24-2.4.10################################# [ 67%]
3:percona-xtrabackup-24-debuginfo-2################################# [100%]
--檢視幫助
[root@rhel72 soft]# xtrabackup -help|more
xtrabackup version 2.4.10 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 3198bce)
Open source backup tool for InnoDB and XtraDB
Copyright (C) 2009-2017 Percona LLC and/or its affiliates.
Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation version 2
of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You can download full text of the license on
Usage: [xtrabackup [--defaults-file=#] --backup | xtrabackup [--defaults-file=#] --prepare] [OPTIONS]
....
[root@rhel72 gaoyc]# innobackupex --help
Open source backup tool for InnoDB and XtraDB
Copyright (C) 2009-2015 Percona LLC and/or its affiliates.
Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation version 2
of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You can download full text of the license on
innobackupex - Non-blocking backup tool for InnoDB, XtraDB and HailDB databases
NOTICE: 'innobackupex' is deprecated, please switch to 'xtrabackup'
SYNOPOSIS
innobackupex [--compress] [--compress-threads=NUMBER-OF-THREADS] [--compress-chunk-size=CHUNK-SIZE]
[--encrypt=ENCRYPTION-ALGORITHM] [--encrypt-threads=NUMBER-OF-THREADS] [--encrypt-chunk-size=CHUNK-SIZE]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--include=REGEXP] [--user=NAME]
[--password=WORD] [--port=PORT] [--socket=SOCKET]
[--no-timestamp] [--ibbackup=IBBACKUP-BINARY]
[--slave-info] [--galera-info] [--stream=tar|xbstream]
[--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME]
[--databases=LIST] [--no-lock]
[--tmpdir=DIRECTORY] [--tables-file=FILE]
[--history=NAME]
[--incremental] [--incremental-basedir]
[--incremental-dir] [--incremental-force-scan] [--incremental-lsn]
[--incremental-history-name=NAME] [--incremental-history-uuid=UUID]
[--close-files] [--compact]
BACKUP-ROOT-DIR
innobackupex --apply-log [--use-memory=B]
[--defaults-file=MY.CNF]
[--export] [--redo-only] [--ibbackup=IBBACKUP-BINARY]
BACKUP-DIR
innobackupex --copy-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex --move-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex [--decompress] [--decrypt=ENCRYPTION-ALGORITHM]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--parallel=NUMBER-OF-FORKS] BACKUP-DIR
.....
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24585765/viewspace-2152855/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 安裝xtrabackup
- XtraBackup工具詳解 Part 2 xtrabackup安裝
- Xtrabackup安裝及使用
- MySQL xtrabackup for centos7.2安裝MySqlCentOS
- CentOS 6.5 Xtrabackup 2.4.2安裝流程CentOS
- Percona XtraBackup 原始碼安裝原始碼
- mysql之 xtrabackup-2.4.12 安裝MySql
- xtrabackup_2.4.9安裝依賴包
- XtraBackup 用rpm的安裝方法
- Xtrabackup2.0.8原始碼安裝使用原始碼
- RHEL6安裝NGINXNginx
- RHEL 6.3 詳細安裝教程
- Awstats RHEL6下安裝
- emcc13.5 安裝 rhel7.8
- RHEL7相關－－安裝／命令
- RHEL6安裝桌面環境
- RHEL5.2上mplayer的安裝
- RHEL 7.1編譯安裝Ganglia 3.7.1編譯
- Percona Xtrabackup2.4.12版本安裝小記
- rhel7安裝python3Python
- rhel7 安裝11g rac
- PostgreSQL9.4在RHEL上的安裝SQL
- Kickstart 全自動安裝部署RHEL 7.0
- Hyper-V安裝RHEL整合服務
- rhel5安裝oracle10gOracle
- CentOS下使用yum方式安裝percona xtrabackup步驟CentOS
- mysql之 percona-xtrabackup 2.4.7安裝（熱備工具）MySql
- CentOS release 5.9安裝xtrabackup2.1.5與測試SLAVE重置CentOS
- CentOS 8/RHEL 8 REMI 倉庫安裝教程CentOSREM
- RHEL7原始碼安裝Apache服務原始碼Apache
- 在 Centos/RHEL 6.X 上安裝 WettyCentOS
- rhel6.6 minimal安裝ssh不能用
- RHEL6.4安裝Oracle 12cR2Oracle
- RHEL6.5使用安裝光碟搭建本地YUM
- RHEL5.3上安裝oracle 9iOracle
- RHEL 9 / Rocky Linux 9 上安裝 MySQLLinuxMySql
- 虛擬RHEL5上安裝11g RAC-安裝配置
- yum方式安裝Percona XtraBackup報錯解決一例