How to leverage Azure Encryption for MYSQL DB

Koteswara Pentakota 71 Reputation points
2022-05-10T04:08:54.053+00:00

Hi Team,

We have explicitly encrypted some PII Data at our MySQL DB. This is causing some issues while connecting to our Database and populate it else where with decryption needed always.

Is there a way we can leverage this to the Azure MySQL where i read the Encryption is taken up by default and while reading the data it auto decrypts the content and shares it back to the queries.

If this is possible, do we see encrypted data for the said columns or the entire Table data while viewing it on the Database and when does it actually return the decrypted version.

Any inputs on this would really help.

Thanks,
Kotesh

Azure Disk Encryption
Azure Disk Encryption
An Azure service for virtual machines (VMs) that helps address organizational security and compliance requirements by encrypting the VM boot and data disks with keys and policies that are controlled in Azure Key Vault.
164 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
Azure ISV (Independent Software Vendors) and Startups
Azure ISV (Independent Software Vendors) and Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.ISV (Independent Software Vendors) and Startups: A Microsoft program that helps customers adopt Microsoft Cloud solutions and drive user adoption.
91 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,586 Reputation points
    2022-05-10T08:52:13.663+00:00

    Thanks for providing more details @Koteswara Pentakota .

    Data Encryption at rest basically protects data against attacks where in the data, backups are all encrypted on disk.

    But if someone has access to database through credentials, they will be able to see all the table data as it is.

    I have received the response back from product group and table/row/column level encryption is not available out of the box as of now.

    However we can use Encryption and Compression Functions to achieve the same. The article mentioned has clear description on how to use them while inserting and then reading the data back from the tables.

    Please let us know if this helps or else we can discuss further on the same.

    ----------

    If answer helps your query, you can mark it 'Accept Answer' to help others having similar query.