Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #16  
Old 09-29-2006, 02:31 AM
eq4me
Hill Giant
 
Join Date: Jul 2006
Posts: 166
Default

Quote:
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.

Last edited by eq4me; 09-29-2006 at 10:38 AM..
Reply With Quote
  #17  
Old 09-29-2006, 02:20 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:39 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3