Re: Doesn't replicate insert statements
I tried to make the BINLOG_FORMAT variable =STATEMENT (it was MIXED) and also insert and update statements were not replicated.
So I changed it's value to ROW then finally insert and update statements were replicated !!!
now the problem has been solved but that's mean I can't take the SBR advantages (by making the format=mixed)?
NOTE:MySQL version is the same in both(master & slave) 5.1.29
How can I replicate the missing data that not replicated on the slave to simulate it between master and slave?(not stop slave and then restore the master's data)
Subject
Views
Written By
Posted
3888
April 02, 2009 06:38AM
2284
April 03, 2009 06:31PM
2289
April 05, 2009 02:07AM
2200
April 05, 2009 03:18AM
2272
April 05, 2009 04:54PM
2280
April 06, 2009 02:09AM
Re: Doesn't replicate insert statements
2368
April 07, 2009 03:09AM
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.