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.
Subject
Views
Written By
Posted
8457
December 12, 2008 09:37AM
4239
December 19, 2008 12:30AM
3809
March 02, 2009 05:57PM
3436
April 07, 2009 01:03PM
3838
April 07, 2009 05:58PM
Re: Multiple masters to single slave
8529
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.