Write Consistency & Geographical Replication

SwampFoxxx

unread,

Mar 9, 2012, 6:43:24 PM3/9/12

to Google Cloud SQL discuss

How is write consistency maintained in case of database failures?

How are you able to perform "multiply geographically replicated"; is
this done using MMM replication?

Joe Faith

unread,

Mar 9, 2012, 7:24:44 PM3/9/12

to google-cloud...@googlegroups.com

Hi

Google Cloud SQL uses synchronous replication, meaning that every write query returns only once the data has been written to multiple geographical locations.

J

--
Joe Faith | Product Manager | Google Cloud

Ronoaldo José de Lana Pereira

unread,

Mar 11, 2012, 9:48:47 AM3/11/12

to google-cloud...@googlegroups.com

Does this impact on the read queries performance? If so, can we set a consistency policy (like we can do on AppEngine M/S Datastore) to speed up read queries?

Joe Faith

unread,

Mar 12, 2012, 1:58:53 PM3/12/12

to google-cloud...@googlegroups.com

Hi Ronoaldo

replication only happens on writes, so it doesn't affect read performance

j

2012/3/11 Ronoaldo José de Lana Pereira <rper...@beneficiofacil.com.br>

Reply all

Reply to author

Forward