Question

Best setup for large vBulletin forum?

  • Posted February 25, 2015

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!

Subscribe
Share

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.

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.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.

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