# ----------------------------------------------------------------------
# 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
# ----------------------------------------------------------------------
# create bootstrap file
# Stop the MTR default DB server
# Run the bootstrap command of datadir1
# Start the DB server with datadir1
SELECT @@global.innodb_redo_log_encrypt ;
@@global.innodb_redo_log_encrypt
1
USE test;
CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
SELECT * FROM tab1;
c1	c2
1	Test consistency undo*
CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
SELECT * FROM tab2;
c1	c2
1	Test consistency undo*
DROP TABLE tab1,tab2;
# Kill the server
# Removing local keyring file for keyring component: component_keyring_file
# Taking backup of global manifest file for MySQL server
# Run the bootstrap command of datadir2, it should fail since the keyring is not loaded.
# Restore global manifest file for MySQL server from backup
# Run the bootstrap command of datadir2
# Start the DB server with datadir2
SELECT @@global.innodb_redo_log_encrypt ;
@@global.innodb_redo_log_encrypt
1
USE test;
CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
SELECT * FROM tab1;
c1	c2
1	Test consistency undo*
CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
SELECT * FROM tab2;
c1	c2
1	Test consistency undo*
DROP TABLE tab1,tab2;
# Kill the server
# Removing local keyring file for keyring component: component_keyring_file
# Run the bootstrap command of datadir3
# Start the DB server with datadir3 and keyring loaded.
SELECT @@global.innodb_redo_log_encrypt ;
@@global.innodb_redo_log_encrypt
0
USE test;
CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
SELECT * FROM tab1;
c1	c2
1	Test consistency undo*
CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
DROP TABLE tab1;
# Kill the server
# Removing local keyring file for keyring component: component_keyring_file
# ----------------------------------------------------------------------
# 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
# ----------------------------------------------------------------------