MySQL vs Percona vs MariaDB for online store?

Question

MySQL

An online store is to be developed from scratch (now the stack on which development will be carried out is being selected and discussed). According to the functionality at the moment, this is a regular online store in which there will be:
1. A bunch of text pages
2. A product catalog divided into categories
3. A system of various discounts
4. Shopping cart
5. Products with ratings, reviews and characteristics (previously stored as an EAV model )
6. Filter products by price, characteristics, etc.
What will be further developed in it is not yet known.
The workload of the project will be approximately average. Number of goods on average (for a general understanding of the volume of stored data): 200,000-300,000. It is also necessary to provide for the possibility of further horizontal scaling of the system.
Actually I wondered which DBMS from the MySQL family (this is important) is better to use? Share your experience how much it makes sense to use Percona / MariaDB instead of MySQL and what profit can you get from this in the future?

Answer 1

boom portal. 200K+ hits/day, there are mailings for 100K+ subscribers/day or several smaller ones.
your iron. a separate Wirth server 4CPU, 40GB of frames is allocated for the database. Shared disk array raid10
mariadb (innodb, aria).
P.S.
The database loves to eat memory, you need to give a lot

Answer 2

I think it's worth relying on Oracle MySQL + InnoDB (Barracuda file format). You need to tune MySQL performance based on the application's performance profile.