[Opensim-users] MySQL on seperate server?

[John Mieske]

Well said.

:)

On Thu, Feb 18, 2010 at 11:56 AM, Master_Mirage <mirage123 at verizon.net>wrote:

>
>
> I arrive late, as usual :-)
>
> When a region has around 12000 primitives, with a db server on the same
> machine you will have hell on earth or something like that.
>
> Boot up time is around 10 minutes and is impossible to do anything but
> using
> zoom. Impossible to move.
>
> I have tested this with 3 machines (4Gb ram, 500Gb hd RAID, Intel Core Duo
> 1,73, Intel Core duo 2,3 and amd64) running windows XP, Vista and Windows
> 7-64 bits.
>
> I was using grid mode (grid server on separate computer... no ROBUST or
> UGAIM, it uses a PHP ugaim system).
>
> Separating Mysql to another machine on the same local network (100 Mbps nc)
> I could move, build, and even another avatar could enter.
>
> Exporting db and running it on separate server with Linux (ubuntu server
> 9.04) I could fill the region with 5000 more prims and 2 avatars could work
> smooth.
>
> Running opensim on Linux (amd64, 4gb ram, ubuntu server 9.04 64 bits) and
> db
> on separate linux server 2 avatars could work smoothly and filling the
> region with 25000 prims (no simple prims, but different sizes, texturized
> and scripted).
>
> Anyway, that were my "home" experiences... My conclusion: separate db,
> don't
> use windows.
>
> Greetings
>
>
> Well 1st a bit on that. going back in time 1.5 years now running
> opensimulator, At 1st it dident really matter as there wasent enough of a
> DB
> to become a problem with YET. I had to take in account baised on (no was
> really shure about anything) what it was i wanted someday. I knew that both
> linux and win were used but seemed a hot argument and still no one really
> had an answer for whats best for running a grid on. I Decided  that the
> only
> true way to know is run both and see.
> So i purchaced 5 quad core servers all the same equip. ram ect. To me this
> would be enough putter power to find out with. Remeber that opensimulator
> is
> still alpha and was more so then.
> I begain testing the MANY ways a grid can be formed and the equip. made it
> a
> bit easyer to see it Side By Side in real time.
> It dident take long to see that mysql would grow in perpotion to the db
> size
> as to its own demands.
> At 1st it was faster to have mysql local to the services and was for
> sometime. Later it started to glom onto the same resources the instances
> needed and begain to get verry slow. At that point assets were around 3-4
> gigs. Seeing the problem i knew i had to do something as the longer i
> waited
> the worse it would get.
> Moved Mysql to another box knowing latency would be there.
> That indeed delt with the 'tipping point' it reached. It wasent hard to see
> for my selph what happend.
> That worked well for sometime but it begain to develop its own problems due
> to the unknowen) as to its settings. Had to readj the MySql settings 4
> times
> and 2 total rebuilds due to the never ending growth of assest data. When it
> hit around 10-11gigs assests a whole new set of problems showed up. The big
> one is all that data has to be maintained and backed up. This took most of
> a
> day of downtime as why its doing all that its locking the tables and
> Opensimulator freeks. Thats not good and not only is the grid offline but
> the amout of time by me to work on it became excessive. As orginaly i had
> bee wise and bought enough computers i spent a good while learing about
> Mysql replication. This does solve some of the problems as it lets me
> switch
> the services to use the other Mysql and allows maint to happen with little
> effort.
> Only the one maint is beeing done on has tables locked not both.
> Moveing to current time. 23+gigs assests and at my goal of 100 regions
> (un-told amout of prims and scripts whatever) it was a verry good plan.
> Is it as fast as it could be? Nope! The problem will allways be there. Is
> it
> scaleable? You betcha!.
> I guess my point is Depends on what you expect your grid tobe and planning
> assuming worse case as best as you can.
> Opensimulator is made to be as felxable as it needs tobe and what oper.
> system i find is a push. Both do an excellent job and Both can and do show
> the same performance when set up properly.
> For me the differances realy boiled down to what was more comfortable for
> me
> to maintain. In my case im dealing with many servers acting as one. If you
> ask me whats better ill say none.
> My best suggestion for ppl starting out is expect nothing and be really
> happy when it all works better than you though
> :-)
> There will allways be argument and theroy and thats a good thing but there
> is no better judge than you and what you can see in realtime.
> :working:
>
> --
> View this message in context:
> http://n2.nabble.com/MySQL-on-seperate-server-tp4575740p4592890.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/20100218/838b0e34/attachment.html>