Does MariaDB TDE Automatically Encrypt mariabackup Files?
I have a MariaDB server with TDE (Transparent Data Encryption) configured using:
ini
file_key_management_filename = /etc/mysql/encryption/keyfile.enc file_key_management_filekey = FILE:/etc/mysql/encryption/keyfile.key
Our goal is to ensure backup files are encrypted without introducing additional keys (e.g., SSL/PGP) due to security team restrictions.
Backups stay on the same VM, with VMware handling secure storage-level backups.
We run: sh
mariabackup --backup --target-dir=/mariadb/backup_encrypted mariabackup --prepare --target-dir=/mariadb/backup_encrypted
The backup files (e.g., .ibd, .xbcrypt) appear to inherit TDE encryption, as they’re unreadable without the TDE key.
Questions
1. Is this assumption correct, or does mariabackup create unencrypted copies during backup/prepare?
2. Are there hidden risks (e.g., temporary unencrypted files) we’re overlooking?
3. For compliance, should we still force encryption via --encrypt-backup despite TDE?
Thanks for your insights!