Database Replication -> Multiple Masters to One Slave
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.
Subject
Views
Written By
Posted
Database Replication -> Multiple Masters to One Slave
9673
August 08, 2013 01:42PM
4106
August 11, 2013 01:52PM
2754
August 22, 2013 09:14AM
2927
September 01, 2013 11:24AM
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.