August 2002
- TECH: Path MTU Discovery Eli Stevens
- Matt's java problems.... Adam
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Kwon Ekstrom
- Non-traditional monsters? eric
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Damion Schubert
- Non-traditional monsters? Bruce Mitchener
- Non-traditional monsters? Edward Glowacki
- Non-traditional monsters? szii@sziisoft.com
- Non-traditional monsters? Nathan F. Yospe
- OT: Gen Con? Michael Tresca
- Unique items vs. item references Brian Hook
- Unique items vs. item references Vincent Archer
- Unique items vs. item references shren
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references lynx@lynx.purrsia.com
- Unique items vs. item references Bruce Mitchener
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references fred@clift.org
- Unique items vs. item references shren
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references Damion Schubert
- Unique items vs. item references Freeman, Jeff
- Unique items vs. item references Harrok
- Unique items vs. item references Zach Collins {Siege}
- Unique items vs. item references fred@clift.org
- Unique items vs. item references Vincent Archer
- Unique items vs. item references Koster, Raph
- Unique items vs. item references Dave Rickey
- Unique items vs. item references Vincent Archer
- Unique items vs. item references Dave Rickey
- Unique items vs. item references Daniel.Harman@barclayscapital.com
- Unique items vs. item references Sean Kelly
- Unique items vs. item references Damion Schubert
- Unique items vs. item references Smith, David {Lynchburg}
- Unique items vs. item references Sean Kelly
- Character skill amplifying player skill Brian Hook
- Character skill amplifying player skill Daniel.Harman@barclayscapital.com
- Character skill amplifying player skill Ling Lo
- narrative Bruce Mitchener
- narrative Brandon J. Van Every
- narrative Robert Zubek
- narrative Brandon J. Van Every
- narrative Sasha Hart
- narrative Benjamin Tolputt
- [Fwd: [Algorithms] ANNOUNCE: updated Chunked LOD demo] Bruce Mitchener
- (no subject) Jack Britt
- (no subject) Brandon J. Van Every
- (no subject) Jack Britt
- (no subject) Jeff Lindsey
- (no subject) Karl Bastiman
- (no subject) Zach Collins {Siege}
- Advertising Thread Rayzam
- Advertising Thread Brandon J. Van Every
- Advertising Thread Matt Mihaly
- Advertising Thread Brandon J. Van Every
- Advertising Thread Russ Whiteman
- Advertising Thread Koster, Raph
- Advertising Thread Russ Whiteman
- Advertising Thread Kristen Koster
- Advertising Thread Rayzam
- Advertising Thread Brandon J. Van Every
- Advertising Thread Shannon Appelcline
- Advertising Thread Brandon J. Van Every
- Advertising Thread Rayzam
- Advertising Thread Matt Mihaly
- Advertising Thread Daniel.Harman@barclayscapital.com
- Advertising Thread Brandon J. Van Every
- Advertising Thread Daniel.Harman@barclayscapital.com
- Advertising Thread Matt Mihaly
- Advertising Thread Jeremy Noetzelman
- Advertising Thread Amanda Walker
- Advertising Thread Matt Mihaly
- Advertising Thread Jeremy Gaffney
- Advertising Thread Matt Mihaly
- Advertising Thread Michael Tresca
- Advertising Thread Dave Rickey
- Advertising Thread Matt Mihaly
- skills (was (no subject)) Travis Casey
- The total DBMS approach (was: Unique items vs. item references) Derek Licciardi
- The total DBMS approach (was: Unique items vs. item references) Crosbie Fitch
- The total DBMS approach (was: Unique items vs. item references) Valerio Santinelli
- The total DBMS approach (was: Unique items vs. item references) Russ Whiteman
From: "Derek Licciardi"
> I believe you could build a database based architecture like you
> describe in scenario one. I also think that it would be cost
> prohibitive to do so for anything larger than a normal sized MUD.
> If you're talking about MMOG size, then you're looking at severe
> costs.(relative to a typical MMOG or game project) In effect you
> would be building something the size of SAP, PeopleSoft, or Oracle
> Applications for your transaction system. Like SAP, given enough
> hardware, it runs amazingly fast. Oracle is capable of handling
> the NASDAQ stock market. It is certainly capable of handling the
> processing requirements of a MUD or even an MMOG. The question
> quickly becomes a money one. SAP, installations run into the 20 -
> 50 million dollar range and higher to achieve MMOG style subsecond
> performance for thousands of users. The benefit of having a
> standardized interface to the game data through SQL simply does
> not outweigh the significant increase in cost.
<snip>
> For a MUD, this might be totally different. If anyone gives the
> approach a try, I'd love to hear how it came out and would be very
> willing to offer database design advice if needed. Even with a
> MUD, you're probably not going to be able to do it without a
> nearly midrange server. We're talking about SCSI RAID arrays,
> Multiple processors, Gobs of memory, and a qualified DBA that can
> tune like a madman.
I'm not sure I can agree with you on the cost to run such a system.
We do a significant portion of our storage with an Oracle db running
on a not extremely expensive server. We haven't bothered moving
everything over to the database primarily because the older,
in-memory/write to disk-cache system works well enough that it's not
worth the effort to replace it at this time. When we finally
decided to make this move, we decided to start with the systems that
would most obviously benefit from the new capabilities, primarily a
high-volume, high-detail logging system for player and game-system
activities, that could be queried by our in-game staff for research
and/or CS issues. Admittedly, our db traffic is not the same kind
of balance that you'd see for the "pure db" option that David was
discussing (our traffic is 90%+ writes, we load the character data
on login, and only in rare system calls at other times), but I don't
have any reason to think that that particular fact would cause any
huge change in performance.
Yes, we do have a SCSI RAID array, but the server itself was, until
recently, actually a dual Pentium-Pro running at ~200 MHz. We
upgraded to a Quad Xeon server primarily to allow for some room to
handle some rather CPU intensive reporting we began offering our
in-game staff. The system handles 11 games, and a total in-game
population of 2200-2300 on average with peaks of well over 3000.
Although we have a license for Oracle Enterprise edition (a
perpetual license at an older, more reasonable cost than today's
licenses), the system doesn't actually use anything not available in
Oracle Standard...which was available for a few hundred dollars per
named user last time I checked. Total cost for the operating system
and database software < $20K (not at all out of reach for a MMOG,
although it could be a bit pricy for an everyday MUD). Last time I
checked, we had ~1.5 million entities (characters and accounts) and
~50 million log entries, and we're handling 1200-1500 transactions
per second at times, without even coming close to bottlenecking
anywhere, so it could ramp up much higher than we're using it...hard
to tell without actually running the load up high enough to start
seeing some significant delays. The CS reports are by far the
biggest load, and they generally run in less than 5 seconds (but as
the game doesn't have to wait for these, who cares?).
Admittedly, it took a fair amount of time, effort, and
experimentation to get things as well tuned as they are, but you're
going to have to spend that on -any- system you build for the game.
<g>
As for safety, we currently mirror the database submissions into XML
files at each transmission point between the game and the db, so we
stand to lose no more than a few seconds of data, no matter where
the system might break (and likely none at all in any single point
of failure). Worst case would be a really bad db corruption at the
same time that we suffer a HD crash in the game...if we lose the XML
-and- the current db and have to restore to backups, we might
actually lose up to a day of activity...but the more likely scenario
is that we get a few duplicate entries (which, for logs, just isn't
a big deal).
> No matter how you position the database, you're going to want to
> write an interface in front of the database that allows
> communication with the game client. The game client should never
> have the ability to fire SQL straight to the database.
I'll certainly agree with you here, and go you one farther...nobody
outside of your database coders should be writing sql straight to
the database, unless you've got an -extremely- simple schema (which
isn't going to be very flexible in the long run). User-written SQL
has that nasty tendency to tie up large amounts of CPU trying to
process extremely unoptimized code...which is simply unacceptable
for a system like this. Even db-aware programmers can have a hard
time getting some queries to run well (and of course, those are the
queries that would be most useful to the in-game staff), and I do
think that replicating the data in a warehouse -will- drive a system
like this into the red pretty quickly.
Bottom line, I believe that it is quite feasible to store all
persistant data in a real db, although you'd best have some
reasonably competent db coders and a decent DBA-type to make it work
well.
- Socket Code Stephen Miller
- Socket Code Smith, David {Lynchburg}
- Socket Code Blane Bramble
- Origins of "carebear" Koster, Raph
- Origins of "carebear" Steve {Bloo} Daniels
- Origins of "carebear" Koster, Raph
- Origins of "carebear" Madrona Tree
- Origins of "carebear" Calandryll
- Origins of "carebear" Dave Trump
- Origins of "carebear" Koster, Raph
- The total DBMS approach Aaron "the mad man" Weeks
- The total DBMS approach Derek Licciardi
- The total DBMS approach Hanz, Rob
- The total DBMS approach Daniel.Harman@barclayscapital.com
- The total DBMS approach Sean Kelly
- The total DBMS approach Hanz, Rob
- The total DBMS approach Elia Mòˆrling
- The total DBMS approach Daniel.Harman@barclayscapital.com
- The total DBMS approach Ian Macintosh
- Otherland Richard A. Bartle
- Efficiency in providing entertainment John Buehler
- Noncombat(and combat) skills WAS: (no subject) "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- Mountaineering and Athletics Brandon J. Van Every
- Mountaineering and Athletics Damion Schubert
- Mountaineering and Athletics John Buehler
- Mountaineering and Athletics Poe, Lawrence
- Mountaineering and Athletics Vincent Archer
- Noncombat(and combat) skills Jo Dillon
- Noncombat(and combat) skills "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Jack Britt
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Brandon J. Van Every
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Artovil
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Zach Collins {Siege}
- What Ever Happened to Imaginary Realities? Phillip Lenhardt
- What Ever Happened to Imaginary Realities? Richard A. Bartle
- Butterfly.net Matt Mihaly
- Butterfly.net Freeman, Jeff
- Butterfly.net Luca Girardo
- Butterfly.net Luca Girardo
- Mythology Articles Shannon Appelcline
- Item handling (was: Advertising Thread) Jeff Lindsey
- Advertising Thread Brad McQuaid
- Advertising Thread Brandon J. Van Every
- Advertising Thread Damion Schubert
- Advertising Thread Marc Bowden
- Advertising Thread Damion Schubert
- Advertising Thread Richard Aihoshi aka Jonric
- Advertising Thread Russ Whiteman
- Advertising Thread Brad McQuaid
- Advertising Thread Dave Rickey
- Advertising Thread Marc LaFleur
- Advertising Thread Koster, Raph
- Advertising Thread Marc LaFleur
- Advertising Thread Koster, Raph
- Advertising Thread Richard Aihoshi aka Jonric
- Advertising Thread Zach Collins {Siege}
- Advertising Thread Ron Gabbard
- Advertising Thread Richard Aihoshi aka Jonric
- Social Networks Dave Rickey
- Social Networks Brian 'Psychochild' Green
- Social Networks Dave Rickey
- Social Networks Brian 'Psychochild' Green
- Social Networks Bruce Mitchener
- Social Networks Harrok
- Social Networks Freeman, Jeff
- Social Networks Sage
- Social Networks Damion Schubert
- Social Networks Matt Mihaly
- Social Networks Harrok
- Social Networks Matt Mihaly
- Social Networks Tess Snider
- Social Networks Paul Schwanz
- Social Networks Bruce Mitchener
- Social Networks Paul Schwanz
- Social Networks Michael Tresca
- Social Networks Marian Griffith
- Social Networks Zach Collins {Siege}
- Social Networks Freeman, Jeff
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Sasha Hart
- Social Networks Dave Rickey
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Freeman, Jeff
- Social Networks Jeff Cole
- Social Networks Koster, Raph
- Social Networks Jeff Cole
- Social Networks Matthew Dobervich
- Social Networks Jeff Cole
- Social Networks Dave Rickey
- Social Networks Jeff Cole
- Social Networks Sasha Hart
- Social Networks Nicolai Hansen
- Social Networks Dave Rickey
- Social Networks Paul E. Schwanz, II
- Social Networks Sasha Hart
- Social Networks paul.schwanz@sun.com
- Social Networks Sasha Hart
- Social Networks Matt Mihaly
- Social Networks John Buehler
- Advertising Thread Edward Glowacki
- Advertising Thread Matt Mihaly
- Histories and Legends paul.schwanz@sun.com
- Histories and Legends Koster, Raph
- Histories and Legends Paul Schwanz
- Histories and Legends Matt Mihaly
- Histories and Legends Paul Schwanz
- Histories and Legends Val Trullinger
- Histories and Legends apollyon
- Histories and Legends Matthew Dobervich
- Histories and Legends Koster, Raph
- Histories and Legends Edward Glowacki
- Histories and Legends Sasha Hart
- Advertising Thread Richard A. Bartle
- Where do you get you numbers? NetEngels@aol.com
- Where do you get you numbers? Dave Rickey
- Mud Advertising Matt Mihaly
- Mud Advertising Christopher Allen
- Mud Advertising Brian 'Psychochild' Green
- Online World Timeline slashdotted Koster, Raph
- Online World Timeline slashdotted Lars Duening
- Online World Timeline slashdotted Dave Rickey
- Online World Timeline slashdotted Ted L. Chen
- Online World Timeline slashdotted Russ Whiteman
- Online World Timeline slashdotted Jon A. Lambert
- TECH: Trusting Network Clients Fox McCloud
- TECH: Trusting Network Clients "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- TECH: Trusting Network Clients Jeremy Noetzelman
- TECH: Trusting Network Clients Nicolai Hansen
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Freeman, Jeff
- TECH: Trusting Network Clients Vincent Archer
- TECH: Trusting Network Clients Brack, J. Allen
- TECH: Trusting Network Clients Kwon J. Ekstrom
- TECH: Trusting Network Clients brian hook
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Koster, Raph
- TECH: Trusting Network Clients Sasha Hart
- TECH: Trusting Network Clients Phillip Lenhardt
- TECH: Trusting Network Clients Sasha Hart
- TECH: Trusting Network Clients apollyon
- TECH: Trusting Network Clients Travis Nixon
- TECH: Trusting Network Clients Sean Kelly
- TECH: Trusting Network Clients Koster, Raph
- TECH: Trusting Network Clients Sean Kelly
- TECH: Trusting Network Clients Paul Schwanz
- TECH: Trusting Network Clients Justin Quimby
- TECH: Trusting Network Clients Steve Dieter
- TECH: Trusting Network Clients Jesus Lopez
- TECH: Trusting Network Clients Nicolai Hansen
- TECH: Trusting Network Clients Tess Snider
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Christohe Badoit
- TECH: Trusting Network Clients Bruce Mitchener
- TECH: Trusting Network Clients Christophe Badoit
- TECH: Trusting Network Clients Fox McCloud
- TECH: Trusting Network Clients Christophe Badoit
- TECH: Trusting Network Clients Edward Glowacki
- TECH: Trusting Network Clients James Ross Nicoll
- TECH: Trusting Network Clients Phillip Lenhardt
- TECH: Trusting Network Clients Russ Whiteman
- TECH: Trusting Network Clients Ian Macintosh
- TECH: Trusting Network Clients damon baker
- TECH: Trusting Network Clients Benjamin Tolputt
- TECH: Trusting Network Clients David H. Loeser Jr.
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Koster, Raph
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Rickey
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Rickey
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Crosbie Fitch
- Natural Selection and Communities Koster, Raph
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Trump
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Damion Schubert
- Natural Selection and Communities Ron Gabbard
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities David Kennerly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Paul Schwanz
- Peer-to-peer hosting of player created content in persistant worlds. Matthew Dobervich
- Sales data Richard A. Bartle
- Sales data Daniel.Harman@barclayscapital.com
- Sales data Luca Girardo
- Sales data Richard A. Bartle
- Sales data Rayzam
- Sales data Robert A. Rice, Jr.
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Sasha Hart
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Sasha Hart
- Cans of Achievements and Quests Justin Quimby
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Paul Schwanz
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests damon baker
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Michael Tresca
- Cans of Achievements and Quests Rayzam
- Muds and High School Textbooks Jon A. Lambert
- Unruly Players (fwd) J C Lawrence