GCP CloudSQL Flashcards

1
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

It is because SQL required better random write performance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Yes during deployment you can select the storage capacity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

No for Gen2 and Yest for Gen1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

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 well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How can be enable backups for CloudSQL?

A

This is a config option, you can schedule the time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Can I replicate the database?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the storage limit on GCP Cloud SQL?

A

10TB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Is data encrypted?

A

Yes, bot at rest and in transit.

17
Q

How can I import and export a database from mysql?

A

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.

18
Q

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

A

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

19
Q

How many backups are retained?

A

7 backups are retained,

20
Q

Are backups incremental?

A

Yes for Gen2 and no for Gen 1

21
Q

Where are backup stored?

A

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

22
Q

I need to export backup, can I do this?

A

No

23
Q

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

A

No for Gen2 and Yes for Gen1

24
Q

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

A

Create read replicas.

25
Q

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

A

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

26
Q

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

A

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

27
Q

What is CloudSQL proxy?

A

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

28
Q

How can make a copy of ClodSQL quickly?

A

Use DB cloning.

29
Q

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

A

Yes, this is an option in the web console.

30
Q

Can I have two fail-over replicas of CloudSQL?

A

No, only a single replica is allowed.

31
Q

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

A

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

32
Q

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

A

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.