MySQL Forums
Forum List  »  MySQL & Storage

Re: MySQL and LUN snapshotting
Posted by: Peter Zaitsev
Date: May 13, 2006 06:08PM

Which storage engine are you looking at ?

With Innodb it is fine it will just do recovery after restore but will be in consistent state.

For MyISAM or storage engienes mix you need to do

FLUSH TABLES WITH READ LOCK;
<create snapshot>
UNLOCK TABLES;

Options: ReplyQuote


Subject
Written By
Posted
March 29, 2006 11:22PM
Re: MySQL and LUN snapshotting
May 13, 2006 06:08PM


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.