Best setup for large vBulletin forum?
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!
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.