Binary Log Encryption: Encryption of Temporary Capture Files

In MySQL 8.0.14 we introduced binary log encryption at rest. When enabled, this feature makes sure that binary log files  generated by the server are encrypted as soon as they hit persistent storage. As of MySQL 8.0.17 transient files created by the server for capturing the changes that end up Continue Reading

Rotating binary log master key online

Starting on version 8.0.16, MySQL server introduces a new command that allowsfor the binary log master key rotation, online! When binary log encryption is enabled, the binary log master key can be rotated online by using the following new command: ALTER INSTANCE ROTATE BINLOG MASTER KEY; ALTER INSTANCE ROTATE BINLOG Continue Reading

Binary log encryption at rest

Starting in version 8.0.14, MySQL server can encrypt all new binary and relay log files on disk. In order to do so, you just need to enable the new binlog_encryption option (and also ensure that you have a keyring). Once enabling the option in a client session, the server will Continue Reading

More house chores: Cleaning up the binary log

Historically, the MySQL binary log has gone through a few revisions resulting in different versions of how the log is formatted. The following shows the version of the binary log and the MySQL version in which it appears. As you can see, version 4 is the current version of the Continue Reading

MySQL binlog administration

If you look into the key elements of replication, then the very basic element is Binary log or binlog. Over the period of time we have made efforts to improve the management of this quintessential element of replication. To keep up with our raising standards and requirements coming from the Continue Reading

>