Subdivide the assets table - Revision history

MakoBot: Robot: Cosmetic changes

2012-03-04T04:14:51Z

Robot: Cosmetic changes

MakoBot: Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

2011-06-10T23:43:07Z

Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

Makopoppo at 06:13, 3 January 2011

2011-01-03T06:13:17Z

Ideia Boa at 00:15, 22 May 2009

2009-05-22T00:15:54Z

Lulurun: /* Main idea */

2008-07-17T00:27:23Z

‎Main idea

Lulurun: /* Main idea */

2008-07-17T00:22:48Z

‎Main idea

Lulurun: /* Main idea */

2008-07-17T00:22:38Z

‎Main idea

Lulurun at 09:19, 16 July 2008

2008-07-16T09:19:40Z

Lulurun: New page: == proposal to subdivide the assets table == === Main idea === My proposal is to subdivide asset table into 2 tables: * user_asset used by UGAI servers for user owned assets *** obj...

2008-07-16T09:19:07Z

New page: == proposal to subdivide the assets table == === Main idea === My proposal is to subdivide asset table into 2 tables: * user_asset ** used by UGAI servers ** for user owned assets *** obj...

New page

== proposal to subdivide the assets table ==

=== Main idea ===
My proposal is to subdivide asset table into 2 tables:
* user_asset
** used by UGAI servers
** for user owned assets
*** objects in inventory
*** appearance
*** attachment, ...
* region_asset
** used by region servers
** for region owned assets
*** background sounds
*** textures on prims
*** sun, moon, ...
*** terrain maptile

=== Advantages ===
Major points first.

1. 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.<br>This would cause some problems:
::# assets table keeps growing in a fast pace.
::# hard to determine which asset is belongs to inactive regions (when you want to "clean" the assets table).
::# 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<br>such like:
::* reduce the responsibility of assetserver
::* disperse the asset requests(especially for big grid service)
::* lower the risk of losing data, ...

2. for Data Portability in virtual world
:* For grid admin,
::* you can concentrate on managing only user(not region owner) relevant information like "users, avatarappearance, inventory"
::* it can reduce the vulnerability caused by foreign assets.
::* no complains about "no texture on prims" any more.
::* 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 standalone-mode user - probably creators,
::* Avatars and buildings are saved separatly, export/import objects will become more simple. Or you can provide the DB file directly.

3. make grid-mode more flexible
:*Here are some pictures, they are showing some configuration patterns after the subdividing:
http://openugai.sourceforge.net/?page=assets_subdividing

4. reduce the possibility of assetid conflict by reducing the scope of assetid.

=== Disadvantages ===
I can hardly imagine the disadvantages so far except many changes are need to be done.
anything you think maybe a disadvantage is very appreciated.

=== Implementation ===
*Things need '''not''' to be changed:
:* The fields of "assets" table need not to be changed (at least for the subdividing).
:* Current implementation of AssetServer need not to be changed.

*Things need to add:
:* Add new table "RegionAssets".
:* Add DB access support for the new table under OpenSim.Data.*
:* Add '''RegionAssetService'''
::* including a '''RegionAssetLoader''' which reads assets/AssetSet.xml stores asset data to RegionAsset table
::* '''LocalRegionAssetService''' (directly select from RegionAssets table)
::* This is the pattern 1 at http://openugai.sourceforge.net/?page=assets_subdividing
:* '''RemoteRegionAssetService'''
::* This is the pattern 2-4 at http://openugai.sourceforge.net/?page=assets_subdividing
:* Of course to use which kind of service should be able to config in "OpenSim.ini".

* Things need to be changed
:*regionserver should not fetch assets from only one assetserver, So, One of the major changes we have to do is:
in "GridAssetCient.cs"
L50: protected override AssetBase GetAsset(AssetRequest req)
to
protected override AssetBase GetAsset(AssetRequest req, string asset_url)

L79: protected override AssetBase StoreAsset(AssetRequest req)
to
protected override AssetBase StoreAsset(AssetRequest req, string asset_url)

=== Migration From Existing System ===
Since this subdividing does not change the front services, there are not so many things to be done for the migration.

* Grid admin
** UGAI servers should work as it used to be. (nothing changes)
** you can forbid foreign assets by assigning assetserver a private address(a lot of ways to do).
** if you want cleanup unreferenced assets, ... try your best, this work won't be needed again.

* Region owner
** you can keep your contents completly in your local server from mow on.
** if you want get back your assets that already been stored in other AssetServer, ... troublesome　but possible.

* VW User
** nothing changes.

* Developer
** you need to watch mantis frequently.

=== What do you think ? ===
please feel free to leave comments in this section :)

@@ Line 1: / Line 1: @@
 __NOTOC__
-{{Template:Quicklinks}}
+{{Quicklinks}}
 <br />

@@ Line 2: / Line 2: @@
 {{Template:Quicklinks}}
 <br />
 [[User:lulurun]]

← Older revision		Revision as of 00:15, 22 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+	<br />
		+
	[[User:lulurun]]		[[User:lulurun]]

@@ Line 21: / Line 21: @@
 related to [[avatar portability]]
-[[Imgage:avatar_portability_5.PNG]]
+[[Image:avatar_portability_5.PNG]]
 === Advantages ===

← Older revision		Revision as of 00:22, 17 July 2008
Line 20:		Line 20:

	related to [[avatar portability]]		related to [[avatar portability]]
		+
	[[Imgage:avatar_portability_5.PNG]]		[[Imgage:avatar_portability_5.PNG]]

@@ Line 33: / Line 33: @@
 . 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.<br>This would cause some problems:
+:* Currently, all of the asset data is stored in assets table, managed by assetserver.<br />This would cause some problems:
 ::# assets table keeps growing in a fast pace.
-::# hard to determine which asset is belongs to inactive regions (when you want to "clean" the assets  table).
+::# hard to determine which asset is belongs to inactive regions (when you want to "clean" the assets table).
 ::# 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<br>such like:
+:* To separate assets table can not only solve these problems, but also brings minor benefits<br />such like:
 ::* reduce the responsibility of assetserver
 ::* disperse the asset requests(especially for big grid service)
@@ Line 49: / Line 49: @@
 ::* no complains about "no texture on prims" any more.
 ::* 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.
+:::* 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
@@ Line 56: / Line 56: @@
 . make grid-mode more flexible
-:*Here are some pictures, they are showing some configuration patterns after the subdividing:
+:* Here are some pictures, they are showing some configuration patterns after the subdividing:
   http://openugai.sourceforge.net/?page=assets_subdividing
@@ Line 66: / Line 66: @@
 === Implementation ===
-*Things need '''not''' to be changed:
+* Things need '''not''' to be changed:
 :* The fields of "assets" table need not to be changed (at least for the subdividing).
 :* Current implementation of AssetServer need not to be changed.
-*Things need to add:
+* Things need to add:
 :* Add new table "RegionAssets".
 :* Add DB access support for the new table under OpenSim.Data.*
@@ Line 82: / Line 82: @@
 * Things need to be changed
-:*regionserver should not fetch assets from only one assetserver, So, One of the major changes we have to do is:
+:* regionserver should not fetch assets from only one assetserver, So, One of the major changes we have to do is:
   in "GridAssetCient.cs"
   L50: protected override AssetBase GetAsset(AssetRequest req)

@@ Line 18: / Line 18: @@
 *** sun, moon, ...
 *** terrain maptile
 === Advantages ===

← Older revision		Revision as of 09:19, 16 July 2008
Line 1:		Line 1:
		+	[[User:lulurun]]
		+
	== proposal to subdivide the assets table ==		== proposal to subdivide the assets table ==

Subdivide the assets table - Revision history

MakoBot: Robot: Cosmetic changes

MakoBot: Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

Makopoppo at 06:13, 3 January 2011

Ideia Boa at 00:15, 22 May 2009

Lulurun: /* Main idea */

Lulurun: /* Main idea */

Lulurun: /* Main idea */

Lulurun at 09:19, 16 July 2008

Lulurun: New page: == proposal to subdivide the assets table == === Main idea === My proposal is to subdivide asset table into 2 tables: * user_asset ** used by UGAI servers ** for user owned assets *** obj...

Lulurun: New page: == proposal to subdivide the assets table == === Main idea === My proposal is to subdivide asset table into 2 tables: * user_asset used by UGAI servers for user owned assets *** obj...