List:Replication« Previous MessageNext Message »
From:Eric Bergen Date:February 1 2009 7:53pm
Subject:Re: Setting up slaves from a dump
View as plain text  
On Sun, Feb 1, 2009 at 5:23 AM, Thomas <tja@stripped> wrote:
> Eric Bergen wrote:
>>
>> You command isn't suitable for setting  up a slave. With the command
>> you used each backup will have a different bin log position. You need
>> to back them up using a single mysqldump command for multiple
>> databases.
>>
>
> I tried that too, dumping the three databases in question with one command -
> and it looked good for some time.
>
> mysqldump --opt --delete-master-logs --flush-logs --lock-all-tables
> --master-data=1 --databases <db1> <db2> <db3>  > mysqldump_NEW
>
> But then, the problem orrured again.

Which problem? Can you send error messages and describe it further?

>
> Does anybody have replication successfully running?

Yes.

> Maybe even with a 4.1.* setup?

Yes.

> Does it work with INNODB or with MyISAM?

Both but you should use one or the other. Try not to mix them.

>
> Could you write a short "howto"?
>
>
> I am at the point where is suspect, that replication just cannot work :-|
>
> And yes, i read quite much!
>
>>  You should also give this a read:
>>
>>
>>
> http://provenscaling.com/blog/2008/10/19/how-mysqldump-locks-tables-with-different-options/
>>
>
> Unfortunately, this site seems to be down :-(
>

It's back now.


-- 
Eric Bergen
eric.bergen@stripped
http://www.provenscaling.com
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