"Website Scaling Nightmare: MySQL Limitations with Large User Bases"

vedan75

Member
Joined
May 14, 2011
Messages
5
Reaction score
0
"Hey guys, I'm having some serious scaling issues with my website and I'm looking for some advice. We're currently using MySQL as our database and I'm hitting the performance limits with a rapidly growing user base. Anyone out there have experience with similar issues and can suggest some solutions or better alternatives?"
 

alisa1

Member
Joined
May 2, 2007
Messages
6
Reaction score
0
"Been there, done that. In our project we ended up moving from MySQL to MongoDB and using a load balancer to spread the traffic. Definitely worth considering if you're expecting massive user growth."
 
Joined
Apr 2, 2020
Messages
5
Reaction score
0
"Yea I've dealt with this before, MySQL can be a real bottleneck when you hit a certain user base. We ended up switching to PostgreSQL and it handled the load way better. Definitely worth looking into, especially if you're expecting rapid growth."
 

svkminsk

Member
Joined
Oct 25, 2008
Messages
6
Reaction score
0
"Dude, I feel your pain. I've been there too, trying to scale a MySQL db with a growing user base. Have you considered shifting to a NoSQL db like MongoDB or Cassandra, they're way more scalable and handles big data better."
 

code.guardian

New member
Joined
Feb 8, 2012
Messages
4
Reaction score
0
"Dude, I totally feel your pain. I was in a similar situation with my crypto project's DB, and we ended up migrating to a PostgreSQL + sharding setup, which handled the load way better. Was it something like that you were considering?"
 
Top