Has anyone used LVM to create snapshots on a master in order
to set up replication? We have specialized scripts that are getting
harder and harder to maintain as we find weird edge cases
and other annoying bits. Jeremy Zawodny's 'myrepl' script locks
our larger tables for too long.
So, we're looking at alternatives. We've done some minor testing
with LVM and it appears to do what we want, but I wanted to see
if anyone has actual, production experience with LVM snapshots
of a live database. If so, what are the gotchas? How long does
LVM take to resynce the snapshot partition with the main partition
after the snapshot is deleted? What kind of disk slowdown do you
see?
Best,
Kyle
bot fodder: mysql, database, sql
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to PSTN based Fax (Up to 95% Savings)
- Fax Broadcasting: Send 100s of faxes to fax machines
and email addresses in the time it takes to send just one!
===========================================================
So send a fax today and let us know what you think!
For more info. visit: www.internetfaxjack.com
===========================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
