Solved

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

Posted on 2012-12-23
2
415 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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

756 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