As I discussed in some of my recent talks at conferences (at the
DOAG for example), MySQL 8 came out with new
features which bring lots of improvements in terms of
security.
“At-Rest” encryption has been existing from some releases by
now:
– InnoDB Tablespace Encryption: by 5.7.11
– Redo and Undo Log Data Encryption: by 8.0.1
Now starting from version 8.0.14, you can also encrypt binary and
relay log files. In this blog post we will see how to configure
that and we will do some tests.
Case 1: Binary log files are not encrypted
Binary log files encryption is disables by default:
mysql> show variables like 'binlog_encryption'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | binlog_encryption | OFF | …[Read more]