Solved

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

Posted on 2012-12-23

1 solution

418 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

Comment

Question by:brothertom

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 24

Accepted Solution

by:johanntagle

johanntagle earned 500 total points

ID: 387176102012-12-23

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.

Author Comment

by:brothertom

ID: 387179652012-12-23

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

Featured Post

Question has a verified solution.

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

Downloading Oracle Log Files in AWS RDS

Article by: Doug

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.

What We Can Learn From the AWS S3 Outage

Article by: Experts Exchange

In the wake of AWS' S3 outage, we want to discuss the importance of storage and data diversification in the event of a hack, crash, or system disruption. We spoke with Experts Exchange’s COO Gene Richardson for a deeper understanding.

Amazon Web Services PostgreSQL

Video by: Doug

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.