diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-05-09 12:31:53 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-05-13 14:27:16 +0200 |
| commit | ab8415d9835c750e7b9c71595744c95d4426d591 (patch) | |
| tree | 5a765391645bc8daa1326ec89e49de4138abbba5 /mysql-test/suite/encryption/r/innodb_encryption.result | |
| parent | b22959903b89e798f8804ec9a815c88f75915cd9 (diff) | |
| download | mariadb-git-ab8415d9835c750e7b9c71595744c95d4426d591.tar.gz | |
move encryption tests to a dedicate suite
remove few tests for variables that never existed (merge error)
Diffstat (limited to 'mysql-test/suite/encryption/r/innodb_encryption.result')
| -rw-r--r-- | mysql-test/suite/encryption/r/innodb_encryption.result | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/mysql-test/suite/encryption/r/innodb_encryption.result b/mysql-test/suite/encryption/r/innodb_encryption.result new file mode 100644 index 00000000000..283c78e33d3 --- /dev/null +++ b/mysql-test/suite/encryption/r/innodb_encryption.result @@ -0,0 +1,57 @@ +SET @start_global_value = @@global.innodb_encryption_threads; +SHOW VARIABLES LIKE 'innodb_encrypt%'; +Variable_name Value +innodb_encrypt_log ON +innodb_encrypt_tables ON +innodb_encryption_rotate_key_age 15 +innodb_encryption_rotation_iops 100 +innodb_encryption_threads 4 +DESCRIBE INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION; +Field Type Null Key Default Extra +SPACE int(11) unsigned NO 0 +NAME varchar(655) YES NULL +ENCRYPTION_SCHEME int(11) unsigned NO 0 +KEYSERVER_REQUESTS int(11) unsigned NO 0 +MIN_KEY_VERSION int(11) unsigned NO 0 +CURRENT_KEY_VERSION int(11) unsigned NO 0 +KEY_ROTATION_PAGE_NUMBER bigint(21) unsigned YES NULL +KEY_ROTATION_MAX_PAGE_NUMBER bigint(21) unsigned YES NULL +# Wait max 5 min for key encryption threads to encrypt one space +# Success! +# Wait max 10 min for key encryption threads to encrypt all space +# Success! +# Now turn off encryption and wait for threads to decrypt everything +SET GLOBAL innodb_encrypt_tables = off; +# Wait max 10 min for key encryption threads to decrypt all space +# Success! +# Shutdown innodb_encryption_threads +SET GLOBAL innodb_encryption_threads=0; +# Turn on encryption +# since threads are off tables should remain unencrypted +SET GLOBAL innodb_encrypt_tables = on; +# Wait 15s to check that nothing gets encrypted +# Success! +# Startup innodb_encryption_threads +SET GLOBAL innodb_encryption_threads=@start_global_value; +# Wait 1 min to check that it start encrypting again +# Success! +# +# Check that restart with encryption turned off works +# even if spaces are encrypted +# +# First wait max 10 min for key encryption threads to encrypt all spaces +# Success! +# Restart mysqld --innodb_encrypt_tables=0 --innodb_encryption_threads=0 +SHOW VARIABLES LIKE 'innodb_encrypt%'; +Variable_name Value +innodb_encrypt_log ON +innodb_encrypt_tables OFF +innodb_encryption_rotate_key_age 15 +innodb_encryption_rotation_iops 100 +innodb_encryption_threads 0 +SELECT COUNT(*) > 0 as should_be_1 +FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION +WHERE MIN_KEY_VERSION <> 0; +should_be_1 +1 +# Restart mysqld again...with default options |