[Opensim-users] opensim migration strategy

[Generic Email]

I am so glad you brought these up.
I believe these are also misconceptions...

In many circumstances, primarily where transactions are involved,  
SQLite beats the pants off mySQL http://www.sqlite.org/speed.html

Granted they are old tests, and I am sure we have all gotten better  
since then, but remember, it almost isn't a fair comparison. SQLite  
has hundreds of fewer features and an order of magnitude less  
complexity when compared with MySQL. All it does is quickly store and  
retrieve data.

Did you know that SQLite db writes are journaled, and and failure will  
result in the transactions being rolled back to a known good state? It  
is being used on literally millions of cellphones every day, with zero  
maintenance. If it was easy to corrupt, then I believe the major  
hardware manufacturers would be steering clear of it, but instead they  
are moving forward and paying for its maintenance.

I really enjoyed listening to http://twit.tv/floss26

Thanks again.

On Dec 5, 2008, at 1:36 PM, Frisby, Adam wrote:

> The problem with SQLite is that it’s very very slow by comparison.
>
> There’s a real noticeable difference between the speed it takes to  
> perform operations, and that of say MySQL.
>
> It’s also a little bit easier to corrupt – for instance you can’t  
> have two processes accessing the one sqlite DB at once.
>
> Adam
>
> From: opensim-users-bounces at lists.berlios.de [mailto:opensim-users-bounces at lists.berlios.de 
> ] On Behalf Of Generic Email
> Sent: Friday, 5 December 2008 8:10 AM
> To: opensim-users at lists.berlios.de
> Subject: Re: [Opensim-users] opensim migration strategy
>
> 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
>
> _______________________________________________
> 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/8f54cf09/attachment.html>