[Opensim-users] MySQL on seperate server?

[John Mieske]

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