Is it relevant to use Mongo to store a product with attributes?

Question

MySQL

There is a doubt about how to store the attributes of goods (colors, sizes, quantity, lalala).
Hands are reaching out to Mongo, but the experience with it is extremely small, so I still tend to the good old MySQL.
The site will be on the scale of a million-plus city - superloads are not expected.
Everything will run on Yii + MySQL and/or Mongo + Memcache.
Gentlemen, what do you say about this?

Answer 1

If the structure, attributes, fields and relationships are not expected to change frequently, then I advise, like the previous commentator, the good old SQL solution (but still better than PostgreSQL).
In general, if the scale is small and it’s not scary to lose data for the last minute and a half in case of problems, then it will be just nice and convenient to work with Mongo.

Answer 2

In spite of the previous speakers, I will say that there is nothing so terrible in Monge, but it is possible to very simply store records with different sets of attributes in one collection, which can be indexed and, accordingly, perform a quick search on them. Well, about the loss of a minute or one and a half records - this is of course nonsense.