1

I've been trying out GCPs SQL high availability options. Is there a way to improve the fail over speed?

Attempting manual failovers through the UI takes literally over 5 minutes where mysql is completely unavailable.

I am using the smallest second generation 5.7 instances possible currently with no traffic hitting it.

It looks like it's actually stopping and starting instances. I'm having trouble seeing how this is an option for "HA" meaning minimal downtime.

Improve this question
0

2 Answers 2

Reset to default
0

Unfortunately you are at the mercy of the managed service provider there. GCPs managed database offering isn't that great, they lag quite far behind the others, they want to steer you onto BigTable, BigQuery and Cloud Spanner. If you are committed to GCP and have a hard requirement for HA then your best option is probably Spanner. – Gaius

Improve this answer
1
  • This is incorrect - moving to Spanner only for HA is probably the incorrect move. Spanner's biggest benefit over traditional SQL servers are scale and global constancy. BigTable, BigQuery, and Cloud Spanner all have different pros and cons, and you should use the best tool for the job at hand.
    – kurtisvg
    Feb 24, 2019 at 20:15
1

There isn't anything you can do to improve the failover time, but you can add a read replica to have read access to your data while your instance is recovering.

If you aren't locked down to MySQL, you should also try the Postgres version of Cloud SQL - it uses a faster method for recovery and from my personal experience is generally down for ~30-60 seconds. Each version has it's own page on HA, which talks about how they work: MySQL, Postgres

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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