Hi, It is very encouraging after hearing such comments. To answer your question.. Actually No. Read Replica's and the Failover replica's are billed separately. For example, assume that you provisioned 1 CloudSQl Master Instance With HA + 1 Read Replica. In this case, you are liable to Pay for 1 CloudSQL Master Instance + 1 Read Replica + Persistent Disks (Used for HA) + Network Charges When a Failover is triggered, you are going to Pay for 1 Failover Instance + 1 Read Replica + Persistent Disk(Userd for HA) + Network Charges For more details, refer this link: cloud.google.com/sql/docs/mysql/pricing Cheers, VSPARKZ
@@CODEMENTAL As per my understanding, if you remove read replica's your HA is considered as < 100 %. Assume that you created a CloudSQL DB with 1 Master Instance + HA. At the time of disaster to the Primary Master Instance, your DB requests will be failed until the HA Instance comes live (New Primary Master). It will take few seconds-minutes to bring-up the HA Instance. During this few seconds-minutes, you cannot perform any DB operations. In the above scenario, if you have created a CloudSQL DB with 1 Master Instance + Read Replica's + HA. During the time of disaster, your Read Replica's are still be available for read/list DB operations. Once HA Instance comes into live you can perform all the DB operations. Cheers, VSPARKZ
I am trying to do the same POC but I am not able to ssh to my VM, I had added firewall policy to enable ingress traffic, still it is not working, any guidelines?
how to access cloudsql database from aws ec2 instances, i have s2s vpn tunnel for connecting both AWS and GCP and successfully connected for ping and remote each other, but when i try to connect db instances in GCP from my ec2 didn't connected, any solution?
Nice video. It felt so relaxing learning about Cloud SQL HA. Are the read replicas included in the price of the Cloud SQL instance with HA?
Hi,
It is very encouraging after hearing such comments.
To answer your question.. Actually No. Read Replica's and the Failover replica's are billed separately.
For example, assume that you provisioned
1 CloudSQl Master Instance With HA + 1 Read Replica.
In this case, you are liable to Pay for 1 CloudSQL Master Instance + 1 Read Replica + Persistent Disks (Used for HA) + Network Charges
When a Failover is triggered, you are going to Pay for 1 Failover Instance + 1 Read Replica + Persistent Disk(Userd for HA) + Network Charges
For more details, refer this link:
cloud.google.com/sql/docs/mysql/pricing
Cheers,
VSPARKZ
@@VSPARKZ Thanks for your detailed answer. The read replica is optional then? Not needed for HA?
@@CODEMENTAL As per my understanding, if you remove read replica's your HA is considered as < 100 %. Assume that you created a CloudSQL DB with 1 Master Instance + HA.
At the time of disaster to the Primary Master Instance, your DB requests will be failed until the HA Instance comes live (New Primary Master).
It will take few seconds-minutes to bring-up the HA Instance. During this few seconds-minutes, you cannot perform any DB operations.
In the above scenario, if you have created a CloudSQL DB with 1 Master Instance + Read Replica's + HA. During the time of disaster, your Read Replica's are still be available for read/list DB operations. Once HA Instance comes into live you can perform all the DB operations.
Cheers,
VSPARKZ
I am trying to do the same POC but I am not able to ssh to my VM, I had added firewall policy to enable ingress traffic, still it is not working, any guidelines?
Please check the firewall posts & sources + ensure proper routing rules are added
Nice
Thanks
how to access cloudsql database from aws ec2 instances, i have s2s vpn tunnel for connecting both AWS and GCP and successfully connected for ping and remote each other, but when i try to connect db instances in GCP from my ec2 didn't connected, any solution?
Hi Anwar,
I suspect the only problem is the firewall parameters' of cloudsql. Check if the ports and the ec2 ranges are opened in the cloudsql.
Thanks
Hey can you make a video on gcp cloud SQL IAM authentication