Google Cloud Platform Blog
Product updates, customer stories, and tips and tricks on Google Cloud Platform
Evaluating Cloud SQL Second Generation for your mobile game
Monday, September 26, 2016
Posted by Joseph Holley, Gaming Solutions Architect, Google Cloud Platform
Many of today's most successful games are played in small sessions on the devices in our pockets. Players expect to open the game app from any of their supported devices and find themselves right where they left off. In addition, players may be very sensitive to delays caused by waiting for the game to save their progress during play. For mobile game developers, all of this adds up to the need for a persistent data store that can be accessed with consistently low latency.
Game developers with database experience are usually most comfortable with relational databases as their backend game state storage. MySQL, with its
ACID-compliant
transactions and well-understood semantics offers a known pattern. However, "game developer" and "database administrator" are different titles for a reason; game developers may not relish standing up and administering a database when they could be building new game content and features. That’s why Google Cloud Platform offers high-performance, fully-managed MySQL instances in the form of Google Cloud SQL Second Generation to help handle your mobile game's persistent storage.
Many game developers ask for guidance about how much player load (concurrent users in a game) Cloud SQL can handle. In order to provide a starting point for these discussions, we recently published a
new solutions document
that details a simple mock game stress-testing framework built on Google Cloud Platform and Cloud SQL Second Generation. For a data model, we looked to the data schema and access patterns of popular massively single-player social games such as Puzzle and Dragons™ or Monster Strike™ for our testing framework. We also made the
source code for the framework
available so you can have a look at whether the simulated gameplay patterns and the data model are similar to your game’s. The results should provide a starting point for deciding if Cloud SQL Second Generation's performance is the right fit for your next game project's concurrent user estimates.
For more information about Cloud SQL Second Generation, have a look at the
documentation
. If you'd like to see more solutions, check out the
gaming solutions page
.
Free Trial
GCP Blogs
Big Data & Machine Learning
Kubernetes
GCP Japan Blog
Firebase Blog
Apigee Blog
Popular Posts
12 best practices for user account, authorization and password management
Cloud TPU machine learning accelerators now available in beta
Introducing Agones: Open-source, multiplayer, dedicated game-server hosting built on Kubernetes
API design: Choosing between names and identifiers in URLs
Why you should pick strong consistency, whenever possible
Labels
Announcements
127
Big Data & Machine Learning
127
Compute
235
Containers & Kubernetes
55
CRE
22
Customers
106
Developer Tools & Insights
126
Events
38
Infrastructure
40
Management Tools
64
Networking
37
Open
1
Open Source
128
Partners
91
Pricing
27
Security & Identity
72
Solutions
20
Stackdriver
19
Storage & Databases
144
Weekly Roundups
16
Feed
Subscribe by email
Certified Professional
Cloud Architect
Demonstrate your proficiency to design, build and manage solutions on Google Cloud Platform.
Learn More
Technical questions? Check us out on
Stack Overflow
.
Subscribe to
our monthly newsletter
.
Google
on
Follow @googlecloud
Follow
Follow