MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: FLUSH TABLES WITH READ LOCK does work with InnoDB
Posted by: Eric Bergen
Date: November 27, 2007 08:22PM

Since drbd replicates the block device a drbd failover without shutting down mysql will most likely corrupt your myisam tables.

I use multi master replication for failover. A presentation on this method can be found here:
http://jcole.us/mysqluc/2007/MySQL%20Scaling%20and%20High%20Availability%20Architectures.pdf

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
FLUSH TABLES WITH READ LOCK does *NOT* work with InnoDB
4372
Dave Juntgen
November 23, 2007 12:15PM
Re: FLUSH TABLES WITH READ LOCK does work with InnoDB
7000
Eric Bergen
November 23, 2007 02:31PM
Re: FLUSH TABLES WITH READ LOCK does work with InnoDB
3278
Dave Juntgen
November 23, 2007 10:29PM
Re: FLUSH TABLES WITH READ LOCK does work with InnoDB
2581
Eric Bergen
November 27, 2007 08:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.