XTRABACKUP(1) Percona XtraBackup XTRABACKUP(1) (NAME) xtrabackup - Percona XtraBackup 8.0 xtrabackup C InnoDB MySQL (link) . xtrabackup (point-in-time) InnoDB / XtraDB (schema) MyISAM . InnoDB (log) . MySQL . --backup --prepare . --stats --print-param . (OTHER TYPES OF BACKUPS) (Incremental Backups) xtrabackup . . . : MyRocks . Percona XtraBackup MyRocks . InnoDB ( ) LSN . LSN . LSN . LSN LSN . . LSN . Percona Server for MySQL changed page tracking . bitmap . xtrabackup . xtrabackup bitmap . --incremental-force-scan bitmap . . LSN --incremental-lsn . LSN LSN . . (Creating an Incremental Backup) . xtrabackup xtrabackup_checkpoints . to_lsn LSN . : $ xtrabackup --backup --target-dir=/data/backups/base --datadir=/var/lib/mysql/ xtrabackup_checkpoints : backup_type = full-backuped from_lsn = 0 to_lsn = 1291135 . : $ xtrabackup --backup --target-dir=/data/backups/inc1 \ --incremental-basedir=/data/backups/base --datadir=/var/lib/mysql/ /data/backups/inc1/ ibdata1.delta test/table1.ibd.delta . LSN 1291135 . xtrabackup_checkpoints : backup_type = incremental from_lsn = 1291135 to_lsn = 1291340 . : $ xtrabackup --backup --target-dir=/data/backups/inc2 \ --incremental-basedir=/data/backups/inc1 --datadir=/var/lib/mysql/ --prepare . : (committed) (log file) (uncommitted) (roll back) . . --apply-log-only . : --apply-log-only . . . : /data/backups/base /data/backups/inc1 /data/backups/inc2 --prepare : xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base : 101107 20:49:43 InnoDB: Shutdown completed; log sequence number 1291135 (log sequence number) to_lsn . . MySQL InnoDB (crash recovery) . (shut down) . : xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base \ --incremental-dir=/data/backups/inc1 /data/backups/base (roll forward) . redo log . /data/backups/base . : incremental backup from 1291135 is enabled. xtrabackup: cd to /data/backups/base/ xtrabackup: This target seems to be already prepared. xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1291340) Applying /data/backups/inc1/ibdata1.delta ... Applying /data/backups/inc1/test/table1.ibd.delta ... .... snip 101107 20:56:30 InnoDB: Shutdown completed; log sequence number 1291340 LSN . /data/backups/base . : () : xtrabackup --prepare --target-dir=/data/backups/base \ --incremental-dir=/data/backups/inc2 : --apply-log-only . --apply-log-only . --apply-log-only . InnoDB --prepare ..SS . : xtrabackup --copy-back --target-dir=BASE-DIR restoring_a_backup . xbstream xbstream . xbstream . BASE () . .INDENT 0.0 $ xtrabackup --backup --target-dir=/data/backups .INDENT 0.0 $ xtrabackup --backup --incremental-lsn=LSN-number --stream=xbstream --target-dir=./ > incremental.xbstream .INDENT 0.0 $ xbstream -x < incremental.xbstream .INDENT 0.0 $ xtrabackup --backup --incremental-lsn=LSN-number --stream=xbstream --target-dir=./ $ ssh user@hostname " cat - | xbstream -x -C > /backup-dir/" xtrabackup innodb_file_per_table . : 1. (regular expression) 2. 3. : copy back . (import) --copy-back. . . test t1 t2 . : xtrabackup . : o --tables o --tables-file o --databases o --databases-file --tables --tables xtrabackup . databasename.tablename . test : $ xtrabackup --backup --datadir=/var/lib/mysql --target-dir=/data/backups/ \ --tables="^test[.].*" test.t1 : $ xtrabackup --backup --datadir=/var/lib/mysql --target-dir=/data/backups/ \ --tables="^test[.]t1" --tables-file . . (case-sensitive) (regular expression) . (fully-qualified) databasename.tablename . $ echo "mydatabase.mytable" > /tmp/tables.txt $ xtrabackup --backup --tables-file=/tmp/tables.txt --databases --databases-file ` --databases` databasename[.tablename] . mysql sys performance_schema . xtrabackup --copy-back . : --prepare . $ xtrabackup --databases='mysql sys performance_schema test ...' --databases-file --databases-file databasename[.tablename] . (case-sensitive) . : --prepare . : --export : $ xtrabackup --prepare --export --target-dir=/path/to/partial/backup --prepare . data dictionary InnoDB .ibd . data dictionary InnoDB . Could not find any file associated with the tablespace ID: 5 Use --innodb-directories to find the tablespace files. If that fails then use --innodb-force-recovery=1 to ignore this and to permanently lose all changes to the missing tablespace(s). . (copy back) datadir <<>> ( mysql ) . : $ sudo mysql --initialize --user=mysql mysql tablespace : 2021-07-19T12:42:11.077200Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 4, name 'test1/t1', file './d2/test1.ibd' is missing! 2021-07-19T12:42:11.077300Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 4, name 'test1/t1', file './d2/test1.ibd' is missing! data dictionary DROP . : $ mkdir /var/lib/mysql/test1/d2 : mysql> DROP DATABASE d2; Query OK, 2 rows affected (0.5 sec) (Analyzing Table Statistics) xtrabackup InnoDB - (read-only) . --stats . --tables . --use-memory . () . . (log) --prepare . : table: test/table1, index: PRIMARY, space id: 12, root page 3 estimated statistics in dictionary: key vals: 25265338, leaf pages 497839, size pages 498304 real statistics: level 2 pages: pages=1, data=5395 bytes, data/pages=32% level 1 pages: pages=415, data=6471907 bytes, data/pages=95% leaf pages: recs=25958413, pages=497839, data=7492026403 bytes, data/pages=91% : o (index) . GEN_CLUST_INDEX (clustered index) PRIMARY KEY . o (dictionary) ANALYZE TABLE InnoDB (cardinality) (query optimizer) . o . o The level pages: . (leaf pages) . (root page) . o leaf pages . . o external pages: ( ) BLOB TEXT. o recs () . o pages . o data . o data/pages (data / (pages * PAGE_SIZE)) * 100% . (page headers footers) . MySQL Performance . (Script to Format Output) : tabulate-xtrabackup-stats.pl #!/usr/bin/env perl use strict; use warnings FATAL => 'all'; my $script_version = "0.1"; my $PG_SIZE = 16_384; # InnoDB defaults to 16k pages, change if needed. my ($cur_idx, $cur_tbl); my (%idx_stats, %tbl_stats); my ($max_tbl_len, $max_idx_len) = (0, 0); while ( my $line = <> ) { if ( my ($t, $i) = $line =~ m/table: (.*), index: (.*), space id:/ ) { $t =~ s!/!.!; $cur_tbl = $t; $cur_idx = $i; if ( length($i) > $max_idx_len ) { $max_idx_len = length($i); } if ( length($t) > $max_tbl_len ) { $max_tbl_len = length($t); } } elsif ( my ($kv, $lp, $sp) = $line =~ m/key vals: (\d+), \D*(\d+), \D*(\d+)/ ) { @{$idx_stats{$cur_tbl}->{$cur_idx}}{qw(est_kv est_lp est_sp)} = ($kv, $lp, $sp); $tbl_stats{$cur_tbl}->{est_kv} += $kv; $tbl_stats{$cur_tbl}->{est_lp} += $lp; $tbl_stats{$cur_tbl}->{est_sp} += $sp; } elsif ( my ($l, $pages, $bytes) = $line =~ m/(?:level (\d+)|leaf) pages:.*pages=(\d+), data=(\d+) bytes/ ) { $l ||= 0; $idx_stats{$cur_tbl}->{$cur_idx}->{real_pages} += $pages; $idx_stats{$cur_tbl}->{$cur_idx}->{real_bytes} += $bytes; $tbl_stats{$cur_tbl}->{real_pages} += $pages; $tbl_stats{$cur_tbl}->{real_bytes} += $bytes; } } my $hdr_fmt = "%${max_tbl_len}s %${max_idx_len}s %9s %10s %10s\n"; my @headers = qw(TABLE INDEX TOT_PAGES FREE_PAGES PCT_FULL); printf $hdr_fmt, @headers; my $row_fmt = "%${max_tbl_len}s %${max_idx_len}s %9d %10d %9.1f%%\n"; foreach my $t ( sort keys %tbl_stats ) { my $tbl = $tbl_stats{$t}; printf $row_fmt, $t, "", $tbl->{est_sp}, $tbl->{est_sp} - $tbl->{real_pages}, $tbl->{real_bytes} / ($tbl->{real_pages} * $PG_SIZE) * 100; foreach my $i ( sort keys %{$idx_stats{$t}} ) { my $idx = $idx_stats{$t}->{$i}; printf $row_fmt, $t, $i, $idx->{est_sp}, $idx->{est_sp} - $idx->{real_pages}, $idx->{real_bytes} / ($idx->{real_pages} * $PG_SIZE) * 100; } } Perl : TABLE INDEX TOT_PAGES FREE_PAGES PCT_FULL art.link_out104 832383 38561 86.8% art.link_out104 PRIMARY 498304 49 91.9% art.link_out104 domain_id 49600 6230 76.9% art.link_out104 domain_id_2 26495 3339 89.1% art.link_out104 from_message_id 28160 142 96.3% art.link_out104 from_site_id 38848 4874 79.4% art.link_out104 revert_domain 153984 19276 71.4% art.link_out104 site_message 36992 4651 83.4% . INDEX ..SS (Binary Logs) xtrabackup log_status table . xtrabackup (replica) (point-in-time recovery) . (Binary Log Position) . xtrabackup xtrabackup_binlog_info . . : 210715 14:14:59 Backup created in directory '/backup/' MySQL binlog position: filename 'binlog.000002', position '156' . . . 210715 14:15:00 completed OK! : Percona XtraBackup 8.0.26-18.0 xtrabackup xtrabackup_binlog_pos_innodb . MySQL Percona Server ibdata . (storage engine) xtrabackup_binlog_info . (Point-In-Time Recovery) xtrabackup (prepare) (restore) xtrabackup_binlog_info (replay) . . (Replication Replica) replica (data directory) . 8.0.22 CHANGE MASTER TO xtrabackup_binlog_info . 8.0.23 CHANGE_REPLICATION_SOURCE_TO . CHANGE_MASTER_TO . ../howtos/setting_up_replication . (Restoring Individual Tables) Percona XtraBackup .ibd (export) . Percona XtraBackup InnoDB Percona Server for MySQL XtraDB MySQL 8.0 (import) . XtraDB MySQL 8.0 . .ibd . : CREATE TABLE export_test ( a int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; (Exporting the Table) innodb_file_per_table --backup .ibd : $ find /data/backups/mysql/ -name export_test.* /data/backups/mysql/test/export_test.ibd (prepare) --export . : $ xtrabackup --prepare --export --target-dir=/data/backups/mysql/ : (tablespace) InnoDB (keyring) : $ xtrabackup --prepare --export --target-dir=/tmp/table \ --keyring-file-data=/var/lib/mysql-keyring/keyring .exp : $ find /data/backups/mysql/ -name export_test.* /data/backups/mysql/test/export_test.exp /data/backups/mysql/test/export_test.ibd /data/backups/mysql/test/export_test.cfg Percona Server for MySQL XtraDB MySQL 8.0 . InnoDB Tablespace Encryption .cfp tablespace . : (metadata) .cfg (dictionary dump) InnoDB . .exp XtraDB . .cfg` tablespace MySQL 8.0 Percona Server for MySQL 8.0 . (tablespace) .cfg InnoDB (schema validation) . Percona Server for MySQL XtraDB innodb_import_table_from_xtrabackup MySQL 8.0 : 1. ALTER TABLE test.export_test DISCARD TABLESPACE; . innodb_file_per_table . (Error) ERROR 1030 (HY000): Got error -1 from storage engine 2. test/ (data directory) 3. ALTER TABLE test.export_test IMPORT TABLESPACE; . SELECT . LRU (LRU dump backup) Percona XtraBackup buffer pool (warm up) . buffer pool ib_buffer_pool . Percona XtraBackup ib_buffer_pool . [] my.cnf buffer pool (warm) . (SEE ALSO): MySQL: Buffer Pool https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html (Streaming Backups) Percona XtraBackup (streaming) . xbstream STDOUT . . (pipe ) . pipe . --stream (xbstream) : $ xtrabackup --stream=xbstream --target-dir=/tmp xtrabackup xbstream STDOUT xbstream . STDOUT xtrabackup . (SEE ALSO): xbstream xbstream_binary xtrabackup InnoDB . quicklz . qpress *.qp xtrabackup qpress qpress file archiver Percona . xbstream . . . +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | backup.xbstream | xtrabackup --backup --stream=xbstream | | | --target-dir=./ > backup.xbstream | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | backup.xbstream | xtrabackup --backup --stream=xbstream | | | --compress --target-dir=./ > | | | backup.xbstream | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | $ xtrabackup --backup --stream=xbstream | | | ./ > backup.xbstream gzip - | openssl | | | des3 -salt -k "password" > | | | backup.xbstream.gz.des3 | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | xbstream -x < backup.xbstream | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | xtrabackup --backup --compress | | | --stream=xbstream --target-dir=./ | ssh | | | user@otherhost "xbstream -x" | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | netcat. | : | | | 0.0 3.5 $ nc -l 9999 | cat - > | | | /data/backups/backup.xbstream 168u | | | 168u | | | : 0.0 3.5 $ xtrabackup | | | --backup --stream=xbstream ./ | nc | | | desthost 9999 168u 168u | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | (one-liner): | $ ssh user@desthost "( nc -l 9999 > | | | /data/backups/backup.xbstream & )" && | | | xtrabackup --backup --stream=xbstream ./ | | | | nc desthost 9999 | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | 10MB/sec pipe viewer [1] | $ xtrabackup --backup --stream=xbstream | | | ./ | pv -q -L10m ssh user@desthost "cat | | | - > /data/backups/backup.xbstream" | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | (checksum) : | : | | | 0.0 3.5 $ nc -l 9999 | tee >(sha1sum > | | | destination_checksum) > | | | /data/backups/backup.xbstream 168u | | | 168u | | | : 0.0 3.5 $ xtrabackup | | | --backup --stream=xbstream ./ | tee | | | >(sha1sum > source_checksum) | nc | | | desthost 9999 168u 168u | | | | | | | | | : | | | 0.0 3.5 $ cat source_checksum | | | 65e4f916a49c1f216e0887ce54cf59bf3934dbad | | | - 168u 168u | | | | | | : | | | 0.0 3.5 $ cat destination_checksum | | | 65e4f916a49c1f216e0887ce54cf59bf3934dbad | | | - 168u 168u | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | xtrabackup --backup --compress | | | --compress-threads=8 --stream=xbstream | | | --parallel=4 --target-dir=./ > | | | backup.xbstream | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |" (FOOTNOTES)" | | |[1] 5 | | | (apt install pv) | | | (streamed) . . | | | | | |Percona XtraBackup xbstream . libgcrypt GnuPG . | | | | | | ( --encrypt-key --encrypt-key-file ): | | |0.0 | | |o 2 | | |--encrypt | | |o 2 | | |:option:` --encrypt-key` | | |o 2 | | |:option:` --encrypt-key-file` | | | | | |168u | | | --encrypt-key --encrypt-key-file . openssl rand -base64 32 . | | | : | | |0.0 | | |3.5 | | |U2FsdGVkX19VPN7VM+lwNI0fePhjgnhgqmDBqbF3Bvs= | | | | | |168u | | | | | |168u | | | . | | | --encrypt-key | | | xtrabackup --encrypt-key : | | |0.0 | | |3.5 | | |$ xtrabackup --backup --encrypt=AES256 --encrypt-key="U2FsdGVkX19VPN7VM+lwNI0fePhjgnhgqmDBqbF3Bvs=" --target-dir=/data/backup | | | | | |168u | | | | | |168u | | | --encrypt-key-file | | | --encrypt-key-file : | | |0.0 | | |3.5 | | |$ xtrabackup --backup --encrypt=AES256 --encrypt-key-file=/data/backups/keyfile --target-dir=/data/backup | | | | | |168u | | | | | |168u | | |: | | |0.0 | | |3.5 | | | KEYFILE CRLF ( ) . . : echo -n "U2FsdGVkX19VPN7VM+lwNI0fePhjgnhgqmDBqbF3Bvs=" > /data/backups/keyfile. | | | | | |168u | | | | | |168u | | | | | | . --encrypt-threads --encrypt-chunk-size . --encrypt-threads (thread) . --encrypt-chunk-size ( ) ( 64K ). | | | | | | xbcrypt . : | | |0.0 | | |3.5 | | |$ for i in `find . -iname "*\.xbcrypt"`; do xbcrypt -d --encrypt-key-file=/root/secret_key --encrypt-algo=AES256 < $i > $(dirname $i)/$(basename $i .xbcrypt) && rm $i; done | | | | | |168u | | | | | |168u | | | --decrypt Percona XtraBackup : | | |0.0 | | |3.5 | | |$ xtrabackup --decrypt=AES256 --encrypt-key="U2FsdGVkX19VPN7VM+lwNI0fePhjgnhgqmDBqbF3Bvs=" --target-dir=/data/backup/ | | | | | |168u | | | | | |168u | | |Percona XtraBackup . *.xbcrypt . | | |: | | |0.0 | | |3.5 | | | --parallel --decrypt . | | | | | |168u | | | | | |168u | | | ..SS | | | --prepare : | | |0.0 | | |3.5 | | |$ xtrabackup --prepare --target-dir=/data/backup/ | | | | | |168u | | | | | |168u | | | | | |xtrabackup --copy-back datadir : | | |0.0 | | |3.5 | | |$ xtrabackup --copy-back --target-dir=/data/backup/ | | | | | |168u | | | | | |168u | | | datadir ( my.cnf ) . : | | |0.0 | | |3.5 | | |150318 11:08:13 xtrabackup: completed OK! | | | | | |168u | | | | | |168u | | | : | | |0.0 | | |3.5 | | |0.0 | | | | | | GnuPG: libgcrypt | | |http://www.gnupg.org/documentation/manuals/gcrypt | | | | | |168u | | | | | |168u | | | | | |168u | | | FLUSH TABLES WITH READ LOCK | | | FLUSH TABLES WITH READ LOCK : | | |0.0 | | |o 2 | | | | | |o 2 | | | | | | | | |168u | | | UNLOCK TABLES . | | |: | | |0.0 | | |3.5 | | |FLUSH TABLES WITH READ LOCK . | | | | | |168u | | | | | |168u | | | InnoDB FLUSH TABLES WITH READ LOCK . . | | | FLUSH TABLES WITH READ LOCK . FLUSH TABLES WITH READ LOCK Waiting for table flush Waiting for master to send event . . | | |: | | |0.0 | | |3.5 | | | . Percona XtraBackup Backup locks FLUSH TABLES WITH READ LOCK . Percona Server for MySQL 5.6 . Percona XtraBackup InnoDB DML InnoDB . | | | | | |168u | | | | | |168u | | | : | | |0.0 | | |o 2 | | |xtrabackup | | |o 2 | | |xtrabackup SELECT | | | | | |168u | | | | | | . . . --ftwrl-wait-timeout . xtrabackup . | | | (0) . | | | . --ftwrl-wait-query-type . all update . all xtrabackup FLUSH TABLES WITH READ LOCK ( --ftwrl-wait-threshold) . update xtrabackup UPDATE/ALTER/REPLACE/INSERT . | | | . . . xtrabackup --ftwrl-wait-threshold . xtrabackup PROCESS SUPER . | | | | | | . FLUSH TABLES WITH READ LOCK . --kill-long-queries-timeout . . . | | | --kill-long-query-type SELECT . xtrabackup PROCESS SUPER ..SS | | |0.0 | | |o 2 | | |--ftwrl-wait-timeout ( ) - . 0 . | | |o 2 | | |--ftwrl-wait-query-type - FLUSH TABLES WITH READ LOCK . all . | | |o 2 | | |--ftwrl-wait-threshold ( ) - . | | |o 2 | | |--kill-long-queries-timeout ( ) - FLUSH TABLES WITH READ LOCK . 0 . | | |o 2 | | |--kill-long-query-type - kill-long-queries-timeout . | | | | | |168u | | | | | | xtrabackup xtrabackup . | | |0.0 | | |3.5 | | |$ xtrabackup --backup --ftwrl-wait-threshold=40 \ | | |--ftwrl-wait-query-type=all --ftwrl-wait-timeout=180 \ | | |--kill-long-queries-timeout=20 --kill-long-query-type=all \ | | |--target-dir=/data/backups/ | | | | | |168u | | | | | |168u | | | FLUSH TABLES WITH READ LOCK xtrabackup . FLUSH TABLES WITH READ LOCK . | | | | | | --parallel --compress-threads | | | xbstream --parallel . (threads) xtrabackup . | | | (innodb_file_per_table) innodb_data_file_path ibdata . ( ) . | | | (fragmented) / (I/O throughput) . ( ). | | | . | | | : | | |0.0 | | |3.5 | | |$ xtrabackup --backup --parallel=4 --target-dir=/path/to/backup | | | | | |168u | | | | | |168u | | | xbstream --compress-threads . xtrabackup . 1 . | | | : | | |0.0 | | |3.5 | | |$ xtrabackup --backup --stream=xbstream --compress --compress-threads=4 --target-dir=./ > backup.xbstream | | | | | |168u | | | | | |168u | | | . | | | --rsync | | | FLUSH TABLES WITH READ LOCK --rsync . xtrabackup InnoDB cp rsync . xtrabackup rsync FLUSH TABLES WITH READ LOCK . rsync ( ) FLUSH TABLES WITH READ LOCK . Percona XtraBackup Backup locks FLUSH TABLES WITH READ LOCK . Percona Server for MySQL 5.6 . Percona XtraBackup InnoDB DML InnoDB . | | |: | | |0.0 | | |3.5 | | | --stream . | | | | | |168u | | | | | |xtrabackup . | | | | | | . datadir | | | | | | . | | |0.0 | | |3.5 | | |$ xtrabackup --backup --target-dir=/path/to/backup | | |$ xtrabackup --prepare --target-dir=/path/to/backup | | | | | |168u | | | | | |168u | | | creating_a_backup preparing_a_backup . | | | | | | (snapshot) . | | | : | | |0.0 | | |3.5 | | |mysql> SHOW BINARY LOGS; | | |+------------------+-----------+ | | || Log_name | File_size | | | |+------------------+-----------+ | | || mysql-bin.000001 | 126 | | | || mysql-bin.000002 | 1306 | | | || mysql-bin.000003 | 126 | | | || mysql-bin.000004 | 497 | | | |+------------------+-----------+ | | | | | |168u | | | | | |168u | | | | | |0.0 | | |3.5 | | |mysql> SHOW MASTER STATUS; | | |+------------------+----------+--------------+------------------+ | | || File | Position | Binlog_Do_DB | Binlog_Ignore_DB | | | |+------------------+----------+--------------+------------------+ | | || mysql-bin.000004 | 497 | | | | | |+------------------+----------+--------------+------------------+ | | | | | |168u | | | | | |168u | | | | | | . | | | datadir ( | | | --log-bin= ). | | | | | |xtrabackup_binlog_info : | | |0.0 | | |3.5 | | |$ cat /path/to/backup/xtrabackup_binlog_info | | |mysql-bin.000003 57 | | | | | |168u | | | | | |168u | | | | | | . | | | : | | |0.0 | | |3.5 | | |$ xtrabackup --copy-back --target-dir=/path/to/backup | | | | | |168u | | | | | |168u | | | ( | | | restoring_a_backup ) | | | mysqlbinlog | | | : | | |0.0 | | |3.5 | | |$ mysqlbinlog /path/to/datadir/mysql-bin.000003 /path/to/datadir/mysql-bin.000004 \ | | | --start-position=57 > mybinlog.sql | | | | | |168u | | | | | |168u | | | | | | . | | | | | | . . | | | 11-12-25 01:00:00 : | | |0.0 | | |3.5 | | |$ mysqlbinlog /path/to/datadir/mysql-bin.000003 /path/to/datadir/mysql-bin.000004 \ | | | --start-position=57 --stop-datetime="11-12-25 01:00:00" | mysql -u root -p | | | | | |168u | | | | | |168u | | | (rolled forward)..SS (Replication) | | | . | | | --slave-info | | | . binary log (source) . CHANGE MASTER xtrabackup_slave_info . | | | . xtrabackup_slave_info . replication_howto . | | | --safe-slave-backup | | | (thread) SQL Slave_open_temp_tables SHOW STATUS . SQL . Slave_open_temp_tables --safe-slave-backup-timeout ( ) . SQL . | | | . | | |: | | |0.0 | | |3.5 | | | . pt-table-checksum . | | | | | |168u | | | | | |168u | | | | | |Percona XtraBackup . Percona XtraBackup 2.2 . . PERCONA_SCHEMA.XTRABACKUP_HISTORY . | | | : | | |0.0 | | |o 2 | | |--history = : . | | |o 2 | | |--incremental-history-name = : . xtrabackup ( to_lsn) to_lsn LSN . --incremental-history-uuid --incremental-basedir --incremental-lsn . LSN ( ) xtrabackup . | | |o 2 | | |--incremental-history-uuid = : UUID . xtrabackup UUID to_lsn LSN . --incremental-basedir --incremental-lsn --incremental-history-name . LSN ( UUID to_lsn ) xtrabackup . | | | | | |168u | | |: | | |0.0 | | |3.5 | | | xtrabackup_history . | | | | | |168u | | | | | |168u | | | xtrabackup mysqldump SELECT * . | | | pxb.privilege . | | | PERCONA_SCHEMA.XTRABACKUP_HISTORY | | | . --history . | | |center; | | ||l|l|. | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |uuid | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |name | | | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | . | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |tool_name | | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |tool_command | | | | | | | | | | --password --encryption_key | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |tool_version | | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |ibbackup_version | | | | xtrabackup | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |server_version | | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |start_time | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |end_time | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |lock_time | ( | | | ) | | | | | | | | | FLUSH | | | TABLES WITH READ LOCK | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |binlog_pos | binlog | | | | | | FLUSH TABLES WITH READ | | | LOCK | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |innodb_from_lsn | LSN | | | | | | | | | | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |innodb_to_lsn | LSN | | | | | | | | | | | | LSN | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |partial | | | | | | | N | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |incremental | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |format | | | | (xbstream) | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |compact | | | | | | | (compact) | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |compressed | | | | | | | (compressed) | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ |encrypted | | | | | | | | | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+ --history . o --incremental-history-name --incremental-history-uuid . (IMPLEMENTATION) xtrabackup . xtrabackup - (read-write) . xtrabackup . - xtrabackup InnoDB InnoDB - . xtrabackup posix_fadvise() () . xtrabackup . (swap out) . xtrabackup : posix_fadvise(file, 0, 0, POSIX_FADV_DONTNEED) xtrabackup (read-ahead) : posix_fadvise(file, 0, 0, POSIX_FADV_SEQUENTIAL) xtrabackup . . (log) xtrabackup . InnoDB ( Percona Server for MySQL innodb_log_block_size XtraDB Percona XtraBackup ). xtrabackup buf_page_is_corrupted() InnoDB . . doublewrite . xtrabackup xtrabackup 0 . 1 . 0 1 MySQL . 255 . (REFERENCES) xtrabackup xtrabackup . xtrabackup : o --backup o --prepare ( --backup) o --copy-back --move-back . o --stats . xtrabackup : $ xtrabackup [--defaults-file=#] --backup|--prepare|--copy-back|--stats [OPTIONS] --prepare : $ xtrabackup --prepare --target-dir=/data/backup/mysql/ xtrabackup mysqld : 1. /etc/my.cnf 2. /etc/mysql/my.cnf 3. /usr/etc/my.cnf 4. ~/.my.cnf. xtrabackup ( --defaults-file) : o --print-defaults xtrabackup . o --no-defaults . o --defaults-file . o --defaults-extra-file . o --defaults-group-suffix . (xtrabackup mysqld) . o --login-path . InnoDB InnoDB my.cnf xtrabackup InnoDB . . InnoDB XtraDB . --innodb-miscellaneous ..SS " (Options)" --apply-log-only redo . . --backup --target-dir. . --backup-lock-timeout (timeout) (metadata locks). --backup-lock-retry-count (metadata locks). --backup-locks FLUSH TABLES WITH READ LOCK . . --no-backup-locks . --check-privileges Percona XtraBackup . . XtraBackup . xtrabackup: Error: missing required privilege LOCK TABLES on *.* xtrabackup: Warning: missing required privilege REPLICATION CLIENT on *.* --close-files . xtrabackup tablespace (file handle) DDL . tablespace . Percona XtraBackup (inconsistent) . . --compress xtrabackup (transaction log) quicklz lz4 . quicklz . --compress=quicklz --compress qpress *.qp xtrabackup qpress qpress . --compress=lz4 *.lz4 . lz4 . : QuickLZ http://www.quicklz.com LZ4 https://lz4.github.io/lz4 --compress-chunk-size=# () . 64K . --compress-threads=# (worker threads) xtrabackup . 1 . (--compress-threads) (--parallel) . --parallel=4 --compress --compress-threads=2 I/O (pipe) . --copy-back . --force-non-empty-directories . --core-file (core dump) (fatal signals). --databases=# . "databasename1[.table_name1] databasename2[.table_name2] . . ." . --databases-exclude=name . --databases . --databases . --databases-file=# . databasename1[.table_name1] . --datadir=DIRECTORY . datadir MySQL my.cnf . --copy-back --move-back --datadir . READ EXECUTE datadir . --debug-sleep-before-unlock=# xtrabackup . --debug-sync=name (debug sync point). xtrabackup . --decompress .qp --compress . --parallel . qpress (PATH) . Percona XtraBackup . --remove-original . --decompress xbstream qpress . lz4 (--compress=lz4) --decompress : --decompress=lz4. --decompress-threads=# xbstream . --decrypt=ENCRYPTION-ALGORITHM .xbcrypt --encrypt . --parallel . Percona XtraBackup . --remove-original . --defaults-extra-file=[MY.CNF] . . --defaults-file=[MY.CNF] . . . --defaults-group=GROUP-NAME . --defaults-group xtrabackup . mysqld_multi . --defaults-group-suffix=# concat(group, suffix) . --dump-innodb-buffer-pool (dump) buffer pool . --dump-innodb-buffer-pool xtrabackup buffer pool ( ) innodb_buffer_pool_dump_status . $ xtrabackup --backup --dump-innodb-buffer-pool --target-dir=/home/user/backup OFF . innodb_buffer_pool_dump_status buffer pool xtrabackup --dump-innodb-buffer-pool-timeout . ib_buffer_pool tablespace ID page ID buffer pool . : MySQL: Buffer Pool https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html --dump-innodb-buffer-pool-timeout xtrabackup innodb_buffer_pool_dump_status buffer pool . --dump-innodb-buffer-pool . 10 . --dump-innodb-buffer-pool-pct buffer pool . --dump-innodb-buffer-pool ON . xtrabackup innodb_buffer_pool_dump_pct MySQL . buffer pool (: --dump-innodb-buffer-pool-timeout) MySQL . : (timeout) buffer pool --dump-innodb-buffer-pool-timeout MySQL: innodb_buffer_pool_dump_pct https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_dump_pct --encrypt=ENCRYPTION_ALGORITHM xtrabackup InnoDB ENCRYPTION_ALGORITHM . : AES128 AES192 AES256 --encrypt-key=ENCRYPTION_KEY . . --encrypt-key-file=ENCRYPTION_KEY_FILE . ( ) . xtrabackup . xtrabackup . --encrypt-threads=# (worker threads) / . xtrabackup . --encrypt-chunk-size=# . xtrabackup . xtrabackup . --export . << >> . --extra-lsndir=DIRECTORY ( --backup): xtrabackup_checkpoints xtrabackup_info . --force-non-empty-directories --copy-back --move-back . . / . --ftwrl-wait-timeout=SECONDS xtrabackup FLUSH TABLES WITH READ LOCK . xtrabackup . 0 FLUSH TABLES WITH READ LOCK . xtrabackup Backup Locks FLUSH TABLES WITH READ LOCK InnoDB DML InnoDB . --ftwrl-wait-threshold=SECONDS xtrabackup --ftwrl-wait-timeout . FLUSH TABLES WITH READ LOCK . --ftwrl-wait-timeout 0 . 60 . xtrabackup Backup Locks FLUSH TABLES WITH READ LOCK InnoDB DML InnoDB . --ftwrl-wait-query-type=all|update xtrabackup . all . --galera-info xtrabackup_galera_info . Percona XtraDB Cluster . (backup locks) . --generate-new-master-key copy-back. --generate-transition-key xtrabackup prepare copy-back keyring vault . --generate-transition-key (transition key) keyring xtrabackup . --get-server-public-key : MySQL: --get-server-public-key https://dev.mysql.com/doc/refman/5.7/en/connection-options.html#option_general_get-server-public-key --help xtrabackup . --history=NAME PERCONA_SCHEMA.xtrabackup_history . . --host=HOST TCP/IP . mysql . mysql --help . --incremental xtrabackup . xtrabackup . --incremental-lsn --incremental-basedir . --incremental-basedir xtrabackup . : xb_incremental --incremental-basedir=DIRECTORY . --incremental-dir=DIRECTORY (prepare) . --incremental-force-scan (full scan) . --incremental-history-name=name PERCONA_SCHEMA.xtrabackup_history . xtrabackup ( innodb_to_lsn) to_lsn lsn . --incremental-history-uuid --incremental-basedir --incremental-lsn . lsn ( ) xtrabackup . --incremental . --incremental-history-uuid=name UUID PERCONA_SCHEMA.xtrabackup_history . --incremental-history-name --incremental-basedir --incremental-lsn . lsn ( UUID ) xtrabackup . --incremental . --incremental-lsn=LSN --incremental-basedir (LSN) . 5.1 LSN . : LSN ( Percona XtraBackup ) . ! --innodb[=name] MySQL . --innodb-miscellaneous InnoDB my.cnf xtrabackup InnoDB . . InnoDB XtraDB : o --innodb-adaptive-hash-index o --innodb-additional-mem-pool-size o --innodb-autoextend-increment o --innodb-buffer-pool-size o --innodb-buffer-pool-filename o --innodb-checksum-algorithm o --innodb-checksums o --innodb-data-file-path o --innodb-data-home-dir o --innodb-directories o --innodb-doublewrite-file o --innodb-doublewrite o --innodb-extra-undoslots o --innodb-fast-checksum o --innodb-file-io-threads o --innodb-file-per-table o --innodb-flush-log-at-trx-commit o --innodb-flush-method o --innodb-io-capacity o --innodb-lock-wait-timeout o --innodb-log-block-size o --innodb-log-buffer-size o --innodb-log-checksums o --innodb-log-files-in-group o --innodb-log-file-size o --innodb-log-group-home-dir o --innodb-max-dirty-pages-pct.IP o 2 --innodb-open-files o --innodb-page-size o --innodb-read-io-threads o --innodb-redo-log-encrypt o --innodb-undo-directory o --innodb-undo-log-encrypt o --innodb-undo-tablespaces` o --innodb-use-native-aio o --innodb-write-io-threads --keyring-file-data=FILENAME keyring. --xtrabackup-plugin-dir . --kill-long-queries-timeout=SECONDS xtrabackup FLUSH TABLES WITH READ LOCK . 0 xtrabackup . xtrabackup PROCESS SUPER . xtrabackup Backup Locks FLUSH TABLES WITH READ LOCK InnoDB DML InnoDB . --kill-long-query-type=all|select (global lock) . "select" . --lock-ddl LOCK TABLES FOR BACKUP ( LOCK INSTANCE FOR BACKUP) DDL . : Percona XtraBackup 8.0.22-15.0 safe-slave-backup SQL InnoDB InnoDB . Percona XtraBackup 8.0.22-15.0 safe-slave-backup SQL InnoDB . --lock-ddl-per-table DDL xtrabackup . : Percona XtraBackup 8.0.15 --lock-ddl-per-table . --lock-ddl . --lock-ddl-timeout LOCK TABLES FOR BACKUP LOCK INSTANCE FOR BACKUP . --log MySQL . --log-bin . --log-bin-index=name (binary log) . --log-copy-interval=# ( ). --login-path (login file) . --move-back . . --no-backup-locks --backup-locks . --no-defaults (login file) . --no-lock FLUSH TABLES WITH READ LOCK . InnoDB . DDL InnoDB ( MyISAM mysql) . xtrabackup Backup Locks FLUSH TABLES WITH READ LOCK InnoDB DML InnoDB . replication . --safe-slave-backup replica replication . --no-server-version-check Percona XtraBackup 8.0.21 . --no-server-version-check . Percona XtraBackup . XtraBackup . (override) . (comparison) . --no-version-check . xtrabackup --backup . xtrabackup --no-version-check . xtrabackup . xtrabackup : o MySQL o o Percona Toolkit o Perl . () MD5 Percona Toolkit . UUID . --open-files-limit=# (file descriptors) ()setrlimit. --parallel=# (threads) . 1 ( ). Percona XtraBackup 2.3.10 --copy-back ( redo ). --password=PASSWORD . . mysql --help . --plugin-load . --port=PORT TCP/IP . mysql . mysql --help . --prepare xtrabackup --backup (recovery) . (preparing a backup) . --print-defaults . . --print-param xtrabackup (restore) . --read-buffer-size (datafile) (page size) . 10Mb . --rebuild-indexes . --prepare --rebuild-threads . --rebuild-threads=# (threads) . --prepare --rebuild-indexes . --remove-original Percona XtraBackup 2.4.6 .qp .xbcrypt .qp.xbcrypt . --rocksdb-datadir RocksDB. --rocksdb-wal-dir WAL RocksDB. --rocksdb-checkpoint-max-age (checkpoint) . --rocksdb-checkpoint-max-count checkpoint . --rollback-prepared-trx (rollback) (prepared) InnoDB. --rsync rsync . xtrabackup cp rsync InnoDB . --stream . --safe-slave-backup xtrabackup FLUSH TABLES WITH READ LOCK SQL (replica) Slave_open_temp_tables SHOW STATUS . SQL . --safe-slave-backup-timeout Slave_open_temp_tables . SQL . Row-Based-Replication . --safe-slave-backup-timeout=SECONDS --safe-slave-backup Slave_open_temp_tables . . --secure-auth ( 4.1.1) . ( --skip-secure-auth .) --server-id=# . --server-public-key-path RSA PEM. : MySQL: --server-public-key-path https://dev.mysql.com/doc/refman/8.0/en/connection-options.html#option_general_server-public-key-path --skip-tables-compatibility-check --tables-compatibility-check . --slave-info (replica) . binary log . binary log CHANGE MASTER xtrabackup_slave_info . CHANGE MASTER binary log xtrabackup_slave_info . --socket UNIX domain socket . mysql . mysql --help . --ssl . MySQL --ssl . --ssl-ca CA SSL . MySQL --ssl-ca . --ssl-capath (CA) SSL PEM. MySQL --ssl-capath . --ssl-cert X509 PEM . MySQL --ssl-cert . --ssl-cipher (ciphers) . MySQL --ssl-cipher . --ssl-crl (CRL) . MySQL --ssl-crl . --ssl-crlpath (certificate revocation list). MySQL --ssl-crlpath . --ssl-fips-mode SSL FIPS ( OpenSSL ) : OFF ON STRICT. --ssl-key X509 PEM . MySQL --ssl-key . --ssl-mode . MySQL --ssl-mode . --ssl-verify-server-cert Common Name (host name) . MySQL --ssl-verify-server-cert . --stats xtrabackup (index statistics) . --stream=FORMAT (stream) . xbstream . --strict xtrabackup . --tables=name databasename.tablename . . (partial backups) . --tables-compatibility-check . ON . --skip-tables-compatibility-check . --tables-exclude=name (regexp). --tables . --tables . --tables-file=name databasename.tablename. . --target-dir=DIRECTORY . xtrabackup . xtrabackup . xtrabackup file exists . xtrabackup . READ WRITE EXECUTE --target-dir . --innodb-temp-tablespaces-dir=DIRECTORY tablespace . --throttle=# (chunks) . 10 MB . 10 MB/s 1 : --throttle=1. : throttling_backups --tls-ciphersuites (cipher) TLS v1.3. --tls-version TLS : TLSv1 TLSv1.1 TLSv1.2 TLSv1.3. --tmpdir=name . --transition-key=name keyring vault . xtrabackup AES tablespace . --transition-key xtrabackup . --prepare . --use-memory --prepare --stats . innodb_buffer_pool_size . InnoDB Hot Backup Oracle . 100MB 1GB 2GB . ( 1MB 1M 1GB 1G). --user=USERNAME MySQL . . mysql --help . -v --version --version xtrabackup . --xtrabackup-plugin-dir=DIRNAME keyring. : Percona Server for MySQL: keyring_vault Data at Rest Encryption https://www.percona.com/doc/percona-server/LATEST/management/data_at_rest_encryption.html#keyring-vault-plugin MySQL: keyring_file https://dev.mysql.com/doc/refman/5.7/en/keyring-file-plugin.html Percona LLC / (COPYRIGHT) 2009-2022 Percona LLC / 8.0 June 15, 2026 XTRABACKUP(1)