Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?

share|improve this question
add comment

6 Answers

This is still not supported as of February 2011, see RDS instance as a replication slave:

Non-RDS to RDS replication is not currently supported [...]. However, we will log your interest for our future road map planning.

share|improve this answer
add comment

Apparently this is now possible, however it is not fully "supported". Amazon will now allow you to replicate an RDS to an external slave, and replicate to an RDS from an external master, however their disclaimer suggests that they don't intend for this to be a permanent part of your server setup.

I have personally not tested this, but I plan on using it to help migrate off of some old non-AWS servers in which I host various databases and applications.

Given your question the below AWS doc will best apply.

Replication to RDS from external Master: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html

Proof of concept on Sönke Ruempler's blog post (RDS to External Slave): http://www.ruempler.eu/2013/07/07/replicating-aws-rds-mysql-databases-to-external-slaves/

share|improve this answer
add comment

You can do this with Tungsten Replicator, which is an open source replacement for MySQL native replication. It now supports replication from a MySQL master to an Amazon RDS slave. For more information, please see the following blog article:

http://scale-out-blog.blogspot.com/2013/01/replicating-from-mysql-to-amazon-rds.html

Cheers, Robert Hodges (Tungsten committer)

share|improve this answer
add comment

Unfortunately not currently supported by Amazon. Hopefully in the future as I am awaiting that ability too.

share|improve this answer
add comment

In addition to John C's link (http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html), AWS created a (lengthy) webcast about it as well: http://youtu.be/TT1M_XRAlQo

share|improve this answer
    
Some detail from the link would improve this answer. Links do break. –  Dave M Mar 18 at 12:51
add comment

http://aws.amazon.com/about-aws/whats-new/2010/10/05/announcing-read-replicas-lower-high-memory-db-instance-prices-for-amazon-rds/

Amazon AWS:

We are excited to announce the release of Read Replicas for Amazon RDS. You can now create one or more replicas of a given “source” DB Instance and serve incoming read traffic from multiple copies of your data. This new database deployment option enables you to elastically scale out beyond the capacity constraints of a single DB Instance for read-heavy database workloads. You can use Read Replicas in conjunction with Multi-AZ replication for scalable, reliable, and highly available production database deployments. To learn more about the release of Read Replicas, please visit the forum post here.

In addition to the release of Read Replicas, we have also lowered the On-Demand and Reserved prices for High Memory Double Extra Large (m2.2xlarge) and Quadruple Extra Large (m2.4xlarge) DB Instances. See the pricing section of the Amazon RDS detail page for full details.

share|improve this answer
3  
-1: this announcement covers the AWS internal replication feature only, thus doesn't answer the question - please correct or delete your answer accordingly, thanks! –  Steffen Opel Jan 26 '12 at 23:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.