List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:April 18 2008 10:09am
Subject:Re: innodb replication
View as plain text  
On 18 Apr 2008, at 10:50, Ed W wrote:

> mysqldump --master-data --lock-all-tables
>
> work..?  I guess although the read lock doesn't stop innodb writing  
> and starting transactions, those transactions will be written after  
> the noted commit point in the log files?  I guess the problem is if  
> the dump reads uncommitted transaction data or the transaction can  
> commit in some way despite the read lock?

I've not tried doing it that way - if it works it's certainly a more  
elegant solution than doing the lock manually. Seems like the MySQL  
docs could use an update on this. I would expect that any uncommitted  
transaction would not appear in the dump at all, but if you did a lock  
tables it would probably prevent the transactions from completing  
until after the dump is complete, so I don't think there's any danger  
there.

> Sure - although technically then you don't have a consistent dump  
> between table types...


Sure, it's just that I don't tend to mix table types within a DB.  
Actually, I don't tend to use anything but InnoDB anyway - I find  
foreign key constraints and transactions too good to live without.

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


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