Taken from this link: https://cloud.google.com/sql/docs/mysql/high-availability#normal

enter image description here

After setup a 2nd generation mySQL failover instance in Cloud SQL, found that actually two IP addresses were provided, one for master, and another for failover instance.

From the picture above, how can we determine the "IP address X"? is it

  1. a separated load balancer IP?
  2. the IP of the master instance?

Cloud SQL has 2 failover (HA) strategies

-- The newest strategy(that correspond to your diagram) does not offer a second public or private IP, you can't reach the standby instance.

-- The legacy strategy you have a second cloud sql instance(failover) that can be accessible from his own public and private IP

In both cases when you master instance has a failover event all traffic is routed to the standby instance/failover replica, using the same IPs and the same connection name.

Always use the master IP address.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.