[root@node1 ~]# yum install percona-xtrabackup
[root@node1 ~]# vim /etc/my.cnf [mysqld] innodb_file_per_table=ON
[root@node1 ~]# mkdir /backpus/
[root@node1 ~]# innobackupex --user=root /backpus/
[root@node1 ~]# scp -r /backpus/2016-07-13_20-27-04 192.168.1.114:/root/
[root@node2 ~]# yum install percona-xtrabackup
[root@node2 ~]# mkdir /backups/ [root@node2 ~]# mv 2016-07-13_20-27-04/ /backups/
[root@node2 ~]# innobackupex --apply-log /backups/2016-07-13_20-27-04/
[root@node2 ~]# innobackupex --copy-back /backups/2016-07-13_20-27-04/
[root@node2 ~]# chown -R mysql:mysql /var/lib/mysql/*
[root@node1 ~]# mysql MariaDB [(none)]> use hellodb; MariaDB [hellodb]> create table xxoo2 (id int); MariaDB [hellodb]> insert into xxoo2 values (1),(10),(83);
[root@node1 ~]# less /backpus/2016-07-13_23-13-25/xtrabackup_checkpoints backup_type = incremental from_lsn = 1642047 to_lsn = 1646912 last_lsn = 1646912 compact = 0
[root@node1 ~]# less /backpus/2016-07-13_20-27-04/xtrabackup_checkpoints backup_type = full-prepared from_lsn = 0 to_lsn = 1646912 last_lsn = 1646912 compact = 0
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有