xtrabackup8.0全备过程

我不是女神ヾ 2022-01-11 12:25 493阅读 0赞

[  
][Link 1]

> 欢迎关注MySQL 8.0必知必会系列课程。
> 
> ####     MySQL8.0必知必会-自动化部署              [https://edu.51cto.com/course/16368.html][https_edu.51cto.com_course_16368.html] ####
> 
> ####     MySQL8.0必知必会之参数标准化配置       [https://edu.51cto.com/course/16358.html][https_edu.51cto.com_course_16358.html] ####

[![image][]][Link 1]

1. 实时备份redo log

> •xtrabackup开启xtrabackup\_log监控线程
> 
> •记录开始的LSN，并实时监测redo log文件的变化
> 
> •将备份过程中新写入到事务日志中的日志页拷贝至xtrabackup\_logfile文件中；

2.拷贝innodb文件

> •开启redo log备份后，同时开启xtrabackup拷贝线程，开始拷贝innodb文件。
> 
> •拷贝顺序：
> 
> •ibdata1, sys\_config.ibd, mysql.ibd,以及其他datadir目录的ibd文件
> 
> •数据库目录下的ibd，test库、employees、sakila等
> 
> •undo文件

3.复制innodb文件结束后，LOCK TABLES FOR BACKUP

> •锁定非innodb表

4.拷贝非innodb文件

> •拷贝mysql、p\_s和其他库下的.frm,.MRG,.MYD,.MYI,.ARM,.ARZ,.CSM,.CSV,.sdi 和.par等类型的文件。

5. 获取LSN和binary log position

> •此时文件备份结束，需要获取LSN和binlog位置
> 
> •LOCK BINLOG FOR BACKUP
> 
> •用于阻止所有可能更改binlog位置的操作
> 
> •然后完成复制REDO日志文件并获取binlog坐标
> 
> •从p\_s.log\_status中获取信息
> 
> •binlog记录到xtrabackup\_binlog\_info文件中
> 
> •LSN记录到xtrabackup\_checkpoints

6.FLUSH NO\_WRITE\_TO\_BINLOG ENGINE LOGS

> •关闭并重新打开，已安装存储引擎的任何可刷新日志，不记录到binlog。
> 
> •这会导致InnoDB将其日志刷新到磁盘。

7.停止xtrabackup\_log线程

8.解锁tables、binlog

9.备份其他信息

> •Copying ib\_buffer\_pool
> 
> •Writing backup-my.cnf
> 
> •Writing xtrabackup\_info

10.binlog位置将打印到STDERR，如果一切正常，xtrabackup将退出返回0。

*  \[mysql@ark ~\]$ xtrabackup --user=root --password=mysql --socket=/mysqldb/db\_ark/mysql.sock --backup --target-dir=/home/mysql/xtrabackup/full  
    xtrabackup: recognized client arguments: --user=root --password=\* --socket=/mysqldb/db\_ark/mysql.sock --backup=1 --target-dir=/home/mysql/xtrabackup/full  
    xtrabackup version 8.0.4 based on MySQL server 8.0.13 Linux (x86\_64) (revision id: c2c0777)  
    190125 06:04:36  version\_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql\_read\_default\_group=xtrabackup;mysql\_socket=/mysqldb/db\_ark/mysql.sock' as 'root'  (using password: YES).  
    190125 06:04:36  version\_check Connected to MySQL server  
    190125 06:04:36  version\_check Executing a version check against the server...  
    190125 06:04:40  version\_check Done.  
    190125 06:04:40 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /mysqldb/db\_ark/mysql.sock  
    Using server version 8.0.13-debug  
    xtrabackup: uses posix\_fadvise().  
    xtrabackup: cd to /mysqldb/db\_ark/data/  
    xtrabackup: open files limit requested 0, set to 65535  
    xtrabackup: using the following InnoDB configuration:  
    xtrabackup:   innodb\_data\_home\_dir = .  
    xtrabackup:   innodb\_data\_file\_path = ibdata1:12M:autoextend  
    xtrabackup:   innodb\_log\_group\_home\_dir = ./  
    xtrabackup:   innodb\_log\_files\_in\_group = 2  
    xtrabackup:   innodb\_log\_file\_size = 134217728  
    Number of pools: 1  
    **190125 06:04:40 >> log scanned up to (801020069)**  
    Opened 2 existing undo tablespaces.  
    xtrabackup: Generating a list of tablespaces  
    Allocated tablespace ID 1 for sys/sys\_config, old maximum was 0  
    190125 06:04:40 \[01\] Copying ./ibdata1 to /home/mysql/xtrabackup/full/ibdata1  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./sys/sys\_config.ibd to /home/mysql/xtrabackup/full/sys/sys\_config.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./ts1.ibd to /home/mysql/xtrabackup/full/ts1.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./mysql.ibd to /home/mysql/xtrabackup/full/mysql.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./test/t1.ibd to /home/mysql/xtrabackup/full/test/t1.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./test/t2.ibd to /home/mysql/xtrabackup/full/test/t2.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./test/t3.ibd to /home/mysql/xtrabackup/full/test/t3.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./test/userinfo.ibd to /home/mysql/xtrabackup/full/test/userinfo.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./employees/employees.ibd to /home/mysql/xtrabackup/full/employees/employees.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./employees/departments.ibd to /home/mysql/xtrabackup/full/employees/departments.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./employees/dept\_manager.ibd to /home/mysql/xtrabackup/full/employees/dept\_manager.ibd  
    190125 06:04:40 \[01\]        ...done  
    190125 06:04:40 \[01\] Copying ./employees/dept\_emp.ibd to /home/mysql/xtrabackup/full/employees/dept\_emp.ibd  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:41 \[01\] Copying ./employees/titles.ibd to /home/mysql/xtrabackup/full/employees/titles.ibd  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:41 \[01\] Copying ./employees/salaries.ibd to /home/mysql/xtrabackup/full/employees/salaries.ibd  
    190125 06:04:41 >> log scanned up to (801020069)  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:41 \[01\] Copying ./db1/db1.ibd to /home/mysql/xtrabackup/full/db1/db1.ibd  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:41 \[01\] Copying ./undo\_002 to /home/mysql/xtrabackup/full/undo\_002  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:41 \[01\] Copying ./undo\_001 to /home/mysql/xtrabackup/full/undo\_001  
    190125 06:04:41 \[01\]        ...done  
    190125 06:04:42 >> log scanned up to (801020069)  
    **190125 06:04:42 Starting to backup non-InnoDB tables and files**  
    190125 06:04:42 \[01\] Copying mysql/general\_log\_197.sdi to /home/mysql/xtrabackup/full/mysql/general\_log\_197.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying mysql/general\_log.CSM to /home/mysql/xtrabackup/full/mysql/general\_log.CSM  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying mysql/general\_log.CSV to /home/mysql/xtrabackup/full/mysql/general\_log.CSV  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying mysql/slow\_log\_198.sdi to /home/mysql/xtrabackup/full/mysql/slow\_log\_198.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying mysql/slow\_log.CSM to /home/mysql/xtrabackup/full/mysql/slow\_log.CSM  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying mysql/slow\_log.CSV to /home/mysql/xtrabackup/full/mysql/slow\_log.CSV  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/cond\_instances\_74.sdi to /home/mysql/xtrabackup/full/performance\_schema/cond\_instances\_74.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_cur\_75.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_cur\_75.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_his\_76.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_his\_76.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_his\_77.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_his\_77.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_78.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_78.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_79.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_79.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_80.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_80.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_81.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_81.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_82.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_82.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_waits\_sum\_83.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_waits\_sum\_83.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/file\_instances\_84.sdi to /home/mysql/xtrabackup/full/performance\_schema/file\_instances\_84.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/file\_summary\_by\_\_85.sdi to /home/mysql/xtrabackup/full/performance\_schema/file\_summary\_by\_\_85.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/file\_summary\_by\_\_86.sdi to /home/mysql/xtrabackup/full/performance\_schema/file\_summary\_by\_\_86.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/host\_cache\_87.sdi to /home/mysql/xtrabackup/full/performance\_schema/host\_cache\_87.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/mutex\_instances\_88.sdi to /home/mysql/xtrabackup/full/performance\_schema/mutex\_instances\_88.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/objects\_summary\_\_89.sdi to /home/mysql/xtrabackup/full/performance\_schema/objects\_summary\_\_89.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/performance\_time\_90.sdi to /home/mysql/xtrabackup/full/performance\_schema/performance\_time\_90.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/rwlock\_instances\_91.sdi to /home/mysql/xtrabackup/full/performance\_schema/rwlock\_instances\_91.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/setup\_actors\_92.sdi to /home/mysql/xtrabackup/full/performance\_schema/setup\_actors\_92.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/setup\_consumers\_93.sdi to /home/mysql/xtrabackup/full/performance\_schema/setup\_consumers\_93.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/setup\_instrument\_94.sdi to /home/mysql/xtrabackup/full/performance\_schema/setup\_instrument\_94.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/setup\_objects\_95.sdi to /home/mysql/xtrabackup/full/performance\_schema/setup\_objects\_95.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/setup\_threads\_96.sdi to /home/mysql/xtrabackup/full/performance\_schema/setup\_threads\_96.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/table\_io\_waits\_s\_97.sdi to /home/mysql/xtrabackup/full/performance\_schema/table\_io\_waits\_s\_97.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/table\_io\_waits\_s\_98.sdi to /home/mysql/xtrabackup/full/performance\_schema/table\_io\_waits\_s\_98.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/table\_lock\_waits\_99.sdi to /home/mysql/xtrabackup/full/performance\_schema/table\_lock\_waits\_99.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/threads\_100.sdi to /home/mysql/xtrabackup/full/performance\_schema/threads\_100.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_cu\_101.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_cu\_101.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_hi\_102.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_hi\_102.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_hi\_103.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_hi\_103.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_su\_104.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_su\_104.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_su\_105.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_su\_105.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_su\_106.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_su\_106.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_su\_107.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_su\_107.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_stages\_su\_108.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_stages\_su\_108.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_109.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_109.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_110.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_110.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_111.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_111.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_112.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_112.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_113.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_113.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_114.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_114.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_115.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_115.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_116.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_116.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_117.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_117.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_118.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_118.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_119.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_119.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_statement\_120.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_statement\_120.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_121.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_121.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_122.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_122.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_123.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_123.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_124.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_124.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_125.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_125.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_126.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_126.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_127.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_127.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_transacti\_128.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_transacti\_128.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_errors\_su\_129.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_errors\_su\_129.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_errors\_su\_130.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_errors\_su\_130.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_errors\_su\_131.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_errors\_su\_131.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_errors\_su\_132.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_errors\_su\_132.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/events\_errors\_su\_133.sdi to /home/mysql/xtrabackup/full/performance\_schema/events\_errors\_su\_133.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/users\_134.sdi to /home/mysql/xtrabackup/full/performance\_schema/users\_134.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/accounts\_135.sdi to /home/mysql/xtrabackup/full/performance\_schema/accounts\_135.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/hosts\_136.sdi to /home/mysql/xtrabackup/full/performance\_schema/hosts\_136.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/socket\_instances\_137.sdi to /home/mysql/xtrabackup/full/performance\_schema/socket\_instances\_137.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/socket\_summary\_b\_138.sdi to /home/mysql/xtrabackup/full/performance\_schema/socket\_summary\_b\_138.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/socket\_summary\_b\_139.sdi to /home/mysql/xtrabackup/full/performance\_schema/socket\_summary\_b\_139.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/session\_connect\_\_140.sdi to /home/mysql/xtrabackup/full/performance\_schema/session\_connect\_\_140.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/session\_account\_\_141.sdi to /home/mysql/xtrabackup/full/performance\_schema/session\_account\_\_141.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/memory\_summary\_g\_142.sdi to /home/mysql/xtrabackup/full/performance\_schema/memory\_summary\_g\_142.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/memory\_summary\_b\_143.sdi to /home/mysql/xtrabackup/full/performance\_schema/memory\_summary\_b\_143.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/memory\_summary\_b\_144.sdi to /home/mysql/xtrabackup/full/performance\_schema/memory\_summary\_b\_144.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/memory\_summary\_b\_145.sdi to /home/mysql/xtrabackup/full/performance\_schema/memory\_summary\_b\_145.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/memory\_summary\_b\_146.sdi to /home/mysql/xtrabackup/full/performance\_schema/memory\_summary\_b\_146.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/table\_handles\_147.sdi to /home/mysql/xtrabackup/full/performance\_schema/table\_handles\_147.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/metadata\_locks\_148.sdi to /home/mysql/xtrabackup/full/performance\_schema/metadata\_locks\_148.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/data\_locks\_149.sdi to /home/mysql/xtrabackup/full/performance\_schema/data\_locks\_149.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/data\_lock\_waits\_150.sdi to /home/mysql/xtrabackup/full/performance\_schema/data\_lock\_waits\_150.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_conn\_151.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_conn\_151.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_grou\_152.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_grou\_152.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_conn\_153.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_conn\_153.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_154.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_154.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_155.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_155.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_156.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_156.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_157.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_157.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_grou\_158.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_grou\_158.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_159.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_159.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/replication\_appl\_160.sdi to /home/mysql/xtrabackup/full/performance\_schema/replication\_appl\_160.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/log\_status\_161.sdi to /home/mysql/xtrabackup/full/performance\_schema/log\_status\_161.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/prepared\_stateme\_162.sdi to /home/mysql/xtrabackup/full/performance\_schema/prepared\_stateme\_162.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/user\_variables\_b\_163.sdi to /home/mysql/xtrabackup/full/performance\_schema/user\_variables\_b\_163.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/status\_by\_accoun\_164.sdi to /home/mysql/xtrabackup/full/performance\_schema/status\_by\_accoun\_164.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/status\_by\_host\_165.sdi to /home/mysql/xtrabackup/full/performance\_schema/status\_by\_host\_165.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/status\_by\_thread\_166.sdi to /home/mysql/xtrabackup/full/performance\_schema/status\_by\_thread\_166.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/status\_by\_user\_167.sdi to /home/mysql/xtrabackup/full/performance\_schema/status\_by\_user\_167.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/global\_status\_168.sdi to /home/mysql/xtrabackup/full/performance\_schema/global\_status\_168.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/session\_status\_169.sdi to /home/mysql/xtrabackup/full/performance\_schema/session\_status\_169.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/variables\_by\_thr\_170.sdi to /home/mysql/xtrabackup/full/performance\_schema/variables\_by\_thr\_170.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/global\_variables\_171.sdi to /home/mysql/xtrabackup/full/performance\_schema/global\_variables\_171.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/session\_variable\_172.sdi to /home/mysql/xtrabackup/full/performance\_schema/session\_variable\_172.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/variables\_info\_173.sdi to /home/mysql/xtrabackup/full/performance\_schema/variables\_info\_173.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/persisted\_variab\_174.sdi to /home/mysql/xtrabackup/full/performance\_schema/persisted\_variab\_174.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[01\] Copying performance\_schema/user\_defined\_fun\_175.sdi to /home/mysql/xtrabackup/full/performance\_schema/user\_defined\_fun\_175.sdi  
    190125 06:04:42 \[01\]        ...done  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/abc//db.opt  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/arkcontrol//db.opt  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/db2//db.opt  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/db3//db.opt  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/db4//db.opt  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 Finished backing up non-InnoDB tables and files  
    **190125 06:04:42 Selecting LSN and binary log position from p\_s.log\_status  
    190125 06:04:42 \[00\] Writing /home/mysql/xtrabackup/full/xtrabackup\_binlog\_info**  
    190125 06:04:42 \[00\]        ...done  
    190125 06:04:42 Executing FLUSH NO\_WRITE\_TO\_BINLOG ENGINE LOGS...  
    xtrabackup: The latest check point (for incremental): '801020069'  
    xtrabackup: Stopping log copying thread at LSN 801020069.  
    .190125 06:04:42 >> log scanned up to (801020069)  
    190125 06:04:42 >> log scanned up to (801020069)

**190125 06:04:43 All tables unlocked**  
190125 06:04:43 \[00\] Copying ib\_buffer\_pool to /home/mysql/xtrabackup/full/ib\_buffer\_pool  
190125 06:04:43 \[00\]        ...done  
190125 06:04:43 Backup created in directory '/home/mysql/xtrabackup/full/'  
MySQL binlog position: filename 'binlog.000009', position '195', GTID of the last change 'c04f9267-ddc0-11e8-8f28-000c299deb99:1-386'  
190125 06:04:43 \[00\] Writing /home/mysql/xtrabackup/full/backup-my.cnf  
190125 06:04:43 \[00\]        ...done  
190125 06:04:43 \[00\] Writing /home/mysql/xtrabackup/full/xtrabackup\_info  
190125 06:04:43 \[00\]        ...done  
 xtrabackup: Transaction log of lsn (801020069) to (801020069) was copied.  
190125 06:04:43 completed OK!  
\[mysql@ark ~\]$

转载于:https://blog.51cto.com/14136767/2347518

[Link 1]: https://s1.51cto.com/images/blog/201901/29/2cac181ab81264e099255ff46c094792.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=
[https_edu.51cto.com_course_16368.html]: https://edu.51cto.com/course/16368.html
[https_edu.51cto.com_course_16358.html]: https://edu.51cto.com/course/16358.html
[image]: https://s1.51cto.com/images/blog/201901/29/7584e6c37d41360a45b82d9ee31180d9.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=