Best setup for large vBulletin forum?

February 25, 2015 1.8k views

I'm hoping to move a fairly large (3m+ posts) vBulletin installation to a DigitalOcean droplet, and while I've managed to get everything functioning there are two elements (viewing a thread, and posting a message) that are incredibly slow, cause up to 100% CPU usage and see MYSQL running at over 200%. This would happen when attempting to view as few as six or seven threads simultaneously.

Viewing any other sort of page is incredibly speedy.

I've tried it on a 2gb droplet with DigitalOcean's LAMP bundle; I tried increasing the size to see if that would help, but it made no difference.

The forum's database is several GB in size.

Is there anything obvious that I should or shouldn't be doing - or is there a different droplet setup that I should explore?

Thanks in advance!

2 comments
  • With a database of that size, I would recommend setting up your MySQL service on a separate droplet from your web server(s). Additionally depending on the traffic you expect you may want to look into setting up a reverse proxy service like CloudFlare which provides caching and can reduce the load on your web services.

  • Thanks for this the other day Ryan - I'm decided to convert the forum to Xenforo which doesn't have that problem, but I'll definitely look into your suggestions anyway as the database remains a similar size.

1 Answer

This question was answered by @ryanpq:

With a database of that size, I would recommend setting up your MySQL service on a separate droplet from your web server(s). Additionally depending on the traffic you expect you may want to look into setting up a reverse proxy service like CloudFlare which provides caching and can reduce the load on your web services.

View the original comment

Have another answer? Share your knowledge.