[Opensim-users] MySQL on seperate server?

Mon Feb 15 19:37:34 UTC 2010

Yea and if you mirror with Raid your Grid is now safe from failures. Its
actually pretty slick.. :)

John

On Mon, Feb 15, 2010 at 2:34 PM, Master_Mirage <mirage123 at verizon.net>wrote:

>
> 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.
> _______________________________________________
> 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/6930817e/attachment.html>