Cloud SQL

Question 1

Cloud SQL definition

Answer 1

Managed database service that provides MySQL, PostgreSQL and SQL Server databases

Question 2

Key points of CloudSQL (4)

Answer 2

1. Allows users to set up database without all the database administration tasks
2. High Availability - manages replication and allows for automatic failover
3. Suited for applications with consistent data structure (for databases that don’t need to scale horizontally)
4. Scales vertically (by running on servers with more memory and CPUs)

Question 3

What databases and versions does CloudSQL support?

Answer 3

1. MySQL 5.6/5.7 up to 416GB RAM and 30TB data storage
2. PostgreSQL up to 416GB RAM and 64 CPUs and 30TB storage
3. SQL Server 416 GB RAM 64 CPUs 30 TB storage

Question 4

How do you connect to Cloud SQL via shell?

Answer 4

gcloud sql connect [INSTANCE NAME] -user=[USERNAME]

Question 5

How do you backup (on demand) Cloud SQL via shell?

Answer 5

gcloud sql backups create –async –instance [INSTANCE NAME]

Question 6

How do you schedule automatic backup on Cloud SQL via shell?

Answer 6

gcloud sql instances patch [INSTANCE NAME] -backup-start-top [HH:MM]

Question 7

Where is backup data stored for Cloud SQL?

Answer 7

In a bucket in Cloud Store.

Question 8

How do you export Cloud SQL data via shell?

Answer 8

gcloud sql export [TYPE] {INSTANCE NAME] gs://[BUCKET]/[FILE NAME] –database=[DATABASE NAME]

You need to make sure that the service account can write to the bucket.

Question 9

How do you import Cloud SQL data via shell?

Answer 9

gcloud sql import [TYPE] {INSTANCE NAME] gs://[BUCKET]/[FILE NAME] –database=[DATABASE NAME]