That was created by Melanie. She might be able to help more . This is an extract of what you can find about it on my user page in opensim ( http://opensimulator.org/wiki/User:Gimisa ) :
Hope it helps : gimisa FSAsset (Added note 181113) In 2015 Osgrid had a major asset crash. This was an experience for all grid owner as to what can happen if database corruption or hardware failure treat you grid installation. OSgrid like any good service providers had implemented ways to overcome both these disruption by using raid mirroring as related in following article http://www.hypergridbusiness.com/2015/03/avination-helps-save-osgrid-donates-cluster-storage-solution/ . I am not acquitted any closely with OSgrid operation more then a user is. I have no clue of the nature of the failure but the article is point to the use of FSAsset as an alternative to whatever OSgrid was doing. I am using MariaDB in for my database which is a fork of MySQL. But the problem remain that large database file size are created when using standard way of storing the asset in the database itself. There is no magic in storing information and the compress asset data has to reside somewhere. Melanie solution is to have it stored in the file system itself instead of the database and use the database as pointers ONLY to the proper asset on disk . This makes the database itself much less subject to corruption and reduced its size to be easily dump for backups remotely. There is more detail about FSAsset setup in http://opensimulator.org/wiki/FSAssets_Service . The article is suggesting to use FSAsset for 50G database size. I decided to go forward even if mine is a mere 15G. My problem is backup of this HUGE database . A backup system can be full backup like raid images , now a day with low pricing for storage space this is the preferred choice. Because of limited resources I am still using incremental backup or what is call snapshots of the drive with the help of DIRVISH a linux backup program. This method takes up much less space due to the incremental nature of the storage. But you can imagine that using this method with database file size of 15G is somehow defeating the purpose. Having smaller database file size and using files system for storage offer the elegant alternative of using system tools and standard backups solutions. One more interest raise by Melanie FSAsset storage is the possibility of database reconstruction using the files already stored in the asset directory. Though I could not find any documents that would support that , I am incline to believe that even with destruction of asset database and corruption of part of the asset directory it would be possible to reconstruction the database pointers from the good element of the asset directory structure. Database and large file are MySQL engineered way to speed for large database installation with many users and demanding services. Getting out of that framework has detrimental effect on speed. In normal asset upload I saw no noticeable delays. But I found that speed is the cost when loading large oars of fresh new asset. FSAsset first checks the database to see if there is a pointer to the UUID of an existing asset when loading oar to avoid loading duplicates and destroy existing assets. So as asset base increase to more then 50G ( the recommended size to use FSAssets) this should trend in reducing the asset handling time and damper the delay witnessed in freshly loading grid like I did. About a month after writing this paragraph I have a hard drive crash. It was time to face the music and see if restoring the mysql database and FSasset folder would do the magic. I am happy to report it did.... Note to 0821 grid users. There is an issue with FSAsset database handling on that version. Reference to that mantis is http://opensimulator.org/mantis/view.php?id=7794 . The patch included in that link need to be applied to release version 0821 to correct the problem. If you need a tested compiled version of that correction don’t hesitate to contact me. Le jeudi 10 octobre 2019 12 h 28 min 47 s HAE, Mike Dickson <mike.dick...@utopiaskye.com> a écrit : Is there any documentation available on how to configure HG Assets to use FSAssets vs the legacy asset store? I expect its as simple as changing the BackingService config setting but I'm curious if there is a way to move the legacy assets in the database info FSAssets and if so how to configure that. I dont want to orphan a bunch of Legacy asset data and more importantly I want to be able to clean up the data in the MySQL assets table in the database. Thanks in advance for your help. Mike _______________________________________________ Opensim-dev mailing list Opensim-dev@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev _______________________________________________ Opensim-dev mailing list Opensim-dev@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
