Question

Consider the following problem domain. What sort of data store (mongodb vs an enterprise grade sql database like mysql) should you use and why?

Your domain: You are building a web based user interface to allow people to play fantasy sports team games. Your data store (mongo or mysql) will store all of the data needed for your fantasty sports league of choice (clearly you need to specify your sport since competitive table tennis [a thing in other parts of the world] may well have different answers than American Football)

Answer 1

Since in order to power the interface, you would have to store all the data needed for your fantasty sports league of a user's choice (depending on the type of sport), the data can grow huge with time and increasing user base. Hence, with time passing and increasing data size, it will be difficult to give the same user experience as before with MySQL the reason being MySQL is difficult to scale horizontally. Whereas MongoDB supports distributed db, sharding, etc to give better latency and throughput with increasing data.