Whereas there are a number of causes to export information out of your databases – reminiscent of to keep up backups, meet regulatory information retention insurance policies, or feed downstream analytics – exports can put undue pressure in your manufacturing methods, making them difficult to schedule and handle. To remove that useful resource pressure, we’ve launched a brand new characteristic for Cloud SQL: serverless exports. Serverless exports allows you to export information out of your MySQL and PostgreSQL database situations with none impression on efficiency or danger to your manufacturing workloads.
Cloud SQL exports, which provide transportable information codecs (SQL, CSV), may be triggered anytime and are written to Cloud Storage buckets that you simply management.
If you want to meet regulatory necessities round information retention, you may simply ship exports to buckets with Bucket Lock enabled. Bucket Lock means that you can configure an information retention coverage for a Cloud Storage bucket that governs how lengthy objects within the bucket should be retained. It additionally means that you can lock the info retention coverage, completely stopping the coverage from being decreased or eliminated.
As one other instance, you may export data to CSV based on a custom query, then import the data on to BigQuery for analytics. And if that is for normal reporting, you may schedule a recurring import with Data Transfer Service or Cloud Scheduler.
Utilizing the brand new serverless export characteristic ensures these exports received’t bathroom down your Cloud SQL database occasion, so you may proceed to run predictably and reliably. And till February 2021, you need to use serverless exports at no charge.
What’s subsequent for Cloud SQL
We’re excited to see what you construct with the brand new serverless exports characteristic. Have extra concepts? Tell us what different options and capabilities you want with our Issue Tracker and by becoming a member of the Cloud SQL discussion group. We’re glad you’re alongside for the experience, and we sit up for your suggestions!