<html><head></head><body><div>This sounds to me like a LVM snapshot of the database file space.</div><div><br></div><div><a href="http://dev.mysql.com/doc/refman/5.7/en/backup-methods.html"><a href="http://devN">http://dev</a>.mysql.com/doc/refman/5.7/en/backup-methods.html</a></div><div><br></div><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><div><br></div><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><div><br></div><div>On Mon, 2016-11-21 at 14:45 -0500, Chris Fowler wrote:</div><blockquote type="cite"><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>I've received this question today and I can't pinpoint on if MySQL supports it or not. Google is flooding me with "snapshot is not a backup" pages.</div><div><br data-mce-bogus="1"></div><div>"Need Processor counts and if the internal DB supports array based snapshots which result in minimal STUN of the virtual disk."</div><div><br data-mce-bogus="1"></div><div>I'm running MySQL 5.X.</div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Chris</div></div><pre>_______________________________________________
Ale mailing list
<a href="mailto:Ale@ale.org">Ale@ale.org</a>
<a href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a>
See JOBS, ANNOUNCE and SCHOOLS lists at
<a href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a>
</pre></blockquote><div><span><pre><pre>-- <br></pre>James P. Kinney III
Every time you stop a school, you will have to build a jail. What you
gain at one end you lose at the other. It's like feeding a dog on his
own tail. It won't fatten the dog.
- Speech 11/23/1900 Mark Twain
http://heretothereideas.blogspot.com/
</pre></span></div></body></html>