Databases in Online (Social) Gaming

This paper discusses the importance of databases for the gaming industry, what its requirements are in terms of database technology as well as a discussion on why MySQL is or should be the database of choice for anyone wanting to develop online social games that are reliable and stable in all their aspects.

Get the whitepaper

Introducton

This paper discusses the importance of databases for the gaming industry, what its requirements are in terms of database technology as well as a discussion on why MySQL is or should be the database of choice for anyone wanting to develop online social games that are reliable and stable in all their aspects.

Table of contents

  • 1. Introduction
  • 2. Business and Technical Challenges
  • 3. Data Modeling and Sharding
    • 3.1. Game Accounts (Legally Liable)
    • 3.2. User Profiles (Legally Liable)
    • 3.3. Friends Connections
    • 3.4. Messaging (Ingame) (Legally Liable)
    • 3.5. Billing (Legally Liable)
    • 3.6. Entitlements
    • 3.7. Sessions
    • 3.8. Inventory
    • 3.9. Leaderboards
    • 3.10. Achievements/Trophies
  • 4. Database recommendation
  • 4.1. Replication limitations
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.