Re: Error Duplicate entry - Master-Slave replication
Posted by:
Sree Mal
Date: January 10, 2012 10:06AM
Connecting and replicating data over to SLAVE from MASTER is not a problem.
I see the "Duplicate Entry on key" issue quite often on my slave. Slave DB is read-only for all the other users [Master is the only one writing to slave], so no one else is updating slave directly.
I see lot of work arounds "slave-skip-errors = 1062" and "sql_slave_skip_counter=1" etc, but, I wanna the root cause of why this is happening?
Subject
Views
Written By
Posted
10364
January 04, 2012 05:02PM
4171
January 05, 2012 07:46PM
Re: Error Duplicate entry - Master-Slave replication
4426
January 10, 2012 10:06AM
4682
January 11, 2012 10:16AM
3923
January 18, 2012 01:46PM
3358
February 21, 2012 07:13AM
3718
February 22, 2012 09:44PM
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.