Slightly loaded system what to use as a DBMS?

Question

Database

I am writing a site where people will fight among themselves for virtual coins.
It is expected that there will be a table in the database called "lobbies" where there will be a lobby that a person can join.
A good option, it seems at first glance.
But then I thought: what will happen if there are not 10 or 100 such lobbies, but 10,000? And there will be 100,000 visitors.
Where to store such data? It seems to me that MySQL is not suitable for such a load.

Answer 1

MySQL, with proper database design, configuration and appropriate hardware, is suitable for both 1M users and 10M.

Answer 2

In any unclear situation, use PostgreSQL.

Answer 3

If you do not anticipate scaling this table to two, three, five (more than one) ... servers, then mysql will fit 100%.