# ---------------------------------------------------------------------- # Setup # Creating custom global manifest file for MySQL server # Creating custom global configuration file for keyring component: component_keyring_file # Re-starting mysql server with manifest file # ---------------------------------------------------------------------- ######################################################################## # Bug#29491749: DATA DICTIONARY UPGRADE FAILING WITH ENCRYPTED MYSQL # TABLESPACE # # Verify that we can upgrade from a server with an encrypted mysql # tablespace. ######################################################################## # Stop the mysqld server which was created by MTR default # Taking backup of local keyring file for keyring component: component_keyring_file # Copy and unzip the datadir # Set different datadir path ######################################################################## # Migrate keys from plugin to component. ######################################################################## # Taking backup of global manifest file for MySQL server # Taking backup of global configuration file for keyring component: component_keyring_file # Applying migration config for keyring component: component_keyring_file # Performing keyring migration # Restoring global configuration file from backup for keyring component: component_keyring_file # Restore global manifest file for MySQL server from backup # Start the server SET debug='+d,skip_dd_table_access_check'; # The mysql tablespace should be encrypted SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; NAME ENCRYPTION mysql Y SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; NAME OPTIONS mysql encryption=Y; # Verify that we can un-encrypt the mysql tablespace ALTER TABLESPACE mysql ENCRYPTION='N'; SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; NAME ENCRYPTION mysql N SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; NAME OPTIONS mysql encryption=N; # Restart the server SET debug='+d,skip_dd_table_access_check'; # The mysql tablespace should now be be un-encrypted SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='mysql'; NAME ENCRYPTION mysql N SELECT NAME,OPTIONS FROM mysql.tablespaces WHERE NAME='mysql'; NAME OPTIONS mysql encryption=N; # Shutdown the server, remove the files, and restart with default options # Removing local keyring file for keyring component: component_keyring_file # Restoring local keyring file from backup for keyring component: component_keyring_file # Restart the server with default options # restart; # ---------------------------------------------------------------------- # Teardown # Removing local keyring file for keyring component: component_keyring_file # Removing global configuration file for keyring component: component_keyring_file # Removing global manifest file for MySQL server # Restarting server without the manifest file # ----------------------------------------------------------------------