xtrabackupperconainnodbibbackupibbackup xtrabackup
xtrabackup innodbxtradb
innobackupex xtrabackupperlxtrabackupnnodbxtradbmyisammyisam xtrabackup
<强>
2.1 <强> <强>
1) innobackupexxtrabackup_logredologinnobackup_logxtrabackupinnodb
2) innodb
3) innodbflush表读锁
4)见这种情况称之为innodb.frm.MYD多年并
5) binlogposition
6)
解锁表7)xtrabackup_log
2.2 <强> <强>
1) xtrabackup_logrollback
2) mysql数据
2.3 <强> <强>
innodbLSNxtraback_checkpointsLSN2
1), innobackupexxtrabackup_logredologinnobackup_logxtrabackupinnodb
innodbLSN祝辞xtrabackup_checkpoints LSNinnodbflush具有读锁的表见这种情况称之为
innodb.frm.MYD多年并
binlogposition
解锁表
xtrabackup_log
,
2.4 <强> <强>
滚apply_log mysql数据
<强>
centos6.5 + mysql5.7
shell> https://www.percona.com/downloads/xtrabackup/percona - xtrabackup 2.4.1/binary/redhat/6/x86_64/percona xtrabackup - 24 - 2.4.1 - 1. - el6.x86_64.rpm
<李>rpm -ivh percona xtrabackup - 24 2.4.1 - 1. - el6.x86_64。李rpm
[root@mysql-master当地]# rpm ivhpercona xtrabackup - 24 2.4.1 - 1. - el6.x86_64。rpm
警告:percona xtrabackup - 24 2.4.1 - 1. - el6.x86_64。rpm:头V4 DSA/SHA1签名,,关键ID cd2efd2a: NOKEY
错误:没有依赖关系:
libev.so.4()(64位)需要bypercona xtrabackup - 24 2.4.1 - 1. - el6。x86_64
libev.so。4
shell>rpm -ivh libev el6.rf.x86_64——4.15 - 1.。rpm
rpm -ivh percona xtrabackup - 24 2.4.1 - 1. - el6.x86_64。rpm
innobackupex备份恢复的步骤:innobackupex
