Sony Online opts for open-source database over Oracle
The switch to open-source EnterpriseDB is eased by compatibility with Oracle
Computerworld - Sony Online Entertainment Inc. is starting to move away from the Oracle databases that are the foundation of its online games, opting instead for a 2-year-old commercial open-source database based on PostgreSQL.
San Diego-based Sony Online offers a number of popular Massively Multiplayer Online Role-Playing Games, or MMORPGs, including EverQuest, EverQuest 2, Star Wars Galaxies and others.
They have "hundreds of thousands" of subscribers, said Rick Herman, vice president of business and legal affairs at Sony Online Entertainment.
The databases store terabytes of data about the "worlds" in which game characters live, battle and fall in love.
"If you took a virtual character in EverQuest and had him start running in one direction, it would take 30 days before he would reach the end of the world," Herman said.
The games also store data on players characters. In Star Wars Galaxies, for instance, every object -- be it lightsaber, X-Wing fighter or blaster gun -- can be heavily customized by its owner. That means the database must store each object in the game individually, rather than storing one version that it provides to every player.
Sony Online now operates more than 150 Oracle 9i databases around the world.
But by midyear, Sony Online expects to have three services moved to EnterpriseDBs Advanced Server 8.1 database, according to Chris Yates, the companys vice president of technology.
One will be Sonys Station Exchange service, which creates an eBay-like marketplace for players of EverQuest and EverQuest 2 to buy and sell online goods such as swords, potions and spells.
The service, which debuted last year, is still small; there were fewer than 1,000 items up for auction at the end of last week, according to Sony. Even so, buyers pay as much as $2,000 for digital items.
Sony also plans to move one of its smaller games, Matrix Online, which it bought last summer, to EnterpriseDB. It also plans to move a message board over to EnterpriseDB.
Yates had been looking for an alternative to Oracle for a year. "We think its a great product, but its so expensive," he said. "We use a lot of Oracles advanced features: clusters, materialized views, high transactions. We knew that our alternative needed to be a real database."
Oracles free Express edition was "not a lot of use," said Yates, who also looked at open-source databases such as MySQL and PostgreSQL. He liked the latters "richness" and its lower price tag. But Yates balked at the costs and hassle of retraining his staff and rewriting the database applications to run on PostgreSQL.
- The Business Value of Continuous Delivery Download this whitepaper to learn more about the business value of Continuous Delivery and see why it could be a game changer for...
- Ten Factors Shaping the Future of Application Delivery Download this research report conducted by Enterprise Management Associates (EMA) to learn how those that are seeking to accelerate application delivery are leveraging...
- Adobe Creative Cloud FAQ The following are answers to common questions about Adobe® Creative Cloud™ for teams membership, purchasing, security, and storage.
- What's coming to Adobe Creative Cloud Editing and video content creation workflows are about to get easier and more exciting, with major updates coming soon to Creative Cloud, bringing...
- NSS Labs & Cisco Present: Evaluating Leading Breach Detection Systems Today's constantly evolving advanced malware and APTs can evade point-in-time defenses to penetrate networks. Security professionals must evolve their strategy in lockstep to...
- Will the Real Endpoint Threat Detection and Response Please Stand Up? This webinar explores new technologies & process for protecting endpoints from advanced attackers as well as the innovations that are pushing the envelope... All App Development White Papers | Webcasts