What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE?
Mysql – the MySQL equivalent of SQL Server 2016 Always Encrypted technology
always-encryptedencryptionMySQL
Related Question
- SQL Server 2016 Encryption – Clarification on Always Encrypted
- SQL Server – Advantages of Always Encrypted 2016 vs Encrypted Columns
- Sql-server – Error 71501, 71561 while encrypting columns using always encrypted feature of SQL Server 2016
- SQL Server 2016 – Combining Always Encrypted and Column Level Encryption
- SQL Server 2016 – Encrypt Data, Log, and Backup Files Using Always Encrypted
- Sql-server – How to rotate the CMK of Always Encrypted using SSMS
- Sql-server – SQL 2016 Always encrypted for all data
Best Answer
The Always Encrypted feature provides end-to-end encryption, which encrypts data both in-flight, and at rest. Data is encrypted & decrypted on the client at the driver. Data is encrypted everywhere except for on he client machine. This is one step beyond encryption at rest (which is handled in SQL Server by Transparent Data Encryption).
Other RDBMS products do not have a feature which is quite the same. To do something similar on another RDBMS, you could perform encryption on the client within your application, and then send data in its encrypted format to the database.
Also, with deterministic encryption, SQL Server Always Encrypted allows point lookups, equality joins, grouping, and indexing on encrypted columns, which is often not handled by home-grown encryption.