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.