MySQL Forums
Forum List  »  Replication

Re: Reverse Replication?
Posted by: Rick James
Date: September 04, 2014 08:01PM

> In short, is it possible to setup a master server to "push" data out to the slave? This would be the reverse of the normal slave/master relationship.

A Master pushes data to its Slave(s). (Actually, each Slave "pulls" the data from its Master, but both need to be involved.)

If you have two machines, each can be Master and Slave -- this is called "dual master". It has issues with auto_increments and duplicate keys if you write to both of them.

If you want multiple machines pushing data to a single central site, you need MariaDB, which provides such.

Also Galera (or any MySQL using it, such as PXC) can have multiple Masters 'pushing' data to a single system.

Options: ReplyQuote


Subject
Views
Written By
Posted
3158
September 03, 2014 09:51PM
Re: Reverse Replication?
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
1126
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.