0

We have one Google Cloud SQL instance with 1 vCPU for production. I want to grab a copy of the data by exporting to a bucket. Is this safe to do? As in might it block other operations on the instance?

Joel Peltonen
  • 13,025
  • 6
  • 64
  • 100

1 Answers1

0

I think it's important to take into consideration the RDBMS that you are using, it's mentioned in here that PostgreSQL has issues when handling big blobs in an export, and at this other SO post there's an answer with the most votes with hints to have an smoother export, since it can lead to DBs getting unresponsive, which is a pretty well known fact.

In the case of MySQL, the product doc have some tips for this case in this article where it stated: "If the server is running, it is necessary to perform appropriate locking so that the server does not change database contents during the backup"

And you can achive this by using mysqldump --lock-tables=false into your export command.

sergio franco
  • 346
  • 2
  • 10