Re: Multiple masters to single slave
Posted by:
Lee Wood
Date: April 07, 2009 05:58PM
You might be able to achieve what you want by using confederated tables. i.e. multiple "master" servers, each with table "A" defined as a confederate of table "A" on the "slave". (NB If the table-in-question contains an auto_increment column, you will need to ensure that each of those "masters" avoid auto-increment collisions, by giving them each a different offset, as one would with circular replication.)
Subject
Views
Written By
Posted
8534
December 12, 2008 09:37AM
4279
December 19, 2008 12:30AM
3849
March 02, 2009 05:57PM
3482
April 07, 2009 01:03PM
Re: Multiple masters to single slave
3881
April 07, 2009 05:58PM
8609
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.