[Opensim-users] MySQL on seperate server?

Tue Feb 16 20:15:33 UTC 2010

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100216/6fc90cf2/attachment.html>