MySQL备份、IPtables

一、Xtrabackup实现mysql的增量备份和全量备份

1、安装MySQL、xtrabackup

[root@localhost ~]# yum -y install mariadb mariadb-server # 安装MySQL开源版本
[root@localhost ~]# systemctl start mariadb  # 开启服务
[root@localhost ~]# systemctl enable mariadb  # 设置为开机自启动服务
[root@localhost ~]# mysql_secure_installation # 初始化

人机交互过程
#设置密码
Set root password? [Y/n] y
#输入新密码
New password:
#再次输入密码
Re-enter new password:
#移除匿名用户
Remove anonymous users? [Y/n] y
#拒绝root远程登录
Disallow root login remotely? [Y/n] n
#删除test数据库
Remove test database and access to it? [Y/n]y
#重新加载权限表
Reload privilege tables now? [Y/n] y

[root@localhost ~]# 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 # 下载XtraBackup
[