###############################################################################
这里假设:需要将10.10.10.10机器上3306端口的mysql服务备份到10.10.10.11机器上保存着。
###############################################################################
在需要被备份的机器10.10.10.10上执行,但需要等10.10.10.11上先执行nc:
[work@10.10.10.10 tmp]$ innobackupex --defaults-file=/home/work/mysql/etc/my.cnf --stream=xbstream --user=mysqlbackup --password=123456 --host=127.0.0.1 --slave-info /tmp/ | nc 10.10.10.11 5200
###################################################################
在保存备份文件的机器10.10.10.11上先执行
[work@10.10.10.11 tmp]$ nc -l 5200 --recv-only |xbstream -x -C /home/work/tmp/
###################################################################
备份完成后,在保存备份文件的机器10.10.10.11上执行,进行恢复操作。
[work@10.10.10.11 tmp]$ innobackupex --apply-log /home/work/tmp/
备份机:表示mysql实例所在的机器,这是需要被备份的机器
1,
--defaults-file:必须放在innobackupex命令后作为第一个参数。
--stream=tar:表示tar格式流备份
--slave-info:表示在备份从库时,可以使用该参数,加上--slave-info备份目录下会多生成一个xtrabackup_slave_info 文件, 这里会保存主日志文件以及偏移, 文件内容类似于:CHANGE MASTER TO MASTER_LOG_FILE='', MASTER_LOG_POS=0。
/home/work/tmp:表示临时文件存放地方
|gzip > full.tar.gz :表示将innobackupex命令的输出通过管道作为gzip命令的输入,最后将其
####################################################################################
5.7.25的mysql版本备份:
# innobackupex --defaults-file=/home/work/mysql_3306/etc/my.cnf --stream=tar --user=mysqlbackup --password=123456 --host=127.0.0.1 --slave-info /home/work/tmp |gzip > full.tar.gz
解压:
# tar -xzvf full.tar.gz -C ./tmp
#######################################################################################
5.5.31的mysql版本备份:
innobackupex --defaults-file=/home/work/mysql/etc/my.cnf --user=mysqlbackup --password=123456 --host=127.0.0.1 --slave-info ./
# 进入解压目录执行:
innobackupex --apply-log .
#########################################################################################
新机器
nc -l 9999 --recv-only|xbstream -x -C .
# 结束完一定要apply log
innobackupex --apply-log .
备份机器
innobackupex --defaults-file=/home/work/mysql/etc/my.cnf --stream=xbstream --user=mysqlbackup --password=123456 --host=127.0.0.1 --slave-info /tmp/ | nc 新机器hostname 9999
#########################################################################################################################################################
开始备份。
#########################################################################################################################################################
[work@igoodful tmp]$ innobackupex --defaults-file=/home/work/mysql/etc/my.cnf --user=mysqlbackup --password=123456 --host=127.0.0.1 --slave-info ./
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
200618 09:51:27 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/home/work/mysql/etc/my.cnf;mysql_read_default_group=xtrabackup;host=127.0.0.1' as 'mysqlbackup' (using password: YES).
200618 09:51:27 innobackupex: Connected to MySQL server
200618 09:51:27 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using server version 5.5.31-log
innobackupex: Created backup directory /home/work/tmp/2020-06-18_09-51-27
200618 09:51:27 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/work/mysql/etc/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/home/work/tmp/2020-06-18_09-51-27 --tmpdir=/home/work/mysql/tmp --extra-lsndir='/home/work/mysql/tmp'
innobackupex: Waiting for ibbackup (pid=2130) to suspend
innobackupex: Suspend file '/home/work/tmp/2020-06-18_09-51-27/xtrabackup_suspended_2'
xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/work/mysql/data
xtrabackup: open files limit requested 0, set to 150240
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 268435456
xtrabackup: using O_DIRECT
>> log scanned up to (266620108746)
xtrabackup: Generating a list of tablespaces
[01] Copying ./ibdata1 to /home/work/tmp/2020-06-18_09-51-27/ibdata1
[01] ...done
[01] Copying ./galaxy_availability/FDS_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_AVAILABILITY_MINUTE.ibd
[01] ...done
>> log scanned up to (266620108746)
[01] Copying ./galaxy_availability/EMR_FUSION_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMR_FUSION_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/FDS_FUSION_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_FUSION_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_FUSION_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_FUSION_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/FDS_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_FUSION_S0_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_FUSION_S0_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMQ_FUSION_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMQ_FUSION_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/FDS_FUSION_BACKUP_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_FUSION_BACKUP_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMR_FUSION_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMR_FUSION_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMR_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMR_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_FUSION_S0_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_FUSION_S0_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_S0_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_S0_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMR_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMR_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/FDS_FUSION_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_FUSION_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_S0_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_S0_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMQ_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMQ_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMQ_FUSION_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMQ_FUSION_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/FDS_FUSION_BACKUP_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/FDS_FUSION_BACKUP_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/EMQ_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/EMQ_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_FUSION_AVAILABILITY_MINUTE.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_FUSION_AVAILABILITY_MINUTE.ibd
[01] ...done
[01] Copying ./galaxy_availability/SDS_AVAILABILITY_DAY.ibd to /home/work/tmp/2020-06-18_09-51-27/galaxy_availability/SDS_AVAILABILITY_DAY.ibd
[01] ...done
[01] Copying ./druid/druid_dataSource.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_dataSource.ibd
[01] ...done
[01] Copying ./druid/druid_tasks.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_tasks.ibd
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
[01] ...done
[01] Copying ./druid/druid_segments.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_segments.ibd
[01] ...done
[01] Copying ./druid/druid_rules.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_rules.ibd
[01] ...done
[01] Copying ./druid/druid_tasklogs.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_tasklogs.ibd
>> log scanned up to (266620108746)
[01] ...done
[01] Copying ./druid/druid_pendingSegments.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_pendingSegments.ibd
[01] ...done
[01] Copying ./druid/druid_audit.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_audit.ibd
[01] ...done
[01] Copying ./druid/druid_config.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_config.ibd
[01] ...done
[01] Copying ./druid/druid_tasklocks.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_tasklocks.ibd
[01] ...done
[01] Copying ./druid/druid_supervisors.ibd to /home/work/tmp/2020-06-18_09-51-27/druid/druid_supervisors.ibd
[01] ...done
[01] Copying ./awsind_resource_management/reviews.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/reviews.ibd
[01] ...done
[01] Copying ./awsind_resource_management/admin.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/admin.ibd
[01] ...done
[01] Copying ./awsind_resource_management/queue_types.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/queue_types.ibd
[01] ...done
[01] Copying ./awsind_resource_management/_apps_old.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/_apps_old.ibd
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
[01] ...done
[01] Copying ./awsind_resource_management/auth_user.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/auth_user.ibd
[01] ...done
[01] Copying ./awsind_resource_management/apps.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/apps.ibd
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620108746)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620141867)
>> log scanned up to (266620142335)
>> log scanned up to (266620142335)
>> log scanned up to (266620142805)
>> log scanned up to (266620143700)
>> log scanned up to (266620144979)
>> log scanned up to (266620146775)
>> log scanned up to (266620148131)
>> log scanned up to (266620293223)
>> log scanned up to (266620295042)
>> log scanned up to (266620299892)
>> log scanned up to (266620301709)
>> log scanned up to (266620303056)
>> log scanned up to (266620304825)
>> log scanned up to (266620306200)
>> log scanned up to (266620308093)
>> log scanned up to (266620309926)
>> log scanned up to (266620311297)
>> log scanned up to (266620313116)
>> log scanned up to (266620314826)
>> log scanned up to (266620316656)
>> log scanned up to (266620318041)
>> log scanned up to (266620320027)
>> log scanned up to (266620321831)
>> log scanned up to (266620323190)
>> log scanned up to (266620325025)
>> log scanned up to (266620326374)
>> log scanned up to (266620328194)
>> log scanned up to (266620329568)
>> log scanned up to (266620331382)
>> log scanned up to (266620333213)
>> log scanned up to (266620334564)
>> log scanned up to (266620336404)
>> log scanned up to (266620337769)
>> log scanned up to (266620339594)
>> log scanned up to (266620341425)
>> log scanned up to (266620342813)
>> log scanned up to (266620344648)
>> log scanned up to (266620346016)
>> log scanned up to (266620347829)
>> log scanned up to (266620349204)
>> log scanned up to (266620351048)
>> log scanned up to (266620352840)
>> log scanned up to (266620354249)
>> log scanned up to (266620356085)
>> log scanned up to (266620357446)
>> log scanned up to (266620359293)
>> log scanned up to (266620360637)
>> log scanned up to (266620362509)
>> log scanned up to (266620364369)
>> log scanned up to (266620365729)
>> log scanned up to (266620367575)
>> log scanned up to (266620410400)
>> log scanned up to (266620412225)
>> log scanned up to (266620413584)
>> log scanned up to (266620415864)
>> log scanned up to (266620417663)
>> log scanned up to (266620419037)
>> log scanned up to (266620420870)
>> log scanned up to (266620422241)
>> log scanned up to (266620424067)
>> log scanned up to (266620425465)
>> log scanned up to (266620426839)
>> log scanned up to (266620426839)
>> log scanned up to (266620428552)
>> log scanned up to (266620430368)
[01] ...done
[01] Copying ./awsind_resource_management/appTrackingUrl.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/appTrackingUrl.ibd
[01] ...done
[01] Copying ./awsind_resource_management/bills.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/bills.ibd
>> log scanned up to (266620431271)
[01] ...done
[01] Copying ./awsind_resource_management/cluster_availability.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/cluster_availability.ibd
[01] ...done
[01] Copying ./awsind_resource_management/containers.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/containers.ibd
[01] ...done
[01] Copying ./awsind_resource_management/operations.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/operations.ibd
[01] ...done
[01] Copying ./awsind_resource_management/bills_v2.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/bills_v2.ibd
[01] ...done
[01] Copying ./awsind_resource_management/xiaomi_teams.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/xiaomi_teams.ibd
[01] ...done
[01] Copying ./awsind_resource_management/auth_team.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/auth_team.ibd
[01] ...done
[01] Copying ./awsind_resource_management/__apps_old.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/__apps_old.ibd
>> log scanned up to (266620574530)
>> log scanned up to (266620574530)
>> log scanned up to (266620574530)
>> log scanned up to (266620577856)
>> log scanned up to (266620579134)
>> log scanned up to (266620580930)
>> log scanned up to (266620582722)
>> log scanned up to (266620584094)
[01] ...done
[01] Copying ./awsind_resource_management/containers_summary.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/containers_summary.ibd
[01] ...done
[01] Copying ./awsind_resource_management/clusters.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/clusters.ibd
[01] ...done
[01] Copying ./awsind_resource_management/queues.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/queues.ibd
[01] ...done
[01] Copying ./awsind_resource_management/cluster_state.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/cluster_state.ibd
>> log scanned up to (266620585450)
[01] ...done
[01] Copying ./awsind_resource_management/bills_v3.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/bills_v3.ibd
>> log scanned up to (266620586840)
[01] ...done
[01] Copying ./awsind_resource_management/schedules.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/schedules.ibd
[01] ...done
[01] Copying ./awsind_resource_management/monitor.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/monitor.ibd
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620587297)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620628704)
>> log scanned up to (266620629172)
>> log scanned up to (266620629172)
>> log scanned up to (266620629642)
>> log scanned up to (266620630111)
>> log scanned up to (266620631817)
>> log scanned up to (266620633169)
>> log scanned up to (266620634969)
>> log scanned up to (266620636793)
>> log scanned up to (266620638164)
>> log scanned up to (266620786540)
>> log scanned up to (266620788115)
>> log scanned up to (266620789920)
>> log scanned up to (266620795015)
>> log scanned up to (266620796374)
>> log scanned up to (266620798267)
>> log scanned up to (266620799660)
>> log scanned up to (266620801471)
>> log scanned up to (266620803290)
>> log scanned up to (266620804681)
>> log scanned up to (266620806511)
>> log scanned up to (266620808357)
>> log scanned up to (266620809720)
>> log scanned up to (266620811670)
>> log scanned up to (266620813045)
>> log scanned up to (266620814880)
>> log scanned up to (266620816673)
>> log scanned up to (266620818049)
>> log scanned up to (266620819862)
>> log scanned up to (266620821237)
>> log scanned up to (266620823068)
>> log scanned up to (266620824893)
>> log scanned up to (266620826259)
>> log scanned up to (266620828073)
>> log scanned up to (266620829449)
>> log scanned up to (266620831280)
>> log scanned up to (266620833116)
[01] ...done
[01] Copying ./awsind_resource_management/cluster_apps.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/cluster_apps.ibd
[01] ...done
[01] Copying ./awsind_resource_management/appInfo.ibd to /home/work/tmp/2020-06-18_09-51-27/awsind_resource_management/appInfo.ibd
>> log scanned up to (266620834830)
>> log scanned up to (266620836643)
>> log scanned up to (266620838462)
>> log scanned up to (266620839829)
>> log scanned up to (266620841659)
>> log scanned up to (266620843022)
>> log scanned up to (266620844882)
>> log scanned up to (266620846711)
>> log scanned up to (266620848077)
>> log scanned up to (266620849912)
>> log scanned up to (266620851278)
>> log scanned up to (266620853139)
>> log scanned up to (266620854988)
>> log scanned up to (266620856371)
>> log scanned up to (266620858193)
>> log scanned up to (266620884446)
>> log scanned up to (266620885807)
>> log scanned up to (266620887624)
>> log scanned up to (266620888973)
>> log scanned up to (266620890927)
>> log scanned up to (266620892770)
>> log scanned up to (266620894127)
>> log scanned up to (266620895964)
>> log scanned up to (266620897341)
>> log scanned up to (266620899169)
>> log scanned up to (266620899637)
>> log scanned up to (266620899637)
>> log scanned up to (266620901350)
>> log scanned up to (266620904291)
>> log scanned up to (266620905672)
>> log scanned up to (266620905672)
>> log scanned up to (266621049461)
>> log scanned up to (266621051165)
>> log scanned up to (266621053396)
>> log scanned up to (266621058063)
>> log scanned up to (266621060724)
>> log scanned up to (266621062087)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621063465)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621175048)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194446)
>> log scanned up to (266621194914)
>> log scanned up to (266621194914)
>> log scanned up to (266621195384)
>> log scanned up to (266621197124)
>> log scanned up to (266621198906)
>> log scanned up to (266621337790)
>> log scanned up to (266621339577)
>> log scanned up to (266621344739)
>> log scanned up to (266621346089)
>> log scanned up to (266621347919)
>> log scanned up to (266621349252)
>> log scanned up to (266621351033)
>> log scanned up to (266621352381)
>> log scanned up to (266621354274)
>> log scanned up to (266621356128)
>> log scanned up to (266621357485)
>> log scanned up to (266621359299)
>> log scanned up to (266621360696)
>> log scanned up to (266621362529)
>> log scanned up to (266621364365)
>> log scanned up to (266621365734)
>> log scanned up to (266621367538)
>> log scanned up to (266621369068)
>> log scanned up to (266621370864)
>> log scanned up to (266621372231)
>> log scanned up to (266621374069)
>> log scanned up to (266621375876)
>> log scanned up to (266621377256)
>> log scanned up to (266621379087)
>> log scanned up to (266621380455)
>> log scanned up to (266621382290)
>> log scanned up to (266621384087)
>> log scanned up to (266621385475)
>> log scanned up to (266621387307)
>> log scanned up to (266621388670)
>> log scanned up to (266621390502)
>> log scanned up to (266621391888)
>> log scanned up to (266621393695)
>> log scanned up to (266621395528)
>> log scanned up to (266621396890)
>> log scanned up to (266621398711)
>> log scanned up to (266621400105)
>> log scanned up to (266621401952)
>> log scanned up to (266621403317)
>> log scanned up to (266621405138)
>> log scanned up to (266621406961)
>> log scanned up to (266621408363)
>> log scanned up to (266621410226)
>> log scanned up to (266621411597)
>> log scanned up to (266621413434)
>> log scanned up to (266621449151)
>> log scanned up to (266621450536)
>> log scanned up to (266621452351)
>> log scanned up to (266621453706)
>> log scanned up to (266621455501)
>> log scanned up to (266621457038)
>> log scanned up to (266621458840)
>> log scanned up to (266621460672)
>> log scanned up to (266621462069)
>> log scanned up to (266621463896)
>> log scanned up to (266621465270)
>> log scanned up to (266621465270)
>> log scanned up to (266621465698)
>> log scanned up to (266621467427)
>> log scanned up to (266621468799)
>> log scanned up to (266621469726)
>> log scanned up to (266621469726)
>> log scanned up to (266621606494)
>> log scanned up to (266621606494)
>> log scanned up to (266621608203)
>> log scanned up to (266621613338)
>> log scanned up to (266621614686)
>> log scanned up to (266621616504)
>> log scanned up to (266621617883)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619261)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621619580)
>> log scanned up to (266621649761)
>> log scanned up to (266621649761)
>> log scanned up to (266621649761)
>> log scanned up to (266621649761)
>> log scanned up to (266621649761)
>> log scanned up to (266621649761)
>> log scanned up to (266621650097)
>> log scanned up to (266621650097)
>> log scanned up to (266621650097)
>> log scanned up to (266621650565)
>> log scanned up to (266621650565)
>> log scanned up to (266621650565)
>> log scanned up to (266621651265)
>> log scanned up to (266621652750)
>> log scanned up to (266621654809)
>> log scanned up to (266621688647)
>> log scanned up to (266621795149)
>> log scanned up to (266621796726)
>> log scanned up to (266621801831)
>> log scanned up to (266621803458)
>> log scanned up to (266621804995)
>> log scanned up to (266621806574)
>> log scanned up to (266621808155)
>> log scanned up to (266621810040)
>> log scanned up to (266621811683)
>> log scanned up to (266621813260)
>> log scanned up to (266621814604)
>> log scanned up to (266621816454)
>> log scanned up to (266621818284)
>> log scanned up to (266621819669)
>> log scanned up to (266621821509)
>> log scanned up to (266621822850)
>> log scanned up to (266621824825)
>> log scanned up to (266621826191)
>> log scanned up to (266621828010)
>> log scanned up to (266621829830)
>> log scanned up to (266621831204)
>> log scanned up to (266621833018)
>> log scanned up to (266621834389)
>> log scanned up to (266621836381)
>> log scanned up to (266621838205)
>> log scanned up to (266621839570)
>> log scanned up to (266621841395)
>> log scanned up to (266621842774)
>> log scanned up to (266621844614)
>> log scanned up to (266621845969)
>> log scanned up to (266621847807)
>> log scanned up to (266621849636)
>> log scanned up to (266621850995)
>> log scanned up to (266621852839)
>> log scanned up to (266621854178)
>> log scanned up to (266621856040)
>> log scanned up to (266621857892)
>> log scanned up to (266621859237)
>> log scanned up to (266621861084)
>> log scanned up to (266621862444)
>> log scanned up to (266621864300)
>> log scanned up to (266621865709)
>> log scanned up to (266621867536)
>> log scanned up to (266621869366)
>> log scanned up to (266621916048)
>> log scanned up to (266621917889)
>> log scanned up to (266621919248)
>> log scanned up to (266621921047)
>> log scanned up to (266621922846)
>> log scanned up to (266621924382)
>> log scanned up to (266621926209)
>> log scanned up to (266621927580)
>> log scanned up to (266621929406)
>> log scanned up to (266621930804)
>> log scanned up to (266621932178)
>> log scanned up to (266621932178)
>> log scanned up to (266621933022)
>> log scanned up to (266621934786)
>> log scanned up to (266621936161)
>> log scanned up to (266622078210)
>> log scanned up to (266622078210)
>> log scanned up to (266622078210)
>> log scanned up to (266622079500)
>> log scanned up to (266622080815)
>> log scanned up to (266622085936)
>> log scanned up to (266622087770)
>> log scanned up to (266622089126)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622090973)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622091310)
>> log scanned up to (266622132062)
>> log scanned up to (266622132062)
[01] ...done
[01] Copying ./owl2_azmb/django_admin_log.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/django_admin_log.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_task.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_task.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_group.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_group.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_cluster.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_cluster.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_pegasus_partition_to_task.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_pegasus_partition_to_task.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_permission.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_permission.ibd
[01] ...done
[01] Copying ./owl2_azmb/django_migrations.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/django_migrations.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_user_groups.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_user_groups.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_cassandracluster.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_cassandracluster.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_group_permissions.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_group_permissions.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_user.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_user.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_pegasus_partition_ballots.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_pegasus_partition_ballots.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_pegasus_tasks_status.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_pegasus_tasks_status.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_namenode.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_namenode.ibd
[01] ...done
[01] Copying ./owl2_azmb/auth_user_user_permissions.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/auth_user_user_permissions.ibd
[01] ...done
[01] Copying ./owl2_azmb/django_session.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/django_session.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_namespace.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_namespace.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_pegasus_partition.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_pegasus_partition.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_job.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_job.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_datanode.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_datanode.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_service.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_service.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_replication.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_replication.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_table.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_table.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_cassandranode.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_cassandranode.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_quota.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_quota.ibd
[01] ...done
[01] Copying ./owl2_azmb/django_content_type.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/django_content_type.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_pegasus_app.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_pegasus_app.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_replicationonrs.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_replicationonrs.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_hbasecluster.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_hbasecluster.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_region.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_region.ibd
[01] ...done
[01] Copying ./owl2_azmb/monitor_regionserver.ibd to /home/work/tmp/2020-06-18_09-51-27/owl2_azmb/monitor_regionserver.ibd
[01] ...done
[01] Copying ./dba_metadata/karma.ibd to /home/work/tmp/2020-06-18_09-51-27/dba_metadata/karma.ibd
[01] ...done
[01] Copying ./dba_metadata/cluster.ibd to /home/work/tmp/2020-06-18_09-51-27/dba_metadata/cluster.ibd
[01] ...done
[01] Copying ./sparksql/sparksql_queue_review.ibd to /home/work/tmp/2020-06-18_09-51-27/sparksql/sparksql_queue_review.ibd
[01] ...done
[01] Copying ./sparksql/grant_history.ibd to /home/work/tmp/2020-06-18_09-51-27/sparksql/grant_history.ibd
[01] ...done
[01] Copying ./sparksql/sparksql_queue.ibd to /home/work/tmp/2020-06-18_09-51-27/sparksql/sparksql_queue.ibd
[01] ...done
[01] Copying ./sparksql/history.ibd to /home/work/tmp/2020-06-18_09-51-27/sparksql/history.ibd
[01] ...done
[01] Copying ./sparksql/kudu_table_reviews.ibd to /home/work/tmp/2020-06-18_09-51-27/sparksql/kudu_table_reviews.ibd
[01] ...done
[01] Copying ./hbase_manager/export_snapshot_task.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/export_snapshot_task.ibd
[01] ...done
[01] Copying ./hbase_manager/t_cluster_report.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_cluster_report.ibd
[01] ...done
[01] Copying ./hbase_manager/t_table_report.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_table_report.ibd
[01] ...done
[01] Copying ./hbase_manager/PitrPeers.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/PitrPeers.ibd
[01] ...done
[01] Copying ./hbase_manager/PitrTables.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/PitrTables.ibd
[01] ...done
[01] Copying ./hbase_manager/t_cluster.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_cluster.ibd
>> log scanned up to (266622132062)
[01] ...done
[01] Copying ./hbase_manager/SnapshotVerification.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/SnapshotVerification.ibd
[01] ...done
[01] Copying ./hbase_manager/valid_user.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/valid_user.ibd
[01] ...done
[01] Copying ./hbase_manager/table_health.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/table_health.ibd
[01] ...done
[01] Copying ./hbase_manager/cluster_cost.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/cluster_cost.ibd
[01] ...done
[01] Copying ./hbase_manager/t_namespace.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_namespace.ibd
[01] ...done
[01] Copying ./hbase_manager/t_table.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_table.ibd
[01] ...done
[01] Copying ./hbase_manager/t_namespace_report.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/t_namespace_report.ibd
[01] ...done
[01] Copying ./hbase_manager/SnapshotPolicy.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/SnapshotPolicy.ibd
[01] ...done
[01] Copying ./hbase_manager/SnapshotTrack.ibd to /home/work/tmp/2020-06-18_09-51-27/hbase_manager/SnapshotTrack.ibd
[01] ...done
xtrabackup: Creating suspend file '/home/work/tmp/2020-06-18_09-51-27/xtrabackup_suspended_2' with pid '2130'
200618 10:00:03 innobackupex: Continuing after ibbackup has suspended
200618 10:00:03 innobackupex: Executing FLUSH TABLES WITH READ LOCK...
200618 10:00:03 innobackupex: All tables locked and flushed to disk
200618 10:00:03 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/home/work/mysql/data/'
innobackupex: Backing up files '/home/work/mysql/data//galaxy_availability/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (23 files)
innobackupex: Backing up files '/home/work/mysql/data//druid/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (11 files)
innobackupex: Backing up files '/home/work/mysql/data//awsind_resource_management/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (25 files)
>> log scanned up to (266622132062)
innobackupex: Backing up files '/home/work/mysql/data//owl2_azmb/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (32 files)
innobackupex: Backing up file '/home/work/mysql/data//dba_metadata/karma.frm'
innobackupex: Backing up file '/home/work/mysql/data//dba_metadata/cluster.frm'
innobackupex: Backing up file '/home/work/mysql/data//dba_metadata/db.opt'
innobackupex: Backing up files '/home/work/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)
innobackupex: Backing up file '/home/work/mysql/data//sparksql/grant_history.frm'
innobackupex: Backing up file '/home/work/mysql/data//sparksql/sparksql_queue_review.frm'
innobackupex: Backing up file '/home/work/mysql/data//sparksql/kudu_table_reviews.frm'
innobackupex: Backing up file '/home/work/mysql/data//sparksql/history.frm'
innobackupex: Backing up file '/home/work/mysql/data//sparksql/db.opt'
innobackupex: Backing up file '/home/work/mysql/data//sparksql/sparksql_queue.frm'
innobackupex: Backing up files '/home/work/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
innobackupex: Backing up files '/home/work/mysql/data//hbase_manager/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (16 files)
200618 10:00:04 innobackupex: Finished backing up non-InnoDB tables and files
200618 10:00:04 innobackupex: Failed to get master binlog coordinates from SHOW SLAVE STATUS
200618 10:00:04 innobackupex: This means that the server is not a replication slave. Ignoring the --slave-info option
200618 10:00:04 innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
200618 10:00:04 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '266622099673'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (266622132062)
xtrabackup: Creating suspend file '/home/work/tmp/2020-06-18_09-51-27/xtrabackup_log_copied' with pid '2130'
xtrabackup: Transaction log of lsn (266620104647) to (266622132062) was copied.
200618 10:00:05 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/home/work/tmp/2020-06-18_09-51-27'
innobackupex: MySQL binlog position: filename 'mysql-bin.000550', position 794971537
200618 10:00:05 innobackupex: Connection to database server closed
200618 10:00:05 innobackupex: completed OK!
###############################################################################################################
备份完毕。
###############################################################################################################
[work@igoodful tmp]$ ls
2020-06-18_09-51-27
[work@igoodful tmp]$ cd 2020-06-18_09-51-27/
[work@igoodful 2020-06-18_09-51-27]$ ls
awsind_resource_management backup-my.cnf dba_metadata druid galaxy_availability hbase_manager ibdata1 mysql owl2_azmb performance_schema sparksql xtrabackup_binlog_info xtrabackup_checkpoints xtrabackup_info xtrabackup_logfile
##################################################################################################################
###################################################################################################################
[work@igoodful 2020-06-18_09-51-27]$ innobackupex --apply-log .
####################################################################################################################
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
200618 10:02:01 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
200618 10:02:01 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/work/tmp/2020-06-18_09-51-27/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/home/work/tmp/2020-06-18_09-51-27
xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: cd to /home/work/tmp/2020-06-18_09-51-27
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2277376, start_lsn=(266620104647)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 2277376
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 2277376
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 266620104647
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages
InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 266622132062 (100%)
InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 794971537, file name /home/work/mysql/log/mysql-bin.000550
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.22 started; log sequence number 266622132062
[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 794971537, file name /home/work/mysql/log/mysql-bin.000550
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 266622132466
200618 10:02:04 innobackupex: Restarting xtrabackup with command: xtrabackup --defaults-file="/home/work/tmp/2020-06-18_09-51-27/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/home/work/tmp/2020-06-18_09-51-27
for creating ib_logfile*
xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: cd to /home/work/tmp/2020-06-18_09-51-27
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 268435456
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 268435456
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Setting log file ./ib_logfile101 size to 256 MB
InnoDB: Progress in MB: 100 200
InnoDB: Setting log file ./ib_logfile1 size to 256 MB
InnoDB: Progress in MB: 100 200
InnoDB: Setting log file ./ib_logfile2 size to 256 MB
InnoDB: Progress in MB: 100 200
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=266622132466
InnoDB: Highest supported file format is Barracuda.
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.22 started; log sequence number 266622132748
[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 794971537, file name /home/work/mysql/log/mysql-bin.000550
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 266622133278
200618 10:02:09 innobackupex: completed OK!
######################################################################
日志应用完毕,此时的备份就可以完全用于恢复了。
######################################################################
[work@igoodful 2020-06-18_09-51-27]$