GCP CloudSQL

Question 1

When creating a Google ClousSQL database, can I have the instances created in more than a single zone?

Answer 1

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.

Question 2

When creating a Google ClousSQL database, can I choose the instance size and memory?

Answer 2

Yes, this can be done when you are creating to ClousSQL database.

Question 3

Why do you think the default drive type is SSD for CloudSQL?

Answer 3

It is because SQL required better random write performance.

Question 4

When creating a Google ClousSQL database, can I decide the capacity of the disk storage?

Answer 4

Yes during deployment you can select the storage capacity.

Question 5

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?

Answer 5

Increase the storage capacity and this increases the amount of read; I, write throughput, and the W/R IOPS.

Question 6

In CloudSQL what can I have CloudSQL automatically do when the disk storage is nearing its max?

Answer 6

You can have CloudSQL automatically increase storage for you, you can also set a cap of how much storage is added.

Question 7

In CloudSQL I need to perform a backup, what options do I have?

Answer 7

CloudSQL comes with automatic backup, you can enable or disable it, by default;t is enabled.

Question 8

In CloudSQL, when a backup is been created, do I get a performance hit?

Answer 8

No for Gen2 and Yest for Gen1

Question 9

In CloudSQL, I want to ensure that maintenance performed by Google is only carried out on Sunday between1am and 6 AM, is this possible

Answer 9

Yes In CloudSQL there is an option in the configuration of the CloudSQL to set up maintenance window.

Question 10

Is it possible for Cloud SQL to be configured for automatic failover?

Answer 10

Yes, this is a config option, it will ensure that if the zone was to fail the database would automatically failover to another zone

Question 11

How can be enable backups for CloudSQL?

Answer 11

This is a config option, you can schedule the time

Question 12

When using a replica, is it free as part of the service?

Answer 12

No, you are billed for the other instance of the database

Question 13

Is it possible to configure the size of the instances service the database?

Answer 13

Yes, you get to chose the instance CPU and memory.

Question 14

Can I replicate the database?

Answer 14

Yes, here are options,
-Read replica: A ClousSQL replica
-External read replica: External MySql replica
-External master: Where you want to migrate data form

Question 15

What is the storage limit on GCP Cloud SQL?

Answer 15

10TB

Question 16

Is data encrypted?

Answer 16

Yes, bot at rest and in transit.

Question 17

How can I import and export a database from mysql?

Answer 17

You can use the inport and export featiure in CloudSQL to import or export database dumps. You cna also use the mysqldump cli command from any linux distro.

Question 18

I need to preform some maintenance on the DB, can I back it manually?

Answer 18

Yes 100%, there is an option in console and also you can use gcloud.

Question 19

How many backups are retained?

Answer 19

7 backups are retained,

Question 20

Are backups incremental?

Answer 20

Yes for Gen2 and no for Gen 1

Question 21

Where are backup stored?

Answer 21

Backup data is stored in two regions on same continent, except for austriala where data is stored also in Asia.

Question 22

I need to export backup, can I do this?

Answer 22

No

Question 23

When talking a backup of the database, will performance be affected?

Answer 23

No for Gen2 and Yes for Gen1

Question 24

I need to increase the read performance of CloudSQL, what are my options?

Answer 24

Create read replicas.

Question 25

I need to increase the read performance of CloudSQL, what are my options?

Answer 25

Create read replicas, I can do this in any of the zones in the region.

Question 26

I need to ensure high availability for Cloud=SQL MySQL, what options do I have?

Answer 26

You can create a fail-over instance of the data base.

Question 27

What is CloudSQL proxy?

Answer 27

It enables you to connect form your application to CloudSQL with out exposing a public IP.

Question 28

How can make a copy of ClodSQL quickly?

Answer 28

Use DB cloning.

Question 29

I have a read replica CloudSQL, is it possible to promote it to be a standalone R/W instance?

Answer 29

Yes, this is an option in the web console.

Question 30

Can I have two fail-over replicas of CloudSQL?

Answer 30

No, only a single replica is allowed.

Question 31

When fail-over occurs of the CloudSQL database, will I have to use a new IP to connect with the CloudSQL?

Answer 31

No, the IP is changed to the failed over instance.

Question 32

I have an on-prem MySQL database and I want to migrate it to cloud, what options do I have?

Answer 32

CloudSQL can help by using Migration Data feature to migrate the database. You create a CloudSQL instance to be used and provide it with a see file form the database you want to migrate, you sldo ensure connectivity and then it will replicate, when finished it get promoted.