List:Replication« Previous MessageNext Message »
From:Rick James Date:February 2 2009 10:23pm
Subject:RE: Master does not write binary logs!
View as plain text  
binlog-do-db... says "send only these databases".
replicate-do-db... says "ignore everything but these dbs".  Note that
those dbs are all that it will see.  So, the replicate-do- is redundant.
(It is also harmless.)

 
Rick James
MySQL Geeks - Consulting & Review

 

> -----Original Message-----
> From: Thomas [mailto:tja@stripped] 
> Sent: Monday, February 02, 2009 1:18 PM
> To: Claudio J. Chiabai; replication@stripped
> Subject: Re: Master does not write binary logs!
> 
> Claudio J. Chiabai wrote:
> > "Change the slave to new master binlog's "
> >
> > Sorry my english ...
> >   
> 
> Thanx for your help!
> 
> I found the problem!
> 
> 
> It is the syntax in the my.cnf files!
> 
> replicate-do-db=nickdb,usr_web1_1,uwc3
> and
> binlog-do-db=nickdb,usr_web1_1,uwc3
> 
> are NOT valid syntax!
> 
> After i change to this version, replication is finally running again:
> 
> replicate-do-db=nickdb
> replicate-do-db=usr_web1_1
> replicate-do-db=uwc3
> 
> binlog-do-db=nickdb
> binlog-do-db=usr_web1_1
> binlog-do-db=uwc3
> 
> :)
> 
> Now, let?s see if the original problem orrurs again ...
> 
> 
> 
> 
> -- 
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    
> http://lists.mysql.com/replication?unsub=1
> 
> 
Thread
Replication of certain databases only?Thomas28 Jan
  • Re: Replication of certain databases only?Jeremy Zawodny29 Jan
    • Re: Replication of certain databases only?Thomas29 Jan
      • RE: Replication of certain databases only?Rick James29 Jan
        • Re: Replication of certain databases only?Thomas Ackermann30 Jan
          • Re: Replication of certain databases only?Truls Bergskaug30 Jan
            • Re: Replication of certain databases only?Thomas Ackermann30 Jan
              • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                  • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                    • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                      • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                        • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                          • Setting up slaves from a dump (was: Re: Replication of certain databasesonly?)Thomas1 Feb
                            • Re: Setting up slaves from a dump (was: Re: Replication of certain databases only?)Eric Bergen1 Feb
                              • Re: Setting up slaves from a dumpThomas1 Feb
                                • Re: Setting up slaves from a dumpEric Bergen1 Feb
                                  • Re: Setting up slaves from a dumpThomas2 Feb
                                    • Re: Setting up slaves from a dumpThomas2 Feb
                                      • Re: Setting up slaves from a dumpThomas2 Feb
                                        • Re: Setting up slaves from a dumpThomas2 Feb
                                          • Re: Setting up slaves from a dumpThomas2 Feb
                                            • Replication does not startThomas Ackermann2 Feb
                                              • Master does not write binary logs! (was: Re: Replication does notstart)Thomas Ackermann2 Feb
                                                • Re: Master does not write binary logs! (was: Re: Replication does not start)Claudio J. Chiabai2 Feb
                                                  • Re: Master does not write binary logs! (was: Re: Replication does not start)Claudio J. Chiabai2 Feb
                                                    • Re: Master does not write binary logs!Thomas2 Feb
                                                      • RE: Master does not write binary logs!Rick James2 Feb
                          • Re: Replication of certain databases only?Thomas1 Feb
                      • Re: Replication of certain databases only?Claudio J. Chiabai30 Jan
                        • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                          • Re: Replication of certain databases only?Claudio J. Chiabai30 Jan
                      • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
          • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan