MySQL Forums
Forum List  »  Replication

Re: Asynchronous Replication
Posted by: Rick James
Date: March 06, 2016 11:15PM

Another thought...

Your site could be a Slave (or many Slaves) to a Plant's Master. That is they could be continually replicating to you. If the databases are different, you could do "multi-source" replication (see MariaDB), which allows a single Slave to receive updates from multiple Masters.

If that is not practical, then you could have multiple instances of MySQL, each being a Slave to one Plant's Master. (Then you would have a programming hassle of reading all of them to consolidate onto a single machine.)

Options: ReplyQuote


Subject
Views
Written By
Posted
1502
A J
February 24, 2016 05:02AM
775
February 26, 2016 01:51PM
814
A J
March 01, 2016 08:40AM
Re: Asynchronous Replication
738
March 06, 2016 11:15PM


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.