On Fri, Nov 18, 2011 at 10:40 AM, Eduardo Morras <nec...@retena.com> 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 _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscr...@freebsd.org"
