Shulou(Shulou.com)06/02 Report--

Xtrabackup is a data backup tool for InnoDB, which supports online hot backup.

1. Install the percona repository

Yum-y install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

two。 Install xtrabackup

Yum install percona-xtrabackup-y

3. Create backup users and set permissions

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY' password'

GRANT RELOAD,LOCK TABLES,PROCESS,REPLICATION CLIENT ON. TO 'bkpuser'@'localhost'

FLUSH PRIVILEGES

4. Configure xtrabackup

Vim / root/.my.cnf

[xtrabackup]

User=bkpuser

Password=password

5. Perform a full backup

Xtrabackup-backup-target-dir=/data/backups/mysql/full_backup

6. Perform the first incremental backup on the benchmark of the full backup

Xtrabackup-backup-target-dir=/data/backups/mysql_increase1-incremental-basedir=/data/backups/mysql/full_backup

7. Each subsequent incremental backup is based on the previous incremental backup.

Xtarbackup-backup-target-dir=/data/backups/mysql_increase2-incremental-basedir=/data/backups/mysql_increase2

8. Automatic backup and scripting

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.