FreeLists / mylvmbackup / [mylvmbackup] Re: alternative backup options

[Lenz Grimmer <lenz@xxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

(replying to an older message from here)

Lenz Grimmer wrote:

> Peter Zaitsev wrote:
> 
> > One thing I also thought about other day for mylvmbackup is to allow
> > it to do backup without flush tables with read lock.
> 
> > If you're only running Innodb it cab be good enough because it will
> > print position it left server at during Innodb recovery anyway.
> 
> Thanks, that's an interesting suggestion! It would probably allow to
> perform the snapshot even faster and with less interruption, if you
> don't have to wait for the server to flush everything?
> 
> I added a note about creating a "--skip-flush-tables" option to the TODO
> in SVN.






FYI, I have now commited this feature to SVN - please give it a try! I
don't think this option alone already deserves a new release.

I wonder if my comment about this option is correct - what do you think?

- --skip_flush_tables::
  Don't issue a FLUSH TABLES WITH READ LOCK command before creating the
  snapshot. Only use this option when backing up InnoDB tables (as they
  don't support this function anyway and will require recovery in any
  case). This option skips the (probably time consuming) flushing of
  buffers.

> Also, I was wondering if it would make sense to provide an option to
> fully shut down the server before taking the snapshot and restarting it
> again afterwards, which would also provide a consistent backup. However,
> this would probably be only useful on servers where some downtime is
> acceptable, e.g. on a Replication Slave. What do you think, is this
> useful to have?






Does anybody have any opinion on that?

Bye,
        LenZ
- --
- ------------------------------------------------------------------
 Lenz Grimmer <lenz@xxxxxxxxxxx>                             -o)
 [ICQ: 160767607 | Jabber: LenZGr@xxxxxxxxxx]                /\\
 http://www.lenzg.org/                                       V_V
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFGjAR1SVDhKrJykfIRAnh5AJ9gd+HmJbCymXYhwxe9xLZsKCgdWgCfX9DK
JLStLhmWEBr5USlWuoC5HxQ=
=jvAu
-----END PGP SIGNATURE-----