Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Test PS-3819

Description

Global non-dynamic variable INNODB_ENCRYPT_ONLINE_ALTER_LOGS added. When turned on, temporary files used for online DDL created encrypted. When variable is turned on, but no keyring plugin loaded or in case of other error, online DDL should fail with error.

 

QA Signoff notes as on 09-May-2019

Tested below features on both 5.7 and 8.0

1. Verified the temp files:

  • when --innodb_encrypt_online_alter_logs =ON/OFF 

  • when encryption is enabled but server is not started with keyring plugin

2. Verified the DDL log files:

  • when --innodb_encrypt_online_alter_logs =ON/OFF 

  • when encryption is enabled, but server is not started with keyring plugin

3. Verify the temporary tables:

  • when destination table is encrypted

  • when destination table is not encrypted

Following MTR test-cases are written to cover the functionality

1.  innodb.innodb_row_log_encryption.test
2. innodb.innodb_online_alter_encryption.test
3. sys_vars.innodb_encrypt_online_alter_logs_basic.test
4. keyring_vault.innodb_online_alter_encryption.test
5. keyring_vault.innodb_row_log_encryption.test

Pending task:
MTR test for testing temporary tables is pending.

QA Test Plan: https://confluence.percona.com/display/QA/PS-3819+Test+Plan

Smart Checklist

Activity

Ramesh Sivaraman January 16, 2019 at 11:59 AM

Yes, we can add remaining variables into encryption qa scripts.

roel.vandepaar January 16, 2019 at 10:52 AM

should we add this (and other encryption variables) to the encryption test script?

Ramesh Sivaraman January 14, 2019 at 1:21 PM

This variable is covered as part of pquery run( encryption specific) 

roel.vandepaar January 14, 2019 at 11:14 AM

was this handled in one of the scripts?

Done

Details

Assignee

Reporter

[Release Manager]

[QA Director]

[QA Engineer]

Release QA Status

[QA Engineer] Signoff product/feature testing

Original estimate

Time tracking

4d 1h 3m logged

Priority

Smart Checklist

Created February 28, 2018 at 9:05 AM
Updated March 6, 2024 at 12:24 PM
Resolved December 31, 2019 at 12:49 PM