<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div><br></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Jim Kinney" <jim.kinney@gmail.com><br><b>To: </b>"Atlanta Linux Enthusiasts" <ale@ale.org><br><b>Sent: </b>Monday, November 21, 2016 4:38:51 PM<br><b>Subject: </b>Re: [ale] MySQL array based snapshot<br></blockquote></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div>This sounds to me like a LVM snapshot of the database file space.</div><br><div><a href="http://devN" target="_blank" data-mce-href="http://devN">http://dev</a><a href="http://dev.mysql.com/doc/refman/5.7/en/backup-methods.html" target="_blank" data-mce-href="http://dev.mysql.com/doc/refman/5.7/en/backup-methods.html">.mysql.com/doc/refman/5.7/en/backup-methods.html</a></div><br><div>Snapshot _IS_ a backup as long as it is copied off the original machine. Loud google mouths are not always accurate. Dump your Google search cookie and see what comes up again.</div><br><div>There is a STUN event but it's pretty short. The key that I see is to lock the DB after a flush (see link) , make the LVM snapshot, then release the lock, copy out the snapshot as a backup. The performance drag happens during the copy of the snapshot but the copy can be 'nice 20' if things are on a decent drive subsystem and drive failure is not expected to be eminent.</div></blockquote><div><br></div><div>I don't see them doing a LVM snapshot on the guest. They'll do it on the host. Maybe they intend to do it on the guest. Maybe VMWare does it for them.</div><div><br data-mce-bogus="1"></div></div></div></body></html>