List:Replication« Previous MessageNext Message »
From:Rick James Date:January 29 2009 1:39am
Subject:RE: Replication of certain databases only?
View as plain text  
Use one or the other, not both, of -do- and -ignore-.

 
Rick James
MySQL Geeks - Consulting & Review

 

> -----Original Message-----
> From: Thomas [mailto:tja@stripped] 
> Sent: Wednesday, January 28, 2009 3:33 PM
> To: Jeremy@stripped
> Cc: replication@stripped
> Subject: Re: Replication of certain databases only?
> 
> Hello Jeremy,
> thanx for your reply!
> 
> I already used line like this in my.cnf:
> 
> binlog-do-db=<db>
> binlog-do-db=<db>
> 
> binlog-ignore-db=<db>
> binlog-ignore-db=<db>
> 
> 
> But to get the slave up to the latest status, i used "load data from 
> master;" - and then, ALL databases got copied!
> 
> 
> I try to use the following then:
> 
> mysqldump --password=<PW> --opt --delete-master-logs 
> --single-transaction --flush-logs --master-data=1 --databases ${db} > 
> mysqldump_${db}_NEW
> cat mysqldump_${db}_NEW | ssh slave "cat | mysql"
> ssh slave
> mysql ${db}
> show slave status;   // Which looks OK!
> start slave;
> show slave status;
> 
> The result are errors like this:
> 
> Error 'Table 'my_database.ibf_sessions' doesn't exist' on 
> query. Default 
> database
> 
> This is a complete different database!
> 
> Also, "grep my_database mysqldump_${db}_NEW2 does NOT show 
> such entries 
> in the database to be replicated.
> 
> It seems, the slave just get´s more data in the binary logs that it 
> should get!
> 
> And this is, why i ask here :)
> 
> It seems, the binlog-ignore-db just does not work!
> 
> Any idea?
> 
> :-O
> 
> 
> -- 
> 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