Issues with pt-mysql-summary encryption checks

Description

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

Environment

None

Smart Checklist

Activity

Show:

Details

Assignee

Reporter

Priority

Components

Affects versions

Fix versions

Story Points

Smart Checklist

Created July 25, 2018 at 5:42 PM
Updated August 3, 2023 at 5:49 PM
Loading...