List:Replication« Previous MessageNext Message »
From:Thomas Ackermann Date:January 30 2009 6:14pm
Subject:Re: Replication of certain databases only?
View as plain text  
I found something over Google:

http://bugs.mysql.com/bug.php?id=19402

Unfortunately, my technical understanding of MySQL is below of what´s 
needed to understand this article ...

I cannot upgrade to MySQL 5 or 5.1 as i have too much older applications 
and OS´s that require MySQL 4.

Also, such a setup already DID run - it worked on a bunch of SuSE 9.3 
servers.
Now, i have Debian Etch, 4.1.22 (self-compiled) instead of 4.1.21, the 
master on Etch, one slave on Etch, the other slave on SuSE 9.3

I could seed the slaves new, if that helps.

I created them with a mysqldump output piped into the slave mysql:

db=DB1 ; mysqldump --password=<password> --opt --delete-master-logs 
--single-transaction --flush-logs --master-data=1 --databases ${db} > 
mysqldump_${db}_NEW

Maybe, my mysqldump options are broken?

fush-logs, single-transactio and master-data=1 are just to enable an 
online dump of the databases, including the needed statements to create 
new databases on the slave as needed.
opt is standard and delete-master-logs should just "clean-up" the mess - 
maybe that was a wrong idea?


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