Question

Best setup for large vBulletin forum?

Posted February 25, 2015 3.5k 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!

Add a comment
compactabt
By:
compactabt
Add a comment
2 comments
  • ryanpq February 25, 2015
    Reply Report

    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.

  • compactabt March 1, 2015
    Reply Report

    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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

2 answers
ryanpq June 9, 2016

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

Reply Report
siving000 January 2, 2020

Hello everyone today I come here just wanna share something about supporter digitalocean they didn’t work on my complain about someone he hosts website on digital ocean. but the website copied contents from a lot of websites include my website too. I sent report to Report Abuse and Contact support but one one reply me. I feel so bad with this service.

Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help