EQEmulator management

[GeorgeS]

Originally Posted by Angelox

I have a DSL connection which is as follows; 1.5mb downstream/512kb upstream with static IP, and it seems to be running as promoted by the ISP.
I was thinking of maybe setting up a public server so players who are not interested their own home server, could try out my DB too. Do you think this would fall short?

I would guess less than 20 people on at once. You should definitely try it as it's a great experience. I have a 6mbit down 0.8up on my DSL.

GeorgeS

DSL is what I have at home, if you never plan on using your internet again you will do about 15 people with lag when there is multiple people in one area fighing or casting.

The second you use the connection to read mail, look at p0rn, or whatever it drops to like 8.

[Angelox]

Well, If you use DSL as-is, and tried some drastic data exchange - you could get extra lag or problems. I can't believe this link is still alive;
http://cable-dsl.home.att.net/
This is where I got my first "tutorial" on DSL - lots of valid info there.

Also at this link;
http://www.speedguide.net/
there's a "TCPOptimizer" tool that I have been using for years on windows machines - works very well.
When I played EQ live, I read on their Faqs that "ping" was very important (latency), if you had a slow ping, then you would have lag in game.

I have been to places where internet, no matter what you have - is not worth a rat's ass.


I was thinking; why not have the zones spread out over different servers at different locations? I mean, like x amount of zones here, another amount at GeorgeS, John Adams, and anyone else who wants to be in on it.

[eq4me]

Originally Posted by Angelox

I was thinking; why not have the zones spread out over different servers at different locations? I mean, like x amount of zones here, another amount at GeorgeS, John Adams, and anyone else who wants to be in on it.

The problem is the Database connection. Each server who starts up zones wants to read whole tables from the MySQL DB. This can take extremely long on a slow connection. And the traffic between the zones and the MySQL DB dont stop after startup. So the uplink probably would be also clogged with traffic to the remote database.
I discovered this when I was trying to start EQEmu in an VMWare instance connecting to the MySQL DB on the host system. Without the propper network drivers out of the VMWare tools its like 100 Kb/s.

Btw: So a dual 750 MHz PIII Server with 2GB Ram would be good enough to hold a well sized crowd? I have an tempting offer. 1U Rackspace with 250GB/month free for 21

[Angelox]

The problem is the Database connection. Each server who starts up zones wants to read whole tables from the MySQL DB. This can take extremely long on a slow connection. And the traffic between the zones and the MySQL DB dont stop after startup. So the uplink probably would be also clogged with traffic to the remote database.

Since different zones would be hosted on different servers, servers could use their own database. The problem would be on how to keep the players data up to date on all the servers, which doesn't sound too hard.

[eq4me]

Originally Posted by Angelox

Since different zones would be hosted on different servers, servers could use their own database. The problem would be on how to keep the players data up to date on all the servers, which doesn't sound too hard.

You could do a master/slave setup for MySQL.

http://dev.mysql.com/doc/refman/4.1/en/replication.html

All you had to worry about is redirecting all write requests to the master database. Either you have to program it into EQEmu itself or find/code a mysql proxy listener that knows which databases to send read and write requests to.
It must be determined how much bandwith such a setup requires on the uplink. Imagine some big come together event on a zoneserver that is on a remote location from the MySQL master database. But I have no idea how much updates per second per player must be written in the database on average and peak.

[John Adams]

Matts stats are the ones that spook me a little. The servers we all own seem robust enough to handle plenty of running zones effectively - but he's right about the bottleneck at our cable modems or DSL. If our uplinks are not so great, once 2 groups of your players start tearing into something together, everything could run as smoothly as Morell-Thule in the early days. Anyone know what those servers hosting 30+ players runs on? must be more than DSL.

As for multi-honing our zones, sounds like an intriguing concept. I'd just be concerned with whomever owns one of the zone boxes staying on top of any issues that might arise, or losing that resource.

[unknownerrors]

i'm doing this whole thing for a home business, for three year i dont have to break a profit but a get a huge tax break on a room in my house and any cost of running the "business" right down the the monthly electic bills. even if the cost really isn't there.. truth be told i never plan to make any money aside from the IRS..

but the server will have to run 24-7.. and it might as well run correct, cause i'm gonna play on it too =)

so one good box can handle 60 - 70 zones.. plus 10 dynmatic? i'd still spread it out over two boxes, boot all zone static, but cut the world down to size and only enable up to OOW.. put them in a closet and real-VNC into them so i dont need monitors mices keyboards and what not.. the connection is an issues.. i hear sprint offers a good high speed business class connection, or should i use a shell account? upload anything to a host and let them handle the connection..