MySQL Forums
Forum List  »  Replication

Re: Multiple masters to single slave
Posted by: Rick James
Date: April 07, 2009 07:11PM

The main configurations practical:

* One Master with many Slaves. ("Star")

* Two Masters (dual-master) each replicating from each other, and each (optionally) having any number of Slaves. This is the best choice for HA. However, to avoid numerous problems, only one Master is writable at any given time.

* "Relay". Add to either of the above slaves hanging off one of the slaves. (Caution: The relay is a 'single-point-of-failure'.)

Back to the original question, plus expanding on Lee's suggestion:

Don't solve the problem with replication, instead use Federation. That is, your 'report' machine (optionally one of the existing ones) reads 'Federated' tables, which are really the live tables on the various Masters.

Options: ReplyQuote


Subject
Views
Written By
Posted
8549
December 12, 2008 09:37AM
4286
December 19, 2008 12:30AM
3858
March 02, 2009 05:57PM
3887
April 07, 2009 05:58PM
Re: Multiple masters to single slave
8618
April 07, 2009 07:11PM


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.