Re: Write directly to slave?
Posted by:
J B
Date: January 12, 2009 02:00AM
If you happen to write directly to the slave
1:- The changes will not be propagated to the master at all, unless you are configured as circular replication as said by Lee.
2:- If the the write is an insert to the slave your replication may stop if another inserts comes from master and violates any unique/primary key
3:- your master/slave will now be holding different data and someone in future has to scratch his/her head to figure out why the values are different.
writing directly to slave is only suggested as a last resort where you have to fix the broken replication.
Subject
Views
Written By
Posted
8418
January 09, 2009 07:34AM
4535
January 11, 2009 03:29PM
Re: Write directly to slave?
4630
January 12, 2009 02:00AM
3597
January 13, 2009 10:22AM
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.