List:Replication« Previous MessageNext Message »
From:Suresh Kuna Date:July 15 2013 4:02pm
Subject:Re: 2 slaves - one Master; continues to fail
View as plain text  
HI Jamen,

There you go, you dump is not consistent. though it is consistent database
by database. the position will increase while you are doing another
database dump.

Where are you collecting the position in the script to start slave ?


On Mon, Jul 15, 2013 at 11:56 AM, McGranahan, Jamen <
jamen.mcgranahan@stripped> wrote:

>  Suresh,****
>
> ** **
>
> I'm using the following mysqldump command within a for loop in a shell
> script to create the dump. We have a centralized MySQL server that houses
> all of our databases, and some are extremely large:****
>
> ** **
>
> ## this part of shell script creates an array of database names ****
>
> ##****
>
> databases=`/opt/pkgs/mysql/bin/mysql --user=$USER --password=$PASSWORD -e
> "SHOW DATABASES;" | tr -d "| " | grep -v Database |grep -v searches |grep
> -v weeding`****
>
> ** **
>
> ## this part of shell script loops through the database array and creates
> the individual dump files ****
>
> ##****
>
> for db in $databases; do****
>
>   /opt/pkgs/mysql/bin/mysqldump --force --single-transaction --opt
> --user=$USER --password=$PASSWORD  --databases $db >
> "/apps/Dbbackup/jamen/$db.dmp"****
>
> done****
>
> ** **
>
> And yes, we do have a mix of InnoDB & MyISAM engine types, but each
> database itself is one or the other (so not a mix of tables with these),
> which I just discovered.****
>
> ** **
>
> *Jamen McGranahan*
>
> *Systems Services Librarian*
>
> *Vanderbilt University Library*
>
> ** **
>
> *From:* Suresh Kuna [mailto:sureshkumarilu@stripped]
> *Sent:* Monday, July 15, 2013 10:48 AM
> *To:* Johan De Meersman
> *Cc:* McGranahan, Jamen; Replication
> *Subject:* Re: 2 slaves - one Master; continues to fail****
>
> ** **
>
> Hi Jame,****
>
> Can you paste you backup mysqldump statement ? ( It should not occur if
> that is consistent ) and secondly I'm thinking about mixed engine types in
> a transaction can also cause such duplicate keys.****
>
> Remember though we set slave's to read only, the super user's can still do
> the writes. So, drop any such user's privileges.****
>
> ** **
>
> On Mon, Jul 15, 2013 at 11:24 AM, Johan De Meersman <vegivamp@stripped>
> wrote:****
>
> ----- Original Message -----
>
> > From: "Jamen McGranahan" <jamen.mcgranahan@stripped>****
>
> > Subject: RE: 2 slaves - one Master; continues to fail****
>
> > Thanks for this message. I’m assuming the percona tool needs to be
> > installed on the MASTER host? Is that correct?****
>
> They're useful everywhere, really :-) For this usage, I do believe the
> master will suffice.****
>
>
> --
>
> Unhappiness is discouraged and will be corrected with kitten pictures.****
>
>
>
>
> -- ****
>
> Thanks
> Suresh Kuna
> MySQL & MongoDB DBA****
>



-- 
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