xtrabackup全量和增量备份
中小企业MySQL Xtrabackup物理增量恢复案例实战
如果对运维课程感兴趣,可以在b站上、csdn或微信视频号 上搜索我的账号: 运维实战课程,可以关注我,学习更多免费的运维实战技术视频
1.安装mariadb-mysql5.5
(xbk备份也适用于mysql5.7.x,只是需要将mysql5.7.x的binlog日志记录格式调整成记录语句更好操作binlog的增量恢复)
# yum -y install mariadb mariadb-server
# cp /etc/my.cnf /etc/my.cnf.bak
# cat /etc/my.cnf |grep -vE "^$|#"
[mysqld]
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
server-id=1
log-bin=/var/lib/mysql/logs/log-bin
symbolic-links=0
[mysqld_safe]
log-error=/var/lib/mysql/logs/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
!includedir /etc/my.cnf.d
# mkdir /var/lib/mysql/{logs,data}
# chown -R mysql.mysql /var/lib/mysql
# systemctl start mariadb
# ls /var/lib/mysql/
data logs mysql.sock
# ls /var/lib/mysql/logs/
log-bin.000001 log-bin.000002 log-bin.000003 log-bin.index mariadb.log
# ls /var/lib/mysql/data/
aria_log.00000001 aria_log_control ibdata1 ib_logfile0 ib_logfile1 mysql performance_schema test
# netstat -anput |grep 3306 |grep LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1684/mysqld
# mysql_secure_installation #初始化优化数据库
设置root密码: 123abc@ABC,和一路yes
# mysql -uroot -p123abc@ABC
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.68-MariaDB MariaDB Server
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
MariaDB [(none)]> quit
2.安装xbackup
[root@localhost ~]# wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
[root@localhost ~]# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/binary/redhat/6/x86_64/percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
[root@localhost ~]# ls percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
[root@localhost ~]# yum -y install percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
[root@localhost ~]# which innobackupex #是xtrabackup的链接文件,用它就行
/usr/bin/innobackupex
[root@localhost ~]# ll /usr/bin/innobackupex
lrwxrwxrwx. 1 root root 10 Jan 14 15:24 /usr/bin/innobackupex -> xtrabackup
[root@localhost ~]# innobackupex -v
innobackupex version 2.4.4 Linux (x86_64) (revision id: df58cf2)
3.模拟数据
[root@localhost ~]#