68 lines
2.2 KiB
Plaintext
68 lines
2.2 KiB
Plaintext
# create bootstrap file
|
|
# Stop the MTR default DB server
|
|
# Run the bootstrap command of datadir1
|
|
# Start the DB server with datadir1
|
|
DROP DATABASE IF EXISTS tde_db;
|
|
CREATE DATABASE tde_db;
|
|
USE tde_db;
|
|
SET GLOBAL innodb_redo_log_encrypt = 1;
|
|
SELECT @@global.innodb_redo_log_encrypt ;
|
|
@@global.innodb_redo_log_encrypt
|
|
1
|
|
SELECT @@global.innodb_redo_log_encrypt ;
|
|
@@global.innodb_redo_log_encrypt
|
|
1
|
|
CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
|
|
INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t1;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
|
|
ENCRYPTION='Y' ENGINE=InnoDB;
|
|
INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t2;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
SELECT @@global.innodb_redo_log_encrypt ;
|
|
@@global.innodb_redo_log_encrypt
|
|
1
|
|
CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
|
|
INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t3;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
|
|
ENCRYPTION='Y' ENGINE=InnoDB;
|
|
INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t4;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
SELECT @@global.innodb_redo_log_encrypt ;
|
|
@@global.innodb_redo_log_encrypt
|
|
1
|
|
CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
|
|
INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t5;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
|
|
ENCRYPTION='Y' ENGINE=InnoDB;
|
|
INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
|
|
SELECT a,LEFT(b,10) FROM tde_db.t6;
|
|
a LEFT(b,10)
|
|
1 aaaaaaaaaa
|
|
UNINSTALL PLUGIN keyring_file;
|
|
DROP DATABASE tde_db;
|
|
# Try starting without keyring : Error
|
|
# Search for error message
|
|
Pattern "Redo log was encrypted, but keyring plugin is not loaded" found
|
|
Pattern "Aborting" found
|
|
# Restart without keyring plugin possible if redo files removed
|
|
# Start the DB server with datadir1
|
|
# Try starting without keyring and --innodb_force_recovery=SRV_FORCE_NO_LOG_REDO.
|
|
# Start the DB server with datadir1
|
|
SELECT 1;
|
|
1
|
|
1
|
|
# restart
|