Setting Up TDE in MySQL RDS

TDE Basics

  1. Increase the size of the data file.
  2. Require developers to make any code changes to use TDE.

Prerequisites

  1. Key Management System (KMS) is enabled.
  2. The RDS is based on either MySQL 5.6 or MS SQL 2008.RDS specifications are high enough to support the overhead of encryption.

Setting Up TDE on ApsaraDB for RDS

  1. Go to the RDS Management Console, select the appropriate RDS instance.
  2. Under Security Control, TDE tab you will be able to find the option to enable TDE.

How Does TDE Work?

Encrypting Tables

alter table  engine=innodb block_format=encrypted;

Decrypting Tables

alter table  engine=innodb block_format=default;

Conclusion

Further Reading

  1. ApsaraDB for RDS for MySQL page
  2. TDE Setup Documentation

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

MongoDB Cluster Replication

Bursting MongoDB to a Remote Kubernetes Clusters in Minutes

Setting up Kibana for Elasticsearch in Local

ELK Stack ElasticSearch, Kibana and Node.Js : Store Logs on ELK