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
3844
April 02, 2009 06:38AM
2270
April 03, 2009 06:31PM
2270
April 05, 2009 02:07AM
2187
April 05, 2009 03:18AM
2254
April 05, 2009 04:54PM
2268
April 06, 2009 02:09AM
Re: Doesn't replicate insert statements
2347
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.