Which database to choose for the comment feed?

Question

MySQL

What database is better to use for an auto-updated comment feed like comments on facebook and VK? On average, about 1000 comments, dozens of images and new users are added per day. Choice between MySQL and MongoDB.

Answer 1

Which one you know better and use. Mongi will need an order of magnitude more resources than mysql. As an alternative to mysql you can look at percona/mariadb. Any of these tools can be optimized, without sufficient knowledge, you can write crookedly even in Mongo, even in mysql.

Answer 2

I tested 1 million comments with likes on mysql, it works quickly, it turns out that you will definitely have enough for 3 years, and then look.

Answer 3

I think the question is not between MySQL and MongoDB, but between SQL and No-SQL. Or between MySQL, SQLite, MS SQL, Oracle, ... and MongoDB, ElasticSearch, CouchDB, RavenDB, ...
As I understand it, you want to create an analogue of social comments that can be integrated into other sites.
I would use a SQL database since in this case the data structure is static and is unlikely to expand or change. Volumes also allow you to make a fast system based on SQL.
On the other hand, if I wanted maximum performance with minimum server resources, I would use no-SQL namely ElasticSearch.