The best database for a high-load project?

Question

MySQL

There is a project on NodeJS, so far it works with MySQL. Judging by the pace of development, in the near future there will be about 38 million records in one table (1000 clients - 38000 records for each). The question arises, how to replace MySQL? I'm afraid he won't make it.
PS The application does not access this table very often, literally 100-200 times a day for each client. Maybe this is an argument to stay on MySQL?

Answer 1

This is a 100% NOT HIGHLY LOADED project!
Stay calm.
Better - look towards optimization of requests.

Answer 2

literally 100-200 times a day for each client.

To all 38,000 records for each? And somehow this number sounds magical ...
In general, judging by the description (one table), it makes no sense to use a relational DBMS. In general, I would recommend looking towards Cassandra

Answer 3

Save the data in 1000 files and distribute via nginx (or as a cache).