RE: LVM-snapshot + mysqldump -- is this a reasonable backup

2005-09-19 Thread James G. Sack (jim)
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote: Dear Jim, Re: your post at http://lists.mysql.com/mysql/189058, why bother creating the mysqldump if you already have the snapshot? Why not just backup the snapshot? (I'd have hit reply online but didn't see a Reply button and

Re: LVM-snapshot + mysqldump -- is this a reasonable backup

2005-09-19 Thread James G. Sack (jim)
On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote: James G. Sack (jim) wrote: On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote: Dear Jim, Re: your post at http://lists.mysql.com/mysql/189058, why bother creating the mysqldump if you already have the snapshot? Why

RE: LVM-snapshot + mysqldump -- is this a reasonable backup strategy?

2005-09-13 Thread James G. Sack (jim)
quoting Alan Williamson [EMAIL PROTECTED] .. This recipe is intended to minimize the impact on ongoing database operations by inhibiting writes only during a relatively speedy operation (creating a snapshot). The long dump operation can ... This seems to be a rather long winded way of doing

LVM-snapshot + mysqldump -- is this a reasonable backup strategy?

2005-09-08 Thread James G. Sack (jim)
This recipe is intended to minimize the impact on ongoing database operations by inhibiting writes only during a relatively speedy operation (creating a snapshot). The long dump operation can then be performed on the (stable) snapshot, without interfering with ongoing use of the live database.

Re: lvm+innodb

2005-08-16 Thread James G. Sack (jim)
On Mon, 2005-08-15 at 20:01 -0700, Patrick Michael Kane wrote: Did you ever get any responses on how to get innodb to a consistent on-disk state for LVM snapshotting? FYI, under LVM2 read/write snapshots are allowed. I never got any replies. If you look closely into my rambling posting,

innodb engine breaks snapshot-based backup strategy

2005-08-11 Thread James G. Sack (jim)
Am I doing something wrong, or does the innodb engine design preclude loading a server with a readonly database snapshot? I'm talking about 4.1.x (or maybe 4.x) and linux lvm snapshots (lvm2) specifically about MySQL-4.1.12 (mysql-4.1.12-2.FC4.1.x86_64.rpm) tested on an AMD-64 + FC4