[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can you use AWS RDB as a slave MySQL server to a non AWS MySQL database

Posted on 2012-12-23
2
Medium Priority
?
426 Views
Last Modified: 2014-11-12
Looking to keep control of our MySQL database on our server but to slave a secondary read only instance on AWS.

Does anyone know if this is technically possible at present or will AWS only slave off another AWS RDB ?

Thanks
BT
0
Comment
Question by:brothertom
2 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 38717610
You mean Amazon RDS, right?  No you cannot make an RDS instance a slave of a non-RDS master.  RDS-master, non-RDS slave is also not possible.

You can however fire up an EC2 instance, configure MySQL on it, then make that your slave.
0
 

Author Comment

by:brothertom
ID: 38717965
Thanks for verifying.  I was thinking along your final suggestion so that seems to be the only way at present.  I wonder why this restriction is in place,  Support I guess.

Cheers
BT
0

Featured Post

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Feb. 28, Amazon’s Simple Storage Service (S3) went down after an employee issued the wrong command during a debugging exercise. Among those affected were big names like Netflix, Spotify and Expedia.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question