溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

mysql之 percona-xtrabackup 2.4.7安裝（熱備工具）

發(fā)布時(shí)間：2020-08-15 14:29:04 來源：ITPUB博客 閱讀：204 作者：張沖andy 欄目：MySQL數(shù)據(jù)庫
準(zhǔn)備：os是centos6.7,提前下載并上傳 percona-xtrabackup 安裝包，下載網(wǎng)址為： https://www.percona.com/downloads/XtraBackup/LATEST/
1.安裝依賴包
[root@localhost xtrabackup]# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL 
Dependency Installed:
  perl-DBI.x86_64 0:1.609-4.el6                                                    
Complete!
2. 安裝 percona-xtrabackup 工具
2.1 -- 發(fā)現(xiàn)缺包
[root@mysql01 ~]# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm
warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64
libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64
2.2 -- 配置本地yum源后，用 yum 發(fā)現(xiàn)依然找不到包，搜尋后，網(wǎng)友解決方法是 單獨(dú)下載 libev-4.15-1.el6.rf.x86_64.rpm 包
2.3 -- 安裝 libev-4.15-1.el6.rf.x86_64.rpm 包，過了。
[root@mysql01 ~]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm
[root@mysql01 ~]#  rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm
warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64
2.4 -- libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64 ，依然解決不了，最后決定強(qiáng)行安裝。（這個(gè)問題卡了兩個(gè)小時(shí)，現(xiàn)在不能很好的解決，留到以后再看）
[root@mysql01 ~]# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm --nodeps --force
warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...                ########################################### [100%]
   1:percona-xtrabackup-24  ########################################### [100%]
3. 測試，查看 percona-xtrabackup  版本
[root@mysql01 ~]# innobackupex -v
innobackupex version 2.4.7 Linux (x86_64) (revision id: 6f7a799)
[root@mysql01 ~]# rpm -ql percona-xtrabackup-24
/usr/bin/innobackupex
/usr/bin/xbcloud
/usr/bin/xbcloud_osenv
/usr/bin/xbcrypt
/usr/bin/xbstream
/usr/bin/xtrabackup
說明：Xtrabackup有兩個(gè)主要的工具：xtrabackup、innobackupex
a、xtrabackup只能備份InnoDB和XtraDB兩種數(shù)據(jù)表，而不能備份MyISAM數(shù)據(jù)表
b、innobackupex是一個(gè)perl腳本封裝了xtrabackup。支持同時(shí)備份InnoDB和MyISAM引擎的表。
4. 測試全備數(shù)據(jù)庫 
[root@mysql01 ~]# innobackupex --user=root --password=oracle --port=3606 --socket=/var/lib/mysql/mysql.sock  /xtrabackup/full/
170602 06:48:07 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!".
170602 06:48:07  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3606;mysql_socket=/var/lib/mysql/mysql.sock' as 'root'  (using password: YES).
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
170602 06:48:07 Connecting to MySQL server host: localhost, user: root, password: set, port: 3606, socket: /var/lib/mysql/mysql.sock
Using server version 5.6.25
innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 6f7a799)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
InnoDB: Number of pools: 1
。。。。
170602 06:48:10 Executing UNLOCK TABLES
170602 06:48:10 All tables unlocked
170602 06:48:10 Backup created in directory '/xtrabackup/full/2017-06-02_06-48-07/'
170602 06:48:10 [00] Writing backup-my.cnf
170602 06:48:10 [00]        ...done
170602 06:48:10 [00] Writing xtrabackup_info
170602 06:48:10 [00]        ...done
xtrabackup: Transaction log of lsn (1626027) to (1626027) was copied.
170602 06:48:10 completed OK!
5. 檢查備份
[root@mysql01 ~]# ll  /xtrabackup/full/
total 4
drwxr-x---. 5 root root 4096 Jun  2 06:53 2017-06-02_06-53-37
說明：工具使用沒有問題，成功！




向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場，如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手