medya.gh
By:
medya.gh

moving my phpBB site to digitalocean and scaling it out !

June 19, 2014 1.9k views
Hi I have a vps on another company, I have a phpBB forum on it, it goes down frequently because of the load on the server, I am thinking about moving my site to digital ocean, I would like to know what is the best practice to scale it out ? do I need a loadbalancer ? or do you recommend having the mysql server on a seprate server than the php server ? and should I still use apache or ngnix ?
1 Answer

There are a lot of ways you can take this, and a lot depends on the kind of traffic that you expect to receive. What are the specs on the VPS you'll be migrating from?

I'm partial to Nginx, but there's no reason not to use Apache if you are more comfortable with it. While Nginx does use slightly less resources, Apache is probably not your real problem. It's much more likely to be MySql.

The first thing is to make sure you are on a server with enough RAM. For example, running an entire website on a 1GB droplet will very likely be more performant than running the front end on a 512MB droplet and the database on a separate 512MB droplet, especially if the problem is MySql's memory usage.

Once you get to a larger scale, running the database on a separate server may begin to make sense. Check out this article:

https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql

It uses Wordpress as an example, but will mostly apply to phpBB as well.

Let us know how it goes, and feel free to ask questions if you hit on a specific problem.

by Justin Ellingwood
When your site begins to get more visitors, you may have to think about how to handle the additional traffic. One easy way of doing this is to separate your database operations from your web server so that each can handle its own load. In this guide, we'll demonstrate how to do this for a WordPress site built on Nginx by configuring a remote MySQL database.
Have another answer? Share your knowledge.