Details

    • Type: Release QA
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.7.21-21
    • Component/s: None
    • Labels:
    • Release QA Status:
      [QA Engineer] Signoff product/feature testing

      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

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                mohit.joshi Mohit Joshi
                Reporter:
                sergei.glushchenko Sergei Glushchenko (Inactive)
                [Release Manager]:
                Hrvoje Matijakovic
                [QA Director]:
                Roel Van de Paar (Inactive)
                [QA Engineer]:
                Mohit Joshi
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - 2 days Original Estimate - 2 days
                    2d
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 4 days, 1 hour, 3 minutes
                    4d 1h 3m