# ---------------------------------------------------------------------- # 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 # ---------------------------------------------------------------------- # ---------------------------------------------------------------------- # Setting up Keyring UDFs INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so'; CREATE FUNCTION keyring_key_fetch RETURNS STRING SONAME 'keyring_udf.so'; CREATE FUNCTION keyring_key_type_fetch RETURNS STRING SONAME 'keyring_udf.so'; CREATE FUNCTION keyring_key_length_fetch RETURNS INTEGER SONAME 'keyring_udf.so'; CREATE FUNCTION keyring_key_remove RETURNS INTEGER SONAME 'keyring_udf.so'; # ---------------------------------------------------------------------- # Stop the running server. # Taking backup of global manifest file for MySQL server # Restart server with keyring_file plugin # Pre-migration: Content of the keyring SELECT keyring_key_length_fetch('key1'); keyring_key_length_fetch('key1') 8 SELECT keyring_key_length_fetch('key2'); keyring_key_length_fetch('key2') 8 SELECT keyring_key_length_fetch('key3'); keyring_key_length_fetch('key3') 16 SELECT keyring_key_type_fetch('key1'); keyring_key_type_fetch('key1') AES SELECT keyring_key_type_fetch('key2'); keyring_key_type_fetch('key2') AES SELECT keyring_key_type_fetch('key3'); keyring_key_type_fetch('key3') AES SELECT keyring_key_fetch('key1'); keyring_key_fetch('key1') abcdefgh SELECT keyring_key_fetch('key2'); keyring_key_fetch('key2') 12345678 SELECT keyring_key_fetch('key3'); keyring_key_fetch('key3') abcdefgh12345678 # Stop the running server. # Perform migration # 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 # Restart server with keyring component SELECT status_key, status_value FROM performance_schema.keyring_component_status WHERE status_key LIKE '%name%' OR status_key LIKE '%status%'; status_key status_value Component_name component_keyring_file Implementation_name component_keyring_file Component_status Active # Post-migration: Content of the keyring SELECT keyring_key_length_fetch('key1'); keyring_key_length_fetch('key1') 8 SELECT keyring_key_length_fetch('key2'); keyring_key_length_fetch('key2') 8 SELECT keyring_key_length_fetch('key3'); keyring_key_length_fetch('key3') 16 SELECT keyring_key_type_fetch('key1'); keyring_key_type_fetch('key1') AES SELECT keyring_key_type_fetch('key2'); keyring_key_type_fetch('key2') AES SELECT keyring_key_type_fetch('key3'); keyring_key_type_fetch('key3') AES SELECT keyring_key_fetch('key1'); keyring_key_fetch('key1') abcdefgh SELECT keyring_key_fetch('key2'); keyring_key_fetch('key2') 12345678 SELECT keyring_key_fetch('key3'); keyring_key_fetch('key3') abcdefgh12345678 SELECT keyring_key_remove('key1'); keyring_key_remove('key1') 1 SELECT keyring_key_remove('key2'); keyring_key_remove('key2') 1 SELECT keyring_key_remove('key3'); keyring_key_remove('key3') 1 # ---------------------------------------------------------------------- # Clean-up DROP FUNCTION keyring_key_fetch; DROP FUNCTION keyring_key_type_fetch; DROP FUNCTION keyring_key_length_fetch; DROP FUNCTION keyring_key_remove; UNINSTALL PLUGIN keyring_udf; # ---------------------------------------------------------------------- # ---------------------------------------------------------------------- # 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 # ----------------------------------------------------------------------