老男孩教育trabackup全量和增量恢复案例-xbk备份

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 ~]#