MySQL as datastore questions

Help and Feedback Scripting Support
#1

So recently I was able to implement MySQL as datastore from my website, my question is will it be able to handle a lot of players lets say I have an average of 10,000 players.

  1. Will the MySQL datastore be able to keep up with 10,000 players daily with the HttpService
  2. Is there a limit to how much data I can store in MySQL, lets say I insert 10,000+ rows a day?
  3. Will my MySQL datastore be vulnerable to exploit and how?
#2

  1. It all depends of your server resources like how much storage you have, the amount of RAM you have been assigned and how many cores you have. If you have adequate resources MySQL will do your job.

  2. There is no limit on number of rows as long as your server has enough storage to store the rows.

  3. MySQL should be secure once your entire server is secure.

1 Like
#3

  1. only 65, 535 rows per table? I thought it can handle more like millions?

  2. What do you mean by entire server is secured? Do you mean if my scripts are not vulnerable to exploiters in roblox or my website is heavily secured with good coding?

1 Like
#4

so mySQL can handle a total database size of 65,536TB you wont have any problems with 10k players im sure. I use MSSQL and MySQL is just as powerfull so no need to worry over size or performance, HTTP Service has restrictions on calls per minute etc thats the key thing here i would say.

1 Like
#5

  1. Sorry about that I meant 65,535 bytes per row. But you can have unlimited rows as long as you have enough storage on your server.

  2. Basically by default MySQL is pretty secure. If possible only allow access to your MySQL server from the localhost. This means that if nothing other than the server it’s self is using the database only allow localhost connections. This will make it much more secure.

1 Like