| 1 |
# ---------------------------------------------------------------------- |
| 2 |
# Setup |
| 3 |
# Creating custom global manifest file for MySQL server |
| 4 |
# Creating custom global configuration file for keyring component: component_keyring_file |
| 5 |
# Re-starting mysql server with manifest file |
| 6 |
# ---------------------------------------------------------------------- |
| 7 |
######################################################################## |
| 8 |
# Bug#29491749: DATA DICTIONARY UPGRADE FAILING WITH ENCRYPTED MYSQL |
| 9 |
# TABLESPACE |
| 10 |
# |
| 11 |
# Verify that we can upgrade from a server with an encrypted mysql |
| 12 |
# tablespace. |
| 13 |
######################################################################## |
| 14 |
# Stop the mysqld server which was created by MTR default |
| 15 |
# Taking backup of local keyring file for keyring component: component_keyring_file |
| 16 |
# Copy and unzip the datadir |
| 17 |
# Set different datadir path |
| 18 |
######################################################################## |
| 19 |
# Migrate keys from plugin to component. |
| 20 |
######################################################################## |
| 21 |
# Taking backup of global manifest file for MySQL server |
| 22 |
# Taking backup of global configuration file for keyring component: component_keyring_file |
| 23 |
# Applying migration config for keyring component: component_keyring_file |
| 24 |
# Performing keyring migration |
| 25 |
# Restoring global configuration file from backup for keyring component: component_keyring_file |
| 26 |
# Restore global manifest file for MySQL server from backup |
| 27 |
# Start the server |
| 28 |
SET debug='+d,skip_dd_table_access_check'; |
| 29 |
# The mysql tablespace should be encrypted |
| 30 |
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; |
| 31 |
NAME ENCRYPTION |
| 32 |
mysql Y |
| 33 |
SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; |
| 34 |
NAME OPTIONS |
| 35 |
mysql encryption=Y; |
| 36 |
# Verify that we can un-encrypt the mysql tablespace |
| 37 |
ALTER TABLESPACE mysql ENCRYPTION='N'; |
| 38 |
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; |
| 39 |
NAME ENCRYPTION |
| 40 |
mysql N |
| 41 |
SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; |
| 42 |
NAME OPTIONS |
| 43 |
mysql encryption=N; |
| 44 |
# Restart the server |
| 45 |
SET debug='+d,skip_dd_table_access_check'; |
| 46 |
# The mysql tablespace should now be be un-encrypted |
| 47 |
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; |
| 48 |
NAME ENCRYPTION |
| 49 |
mysql N |
| 50 |
SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; |
| 51 |
NAME OPTIONS |
| 52 |
mysql encryption=N; |
| 53 |
# Shutdown the server, remove the files, and restart with default options |
| 54 |
# Removing local keyring file for keyring component: component_keyring_file |
| 55 |
# Restoring local keyring file from backup for keyring component: component_keyring_file |
| 56 |
# Restart the server with default options |
| 57 |
# restart; |
| 58 |
# ---------------------------------------------------------------------- |
| 59 |
# Teardown |
| 60 |
# Removing local keyring file for keyring component: component_keyring_file |
| 61 |
# Removing global configuration file for keyring component: component_keyring_file |
| 62 |
# Removing global manifest file for MySQL server |
| 63 |
# Restarting server without the manifest file |
| 64 |
# ---------------------------------------------------------------------- |