[Opensim-dev] Proposal to subdivide the assets table

[Destiny Niles]

On Thu, Jun 26, 2008 at 9:27 AM, liu xiaolu <lulurun at gmail.com> wrote:
> Hi everyone,
>
> my proposal is to subdivide current assets table into 2 tables:
> user_assets  : for user owned assets (mainly in inventory, appearance,
> attachment, ...)
>   user_asset is used by UGAI servers
> region_assets: for region owned assets, sounds, textures(including sun,
> moon, ...)
>   region_asset is used by region servers
>
> I wrote the whole, detailed idea at:
> http://opensimulator.org/wiki/User:Lulurun#proposal_to_subdivide_the_assets_table
> Please have a look at it, here is only a brief introduction.
>
> This could bring us many advantages such as:
> 0. increase the dispersity of asset data, clarify the responsibility of each
> server.
> Currently, all of the asset data is stored in assets table, managed by
> assetserver.
> This would cause some problems:
>  1. assets table keeps growing in a fast pace.
>  2. hard to determine which asset is belongs to inactive regions (when you
> want to "clean"
> the assets table).
>  3. assetserver not only serves users' data but also regions' data, if
> something happened to
> assetserver both of avatar and prims will become gray.
> To separate assets table can not only solve these problems, but also brings
> minor benefits
> such like: reduce the responsibility of assetserver, disperse the asset
> requests(especially
> for big grid service), lower the risk of losing data, ...
>
> 1. for Data Portability in virtual world
> For grid admin,
>  * you can concentrate on managing only user(not region owner) relavent
> information
>    like "users, avatarappearance, inventory"
>  * it can reduce the vulnerability caused by foreign assets.
>  * when a region leaves your grid, you don't have to worry about its assets
> becoming garbage.
>   - on the other hand, this also good for region owners.
> For when a user registers their region server with a grid,
>  * When you want to switch your sim to a new grid, "prims, primshapes,
> terrain, region_asset"
>    are always tied-up together. the only thing you need to do is to edit
> UGAI servers URI in
>    your OpenSim.ini
>
> For more advantages, please have a look at
> http://opensimulator.org/wiki/User:Lulurun#Advantages
>
> If this is a good way to go, not so many changes is needed:
> * UGAI servers would remain as they used to be.
> * VW user won't feel anything different.
> * Of course this should be a option in OpenSim.ini so that we can
> enable/disable/config
> * Just need to add supports for a new table "RegionAssets" with the same
> structure as "assets".
> * AssetClient in RegionServer should be improved to be able to get assets
> from mutilple servers.
>
> For more detailed plan of the implementation, please have a look at
> http://opensimulator.org/wiki/User:Lulurun#Implementation
>
> Any advice, comment, thought is appreciate.
>
> --
> Lulurun
> regards
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>