List:Replication« Previous MessageNext Message »
From:Johan De Meersman Date:February 18 2014 12:00pm
Subject:Re: Mysql replication setup
View as plain text  

----- Original Message -----
> From: "shawn l.green" <shawn.l.green@stripped>
> Subject: Re: Mysql replication setup
> 
> The only thing I would add to this is to have your master operating with
> --binlog-format=ROW.  This way you are not relying on missing tables in
> your partially-migrated schema to be present in order to execute any SQL
> commands as you would get if you had --binlog-format=STATEMENT or MIXED.

Shawn,

Could you expand a bit on that? It sounds like you're saying FORMAT=ROW will magically
create the tables (or, possibly, ignore nonexisting tables)?

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.
Thread
Mysql replication setupBalogh Péter17 Feb 2014
  • Re: Mysql replication setupshawn l.green17 Feb 2014
    • Re: Mysql replication setupJohan De Meersman18 Feb 2014
      • Re: Mysql replication setupshawn l.green19 Feb 2014
        • Re: Mysql replication setupJohan De Meersman19 Feb 2014
          • Re: Mysql replication setupshawn l.green19 Feb 2014
            • Re: Mysql replication setupJohan De Meersman19 Feb 2014
  • Re: Mysql replication setupJohan De Meersman18 Feb 2014
Re: Mysql replication setupJohan De Meersman19 Feb 2014
Re: Mysql replication setupBalogh Péter23 Feb 2014