What is the best option: MongoDB or MySQL for the following use-case?
Hello Everyone,
I hope you all doing well.
We are working on a project combination of E Commerce + Social. so its basically Social business community where people can socialize like facebook, twitter, etc and can open store like multivendor options for example Alibaba.com amazon.com etc, and people sale their home items like classified products. here we have included all the categories for for sale and purchase. here 3rd party companies will also work as a partner for their business sale , purchase and advertisement. we will have our own Blog and Forum discussion pages within this platform.
We are working on MEAN technology, but I come to know that there are some limitations in MongoDB or have crash problems like financial transaction work. I have read old comments and reviews on mongodb regarding this issue, I want to know whats the current situation regarding these issues? which one is the best option according to above requirements. MongoDB or MySQL?
Many thanks in advance for your answers.
regards
Faisal