[Opensim-users] MySQL on seperate server?

[Master_Mirage]

Ahhh my bad, i dident see you were talking about going over the internet, i
was reffering to local LAN. All our servers are on the same lan not remote.
Still evan at wire speeds there is a notable diff. in latency that would
tend to be amplifyed over the internet for the same resions.
Opensimulator dosent really care where the mysql server is and its settings
are flexable for that reasion.
In that case i would go the extra step and add in a local slave replicator
for safety. It will not add the same impact that the master did. It tracks
the master dataserver giving you a clone of all of it in small bursts.
Should say something happen to the master the slave can now kick in as
needed. For us we had other resions for doing that. I might also point out a
toy called mysql proxy. It makes Failover quite painless but its also verry
alpha too.
I made use of it allready and lets me quickly switch the proxy port to a
slave so that downtime of the grid is minor. B4 it we would be offline all
day.


John Mieske wrote:
> 
> you get it :)
> 
> Also the latency IS an issue..  but keep in mind this is about the
> internet
> connection at this time. There is one other point I would like to bring
> up.
> The Cache system in the OpenSim servers ALSO accommodate for the latency.
> So
> in a sense you shouldn't have to worry about it too much. The Cache setup
> is
> where this can "buffer" your interactions with the sim. But yes that is
> correct that it CAN be a problem with your bandwidth ISP. But you'll
> always
> have that risk.
> 
> John
> 
> On Mon, Feb 15, 2010 at 12:58 PM, Master_Mirage
> <mirage123 at verizon.net>wrote:
> 
>>
>> Theres things to think about here. If your just running a small amout of
>> regions you prob wount see mutch of a differance. On the other hand
>> having
>> mysql on its own dedicated server allows more ram free to the region
>> servers, far less stress on the processor as thats handled by the other
>> box.
>> U have allways run my servers in that way. The down side is your adding
>> in
>> latency as your having togo accrost lan type connections that can actualy
>> make things slower.  In my case we run many servers and it was the best
>> balance possable given the amount of data ect. Another resion you may way
>> to
>> consider it, is your ini for all your instances will be the same
>> connection
>> string (makes changing things alot easyer). It also tends to add a tad
>> bit
>> more security as your not exposing the Mysql server to the outside world
>> and
>> it dosent exist on the same servers that have tobe exposed.
>> I found it qute flexable and stable no matter what we throw at it. The
>> other
>> thing is main tasks are also sep. from the server running the regions. It
>> can now have its own set of events that dont bother mutch.
>> Its not hard to set it up like that but you do have to install mysql to
>> allow remote lan connections.
>> Other things i found was we needed mysql replication because our data
>> base
>> became so large that it was an all day thing to deal with. Alot of this
>> most
>> wount need for along time. It took well over a year to get to a point
>> where
>> it all mattered.
>> MySql eats memory and adds to the overhead of the cpu and i/o.
>> If you have the equipment and plan on expanding over time, its prob a
>> good
>> idea to set it up like that now.
>> If you never plan on more than a few regions you prob dont need to set it
>> up
>> like that.
>>
>> :working:
>>
>> Ken Grunke wrote:
>> >
>> > 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.
>> >
>> > _______________________________________________
>> > Opensim-users mailing list
>> > Opensim-users at lists.berlios.de
>> > https://lists.berlios.de/mailman/listinfo/opensim-users
>> >
>> >
>>
>> --
>> View this message in context:
>> http://n2.nabble.com/MySQL-on-seperate-server-tp4575740p4575964.html
>> Sent from the opensim-users mailing list archive at Nabble.com.
>> _______________________________________________
>> 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
> 
> 

-- 
View this message in context: http://n2.nabble.com/MySQL-on-seperate-server-tp4575740p4576547.html
Sent from the opensim-users mailing list archive at Nabble.com.