Friday, December 1, 2017

[google-cloud-sql-discuss] Re: cloud sql failover instance connecting to wrong master instance

I was not able to reporduce your scenario. This are the steps I followed. 

1- Created a Cloud SQL  second generation instance named "master-instance-a" and setup root password
2- Cloned the instance to "master-instance-b"
3- Added the failover to the cloned instance using the console.  The server deployed with no errors.

Since in this first test the original instance did not had a failover, I tested again

4- I cloned Master-Instance-b (which now had a failover) and created "master-instance-c"
5- Add a failover. 

After that I had the following servers:

~$ gcloud sql instances list
NAME                         DATABASE_VERSION  REGION       TIER              ADDRESS         STATUS
master-instance--c           MYSQL_5_7         us-central1  db-n1-standard-1  xxxxxxxxxxxxxx  RUNNABLE
master-instance--c-failover  MYSQL_5_7         us-central1  db-n1-standard-1  xxxxxxxxxxxxxx  RUNNABLE
master-instance-a            MYSQL_5_7         us-central1  db-n1-standard-1  xxxxxxxxxxxxxx  RUNNABLE
master-instance-b            MYSQL_5_7         us-central1  db-n1-standard-1  xxxxxxxxxxxxxx  RUNNABLE
master-instance-b-failover   MYSQL_5_7         us-central1  db-n1-standard-1  xxxxxxxxxxxxxx  RUNNABLE

How dows it look for your project when you list the instances using the CLI? You can try to delete any undesired instances via the CLI. Can you provide details on the command used to connect to the failover?


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f7986236-7cd6-4d9a-9a3c-aaf0e4fcec86%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment