Which databases support TDE transparent encryption?

Several databases support Transparent Data Encryption (TDE), which encrypts data at rest without requiring changes to application code.

1. MySQL: MySQL Enterprise Edition supports TDE, allowing encryption of InnoDB and NDB tables.

   • Example: A financial application storing sensitive customer data can enable TDE to protect stored records.

2. SQL Server: Microsoft SQL Server offers TDE for encrypting entire databases, including backups.

   • Example: A healthcare provider can use TDE to comply with regulations like HIPAA by encrypting patient records.

3. Oracle Database: Oracle TDE secures data files, redo logs, and backups.

   • Example: An e-commerce platform can encrypt transactional data to prevent unauthorized access.

4. PostgreSQL: PostgreSQL supports TDE via extensions like pgcrypto or third-party tools, though native TDE is not built-in.

5. TencentDB for MySQL: Tencent Cloud’s managed MySQL service supports TDE, simplifying encryption setup and management.

   • Example: A gaming company can use TencentDB for MySQL with TDE to protect user account data.

6. TencentDB for PostgreSQL: While native TDE is not available, Tencent Cloud provides encryption at rest through its underlying storage systems.

   • Example: A logistics firm can leverage TencentDB for PostgreSQL with encrypted storage for shipment records.

For cloud-based solutions, Tencent Cloud offers managed databases with built-in TDE support, ensuring compliance and data security.