Skip to main content
Game Development

Return to Answer

added 37 characters in body
Source Link
Philipp
Philipp
  • 123k
  • 28
  • 264
  • 344

I'm sorry, but we can not even give you a rough estimate as long as we do not know anything about your game. We do not know how many SQL queries each player generates. It could be anything between one SELECT and one UPDATE per session (one when they log in and one when they log out) or they could be generating multiple queries per second. And we also don't know how complex those queries are. They could be thosesimple ones which only take microseconds to answer, or very complex ones which take multiple secondskeep your whole MySQL cluster busy for seconds.

So in order to get at least the order of magnitude correct, you won't get around making a load-test. Tell your development team* to develop your gameserver to a level that it can access a database and send a couple queries which are similar to the usage patterns you would expect from the clients. Then spin up a small SQL server for load-testing. SQL queries will scale with the amount of data in the tables you query. So you also need to generate an appropriate amount of test data. Then simulate a couple thousand players on your server, check the load on the SQL server and extrapolate.

* You do have a team, right? MMORPGs are among the most complex and expensive games to develop and operate. They are not projects you can pull off as a solo developer.

I'm sorry, but we can not even give you a rough estimate as long as we do not know anything about your game. We do not know how many SQL queries each player generates. It could be anything between one SELECT and one UPDATE per session (one when they log in and one when they log out) or they could be generating multiple queries per second. And we also don't know how complex those queries are. They could be those which take microseconds to answer, or very complex ones which take multiple seconds.

So in order to get at least the order of magnitude correct, you won't get around making a load-test. Tell your development team* to develop your gameserver to a level that it can access a database and send a couple queries which are similar to the usage patterns you would expect from the clients. Then spin up a small SQL server for load-testing. SQL queries will scale with the amount of data in the tables you query. So you also need to generate an appropriate amount of test data. Then simulate a couple thousand players on your server, check the load on the SQL server and extrapolate.

* You do have a team, right? MMORPGs are among the most complex and expensive games to develop and operate. They are not projects you can pull off as a solo developer.

I'm sorry, but we can not even give you a rough estimate as long as we do not know anything about your game. We do not know how many SQL queries each player generates. It could be anything between one SELECT and one UPDATE per session (one when they log in and one when they log out) or they could be generating multiple queries per second. And we also don't know how complex those queries are. They could be simple ones which only take microseconds to answer, or very complex ones which keep your whole MySQL cluster busy for seconds.

So in order to get at least the order of magnitude correct, you won't get around making a load-test. Tell your development team* to develop your gameserver to a level that it can access a database and send a couple queries which are similar to the usage patterns you would expect from the clients. Then spin up a small SQL server for load-testing. SQL queries will scale with the amount of data in the tables you query. So you also need to generate an appropriate amount of test data. Then simulate a couple thousand players on your server, check the load on the SQL server and extrapolate.

* You do have a team, right? MMORPGs are among the most complex and expensive games to develop and operate. They are not projects you can pull off as a solo developer.

Source Link
Philipp
Philipp
  • 123k
  • 28
  • 264
  • 344

I'm sorry, but we can not even give you a rough estimate as long as we do not know anything about your game. We do not know how many SQL queries each player generates. It could be anything between one SELECT and one UPDATE per session (one when they log in and one when they log out) or they could be generating multiple queries per second. And we also don't know how complex those queries are. They could be those which take microseconds to answer, or very complex ones which take multiple seconds.

So in order to get at least the order of magnitude correct, you won't get around making a load-test. Tell your development team* to develop your gameserver to a level that it can access a database and send a couple queries which are similar to the usage patterns you would expect from the clients. Then spin up a small SQL server for load-testing. SQL queries will scale with the amount of data in the tables you query. So you also need to generate an appropriate amount of test data. Then simulate a couple thousand players on your server, check the load on the SQL server and extrapolate.

* You do have a team, right? MMORPGs are among the most complex and expensive games to develop and operate. They are not projects you can pull off as a solo developer.