<html><head></head><body>You'll get what's called "crash-consistent", which means the filesystem and database both have to do a consistency check and replay or rollback their journals.<br>
This *usually* works automatically, but many things can cause problems.<br>
Remember that restoring a snapshot is almost exactly equivalent to pulling the plug on a server and then rebooting it (minus the risk of writing corrupt data during the handful of milliseconds the system keeps running with insufficient power)... In other words, if you kill -9'd the KVM process and restarted it, you'd be in exactly the same situation as when restoring a snapshot.<br>
So if your software stack usually handles that kind of failure, it'll also usually handle snapshots properly. Most systems & software do, nowadays, including ext3 and MySQL.<br>
-Adam<br><br><div class="gmail_quote">On July 28, 2014 12:56:45 PM CDT, "Luis G. Coralle" <luiscoralle@fi.uncoma.edu.ar> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr"><div><div>Hi all </div><div><br /></div><div>I have a question regarding backups. </div><div>Assuming a traditional installation of 3.2 pve a linux vm with qcow2, saved on disk /dev/mapper/pve-data on /var/lib/vz type ext3 </div>
<div>Assuming I have mysql running on the VM with a large DB. What happens when a backup is made in snapshot mode of the vm? <br /></div><div>When the backup is restored, the DB is in a consistent state?</div></div><div><br />
</div><div><br /></div>-- <div>Luis G. Coralle<br />
</div></div>
<p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />pve-user mailing list<br />pve-user@pve.proxmox.com<br /><a href="http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user">http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user</a><br /></pre></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>