[Opensim-users] opensim migration strategy

[Generic Email]

This is a bit of a soap box, so if your are easily offended or  
annoyed, just pass by, there is nothing to see here.

I see in the OpenSim world the assertion that SQLite is not production  
worthy often. Most recently here:

> http://opensimulator.org/wiki/Upgrading

SQLite (default - a lightweight database that comes bundled with  
OpenSim and can be used without requiring any extra configuration. It  
is mostly intended to get you up and running quickly, not for  
production use.)

I prefer to describe SQLite as:
SQLite is a software library that implements a self-contained,  
serverless, zero-configuration, transactional SQL database engine.  
SQLite is the most widely deployed SQL database engine in the world.  
The source code for SQLite is in the public domain.

These companies believe SQLite is production worthy/ready: http://www.sqlite.org/famous.html

I am a huge fan of SQLite, and for what it does, I believe it does it  
very well.

Thanks for letting me get that out, and I hope I can influence more of  
you to take a better look at SQLite.

On Dec 5, 2008, at 10:58 AM, Justin Clark-Casey wrote:

> Paul Fishwick wrote:
>> From one version of opensim to the next, what is the accepted  
>> migration
>> strategy?  In particular, what happens if someone changes an SQLite
>> or MySQL schema from one revision to the next? I tried METHOD 2
>> last night when going from r7320 to r7605, and it failed. Not sure  
>> why
>> yet...I ended up just creating new regions from scratch.
>>
>> If someone can suggest a more efficient approach, that would
>> be great. Once it is down, we can put it in the wiki. It could go
>> under:
>>
>> http://opensimulator.org/wiki/Configuration
>
> Actually, just a couple of days ago I started a rough wiki page for  
> this.
>
> http://opensimulator.org/wiki/Upgrading
>
> It has the standalone info but not really the grid stuff.  Also,  
> your bullet point format is much clearer.
>
>>
>>
>> METHOD 1: If Using SQLite in StandAlone Mode
>>
>> 1. Build the latest version from source (or download the binaries)
>> 2. Put this new installation in a new folder
>> 3. Copy the following files from the old \bin to the new \bin
>>    3a. All *.db files
>>    3b. The opensim.ini file
>>    3c. The \bin\regions XML files
>> 4. Launch the new opensim.exe
>>
>> METHOD 2: If Using MySQL in StandAlone Mode
>>
>> 1. Build the latest version from source (or download the binaries)
>> 2. Put this new installation in a new folder
>> 3. Copy the following files from the old \bin to the new \bin
>>    3a. The opensim.ini file
>>    3b. The \bin\regions XML files
>> 4. Launch the new opensim.exe
>>
>> METHOD 3: If Using MySQL in Grid Mode
>>
>> 1. Build the latest version from source (or download the binaries)
>> 2. Put this new installation in a new folder
>> 3. Copy the following files from the old \bin to the new \bin
>>    3a. The opensim.ini file
>>    3b. The \bin\regions XML files
>>    3c. The 5 XML config files
>> 4. Launch services in the following order: UGAIM + R where
>>    "R" designates the region server (OpenSim)
>>
>
>
> -- 
> justincc
> Justin Clark-Casey
> http://justincc.wordpress.com
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20081205/b6a74fd0/attachment.html>