Re: [Mysqlfs-general] Questions about this project's status.

[Michal L. <mi...@lo...>]

Tony Shadwick wrote:
> I'm in the process of setting up a MySQL cluster and realized it might 
> be neat to have an FS write into that replicating cluster, did a google 
> and wound up here. :)
> 
> I read through the archives, and I think I'm up to speed, but a few 
> questions linger:
> 
> 1.  Did the issue of permissions ever get addressed? 

Not yet. I have never used mysqlfs in multiuser environment.

> This is a bit 
> important to me, as the main use of this for me would be for home 
> directories, specifically for apache to read out public_html, and the 
> fact that apache does suexec.  Would be a bit of a nightmare if those 
> permissions got straight-up ignored.

Do some testing. I did once many months ago and it didn't take
permissions into account. Could be that I did something wrong.

> 2. Is anyone using this with engine=ndbcluster on tables?  How well does 
> it respond?

I haven't heard about anyone using it with ndb.

> 3.  Reasonably speaking, how stable is 0.3.1?  Is it good enough for day 
> to day use with only minor hiccups, or is data corruption relatively 
> rampant? :)

mysqlfs 0.3.1 *has* data corruption issues. Use 0.4-rc1 instead. It
should be fixed there. However even this version may experience some
problems with heavy concurrent access to a single file  due to not yet
implemented inode locking. It won't be difficult to fix though.

Frankly speaking, developing mysqlfs was a nice exercise to learn
something about FUSE, a new technology at that time. I still aim to fix
bugs if they are reported and could perhaps be persuaded to implement
some missing features (e.g. the permissions checking), but other than
that mysqlfs is not anywhere near the top of my development priorities
list. (JFYI my primary toy project is currently s3cmd at
http://s3tools.logix.cz)

That said, I wouldn't use it in a production environment or store any
precious data on it though. But if you're into programming, feel free to
play with mysqlfs, (it's reasonably stable in a sense that it doesn't
crash  and doesn't lose data all the times), enhance it, send us your
patches and make mysqlfs more usable for future generations :-)

HTH

Michal