MySQL Forums
Forum List  »  Replication

Re: Reverse Replication?
Posted by: Jason Harp
Date: September 05, 2014 04:04AM

Ill give you guys a bit more detail on the set-up.

We have industrial equipment that logs operational data into its own MySQL database on each site. We have multiple sites, that all have there own unique database that is located on site.

I currently have the site servers set-up as master servers with our 1 central server set-up as a slave to all masters.

Each master has a unique schema name that is replicated into the slave.

Master 1 data = 1234_Data schema
Master 2 data = 2345_Data schema
Master 3 data = 3456_Data schema
ect...

There is no need to ever write data into the slave as it is purely for archive and data analysis.

I am trying to figure out a way that the Master 1, 2, 3 ect send data via an internet connection to the main archive server.

Options: ReplyQuote


Subject
Views
Written By
Posted
3158
September 03, 2014 09:51PM
1518
September 04, 2014 08:01PM
1190
September 09, 2014 08:00PM
979
September 09, 2014 09:05PM
936
September 10, 2014 04:40PM
1151
September 10, 2014 06:26PM
1124
September 05, 2014 02:54AM
Re: Reverse Replication?
1125
September 05, 2014 04:04AM
932
September 05, 2014 04:06AM


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.