Enterprise Cloud SQL Masking

[Ashwin Purohit]

Is there a way to enable MySQL's Enterprise Masking and De-identification (https://www.mysql.com/de/products/enterprise/masking.html) on Google Cloud SQL? We could pay for a license, I just don't know if this is possible. If this is not possible, does anyone know a way around this that isn't as expensive as DataSunrise (which costs 8k yearly per instance + 6k for all further instances)?

[Jad El Houssami]

Hello Ashwin, 

It is not possible to install Enterprise Masking and De-identification on CloudSQL instances because that would require the “INSTALL PLUGIN” statement which is not supported by CloudSQL (see "Unsupported statements").

As a workaround, you can install your MySQL databases on Google Compute Engine (GCE) instances instead. Those instances will have to be managed by you, however it will allow you to use the statements required to install Masking and De-identification. You may estimate the costs of using GCE instances using the Google Cloud Platform Pricing Calculator.

[Ashwin Purohit]

Thank you!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2f96dddd-2221-4ef3-8583-67d9715b3a2e%40googlegroups.com.

--

Ashwin Purohit

Director of Operations, EMEA | Lilt GmbH, Berlin