List:Replication« Previous MessageNext Message »
From:Edson Noboru Yamada Date:March 23 2008 10:19pm
Subject:innodb replication
View as plain text  
Hi, guys

I´m going to set up a innodb database replication, and I have some doubts
about the backing up the master database step.

Normally, I do a "FLUSH TABLES WITH READ LOCK", backup the data files (or
use mysqldump), get the current log coordinates with "SHOW MASTER STATUS"
and unlock the tables. Using exactly the same steps work for innodb
databases?

According to some texts, it seems not, but I haven´t found a clear cookbook.


Just doing a "mysqldump --master-data --single-transaction" is enough to
replace the above steps?

Thank you.

Thread
innodb replicationEdson Noboru Yamada23 Mar
  • Re: innodb replicationMarcus Bointon24 Mar
  • Re: innodb replicationEd W18 Apr
    • Re: innodb replicationMarcus Bointon18 Apr
      • Re: innodb replicationEd W18 Apr
        • Re: innodb replicationMarcus Bointon18 Apr
      • RE: innodb replicationRick James19 Apr
        • Re: innodb replicationEric Bergen20 Apr
          • Re: innodb replicationAugusto Bott22 Apr
            • Re: innodb replicationMark Callaghan22 Apr
              • Re: innodb replicationAugusto Bott22 Apr
                • Re: innodb replicationEric Bergen22 Apr
              • Re: innodb replicationAugusto Bott23 Apr
                • Re: innodb replicationEric Bergen23 Apr
                  • RE: innodb replicationRick James23 Apr
                    • Re: innodb replicationMarcus Bointon23 Apr
                    • Re: innodb replicationJeremy Cole23 Apr
                      • RE: innodb replicationRick James23 Apr
                        • Re: innodb replicationJeremy Cole23 Apr
                          • RE: innodb replicationRick James23 Apr
                            • Re: innodb replicationMarcus Bointon23 Apr
                              • Re: innodb replicationEric Bergen24 Apr
                                • Re: innodb replicationMoon's Father21 May