Re: InnoDB Netapp Snapshot

2005-07-27 Thread Jeff Richards
Hi Dobromir, Thanks for the feedback. So you have successfully restored from a Snapshot created in this way? Jeff On Wed, 2005-07-27 at 12:30 +0300, Dobromir Velev wrote: > Hi, -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List Fo

Re: InnoDB Netapp Snapshot

2005-07-27 Thread Dobromir Velev
Hi, This procedure works for me and until now I haven't had any problems with it. You should b aware that if your database is under heavy load you might experience problems with transactions timing out due to the lock. HTH On Wednesday 27 July 2005 09:14, Jeff Richards wrote: > Hi, > > I need a

InnoDB Netapp Snapshot

2005-07-26 Thread Jeff Richards
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 * Iss