maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

This is documented at
https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/ "Percona
XtraBackup cannot back up instances that use encrypted InnoDB log files."

- Peter

On Wed, Jun 1, 2016 at 5:13 PM, Guillaume Lefranc <
guillaume.lefranc@xxxxxxxxxxx> wrote:

> 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
>
> _______________________________________________
> 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
>
>