Replication local MySQL to Google Cloud SQL

[WooDzu]

Hello all,

I would like to setup Master-Slave replication with Clould SQL to backup our in-premises databases.

Am I right in thinking that Master-Slave replication needs the SUPER privilege which isn't available in Cloud SQL thus it cannot serve as SLAVE?

Peter

[Vinny P]

On Fri, Feb 21, 2014 at 8:01 AM, WooDzu <wood...@gmail.com> wrote:

I would like to setup Master-Slave replication with Clould SQL to backup our in-premises databases.

Am I right in thinking that Master-Slave replication needs the SUPER privilege which isn't available in Cloud SQL thus it cannot serve as SLAVE?

You can't replicate to a Cloud SQL instance as a slave, see the overview section here: https://developers.google.com/cloud-sql/docs/replication#replication-overview

However, depending on the way your in-house machines are set up, it may be possible to set the Cloud SQL machine as master and then configure your in-house machines to serve as slaves. 

 

 

-----------------

-Vinny P

Technology & Media Advisor

Chicago, IL

App Engine Code Samples: http://www.learntogoogleit.com

[WooDzu]

Yeah. It's a pitty Google didn't make it available.

Unfortunately we're not moving our apps to GAE yet for various reasons. Managed DBaaS with replication would certainly speed it up and allow for no-downtime move. The reason I'm asking this is purely instant cloud backup solution for our in-premises database.

Thanks,
Peter
EditShare