MongoDB or MySQL for large table and millions of records

Mario Bernheim
Mario Bernheim used Ask the Experts™
on
A new API requires us to receive about 45kb of information per row (record) and save this in a database, we see think about 700GB of data will be added PER year. The table is simple with 50 columns or fields. We are not sure if this is a job for MongoDB or MySQL. The setup must be able to scale horizontally, table will also be queried and searchable . About 1000 transactions per second.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Commented:
At the scale you indicate I would eliminate MySQL.

Scaling Mongodb isn't something I have ever been involved in, but there is plenty of written material on the subject. e.g.
https://www.compose.com/articles/how-we-scale-mongodb/
DBA and Business Intelligence Developer
Commented:
As my understanding, the API returns data in JSON format. If YES, MongoDB is the candidate. If you parse data and insert into table, MySQL is the candidate. As I knew, MySQL supports scale-out https://www.mysql.com/products/cluster/scalability.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial