Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

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

Posted on 2012-12-23

1 solution

Medium Priority

420 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 2000 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

Master your MySQL data - Table partitioning approach for better performance.

Article by: Tomas Helgi

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…

Introduction to SQL Server Containers

Article by: Paul

Windocks is an independent port of Docker's open source to Windows. This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.

How Do You Implement High Availability in a Database Environment?

Video by: Percona

In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

Some Basic Differences Between MySQL and MongoDB

Video by: Percona

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…