2

I'm running a Google Cloud SQL instance ("mysql-master") and it has one replica. ("mysql-replica") Web apps on another servers read and write data on the Cloud SQL instance.

While mysql-master is restarting, can app servers read and write data?

I want to run gcloud sql instances patch mysql-master, but it sometimes requires the instance to restart. I wonder if web apps can read/write data on the instance while it is restarting.

Improve this question

1 Answer 1

Reset to default
3

No, your read replica is a read-only, so it cannot take writes during downtime of the master. There's no good solutions to avoiding the downtime, but if you have a small database, it should come back in order seconds (most come back within 5 seconds or so).

Improve this answer
1
  • 1
    Hmm... so you can read data while restarting, but cannot write, right? OK, thank you.
    – Jumpei Ogawa
    Nov 5, 2015 at 4:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .