[mylvmbackup] Re: alternative backup options (was: mylvmbackup 0.5 released, mailing list created)

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

Hi Peter!

thanks for your message. I noticed that you are now subscribed to the
list, so I hope you don't mind if I move this discussion over here...

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.

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?

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

iD8DBQFGQeJ8SVDhKrJykfIRAo/iAJ0YhvEEyTM8S9/5xB9iCCDR+9LK4wCcDP/h
2O3O0lHWWt2RRnd0BQbw7iA=
=96Pt
-----END PGP SIGNATURE-----

Other related posts: