Solved

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

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

When using AWS as your chosen public cloud provider you will ultimately come to a point where you need to decide and define what your storage requirements are for your data that you wish to store on AWS. There are a variety of options to choose from…
Creating and Managing Databases with phpMyAdmin in cPanel.
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.

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now