On Fri, Nov 18, 2011 at 10:40 AM, Eduardo Morras <[email protected]> wrote: > I mean that surely db will be corrupted and nothing could be recovered. I > know postgresql and there you have a begin snapshot - end snapshot for this > topic, data changes are stored in temporal archives and main db files are > consistent, allowing you to make a filesystem snapshot. For mysql don't > know.
You can do similar thing with MySQL - 'FLUSH TABLES WITH READ LOCK', zfs snapshot, release lock, job done. It's not as good as postgresql, which doesn't require the tables to be locked for writes. I would imagine as ZFS and MySQL are both owned by Oracle the situation will improve. Cheers Tom _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[email protected]"
