[Opensim-users] MySQL on seperate server?
Steve
steveamigauk at yahoo.co.uk
Tue Feb 16 20:45:11 UTC 2010
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
> <mailto: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
> <mailto: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 <mailto: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
>> <mailto: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
>> <mailto: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
>> <mailto:Opensim-users at lists.berlios.de>
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> <mailto: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 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/20100216/9d47160f/attachment.html>
More information about the Opensim-users
mailing list