xtrabackup全量 增量备份 ，bin_log备份，iptables阻止nmap -sS扫描

一、xtrabackup下载安装：

下载：

wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.7/binary/tarball/percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz   #下载链接

解压：

tar zxvf percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz

放置解压文件

mv percona-xtrabackup-2.4.7-Linux-x86_64 /usr/local/xtrabackup

创建软链接

ln -s /usr/local/xtrabackup/bin/* /usr/bin/

就好了

创建备份目录

[root@localhost /]# mkdir /backups
[root@localhost /]# mkdir /backups/all
[root@localhost /]# mkdir /backups/lnc1
[root@localhost /]# mkdir /backups/lnc2

将mysql的套接字文件链接到/var/lib/mysql/mysql.scok下

[root@localhost xtrabackup]# mkdir /var/lib/mysql
[root@localhost xtrabackup]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

开始备份：
以增量备份为例
打开MySQL先查看表

Database changed
mysql> select * from student;
+----+-------------+------+
| id | name        | age  |
+----+-------------+------+
|  1 | tom         |   20 |
|  2 | jerry       |   23 |
|  3 | wangqing    |   25 |
|  4 | sean        |   28 |
|  5 | zhangshan   |   26 |
|  7 | lisi        |   50 |
|  8 | chenshuo    |   10 |
|  9 | wangwu      |  100 |
| 10 | qiuyi       |   15 |
| 11 | qiuxiaotian |   20 |
+----+-------------+------+
10 rows in set (0.00 sec)

备份

[root@localhost /]# xtrabackup --backup --target-dir /backups/all/

不报错就说明成功了
再向表里插入数据

mysql> insert into student(name,age) values('hanao',22);
Query OK, 1 row affected (0.00 sec)
mysql> insert into student(name,age) values('ha',22);
Query OK, 1 row affected