MySQL Forums
Forum List  »  Replication

Database Replication -> Multiple Masters to One Slave
Posted by: Filip Corgan
Date: August 08, 2013 01:42PM

Hello.

I am trying to replicate many master databases (several different customer locations) into one slave database which I am hosting on the internet.

My problem I am having is that all of the master databases have the same name.

Site #1 Database is: Services -> tables
Site #2 Database is: Services -> same tables as above
Site #3 Database is: Services -> same tables as above

I want the data from all 3 locations to be replicated into a slave (read-only) hosted on the internet:

Server On Internet (Slave) would have following Databases:
Services1 (Copy of Site 1), Services2 (Copy of Site 2), Services3 (Copy of Site 3)

Does anyone know how to accomplish this with master-slave database replication?
Is there another way to do it?

Thanks in advance for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Database Replication -> Multiple Masters to One Slave
9673
August 08, 2013 01:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.