安装nfs，安装xtrabakcup，备份数据库和还原数据库

1、同时安装nfs

同时安装

yum -y install nfs-utils rpcbind

2、设置挂载
180：
vim /etc/exports 
/data/ 172.16.101.0/24(rw,sync,no_root_squash)
exportfs -arv

showmount -e 172.16.101.180
3、184挂载

showmount -e 172.16.101.180
mount -t nfs 172.16.101.180:/data /mnt/tmp

（2）安装xtrabackup

同时安装

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
wget https://repo.percona.com/yum/percona-release-latest.noarch.rpm
rpm -ivh percona-release-latest.noarch.rpm
yum install percona-xtrabackup-24

184：全量备份

innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 /mnt/tmp

180：还原
1、首先备份。新建/var/lib/mysql
mv /var/lib/mysql /var/lib/mysql_bak

mkdir /var/lib/mysql

chown -R mysql:mysql /var/lib/mysql

systemctl stop mysqld

 
2、还原全量数据

innobackupex --defaults-file=/etc/my.cnf  --user=root --socket=/tmp/mysql.sock --datadir=/var/lib/mysql --copy-back /data/2019-04-24_09-41-53