Which database to choose for a highly visited project with 1 million products?

Question

MySQL

Good afternoon.
A database with 10 million records and growth up to 50 million is planned (product catalog)
Is it correct to use MySQL for a highly visited project or another database?
The task is high speed: displaying search
products filtering (for each attribute, show how many values ​​it gets under the current filter (the current filter means the current combination of other attributes) And what kind of server architecture do you recommend

Answer 1

As long as the entire database fits in memory, there should not be a problem on any DBMS. So take it.

Answer 2

50 million for reading is a penny for any database.
MySQL is not the slowest option.

Answer 3

50 million is not a lot of filters, of course, you have to do it on sphinxsearch, solr or something like that.