What database can withstand a load of 10k requests per minute?

Question

PHP

Hello. While not a lot of coding, I realized that there is no point in using mysqli in our time. As a result, the database should calmly withstand 10k requests per minute, but there may be peaks of up to 200k requests. Which one to choose? what cluster can build?) Thanks in advance.
PS
On one forum, I was advised to design my own database and not worry, I ask you not to write such an answer :)
I was also advised to take noSQL and write json there, is it worth my torment?)

Answer 1

most likely you were advised to competently design a database, and not write your own DBMS.
10K requests per minute is only 166 requests per second. Further already the question goes - what plan zaprsy. If simple selects, then any will do. Well, if not simple, then you already have to think about it. Again, everything depends on the architecture of your database and what you will do with it.
In general, potsgres is the most universal answer, and not only because it has normal performance and it scales well horizontally.

Answer 2

Excuse me, what were you guided by when deciding that "mysqli makes no sense to use in our time"? MySQLi itself has no alternatives within the framework of the tasks it performs, maybe you had NoSQL solutions at all? Then yes. Only these are different things. Everything that is offered to you in the comments is SQL solutions. It's just that the motives are really interesting when they write off normal technologies out of ignorance. It's like rewriting a project on objects into procedures, with only a misinterpreted statement that this adds to productivity.

Answer 3

You need a clickhouse