[Opensim-users] Approach to get fresh content for an OpenSim Grid on New Servers

[Chris]

Hi Ai, It has been my experience that when I take the approach of saving 
and reloading OAR/IAR files to a new fresh database it usually does 
result in a smaller assets table (as compared to the previous database) 
but I suppose the space gain all depends on how many unreferenced assets 
there were on the previous database.

As far as I can tell, IAR and OAR saves work by only collecting assets 
that are referenced on the regions that have had OARs made from, and any 
assets that are referenced in the path specified for IARs that are 
created from user inventories. Any thing left over will be gone once a 
new empty database is created.

I am not 100% certain since I am only going by what I have observed in 
the process of saving/loading archives and transferring to a new 
database so anyone please by all means correct me if I'm not entirely 
accurate here :)


On 4/11/2013 9:39 AM, Ai Austin wrote:
> Our OpenSim grid has been running continuously since version 0.4 from 
> September 2007... and has probably by now accumulated a LOT of stuff 
> that has not been garbage collected.
>
> We are changing to some new more powerful core servers in the next few 
> weeks, and I had an idea of how to do the upgrade that MIGHT get rid 
> of the clutter while still keeping in place the region UUIDs (for web 
> map servers, etc), the avatar UUIDs for permissions and .ini files 
> that refer to these, and even perhaps the UUIDs of key assets in case 
> they are in scripts.
>
> but i am assuming that the IARs and OARs work by trying to reuse the 
> UUIDs if they are not already use din the data base.
>
> Will this process work..
>
> 1. Save each region as an OAR and the avatar inventories we wish to 
> carry over as an IAR
>
> 2. Create a completely fresh data base - empty.
>
> 3. Create the avatars we want to preserve using the ption to set a 
> specific UUID for them
>
> 4. Start up with the original region.ini files which have the old UUID 
> in them
>
> 5. restore the OARS to the relevant regions, and the IARs to the 
> relevant avatars.
>
> 6. Then fingers crossed we have a smaller neater, no clutter version 
> of what we have now?
>
> Or is that just plain silly and we have to take over more, or dump to 
> SQL and restore the data base as is?
>
> Any comments from devs or those with experience of a migration would 
> be appreciated before we try this if its going to be a waste of time.  Ai
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users


-- 
OpenSim: 10 Region Standalone on 0.7.6 Dev
Physics: Open Dynamics Engine
OS: Windows 7 (x64)
CPU: AMD Phenom II X4 840 3.2 GHz
Memory: 11 GB DDR3
Database: MySQL 5.1.63 (x64)