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.

What we’ll cover in this white paper

• 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