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

Yes, as below to catch if any other objects in db.

mysqldump --all-databases --master-data=1 --log-error=mysqldump.err
--lock-all-tables --opt --triggers --routines --events >  all.dmp

hope this helps.


On Mon, Jul 15, 2013 at 12:06 PM, McGranahan, Jamen <
jamen.mcgranahan@stripped> wrote:

>  On the MASTER, I issued the “show master status;” command which gave me
> the File & Position.****
>
> ** **
>
> So, if I understand you correctly, I need to just do one big dump –
> something like this:****
>
> ** **
>
> mysqldump --all-databases --force --single-transaction > bigdump.dmp****
>
> ** **
>
> *Jamen McGranahan*
>
> *Systems Services Librarian*
>
> *Vanderbilt University Library*
>
> ** **
>
> *From:* Suresh Kuna [mailto:sureshkumarilu@stripped]
> *Sent:* Monday, July 15, 2013 11:02 AM
> *To:* McGranahan, Jamen
> *Cc:* Johan De Meersman; Replication
>
> *Subject:* Re: 2 slaves - one Master; continues to fail****
>
> ** **
>
> 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****
>



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