Debian Codegraph @

mysql-test/suite/component_keyring_file/r/migration.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 # Setting up Keyring UDFs
9 INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so';
10 CREATE FUNCTION keyring_key_fetch RETURNS STRING SONAME 'keyring_udf.so';
11 CREATE FUNCTION keyring_key_type_fetch RETURNS STRING SONAME 'keyring_udf.so';
12 CREATE FUNCTION keyring_key_length_fetch RETURNS INTEGER SONAME 'keyring_udf.so';
13 CREATE FUNCTION keyring_key_remove RETURNS INTEGER SONAME 'keyring_udf.so';
14 # ----------------------------------------------------------------------
15 # Stop the running server.
16 # Taking backup of global manifest file for MySQL server
17 # Restart server with keyring_file plugin
18 # Pre-migration: Content of the keyring
19 SELECT keyring_key_length_fetch('key1');
20 keyring_key_length_fetch('key1')
21 8
22 SELECT keyring_key_length_fetch('key2');
23 keyring_key_length_fetch('key2')
24 8
25 SELECT keyring_key_length_fetch('key3');
26 keyring_key_length_fetch('key3')
27 16
28 SELECT keyring_key_type_fetch('key1');
29 keyring_key_type_fetch('key1')
30 AES
31 SELECT keyring_key_type_fetch('key2');
32 keyring_key_type_fetch('key2')
33 AES
34 SELECT keyring_key_type_fetch('key3');
35 keyring_key_type_fetch('key3')
36 AES
37 SELECT keyring_key_fetch('key1');
38 keyring_key_fetch('key1')
39 abcdefgh
40 SELECT keyring_key_fetch('key2');
41 keyring_key_fetch('key2')
42 12345678
43 SELECT keyring_key_fetch('key3');
44 keyring_key_fetch('key3')
45 abcdefgh12345678
46 # Stop the running server.
47 # Perform migration
48 # Taking backup of global configuration file for keyring component: component_keyring_file
49 # Applying migration config for keyring component: component_keyring_file
50 # Performing keyring migration
51 # Restoring global configuration file from backup for keyring component: component_keyring_file
52 # Restore global manifest file for MySQL server from backup
53 # Restart server with keyring component
54 SELECT status_key, status_value FROM
55 performance_schema.keyring_component_status
56 WHERE status_key LIKE '%name%' OR status_key LIKE '%status%';
57 status_key status_value
58 Component_name component_keyring_file
59 Implementation_name component_keyring_file
60 Component_status Active
61 # Post-migration: Content of the keyring
62 SELECT keyring_key_length_fetch('key1');
63 keyring_key_length_fetch('key1')
64 8
65 SELECT keyring_key_length_fetch('key2');
66 keyring_key_length_fetch('key2')
67 8
68 SELECT keyring_key_length_fetch('key3');
69 keyring_key_length_fetch('key3')
70 16
71 SELECT keyring_key_type_fetch('key1');
72 keyring_key_type_fetch('key1')
73 AES
74 SELECT keyring_key_type_fetch('key2');
75 keyring_key_type_fetch('key2')
76 AES
77 SELECT keyring_key_type_fetch('key3');
78 keyring_key_type_fetch('key3')
79 AES
80 SELECT keyring_key_fetch('key1');
81 keyring_key_fetch('key1')
82 abcdefgh
83 SELECT keyring_key_fetch('key2');
84 keyring_key_fetch('key2')
85 12345678
86 SELECT keyring_key_fetch('key3');
87 keyring_key_fetch('key3')
88 abcdefgh12345678
89 SELECT keyring_key_remove('key1');
90 keyring_key_remove('key1')
91 1
92 SELECT keyring_key_remove('key2');
93 keyring_key_remove('key2')
94 1
95 SELECT keyring_key_remove('key3');
96 keyring_key_remove('key3')
97 1
98 # ----------------------------------------------------------------------
99 # Clean-up
100 DROP FUNCTION keyring_key_fetch;
101 DROP FUNCTION keyring_key_type_fetch;
102 DROP FUNCTION keyring_key_length_fetch;
103 DROP FUNCTION keyring_key_remove;
104 UNINSTALL PLUGIN keyring_udf;
105 # ----------------------------------------------------------------------
106 # ----------------------------------------------------------------------
107 # Teardown
108 # Removing local keyring file for keyring component: component_keyring_file
109 # Removing global configuration file for keyring component: component_keyring_file
110 # Removing global manifest file for MySQL server
111 # Restarting server without the manifest file
112 # ----------------------------------------------------------------------