MySQL on BTRFS Experiences

MySQL on BTRFS Experiences

[Jason J. W. Williams]

Hi,

My shop is a long time (~2006) ZFS user, considering moving off OpenSolaris
due to a number of non-technical issues. We use ZFS for all of our MySQL
databases. It's cheap/fast snapshots are critical to our backup strategy,
and we rely on the L2ARC and dedicated log device (i.e. NVRAM) features to
accelerate our pools with SSDs.

I've read through the archives for comments on stability, but they seem to
be generic "is it stable" questions. Is there anyone who is running a
critical MySQL operation on BTRFS that could comment on their experience
with it? "critical" to me means a 24x7 operation with 3-4 nines uptime
requirement.

Also, as BTRFS doesn't seem to have SSD acceleration features yet, is anyone
using BTRFS in combination with flashcache?

Anybody who's come to BTRFS from ZFS would be very helpful too.

Thank you in advance.

-J

Re: MySQL on BTRFS Experiences

[Fabio]

Jason J. W. Williams ha scritto:
> Hi,
>
> My shop is a long time (~2006) ZFS user, considering moving off OpenSolaris
> due to a number of non-technical issues. We use ZFS for all of our MySQL
> databases. It's cheap/fast snapshots are critical to our backup strategy,
> and we rely on the L2ARC and dedicated log device (i.e. NVRAM) features to
> accelerate our pools with SSDs.
>
> I've read through the archives for comments on stability, but they seem to
> be generic "is it stable" questions. Is there anyone who is running a
> critical MySQL operation on BTRFS that could comment on their experience
> with it? "critical" to me means a 24x7 operation with 3-4 nines uptime
> requirement.
>   
As already discussed, the main concern against BTRFS is not stability, 
but the lack of a functional fsck utility.

> Also, as BTRFS doesn't seem to have SSD acceleration features yet, is anyone
> using BTRFS in combination with flashcache?
>
> Anybody who's come to BTRFS from ZFS would be very helpful too.
>
> Thank you in advance.
>
> -J
>   


-- 
Fabio