[LRUG] Idempotency vs the cloud

[Frederick Cheung]

You can (apparently) now stream the mysql bin log from your rds instance, which is I think all you really need for replication. I've seen a few blog posts[1] that claim to show how to use this to setup replication although I've only given them a very cursory glance. You also have to be running the very latest and greatest mysql 5.6

Fred

[1] http://www.ruempler.eu/2013/07/07/replicating-aws-rds-mysql-databases-to-external-slaves/
On 17 Jul 2013, at 14:46, David Salgado <david at digitalronin.com> wrote:

> I don't think they mean what you think they mean.
> 
> I visited Amazon in April, and specifically asked about setting up a mysql slave outside of AWS, replicating from an RDS master. I was told it couldn't (then) be done, but was their single most requested feature for RDS.
> 
> The July announcement looks like it's worded to *suggest* you can do that, without actually *saying* you can.
> 
> My gut feeling is that, if you could do that, they and the blogosphere would have made a lot more noise about it.
> 
> But, I would be delighted to be proven wrong.
> 
> David
> 
> 
> 
> 
> On 17 July 2013 14:43, Jon Wood <jon at ninjagiraffes.co.uk> wrote:
> On 17 July 2013 14:41, David Salgado <david at digitalronin.com> wrote:
> 
> On 17 July 2013 14:34, Jon Wood <jon at ninjagiraffes.co.uk> wrote:
> RDS also has the major (for some people) problem that you can't replicate into or out of it without using separate tools.
> 
> I believe that's not longer the case, at least if I read the announcement[1] correctly.
> 
> I think that just means you can set up replica slaves *within* RDS - not slaves/masters outside of it.
> 
> You could always (or at least as long I remember) create replicas within RDS, they certainly mention "This can be useful for a variety of purposes such as syncing data with an on-premises deployment". 
> 
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org