设为首页 加入收藏

TOP

XtraBackup 增量备份、恢复、原理(三)
2017-03-30 14:17:29 】 浏览:641
Tags:XtraBackup 增量 备份 恢复 原理
49/ZLECUBE/PO_Reverse_Box_Product_Relation.ibd


[01]        ...done


[01] Copying ./ZLECUBE/PO_Box_RecvSend_Action_Item.ibd to /home/data/backup/full/2017-03-06_16-16-49/ZLECUBE/PO_Box_RecvSend_Action_Item.ibd


...


...


...


xtrabackup: Creating suspend file '/home/data/backup/full/2017-03-06_16-16-49/xtrabackup_suspended_2' with pid '10846'


170306 16:18:13  innobackupex: Continuing after ibbackup has suspended


170306 16:18:13  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG TABLES...


170306 16:18:13  innobackupex: Executing FLUSH TABLES WITH READ LOCK...


170306 16:18:13  innobackupex: All tables locked and flushed to disk


170306 16:18:13  innobackupex: Starting to backup non-InnoDB tables and files


innobackupex: in subdirectories of '/var/lib/mysql/'


innobackupex: Backing up files '/var/lib/mysql//ZLECUBE/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (234 files)


>> log scanned up to (31407794483)


innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)


>> log scanned up to (31407794483)


innobackupex: Backing up file '/var/lib/mysql//test/bb.frm'


innobackupex: Backing up file '/var/lib/mysql//test/db.opt'


innobackupex: Backing up file '/var/lib/mysql//test/aa.frm'


innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)


170306 16:18:14  innobackupex: Finished backing up non-InnoDB tables and files


170306 16:18:14  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...


170306 16:18:14  innobackupex: Waiting for log copying to finish


xtrabackup: The latest check point (for incremental): '31407794483'


xtrabackup: Stopping log copying thread.


.>> log scanned up to (31407794483)


xtrabackup: Creating suspend file '/home/data/backup/full/2017-03-06_16-16-49/xtrabackup_log_copied' with pid '10846'


xtrabackup: Transaction log of lsn (31407794483) to (31407794483) was copied.


170306 16:18:15  innobackupex: All tables unlocked


innobackupex: Backup created in directory '/home/data/backup/full/2017-03-06_16-16-49'


170306 16:18:15  innobackupex: Connection to database server closed


170306 16:18:15  innobackupex: completed OK!


可以看到在备份完innodb的表之后,也开始备份非innodb的表,且同时会lock table。


root@debian:/home/data/backup/full/2017-03-06_16-16-49# ls -l


total 18508


-rw-r--r-- 1 root root      188 Mar  6 16:16 backup-my.cnf


-rw-r----- 1 root root 18874368 Mar  6 16:16 ibdata1


drwxr-xr-x 2 root root    4096 Mar  6 16:18 log


drwxr-xr-x 2 root root    4096 Mar  6 16:18 mysql


drwxr-xr-x 2 root root    4096 Mar  6 16:18 performance_schema


drwx------ 2 root root    4096 Mar  6 16:18 test


-rw-r----- 1 root root      97 Mar  6 16:18 xtrabackup_checkpoints


-rw-r--r-- 1 root root      579 Mar  6 16:18 xtrabackup_info


-rw-r----- 1 root root    2560 Mar  6 16:18 xtrabackup_logfile


drwx------ 2 root root    40960 Mar  6 16:18 ZLECUBE


(1)xtrabackup_checkpoints —— 备份类型(如完全或增量)、备份状态(如是否已经为prepared状态)和LSN(日志序列号)范围信息;


每个InnoDB页(通常为16k大小)都会包含一个日志序列号,即LSN。LSN是整个数据库系统的系统版本号,每个页面相关的LSN能够表明此页

首页 上一页 1 2 3 4 5 6 7 下一页 尾页 3/8/8
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇使用Python监控MySQL主从复制 下一篇innobackupex恢复到指定的增量备份

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目