maria-discuss team mailing list archive

[Guillaume Lefranc <guillaume.lefranc@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
-- 
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation