Date: Fri, 18 Nov 2011 12:22:20 +0000 From: Tom Evans <tevans.uk@googlemail.com> To: Eduardo Morras <nec556@retena.com> Cc: freebsd-performance@freebsd.org Subject: Re: ZFS Few Questions Message-ID: <CAFHbX1KgtUZsXuGYdxv93Uyb=LfXQ4yx_DJGxi6Y-LmSpCz6Lw@mail.gmail.com> In-Reply-To: <4ec63674.03d5960a.7701.58bfSMTPIN_ADDED@mx.google.com> References: <CAKy=mtCcHavRFh16yaVH86Oh6DgePmxOhbQmmAySxWA5Zn8-yA@mail.gmail.com> <4ec60f6b.893a440a.4ce1.ffffa30dSMTPIN_ADDED@mx.google.com> <CAB25XEUj6%2BNfDgQ_Odg4r1Ga%2BosRMC4Ww10E%2Bq1tM6ccPAR5hg@mail.gmail.com> <4ec63674.03d5960a.7701.58bfSMTPIN_ADDED@mx.google.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, Nov 18, 2011 at 10:40 AM, Eduardo Morras <nec556@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFHbX1KgtUZsXuGYdxv93Uyb=LfXQ4yx_DJGxi6Y-LmSpCz6Lw>