This feature is considered BETA quality.
In Percona Server
5.7.20-18 existing tablespace encryption support
has been extended to handle general tablespaces. A general tablespace is either
fully encrypted, covering all the tables inside, either not encrypted at all.
It is not possible to have only some of the tables in the general tablespace
This feature extends the CREATE TABLESPACE
statement to accept the
Only one keyring plugin should be enabled at a time. Enabling multiple keyring plugins is unsupported and may result in data loss.
General tablespace encryption is enabled by the following syntax extension:
mysql> CREATE TABLESPACE tablespace_name ... ENCRYPTION='Y'
Attempts to create or to move tables, including partitioned ones, to a general tablespace with an incompatible encryption setting are diagnosed and aborted.
As you cannot move tables between encrypted and unencrypted tablespaces,
you will need to create another table, add it to a specific tablespace and run
INSERT INTO SELECT from the table you want to move from, and then you will
get encrypted or decrypted table with your desired content.
To create an encrypted tablespace run:
mysql> CREATE TABLESPACE foo ADD DATAFILE 'foo.ibd' ENCRYPTION='Y';
To add an encrypted table to that table space run:
mysql> CREATE TABLE t1 (a INT, b TEXT) TABLESPACE foo ENCRYPTION="Y";
Trying to add unencrypted table to this table space will result in an error:
mysql> CREATE TABLE t3 (a INT, b TEXT) TABLESPACE foo ENCRYPTION="N"; ERROR 1478 (HY000): InnoDB: Tablespace `foo` can contain only an ENCRYPTED tables.
Percona XtraBackup currently doesn’t support backup of encrypted general tablespaces.
The safest way to load the plugin is to do it on the server startup by using –early-plugin-load variable option:
--early-plugin-load="keyring_vault=keyring_vault.so" \ --loose-keyring_vault_config="/home/mysql/keyring_vault.conf"
It should be loaded this way to be able to facilitate recovery for encrypted tables.
Apart from installing plugin you also need to set the
keyring_vault_config variable. This variable should point to the
keyring_vault configuration file, whose contents are discussed below.
This plugin supports the SQL interface for keyring key management described in General-Purpose Keyring Key-Management Functions manual.
To enable the functions you’ll need to install the
mysql> INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so';
On plugin initialization
keyring_vault connects to the Vault server using
credentials stored in the credentials file. Location of this file is specified
keyring_vault_config. On successful initialization it
retrieves keys signatures and stores them inside an in-memory hash map.
Configuration file should contain following information:
vault_url- the address of the server where Vault is running. It can be a named address – like in example or ip address. The important part is that it should start with
secret_mount_point- the name of the mount point where
keyring_vaultwill store keys
token- the token that
keyring_vaultshould use when connecting to the Vault. When
keyring_vaultis to used only for transparent data encryption and not for
keyring_udfplugin, the token allows for storing new keys in secret mount point. However if
keyring_udfplugin is used with
keyring_vaultplugin this token also allows removing keys from vault. This is due to the fact that
vault_ca [optional]- this variable needs to be specified only when Vault’s CA certificate is not trusted by the machine that is going to connect to the Vault server. In this case this variable should point to CA certificate that was used to signed Vault’s certificates.
An example of the configuration file looks like this:
vault_url = https://vault.public.com:8202 secret_mount_point = secret token = 58a20c08-8001-fd5f-5192-7498a48eaf20 vault_ca = /data/keyring_vault_confs/vault_ca.crt
When a key is fetched from a
keyring for the first time
goes to the Vault server and retrieves key’s type and data. Next it queries
the Vault server for the key type and data and caches it locally.
Key deletion will permanently delete key from in-memory hash map and the Vault server.
Percona XtraBackup currently doesn’t support backup of tables encrypted with Keyring Vault plugin.
This variable is used to define the location of the Keyring Vault plugin configuration file.
For general inquiries, please send us your question and someone will contact you.