This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

Using MySQL as a filesystem

Posted by: Dummy00001 on February 16, 2008 07:00 PM

That's interesting.

What about putting MySQL server on real (powerful) server and using fs on a client system, connecting it to the server? That'd be fun.

The idea isn't new. But it is nice to see that now with Linux it can be done so easily. If nothing else, it shows that Linux VFS layers and infrastructure around it allows to create really specialized things on cheap.

P.S. For better performance, one would have to simulate FS B+-trees: split data in chunks and organize them in balanced tree. Making trees of arbitrary height in SQL.... But probably by limiting size of file, one can make N tables to simulate tree of height N with one table per level.

#

Return to Using MySQL as a filesystem