What are your honest thoughts on scaling with MySQL and NoSQL. Which one can handle 100M queries easily? What are the drawbacks of using each one of them?
What is 100M traffic?
100.000.000 queries per second? Not many come close to that.
100Mb database? Any database can handle that, only amateur hosts makes a database able to less.
I think the answers depends on the kind of queries
Michael Gilley
Frontend Engineer at Zapier
You can scale either. With cloud computing and clusters the number of queries isn't the bottleneck. It's all about how your data is stored to be efficiently queried (indexing), how you're utilizing caching, and what kind of operations are being done in the db server. There's also a concern for how your application is built, optimized, and clustered itself since no db is an island. :)