Debian Codegraph @

mysql-test/suite/component_keyring_file/r/dd_upgrade_encrypted.result

raw
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 # ----------------------------------------------------------------------