IssueTracker

What you would like to accomplish:

The user has the possibility of read replica delayed replication using Cloud SQL - MySQL. As of now CloudSQL-MySQL do NOT support creating read replica with delayed replication.

How this might work:

The user would be able to configure the read replica delayed replication on their Cloud SQL replica like using the command:

$ CHANGE MASTER TO MASTER_DELAY = N

So an event received from the source is not executed until at least N seconds later than its execution on the source.

If applicable, reasons why alternative solutions are not sufficient:

There is always the possibility to use Google Compute Engine to run a MySQL database there. But you will lose the advantages of Cloud SQL in terms of managed solutions.

Other information (workarounds you have tried, documentation consulted, etc):

I found that “The ‘CHANGE MASTER TO’ statement requires the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER privilege).” [1]

Since Cloud SQL is a managed service, it’s accompanied by some restrictions. One of them is that “customers cannot create or have access to users with superuser attributes.” [2]

[1] https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html

[2] https://cloud.google.com/sql/docs/mysql/users#superuser_restrictions