From: Jeff Richards
Date: July 27 2005 6:14am
Subject: InnoDB Netapp Snapshot
List-Archive: http://lists.mysql.com/mysql/186961
Message-Id: <1122444864.3039.33.camel@newton>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi,

I need a procedure that will allow me to take an online (i.e. database
up) Netapp Snapshot of a large InnoDB-based database. Could someone
please confirm that this is a valid way of making a Snapshot:

* Issue a "flush tables with read lock;"
* Issue a "flush logs;"
* Create the Snapshot
* Issue an "unlock tables;"

The reason I ask is that this list is the only place I can find
reference to this procedure. Everywhere else talks about either
mysqldump or the InnoDB Hot Backup utility for making online backups.

Thanks in advance!

Jeff

-- 
Jeff Richards
Consulting Architect
Openwave Systems Asia Pacific
+61 415 638757