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.
On Wednesday 27 July 2005 09:14, Jeff Richards wrote:
> 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 Richards
> Consulting Architect
> Openwave Systems Asia Pacific
> +61 415 638757