List:Replication« Previous MessageNext Message »
From:Jamen McGranahan Date:July 18 2013 1:48pm
Subject:RE: 2 slaves - one Master; continues to fail
View as plain text  
I guess the best thing for me to do is to try another full snapshot of my Master MySQL
server, then do the apply log, then tar/gzip, then scp to my slave. Do you all see
anything wrong with my backup command?

innobackupex --defaults-file=/opt/pkgs/mysql/my.cnf --rsync --safe-slave-backup --compress
--compress-threads=4 --user=USER --password=PWD /apps/Dbbackup/jamen/

Jamen McGranahan
Systems Services Librarian
Vanderbilt University Library

From: Suresh Kuna [mailto:sureshkumarilu@stripped]
Sent: Thursday, July 18, 2013 8:44 AM
To: McGranahan, Jamen
Cc: Marcus Bointon; Replication
Subject: Re: 2 slaves - one Master; continues to fail

Exactly Jamen, most important is to apply logs.

On Thu, Jul 18, 2013 at 9:29 AM, McGranahan, Jamen
<jamen.mcgranahan@stripped<mailto:jamen.mcgranahan@stripped>>
wrote:
Thanks Marcus. I will try that, though I just realized this morning that I missed a step -
the --apply-log step. Though when I tried it, I got even more errors. This is making me
mad/frustrated. This should not be this complicated.

Jamen McGranahan
Systems Services Librarian
Vanderbilt University Library

-----Original Message-----
From: Marcus Bointon
[mailto:marcus@stripped<mailto:marcus@stripped>]
Sent: Thursday, July 18, 2013 7:54 AM
To: Replication
Subject: Re: 2 slaves - one Master; continues to fail
On 18 Jul 2013, at 14:19, "McGranahan, Jamen"
<jamen.mcgranahan@stripped<mailto:jamen.mcgranahan@stripped>>
wrote:

> Here's what I had followed:
>
> http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_re
> plication.html

I find xtrabackup is really excellent for setting up slaves, generally much faster and
friendlier than other mechanisms.

If you've got missing files, are you sure you included the 'i' option when untarring your
backup? A standard 'tar xvzf x.tar.gz' will break quite badly.

Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/ UK info@hand CRM solutions
marcus@stripped<mailto:marcus@stripped> |
http://www.synchromedia.co.uk/


--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe:    http://lists.mysql.com/replication




--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe:    http://lists.mysql.com/replication



--
Thanks
Suresh Kuna
MySQL & MongoDB DBA

Thread
2 slaves - one Master; continues to failJamen McGranahan14 Jul
  • Re: 2 slaves - one Master; continues to failSuresh Kuna14 Jul
    • RE: 2 slaves - one Master; continues to failJamen McGranahan14 Jul
      • Re: 2 slaves - one Master; continues to failSuresh Kuna14 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
    • RE: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
    • Re: 2 slaves - one Master; continues to failTruls Bergskaug15 Jul
  • Re: 2 slaves - one Master; continues to failJesper Wisborg Krogh15 Jul
    • Re: 2 slaves - one Master; continues to failDivesh Kamra16 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
    • Re: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
      • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
        • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
          • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
            • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
              • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman17 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman18 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
    • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
      • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
        • Re: 2 slaves - one Master; continues to failSuresh Kuna18 Jul
          • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
        • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
          • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
            • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
              • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
              • RE: 2 slaves - one Master; continues to failJamen McGranahan22 Jul
                • Re: 2 slaves - one Master; continues to failSuresh Kuna22 Jul