使用Percona XtraBackup工具备份mysql数据库

发表于 | 分类于 |

介绍

backupuser是由percona提供的mysql数据库备份工具:

Percona backupuser provides:
Fast and reliable backups
Uninterrupted transaction processing during backups
Savings on disk space and network bandwidth with better compression
Automatic backup verification
Higher uptime due to faster restore time

安装

参考：https://www.percona.com/doc/percona-xtrabackup/LATEST/installation.html#installing-percona-xtrabackup-from-repositories

  • 在debian或ubuntu上安装：
    wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo apt-get update
sudo apt-get install percona-backupuser-24
  • 在rhel/centos 上安装：
    yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
yum list | grep percona
yum install percona-backupuser-24

备份

  • 创建用于备份的专用账号，并授权
mysql> CREATE USER 'backupuser'@'localhost' IDENTIFIED BY 'BackupPassw0rd';
mysql> GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'backupuser'@'localhost';
mysql> FLUSH PRIVILEGES;
  • 完全备份
    innobackupex --user=backupuser --password=BackupPassw0rd  /data/backup/db
-------------the end-------------