List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 20 2012 11:31am
Subject:Re: Maser-Slave replication is playing up
View as plain text  

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)


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upReindl Harald20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr
      • Re: Maser-Slave replication is playing upReindl Harald20 Apr
        • Re: Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upshawn green20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr