Is keyring error in xtrabackup not a serious error?

MySQL & MariaDB Percona XtraBackup
1

We are using an encrypted table with the keyring_file plugin in our DB.

I tried to backup with innobackupex tool, but there was an error on the encrypted table due to keyring plugin setting error.

But the backup is successful. (exit status 0)

Therefore, the user will recognize that the backup was completed normally without errors.

Likewise, for an apply-log on recovery, the encrypted table is not recovered, but it is finally marked as recovered normally.

Is keyring plugin error in xtrabackup not a serious problem?

InnoDB: Allocated tablespace ID 4 for mysql/plugin, old maximum was 2
InnoDB: Encryption can’t find master key, please check the keyring plugin is loaded.
InnoDB: Encryption information in datafile: ./TEST/tde.ibd can’t be decrypted , please confirm the keyfile is match and keyring plugin is loaded.
…
170216 04:30:08 completed OK!

2

meet the same issue , have you resolved it ?Thanks!

3

I just found solution, and post here in case anyone meet same issue.

there is a parameter “–xtrabackup-plugin-dir” of xtrabackup to identify the path of xtrabackup plugin.

so for full backup with xtrabackup binary version:

xtrabackup --backup --target-dir=/data/backup/ --user=root --keyring-file-data=/var/lib/mysql-keyring/keyring --server_id=1 --xtrabackup-plugin-dir=/home/wen/xtrabackup/lib/plugin

4

Thanks for posting that, appreciated!