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
3968
April 02, 2009 06:38AM
2333
April 03, 2009 06:31PM
2330
April 05, 2009 02:07AM
2253
April 05, 2009 03:18AM
2312
April 05, 2009 04:54PM
2322
April 06, 2009 02:09AM
Re: Doesn't replicate insert statements
2424
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.