Issues with pt-mysql-summary encryption checks
General
Escalation
General
Escalation
Description
Environment
None
created by
Smart Checklist
Activity
Show:
Details
Assignee
Sveta SmirnovaSveta SmirnovaReporter
C WC WPriority
MediumComponents
Fix versions
Labels
Story Points
1
Details
Details
Assignee

Reporter

Priority
Components
Fix versions
Labels
Story Points
1
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created July 25, 2018 at 5:42 PM
Updated August 3, 2023 at 5:49 PM
There are 2 functions in pt-mysql-summary that will not work quite as expected:
collect_encrypted_tables
The first one will return tables that are potentially unencrypted (see bug #91791). From what I can tell, to correctly determine
collect_encrypted_tables
you need to use the something like the following to confirm:PS
MariaDB
For MariaDB, tables can be automatically encrypted and do not appear to have the identifier in the create options:
For MariaDB in particular, it should be noted that the comment (and alter) is different:
Sadly, Oracle doesn't seem to have a way other than by trying to inspect the data.
collect_encrypted_tablespaces
This will fail on MySQL 8.0 as the views have been renamed