On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote: > > 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.
Indeed it does. As you data grows, you really need a better way to produce snapshots. I've started producing snapshots on a primary slave when I need them because the RAID volume on our primary server has rather sucky performance (with the 2.4 kernel's VM damage on top of it). > 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. I can't offer any practical advice with LVM. But if the tables are all flushed and locked (like mysqlsnapshot (was called myrepl) does) before and during the snapshot, you should be safe. What sort of performance have you seen in your testing so far? If this is a useful technique, I'd like to include it in some writing that I'm working on (heh, is that vague enough?). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 55 days, processed 1,245,039,944 queries (257/sec. avg) --------------------------------------------------------------------- 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
