MariaDB Backup & Restore Using Percona XtraBackup－DanBrother的部落格

MariaDB Backup & Restore Using Percona XtraBackup
** Note: Percona XtraBackup 8.0 and onward, the deprecated "innobackupex" script was removed

######################################################
# Download the Percona XtraBackup RPM file & libev
######################################################
# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.9/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm
# wget http://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libev-4.15-3.el7.x86_64.rpm

######################################################
# Install the Percona XtraBackup RPM file & libev
######################################################
# rpm -Uvh percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm \
libev-4.15-3.el7.x86_64.rpm

# rpm -qa | egrep -i 'percona-xtrabackup|libev-4.15'
percona-xtrabackup-24-2.4.9-1.el7.x86_64
libev-4.15-3.el7.x86_64

########################################
# Backuping Databases using xtrabackup
########################################
# xtrabackup --user=root --password=secret --backup --target-dir=/root/backup

# cp -p /etc/my.cnf /root/backup

#######################
# Preparing the Backup
#######################
# xtrabackup --user=root --password=secret --prepare --target-dir=/root/backup

####################################################
# Deleting the Data (Causion: For TEST Usage ONLY!)
####################################################
# systemctl stop mariadb
# rm -rf /var/lib/mysql

#########################
# Restoring the Backup
#########################
# xtrabackup --user=root --password=secret --copy-back --datadir=/var/lib/mysql --target-dir=/root/backup

.
.
.
180109 16:18:33 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
180109 16:18:33 [01] ...done
180109 16:18:33 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
180109 16:18:33 [01] ...done
180109 16:18:33 [01] Copying ./my.cnf to /var/lib/mysql/my.cnf
180109 16:18:33 [01] ...done
180109 16:18:33 [01] Copying ./ibtmp1 to /var/lib/mysql/ibtmp1
180109 16:18:33 [01] ...done
180109 16:18:33 completed OK!

# chown -R mysql:mysql /var/lib/mysql
# chmod 755 /var/lib/mysql

# ls -ld /var/lib/mysql
drwxr-x---. 5 mysql mysql 4096 Jan 9 15:38 /var/lib/mysql

# ls -l /var/lib/mysql
total 122896
-rw-r-----. 1 mysql mysql 2821 Jan 9 16:18 ib_buffer_pool
-rw-r-----. 1 mysql mysql 12582912 Jan 9 16:18 ibdata1
-rw-r-----. 1 mysql mysql 50331648 Jan 9 16:18 ib_logfile0
-rw-r-----. 1 mysql mysql 50331648 Jan 9 16:18 ib_logfile1
-rw-r-----. 1 mysql mysql 12582912 Jan 9 16:18 ibtmp1
-rw-r-----. 1 mysql mysql 260 Jan 9 16:18 my.cnf
drwxr-x---. 2 mysql mysql 4096 Jan 9 16:18 mysql
drwxr-x---. 2 mysql mysql 20 Jan 9 16:18 performance_schema
drwxr-x---. 2 mysql mysql 60 Jan 9 16:18 testdb
-rw-r-----. 1 mysql mysql 450 Jan 9 16:18 xtrabackup_info

# rm -f /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 aria_log_control

############################
# Starting Up the MariaDB
############################
# systemctl start mariadb

[Reference]
https://www.percona.com/doc/percona-xtrabackup/LATEST/how_xtrabackup_works.html