[Opensim-users] MySQL on seperate server?

Thu Feb 18 10:26:24 UTC 2010

I arrive late, as usual :-)

When a region has around 12000 primitives, with a db server on the same
machine you will have hell on earth or something like that.

Boot up time is around 10 minutes and is impossible to do anything but using
zoom. Impossible to move.

I have tested this with 3 machines (4Gb ram, 500Gb hd RAID, Intel Core Duo
1,73, Intel Core duo 2,3 and amd64) running windows XP, Vista and Windows
7-64 bits.

I was using grid mode (grid server on separate computer... no ROBUST or
UGAIM, it uses a PHP ugaim system).

Separating Mysql to another machine on the same local network (100 Mbps nc)
I could move, build, and even another avatar could enter.

Exporting db and running it on separate server with Linux (ubuntu server
9.04) I could fill the region with 5000 more prims and 2 avatars could work
smooth.

Running opensim on Linux (amd64, 4gb ram, ubuntu server 9.04 64 bits) and db
on separate linux server 2 avatars could work smoothly and filling the
region with 25000 prims (no simple prims, but different sizes, texturized
and scripted).

Anyway, that were my "home" experiences... My conclusion: separate db, don't
use windows.

Greetings

2010/2/16 Steve <steveamigauk at yahoo.co.uk>

>  Thank you, although this doesn't tie in to my bandwidth usage reports :/
>
> I have 60Gig peak, 240 Gig off peak allowance with my provider download. No
> limit upload. I have had the sim up and running for a week 24/7 (one region
> only - and 24/7 apart from a OpenSimulator version upgrade and the odd
> restart), using my net connection as normal on my main PC.
>
> My usage for 1 - 15 Feb is 11.78 Gig D/L (which includes 3 Gig HD vid from
> BBC iPlayer) and 2 Gig upload.
>
> I was interested in the OP question because I have a SQL server sat on my
> web hosts servers doing nada, but it looks like I will gain neither
> performance nor speed by trying to use it, nor will I save any bandwidth.
>
> This is a real learning experience.
>
> Steve
>
>
> On 16/02/2010 8:15 PM, John Mieske wrote:
>
> Oh I might add, that is 20 - 40KBytes Upload one way and 20 - 80 KB
> download one way. I thought I would meantion that.
> John
>
> On Tue, Feb 16, 2010 at 3:14 PM, John Mieske <johnmieske at gmail.com> wrote:
>
>> here is an example of what happened to me on a few Grids I have tested.
>> Per AV I am uploading / downloading roughly 40KBytes a second. Not kBits.
>> That is full load with everything going on. So I am giving the most I have
>> seen in this case. That is roughly 320 KBit upload and download just for one
>> avatar. So in theory, you should be able to push less then 40K IF your
>> avatars are not really doing all of what they want them to. Example : Voice.
>>
>>
>>  So with a 1 Meg upload, your looking at around 3 Avatars smoothly. If
>> your going to go with 2 Meg Upload which some of us have, then your could go
>> to about 7 Avatars smoothly. Again, this is all dependant on what your USERS
>> are doing. If all are building and in Voice all at once, then 1 Meg = 3
>> Avatars smoothly.
>>
>>  Keep in mind, this is a test I did myself on 5 Grids I have tested. Each
>> with different ISPs. So if your going to run a Grid you also have to account
>> that the region that ties into your main region ALSO has to accomodate for
>> the extra communication between each region that is not on the same computer
>> / ISP. AND they are constantly 24 / 7 communicating. So if you have a
>> bandwidth limit, you could be in trouble. At a Previous version of Sim
>> world, we had 500 Megabytes transfer for about a weeks worth of time. And
>> that is with only 8 regions and VERY little activity. The limit ?  1
>> Terribyte. So in one week, we ate up half our bandwidth limit. ( Thats all
>> the HOST allowed at the time )
>>
>>  Bottom line, you MUST do the math to see if this is even possible to
>> keep running before spending a lot of money.
>>
>>  John
>>
>>
>> On Tue, Feb 16, 2010 at 2:41 PM, Steve <steveamigauk at yahoo.co.uk> wrote:
>>
>>>  So out of interest, what are the upload limits per avatar for example. I
>>> have just shy of 1 Mb upload speed, and have happily accommodated 8 Avatars
>>> (after one in particular who was throwing up masses of errors left). How far
>>> could I, in theory, push it?
>>>
>>> Steve
>>>
>>>
>>> On 15/02/2010 11:00 PM, Ken G. wrote:
>>>
>>> Alright, thanks Daz for answering my question and thanks to John and
>>> Master_Mirage for the input. I am just a hobby user of opensim, connected to
>>> OSGrid, hoping that maybe there was a way to improve my mediocre connection
>>> :)
>>>
>>> Ken aka Key
>>>
>>>
>>> On Mon, Feb 15, 2010 at 3:00 PM, John Mieske <johnmieske at gmail.com>wrote:
>>>
>>>> I have to agree with Darren here. If your doing this at home, you might
>>>> as well have both on the same computer. Your internet in general will
>>>> dictate what you can do. So if your running this at home, hang up the idea
>>>> of two computer region serving because no one will see a difference when
>>>> they already bogg down from a slow internet connection to your region. I
>>>> have seen some Regions who run them at home with the best of intentions only
>>>> shut down days later because they realize their internet only allowed 2
>>>> avatars to run smoothly. When they got to 3, their sim started to crash. It
>>>> is all about your upload speed. However, if you got a FAT PIPE ( not to
>>>> smoke hahaha ) then yea you definitely might want to try the way I
>>>> suggested. Again everything in OpenSim is based on HOW you run your Grid /
>>>> Regions. Nothing is 100% set one way. I only offered a suggestion to those
>>>> who could use this benefit. And there are already some servers that has been
>>>> setup this way and they are smooth.
>>>>
>>>>  John
>>>>
>>>>   On Mon, Feb 15, 2010 at 3:39 PM, Darren Williams <
>>>> darren at dmmhosting.co.uk> wrote:
>>>>
>>>>>   Ken G asked:
>>>>>
>>>>>
>>>>>
>>>>> Dumb question from a casual opensim user who is not fully clued in on
>>>>> it's workings, that popped into my head after reading John Mieske's Space
>>>>> Grid Station post:
>>>>>
>>>>> Is it feasible and sensible while running opensim on a home PC
>>>>> connection to be able to use a MySQL database on a shared web hosting
>>>>> server, such as Hostgator for example? If possible, would this type of setup
>>>>> improve performance of a lightly used standalone or grid-connected sim?
>>>>> I haven't put much thought into this idea, just wanted to blurt it out
>>>>> and see if it's worth pursuing.
>>>>>
>>>>>
>>>>>
>>>>> Ken,
>>>>>
>>>>>
>>>>>
>>>>> You shouldn’t receive any benefit at all doing the above. In fact it
>>>>> will probably make things worse.
>>>>>
>>>>>
>>>>>
>>>>> If I’m reading this right then the region server which you have running
>>>>> locally would then be pulling/pushing the data from across the net on the
>>>>> mysql server, back to your machine. It would probably run worse.
>>>>>
>>>>>
>>>>>
>>>>> Daz
>>>>>
>>>>>  _______________________________________________
>>>>> Opensim-users mailing list
>>>>> Opensim-users at lists.berlios.de
>>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> John Mieske / Winword Exonar
>>>> http://johnmieske.org
>>>> Space Grid Station
>>>>
>>>> _______________________________________________
>>>> Opensim-users mailing list
>>>> Opensim-users at lists.berlios.de
>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>>
>>>>
>>> _______________________________________________
>>> Opensim-users mailing listOpensim-users at lists.berlios.dehttps://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
>>>
>>>
>>
>>
>> --
>> John Mieske / Winword Exonar
>> http://johnmieske.org
>> Space Grid Station
>>
>
>
>
> --
> John Mieske / Winword Exonar
> http://johnmieske.org
> Space Grid Station
>
> _______________________________________________
> Opensim-users mailing listOpensim-users at lists.berlios.dehttps://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/20100218/51783b14/attachment.html>