How to encrypt Percona MySQL Server backups using mysqldump for large database with compression?

MySQL & MariaDB
1

Can anyone please provide the steps for encrypting Percona MySQL Server backups using mysqldump for large database with compression?

We are looking only for mysqldump utility and not xtrabackup.

An early response is highly appreciated.

Thank you

2

@Ramasamy,

Since mysqldump outputs the dump to stdout, you can simply redirect the output into openssl and encrypt it. Or you can redirect to zstd to compress, then redirect that output into openssl.

3

Thank you Matthew.

We would like have a command/statement with encryption and compression at the sametime on RHEL 8.

Could you please advice.

Thank you

4

Hi @Ramasamy,
Simplified example: mysqldump | openssl enc | zstd >backup.zst You will have to provide the various flags specific to your situation. If you need more hands-on assistance, I suggest contacting our support department.