The Ultimate Guide to High Availability with MariaDB

Aria Disabling Encryption

You are viewing an old version of this article. View the current version here.

Disabling Encryption for Automatically Encrypted Tables

Disabling Encryption for User-created Tables

Disabling encryption of Aria tables is done by setting aria_encrypt_tables=OFF. When this is set, all Aria tables that are created from that point forward will be unencrypted.

Decrypting Pre-existing Aria Tables

The InnoDB storage engine has background encryption threads that allow the storage engine to perform encryption changes as the configuration changes. Aria does not currently have anything like that.

If you want to decrypt pre-existing Aria tables after a configuration change, then it will take a bit more work.

First, set aria_encrypt_tables=OFF:

SET GLOBAL aria_encrypt_tables=OFF;

Then, find any Aria tables that use the PAGE ROW_FORMAT:

SELECT TABLE_SCHEMA, TABLE_NAME 
FROM information_schema.TABLES 
WHERE ENGINE='Aria' 
AND ROW_FORMAT='PAGE'
AND TABLE_SCHEMA != 'information_schema';

Then, for each table in the results, rebuild the table:

ALTER TABLE aria_tab ENGINE=Aria ROW_FORMAT=PAGE;

When the table is rebuilt, it will be unencrypted.

Disabling Encryption for Internal On-disk Temporary Tables

Disabling encryption of internal temporary tables that use Aria is done by setting encrypt_tmp_disk_tables=OFF. When this is set, all internal temporary tables that are created from that point forward will be unencrypted.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.