3

In order to create more 'data recovery' points than the standard automatic backup policy allows, I'm going to run a cron which will export sql dumps out of my CloudSQL instances at intervals throughout the day. I know I can do this using the gcloud command as follows:

cloud sql export sql [INSTANCE_NAME] gs://[BUCKET_NAME]/sqldumpfile.gz \
    --database=[DATABASE_NAME] --table=[TABLE_NAME1,TABLE_NAME2, ...]

There is not much info on Google support docs as to what is actually happening here. What's important to me is whether this process causes tables to be locked on export like a mysqldump command would (without the appropriate flags)

I know that the gcloud export function includes the --skip-triggers flag, but there is no information about table locking. Can anybody help?

  • Any particular reason you don't want to ask Google support, for which you are probably paying? – mustaccio Jan 23 '19 at 13:25
  • @molenpad were you able to find an answer? I'm in the same boat. – Mark S Jan 20 at 16:18
  • 1
    @MarkS Yes, there is no table locking involved with mysql on cloudsql. To be honest, we managed to avoid doing it this way by running a cron job in kubernetes which issues a gcloud sql backup command every few hours. I'd suggest looking at something like that. – Molenpad Jan 31 at 14:39
  • Thanks @Molenpad! – Mark S Jan 31 at 18:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.