[ale] MySQL array based snapshot
jim.kinney at gmail.com
Tue Nov 22 13:02:29 EST 2016
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.
On Nov 22, 2016 11:40 AM, "Chris Fowler" <cfowler at outpostsentinel.com>
> *From: *"Jim Kinney" <jim.kinney at gmail.com>
> *To: *"Atlanta Linux Enthusiasts - Yes! We run Linux!" <ale at ale.org>
> *Sent: *Tuesday, November 22, 2016 10:09:36 AM
> *Subject: *Re: [ale] MySQL array based snapshot
> 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.
> I've received even more Greek when I asked if they were planning on doing
> snapshots in their storage
> "Snaps through VAAI. Our storage is VASA aware. It is the disk STUN I am
> worried about related to running DB."
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Ale