1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ85

Database Security

Which two statements are correct about the binary log encryption feature?

Choose two
  • A It encrypts any connecting slaves connection thread.
  • B It can be set at run time.
  • C It requires a keyring plugin.
  • D When enabled it encrypts existing binary logs.
  • E It can be activated per session.
Explanation

Binary log encryption is controlled by the dynamic global binlog_encryption system variable and can be activated while MySQL Server is running. It requires a configured keyring plugin to provide the keyring service used to store binary log encryption keys. Activating it rotates the logs so that new and subsequent log files are encrypted; existing files are not automatically encrypted.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!