Not the answer you need?
Register and ask your own question!

Is keyring error in xtrabackup not a serious error?

kirbykirby EntrantInactive User Role Beginner
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!


  • wenwen Entrant Current User Role Beginner
    meet the same issue , have you resolved it ?Thanks!
  • wenwen Entrant Current User Role Beginner
    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
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Thanks for posting that, appreciated!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.