jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

feature request: master-master replication #109

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
This is not a problem, it is a lack of a feature (feature 

What is the name of your database instance?
N/A for this issue.

What is the expected output? What do you see instead?
N/A for this issue.

Please provide any additional information below.
It would be really great if Cloud SQL supported master-master replication with 
one of the instances being a local MySQL instance.
It looks like MariaDB supports this, so maybe not that difficult for Cloud SQL 
to support:
https://mariadb.com/kb/en/mariadb/what-is-mariadb-galera-cluster/

Our use case is an existing ecommerce database (hundreds of tables) that is 
hosted outside Google Cloud (and will likely continue so) with a copy of that 
database now running on Cloud SQL and being refreshed every 12 hours. The 
problem is, we do need to make writes back to the database in Google Cloud 
(small % of load, but lots of transactions) and write those back to the master 
ecommerce database. So if we had a master-master setup where we could 
read/write the Google Cloud SQL instance and it would update the other master 
ecommerce database, that would solve our problem completely.

Original issue reported on code.google.com by rhd...@gmail.com on 8 May 2015 at 5:28