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

brothertom
brothertom used Ask the Experts™
on
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
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
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

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial