for those who were interested in using a mysql database as a filesystem for
backuppc, this is possible with the fuse mysqlfs.
seems to be a promising project to allow un-altered backuppc installs to use
mysql.
currently, some things take 10 times as long as a native filesystem which is
a direct result of the fuse module not being mature or tuned but many this
take less time even though unoptimized fuse can be slow, such as file and
directory creation and deletion which is a testament to how much faster
mysql is than a regular filesystem. even afer optimisation i suspect that
large file writes will still be some multiple slower on mysqlfs than a
regular filesystem as mysql is not great at storing large chunks of data
and/or splitting up the data into more manageable chucks has overheade.
advantages:
BIG - mysql caching!
take advantage of small transaction efficiency of mysql
remote mounting of filesystem database, potential to create client side
mysql connector for easier remote backups
syncronous mounting of database so 2 machines can access same filesystem at
same time.
BIG - online remote replication
disadvantages:
fuse is slow when unoptimized
very slow now for large files, probably never get up to even 1/2 regular
filesystem performance for large files
need to run another service on backuppc server(mysql) which means more
resources.
unknowns:
not a good idea to compress disk that mysql database sits on and mysql
compression modules may not compress as well, would be nice to not use
backuppc compression and let 'filesystem' handle it as it would be nicer for
users.
future of the mysqlfs project!
potential of bad fuse code bringing down the system
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
BackupPC-users mailing list
[email protected]
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
