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?