Our approach included a MySQL database for storing all the data, with all the essential game logic set up on the server-side. We also took into consideration that load balancing would be more crucial for this type of game development. Furthermore, our team carried out a stress test for the server-side to ensure it could handle the vast number of players that we expected. Throughout the extended hours of the stress test, we gathered the necessary data and analyzed performance.
Our game development team successfully set up the Photon server in AWS, ensured Photon server load balancing, set up the MySQL databases, and implemented game logic in the server while securing data communication between the game, server, and database.
Additionally, we wanted to make sure that our approach included user behaviors. To understand the player better, we made sure to collect user data and analyze common behaviors after the initial release. For us, it was crucial to collect analytics such as the quest completion rate, DAU, and MAU. Then, based on the information collected, our game designers can update and refine the game. In addition to my role in multiplayer development, I also developed a KPI tool for tracking daily users and their activities through Steam.