GCP CloudSQL Flashcards
When creating a Google ClousSQL database, can I have the instances created in more than a single zone?
No there is only a single instance of the database, so it will only be created in a single zone. But you can have a read replica or a fail-over node in a separate zone.
When creating a Google ClousSQL database, can I choose the instance size and memory?
Yes, this can be done when you are creating to ClousSQL database.
Why do you think the default drive type is SSD for CloudSQL?
It is because SQL required better random write performance.
When creating a Google ClousSQL database, can I decide the capacity of the disk storage?
Yes during deployment you can select the storage capacity.
When creating a Google ClousSQL database, I need to increase the performance of the read and write, I am already using SSD, what can I do?
Increase the storage capacity and this increases the amount of read; I, write throughput, and the W/R IOPS.
In CloudSQL what can I have CloudSQL automatically do when the disk storage is nearing its max?
You can have CloudSQL automatically increase storage for you, you can also set a cap of how much storage is added.
In CloudSQL I need to perform a backup, what options do I have?
CloudSQL comes with automatic backup, you can enable or disable it, by default;t is enabled.
In CloudSQL, when a backup is been created, do I get a performance hit?
No for Gen2 and Yest for Gen1
In CloudSQL, I want to ensure that maintenance performed by Google is only carried out on Sunday between1am and 6 AM, is this possible
Yes In CloudSQL there is an option in the configuration of the CloudSQL to set up maintenance window.
Is it possible for Cloud SQL to be configured for automatic failover?
Yes, this is a config option, it will ensure that if the zone was to fail the database would automatically failover to another zone
How can be enable backups for CloudSQL?
This is a config option, you can schedule the time
When using a replica, is it free as part of the service?
No, you are billed for the other instance of the database
Is it possible to configure the size of the instances service the database?
Yes, you get to chose the instance CPU and memory.
Can I replicate the database?
Yes, here are options,
- Read replica: A ClousSQL replica
- External read replica: External MySql replica
- External master: Where you want to migrate data form
What is the storage limit on GCP Cloud SQL?
10TB