Debian Codegraph @

mysql-test/suite/component_keyring_file/r/log_encrypt_6.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 # create bootstrap file
8 # Stop the MTR default DB server
9 # Run the bootstrap command of datadir1
10 # Start the DB server with datadir1
11 DROP DATABASE IF EXISTS tde_db;
12 CREATE DATABASE tde_db;
13 USE tde_db;
14 SELECT status_key, status_value FROM
15 performance_schema.keyring_component_status
16 WHERE status_key LIKE '%name%' OR status_key LIKE '%status%';
17 status_key status_value
18 Component_name component_keyring_file
19 Implementation_name component_keyring_file
20 Component_status Active
21 SET GLOBAL innodb_redo_log_encrypt = 1;
22 SELECT @@global.innodb_redo_log_encrypt ;
23 @@global.innodb_redo_log_encrypt
24 1
25 SELECT @@global.innodb_redo_log_encrypt ;
26 @@global.innodb_redo_log_encrypt
27 1
28 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
29 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
30 SELECT a,LEFT(b,10) FROM tde_db.t1;
31 a LEFT(b,10)
32 1 aaaaaaaaaa
33 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
34 ENCRYPTION='Y' ENGINE=InnoDB;
35 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
36 SELECT a,LEFT(b,10) FROM tde_db.t2;
37 a LEFT(b,10)
38 1 aaaaaaaaaa
39 SELECT @@global.innodb_redo_log_encrypt ;
40 @@global.innodb_redo_log_encrypt
41 1
42 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
43 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
44 SELECT a,LEFT(b,10) FROM tde_db.t3;
45 a LEFT(b,10)
46 1 aaaaaaaaaa
47 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
48 ENCRYPTION='Y' ENGINE=InnoDB;
49 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
50 SELECT a,LEFT(b,10) FROM tde_db.t4;
51 a LEFT(b,10)
52 1 aaaaaaaaaa
53 SELECT @@global.innodb_redo_log_encrypt ;
54 @@global.innodb_redo_log_encrypt
55 1
56 CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
57 INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
58 SELECT a,LEFT(b,10) FROM tde_db.t5;
59 a LEFT(b,10)
60 1 aaaaaaaaaa
61 CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
62 ENCRYPTION='Y' ENGINE=InnoDB;
63 INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
64 SELECT a,LEFT(b,10) FROM tde_db.t6;
65 a LEFT(b,10)
66 1 aaaaaaaaaa
67 DROP DATABASE tde_db;
68 # Taking backup of global manifest file for MySQL server
69 # Try starting without keyring : Error
70 # Search for error message
71 Pattern "Redo log was encrypted, but keyring is not loaded" found
72 Pattern "Aborting" found
73 # Restart without keyring plugin possible if redo files removed
74 # Start the DB server with datadir1
75 # Try starting without keyring and --innodb_force_recovery=SRV_FORCE_NO_LOG_REDO.
76 # Start the DB server with datadir1
77 SELECT 1;
78 1
79 1
80 # Restore global manifest file for MySQL server from backup
81 # ----------------------------------------------------------------------
82 # Teardown
83 # Removing local keyring file for keyring component: component_keyring_file
84 # Removing global configuration file for keyring component: component_keyring_file
85 # Removing global manifest file for MySQL server
86 # Restarting server without the manifest file
87 # ----------------------------------------------------------------------