My Oracle Support Banner

FAQ - MySQL Encryption for Community Version (Doc ID 2998537.1)

Last updated on JANUARY 17, 2024

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Purpose

This document is created to answer basic questions on encryption for MySQL Community Version

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q1: What are the steps to enable encryption on MySQL Server Community?
 Q2: Will it be enable on new tables or we can do it on existing?
 Q3: What will be the impact, downtime and steps for InnoDB cluster?
 Q4: Can we do it on whole database or table level or both?
 Q5: Why can not we do restart all secondary nodes when modified my.cnf files on all three nodes. and then set on secondary node as primary and then restart the former primary so that we do not have a downtime for this activity?
 Q6: What will be the impact of altering the existing table with setting encryption to YES. Once encryption is enabled, then what will be the performance impact of it?
 Q7: Can we backup and restore it to some other machine or it will require some other method to restore the backup as encryption will be enabled?
 Q8: How can we rollback if for some reason we want to revert?
 Q9: Can you please share the details of encryption method available both in Community and Enterprise Version?
 Q10: When encryption is enabled on tables, and we take backup using mysqldump or any other utility then how will we restore it? Do we need to do any additional steps while backup and restore?
 Q11: What would be the strategy for mysql to acquire the key? 
 Q12: How do we proceed with InnoDB clusterset?
 Q13: What will be the post steps of encryption?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.