[Opensim-users] opensim migration strategy

[Justin Clark-Casey]

Generic Email wrote:
> 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.)

Dear Generic,

I'm a little confused - that text doesn't appear anywhere on that wiki page, and never has.  I guess you're probably 
referring to some other page.

> 
> 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.

That's true, although it's best suited to some needs and not others.  In particular, I suspect that multi-user access 
with large data sets is not one of its targets.

As far as I recall, the creator of SQLite himself pretty much said this on one of Leo Laporte's FLOSS podcasts.

http://twit.tv/floss26

> 
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users


-- 
justincc
Justin Clark-Casey
http://justincc.wordpress.com