What happens:
1) It creates the schema PERCONA_SCHEMA
2) It creates an empty table with no records.
3) After running the xtrabackup (full backup), it does not create any entry into the table.
mysql> use PERCONA_SCHEMA
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+--------------------------+
| Tables_in_PERCONA_SCHEMA |
+--------------------------+
| xtrabackup_history |
+--------------------------+
1 row in set (0.00 sec)
mysql> select uuid, start_time, end_time, incremental, compact, compressed, encrypted from PERCONA_SCHEMA.xtrabackup_history order by start_time desc;
Empty set (0.00 sec)
Hi, Is there any update on this issue?
I experienced the same issue on MySQL 5.7.22 (Oracle - community edition), while having the master-master setup. Versions:
root@server:~# mysql --version
mysql Ver 14.14 Distrib 5.7.22, for linux-glibc2.12 (x86_64) using EditLine wrapper
root@server:~# xtrabackup --version
xtrabackup version 2.4.11 based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5)
Query used: file=$DEFAULTS_ FILE --login-path=xtrab --compress --compress- threads= 1 --encrypt-threads=1 --parallel=2 --target- dir="$BACKUP_ DIR/$DATE" --encrypt=AES256 --encrypt- key-file= $encryption_ key_file --backup --history 2> "$BACKUP_ LOG/$DATE/ Xtra-backup- progress. log"
$XTRABACKUP --defaults-
What happens:
1) It creates the schema PERCONA_SCHEMA
2) It creates an empty table with no records.
3) After running the xtrabackup (full backup), it does not create any entry into the table.
mysql> use PERCONA_SCHEMA
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed ------- ------- ------+ in_PERCONA_ SCHEMA | ------- ------- ------+ ------- ------- ------+
mysql> show tables;
+------
| Tables_
+------
| xtrabackup_history |
+------
1 row in set (0.00 sec)
mysql> select uuid, start_time, end_time, incremental, compact, compressed, encrypted from PERCONA_ SCHEMA. xtrabackup_ history order by start_time desc;
Empty set (0.00 sec)