GCP Cloud SQL PITR, how long can it take?

210 views Asked by At

We had sort of a disastrous event with a database at work (managed on Cloud SQL, it's a MySQL db) and thankfully we have point in time recovery enabled.

We went ahead and cloned the production database to a certain point in time to be able to recover the data just before the disaster, but it's now been running for more than 5 hours for a 69GB database (the size advertised on the GCP Cloud SQL panel, so the real size of the DB is probably less than that).

Does anyone have experience with this ? The status of the operation when querying it with the gcloud CLI says "RUNNING". We checked the logs of the instance to see if anything was off but there just isn't any log at all.

1

There are 1 answers

0
thclark On

Far too late for this, but I just had to do a PITR recovery on a Cloud SQL postgres instance with 4gb ram and 9Gb data in it - it took c. 25 minutes from clicking 'create' to being available.

25 minutes too long ;) but I guess I can't whine as it largely saved my a$$ this morning.