Thanks, So the actions should be: 1. Stop slaves 2. On Slaves: SET GLOBAL binlog_format=MIXED 3. Start slaves.
What is "restart the replication from scratch with a binary ident copy (rsync)" Is it to use rsync to rsync mysql data on masters and slaves? and than run chnge the master to .... to start from zero ground? Many thanks On 20 April 2012 12:31, Reindl Harald <h.rei...@thelounge.net> wrote: > > > Am 20.04.2012 13:17, schrieb nixofortune: > > So far I found : > > binlog_format different: > > Masters (MIXED) > > Slaves (STATEMENT) > > > > sync_binlog different on one of the slaves: 1024 against 0 on the rest > > binlog format "statement" is practically unuseable > there are way too much possible queries which can not > work this way over the long > > if i were you i would fix the configurations and restart > the replication from scratch with a binary ident copy (rsync) > >
