Hello,

on the contrary, it is clearly stated:

• Percona XtraBackup cannot back up instances that use encrypted InnoDB log files.

So, either don't encrypt the log files (potentially unsafe), or use filesystem backups.

Regards

GL

On Wed, Jun 1, 2016 at 5:02 PM Lee Bennett <lee@gravity667.com> wrote:

Hi

We are in the process of setting up data at rest encryption encryption with MariaDB 10.1.13 so we can encrypt specific table. This works without any problem however when I try and backup with Percona Xtrabackup it fails saying table appears to be corrupted:

60601 14:53:46 [01]        ...done

160601 14:53:46 [01] Streaming ./mytest/customers_big.ibd

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

160601 14:53:46 >> log scanned up to (3146117051)

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Database page corruption detected at page 1, retrying...

[01] xtrabackup: Error: failed to read page after 10 retries. File ./mytest/customers_big.ibd seems to be corrupted.

[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.

[01] xtrabackup: Error: failed to copy datafile.

This says to me that Xtrabackup isn’t compatible with MariaDB encryption however the documents kind of give the impression it is: https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/

Regards

Lee

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

--

Guillaume Lefranc

Remote DBA Services Manager

MariaDB Corporation

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp