<p dir="ltr">Ah. Vm dude. Ask for his "best method for hot db backup with SAN/NAS drive space of vm". Change san to nas as required. I hear a vm specialist that's been bit before on performance during backups not wanting that pile of meetings ever again.</p>
<div class="gmail_extra"><br><div class="gmail_quote">On Nov 22, 2016 11:40 AM, "Chris Fowler" <<a href="mailto:cfowler@outpostsentinel.com">cfowler@outpostsentinel.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:#000000"><div><br></div><div><br></div><hr id="m_2688285578618130403zwchr"><div><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"><b>From: </b>"Jim Kinney" <<a href="mailto:jim.kinney@gmail.com" target="_blank">jim.kinney@gmail.com</a>><br><b>To: </b>"Atlanta Linux Enthusiasts - Yes! We run Linux!" <<a href="mailto:ale@ale.org" target="_blank">ale@ale.org</a>><br><b>Sent: </b>Tuesday, November 22, 2016 10:09:36 AM<br><b>Subject: </b>Re: [ale] MySQL array based snapshot<br></blockquote></div><div><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"><p dir="ltr"><br></p><p dir="ltr"><br></p><p dir="ltr">That's even easier. From inside vm, sync and lock db, vm snapshot, unlock. Copy snapshot away. Flatten vm snapshot. Vmware and Ovirt/KVM will do this.</p></blockquote><div><br></div><div><span style="font-family:arial,helvetica,sans-serif;font-size:12pt">I've received even more Greek when I asked if they were planning on doing snapshots in their storage</span></div><div><br></div><div><span style="color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;font-size:12pt;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important;background-color:rgb(255,255,255)">"Snaps through VAAI. Our storage is VASA aware. It is the disk STUN I am worried about related to running DB."</span><br></div><div><span style="color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;font-size:12pt;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important;background-color:rgb(255,255,255)"><br></span></div><div><span style="color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;font-size:12pt;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important;background-color:rgb(255,255,255)"><br></span></div><div><span style="font-family:arial,helvetica,sans-serif;font-size:12pt"><font face="tahoma, new york, times, serif">The good news is that the transactions to the DB are not that high. It could be if they grow significantly and start monitoring SNMP. I store traps in the DB. They could lock the database and that would cause all processes to "pause" till it was unlocked. I know this because I've received complaints when I've done mysqldumps. Those locks are not lock enough to cause timeouts in the apps. They just block until the lock is released.</font></span></div><div><span style="font-family:arial,helvetica,sans-serif;font-size:12pt"><font face="tahoma, new york, times, serif"><br></font></span></div><div><span style="font-family:arial,helvetica,sans-serif;font-size:12pt"><font face="tahoma, new york, times, serif">Chris</font></span></div><br></div></div></div></blockquote></div></div>