Demoing Oracle MySQL Transparent Data Encryption

A key part of database security is ensuring that we encrypt data at all levels required. One of the important parts of encryption is encrypting at rest. Making sure the data files of the corresponding sensitive tables and data is encrypted, and that key recovery and/or rotation can be carried out without having to re-encrypt the entire system. Here we will be looking into MySQL Keyring, also known as Transparent Data Encryption (TDE), and walking through an example.