I want to create an app like Post Affiliate Pro/Refersion/LeadDyno where I help online businesses manage their affiliate program. I'm doing some research and I keep hearing how MongoDB scales better than MySQL and that Laravel's performance is not as good as a framework like Django.
One thing I really love about Laravel is that it has excellent documentation and learning it to build apps is much easier compared to the other frameworks like Django and MERN stack because of the number of resources available.
The downside is I keep hearing Laravel is bad at horizontally scaling when an app gets big, and Post Affiliate Pro (biggest of the three) seems to get several million page views a month. Not that my app will be anywhere even remotely close to that big, but hypothetically speaking, since I'm just choosing the stack to develop my app with and imagining that changing stacks midway would be annoying. Would Laravel be able to handle an app like that? I'd have to keep track of cookies and links by the millions to track which affiliate link is getting commission and tracking analytics for link spamming fraud detection and things like that.
I'm thinking of going with MERN because I can work easily with MongoDB and React.js but I really love the Laravel community because of its vast amount of resources. Do you guys think I can stick with Laravel and create an app like Post Affiliate Pro?
I've heard working with MongoDB with Laravel might not work too well and I will also be sticking with React instead of Vue if I do work with Laravel.
On a side note, I think Post Affiliate Pro runs on PHP because I was reading their release notes and it had something about PHP version compatibility notes in it. So I guess I can create it with Laravel, but my major worry is about the horizontal scalability of the Laravel and MySQL stack.
How many concurrent users and request will there be, is one thing to be concerned about, but PHP can be scaled via load balancing. Just remember MySQL doesn't handle tens of thousands of queries at one time.
Just verify all the specifications of MySQL and make sure it will work for your needs. Otherwise use SQL Server.
Please or to participate in this conversation.