List:Replication« Previous MessageNext Message »
From:Ed W Date:April 18 2008 9:27am
Subject:Re: innodb replication
View as plain text  
Edson Noboru Yamada wrote:
> 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?
>
>   

How would you put these two things together in the case of a server 
using mixed database table types for a clean backup that can be used to 
restart synchronisation?

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