<div dir="ltr">You have no idea how happy you've just made me ;)<div class="gmail_extra"><br><div class="gmail_quote">On 17 July 2013 14:51, Frederick Cheung <span dir="ltr"><<a href="mailto:frederick.cheung@gmail.com" target="_blank">frederick.cheung@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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<br>
<br>
Fred<br>
<br>
[1] <a href="http://www.ruempler.eu/2013/07/07/replicating-aws-rds-mysql-databases-to-external-slaves/" target="_blank">http://www.ruempler.eu/2013/07/07/replicating-aws-rds-mysql-databases-to-external-slaves/</a><br>
<div class="HOEnZb"><div class="h5">On 17 Jul 2013, at 14:46, David Salgado <<a href="mailto:david@digitalronin.com">david@digitalronin.com</a>> wrote:<br>
<br>
> I don't think they mean what you think they mean.<br>
><br>
> 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.<br>
><br>
> The July announcement looks like it's worded to *suggest* you can do that, without actually *saying* you can.<br>
><br>
> My gut feeling is that, if you could do that, they and the blogosphere would have made a lot more noise about it.<br>
><br>
> But, I would be delighted to be proven wrong.<br>
><br>
> David<br>
><br>
><br>
><br>
><br>
> On 17 July 2013 14:43, Jon Wood <<a href="mailto:jon@ninjagiraffes.co.uk">jon@ninjagiraffes.co.uk</a>> wrote:<br>
> On 17 July 2013 14:41, David Salgado <<a href="mailto:david@digitalronin.com">david@digitalronin.com</a>> wrote:<br>
><br>
> On 17 July 2013 14:34, Jon Wood <<a href="mailto:jon@ninjagiraffes.co.uk">jon@ninjagiraffes.co.uk</a>> wrote:<br>
> RDS also has the major (for some people) problem that you can't replicate into or out of it without using separate tools.<br>
><br>
> I believe that's not longer the case, at least if I read the announcement[1] correctly.<br>
><br>
> I think that just means you can set up replica slaves *within* RDS - not slaves/masters outside of it.<br>
><br>
> 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".<br>
><br>
</div></div><div class="HOEnZb"><div class="h5">> _______________________________________________<br>
> Chat mailing list<br>
> <a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>
> <a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
<br>
</div></div></blockquote></div><br></div></div>