Update the Encrypting a File-Per-Table Tablespace examples
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Done
Details
Details
Assignee
alina.derkach
alina.derkachReporter
Eleonora Zinchenko
Eleonora ZinchenkoPlanned Version/s
Needs QA
Yes
Needs Doc
Yes
Components
Fix versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created March 12, 2024 at 1:22 PM
Updated March 14, 2024 at 5:29 PM
Resolved March 14, 2024 at 5:29 PM
Hi,
There are some errors in https://docs.percona.com/percona-server/5.7/security/data-at-rest-encryption.html#architecture
Encrypting a File-Per-Table Tablespace should have comma:
CREATE TABLE myexample (id INT, mytext varchar(255)) ENCRYPTION='Y';
`To enable encryption to an existing tablespace, add the
ENCRYPTION
option to theALTER TABLE
statement.` should be ALTER but not create:ALTER TABLE myexample ENCRYPTION='Y';
`The CREATE TABLESPACE statement is extended to allow the
ENCRYPTION=[' Y/N']
option.` I think here in examples we were planning to havetablespace
but not table like:CREATE TABLESPACE my_tablespace ENCRYPTION='Y';