ZFS Few Questions

[Tom Evans]

On Fri, Nov 18, 2011 at 10:40 AM, Eduardo Morras <nec556 at 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