[MDEV-9639] Galera Cluster files (galera.cache, others) and slow log/general log are not encrypted when encryption is enabled Created: 2016-02-26 Updated: 2024-01-14 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Encryption |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | Alexander Rubin | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 5 |
| Labels: | None | ||
| Issue Links: |
|
||||
| Description |
|
All data points of MariaDB 10.1.11 can be encrypted except: Please make those encryptable. Thank you! |
| Comments |
| Comment by Elena Stepanova [ 2016-02-26 ] | ||
|
arubin, | ||
| Comment by Alexander Rubin [ 2016-02-27 ] | ||
|
Elena Stepanova, I have upgraded to MariaDB 10.1.12 and relay logs are encrypted. | ||
| Comment by Elena Stepanova [ 2016-02-27 ] | ||
|
Other things are not supposed to be encrypted, it has never been implemented or declared as such. I'll convert it into a feature request, although I'm not sure that encryption of general log / slow query log is practical. | ||
| Comment by Alexander Rubin [ 2016-02-29 ] | ||
|
Elena, Thank you very much for your comments! Make sense on Slow Query log / General Log. Is there any plans to implement encryption for Galera files? Thanks! | ||
| Comment by Elena Stepanova [ 2016-02-29 ] | ||
|
nirbhay_c, see the question above – any plans for encryption of Galera files? | ||
| Comment by Valerie Parham-Thompson [ 2016-03-07 ] | ||
|
@Elena, I would like to see the slow log encrypted, too, but I see the issue as you described it. What if you were to automatically encrypt the tables created when encryption is configured to be on, in the case these logs were written to table only (not file) as in https://mariadb.com/kb/en/mariadb/writing-logs-into-tables/ (I know this is not InnoDB though)?
| ||
| Comment by Kolbe Kegel (Inactive) [ 2016-03-07 ] | ||
|
I added a note about these limitations to https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/#limitations. | ||
| Comment by Nirbhay Choubey (Inactive) [ 2016-03-08 ] | ||
|
Its indeed a better choice to enable encryption for CSV engine and switch to table based logs for encryption. | ||
| Comment by Kolbe Kegel (Inactive) [ 2016-03-08 ] | ||
|
The Aria engine can be used for the log tables, and Aria tables can be encrypted. However, the Aria log is not currently encrypted, so Aria-based log tables ends up being not a very good solution. | ||
| Comment by Guillaume Lefranc [ 2016-06-07 ] | ||
|
galera replication data can be encrypted using SSL: | ||
| Comment by Ceri Williams [ 2018-07-25 ] | ||
|
The limitation description is deceptive:
When using SET GLOBAL log_output = "TABLE" you would clearly consider this to no longer be FILE, despite the CSV engine writing files that are human readable. |