Hi, What is your xtrabackup version?
I use the same PS 5.7.18 with ordinary master/slave setup + PXB 2.4.8 and everything looks OK.
xtrabackup --defaults-file=/home/shahriyar.rzaev/sandboxes/rsandbox_Percona-Server-5_7_18/master/my.sandbox.cnf --user=msandbox --password='msandbox' --target-dir=/home/shahriyar.rzaev/backup_dir/ps_5.7_master/full/2017-08-01_07-17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt-key='VVTBwgM4UhwkTTV98fhuj+D1zyWoA89K' --encrypt-threads=4 --encrypt-chunk-size=65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream="xbstream" > /home/shahriyar.rzaev/backup_dir/ps_5.7_master/full/2017-08-01_07-17-15/full_backup.stream
master [localhost] {root} (PERCONA_SCHEMA) > show tables; +--------------------------+ | Tables_in_PERCONA_SCHEMA | +--------------------------+ | xtrabackup_history | +--------------------------+ 1 row in set (0.00 sec)
> select * from xtrabackup_history\G *************************** 1. row *************************** uuid: 830b4057-7689-11e7-ac73-002590e9b448 name: NULL tool_name: xtrabackup tool_command: --defaults-file=/home/shahriyar.rzaev/sandboxes/rsandbox_Percona-Server-5_7_18/master/my.sandbox.cnf --user=msandbox --password=... --target-dir=/home/shahriyar.rzaev/backup_dir/ps_5.7_master/full/2017-08-01_07-17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt-key=... --encrypt-threads=4 --encrypt-chunk-size=65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream=xbstream tool_version: 2.4.7 ibbackup_version: 2.4.7 server_version: 5.7.18-15-log start_time: 2017-08-01 07:17:15 end_time: 2017-08-01 07:17:43 lock_time: 0 binlog_pos: filename 'mysql-bin.000005', position '154', GTID of the last change '00020393-1111-1111-1111-111111111111:1-1511' innodb_from_lsn: 0 innodb_to_lsn: 2892770773 partial: N incremental: N format: xbstream compact: N compressed: N encrypted: Y 1 row in set (0.00 sec)
RESULT: could not reproduce. Marking as invalid for now.
As a general rule, I am not suggesting to use innobackupex because it is already deprecated and it is going to be removed in future releases. Please use xtrabackup instead. As described here: https://www.percona.com/doc/percona-xtrabackup/LATEST/manual.html
Hi,
What is your xtrabackup version?
I use the same PS 5.7.18 with ordinary master/slave setup + PXB 2.4.8 and everything looks OK.
xtrabackup --defaults- file=/home/ shahriyar. rzaev/sandboxes /rsandbox_ Percona- Server- 5_7_18/ master/ my.sandbox. cnf --user=msandbox --password= 'msandbox' --target- dir=/home/ shahriyar. rzaev/backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt- key='VVTBwgM4Uh wkTTV98fhuj+ D1zyWoA89K' --encrypt-threads=4 --encrypt- chunk-size= 65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream="xbstream" > /home/shahriyar .rzaev/ backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15/full_ backup. stream
master [localhost] {root} (PERCONA_SCHEMA) > show tables; ------- ------- ------+ in_PERCONA_ SCHEMA | ------- ------- ------+ ------- ------- ------+
+------
| Tables_
+------
| xtrabackup_history |
+------
1 row in set (0.00 sec)
> select * from xtrabackup_ history\ G ******* ******* ****** 1. row ******* ******* ******* ****** 7689-11e7- ac73-002590e9b4 48 file=/home/ shahriyar. rzaev/sandboxes /rsandbox_ Percona- Server- 5_7_18/ master/ my.sandbox. cnf --user=msandbox --password=... --target- dir=/home/ shahriyar. rzaev/backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt-key=... --encrypt-threads=4 --encrypt- chunk-size= 65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream=xbstream 1111-1111- 1111-1111111111 11:1-1511'
*******
uuid: 830b4057-
name: NULL
tool_name: xtrabackup
tool_command: --defaults-
tool_version: 2.4.7
ibbackup_version: 2.4.7
server_version: 5.7.18-15-log
start_time: 2017-08-01 07:17:15
end_time: 2017-08-01 07:17:43
lock_time: 0
binlog_pos: filename 'mysql-bin.000005', position '154', GTID of the last change '00020393-
innodb_from_lsn: 0
innodb_to_lsn: 2892770773
partial: N
incremental: N
format: xbstream
compact: N
compressed: N
encrypted: Y
1 row in set (0.00 sec)
RESULT: could not reproduce. Marking as invalid for now.
As a general rule, I am not suggesting to use innobackupex because it is already deprecated and it is going to be removed in future releases. Please use xtrabackup instead. /www.percona. com/doc/ percona- xtrabackup/ LATEST/ manual. html
As described here:
https:/