Looking for advice on Production / Test environment droplets

July 3, 2015 383 views
Deployment Server Optimization Ubuntu

I currently have my Production website in the $20 droplet, with my production MySQL database hosted in Amazon RDS. For performance reasons, I'd like to consider moving my database over to DigitalOcean. I'd also like to set up an isolated testing environment here. I'm wanting some advice on the recommended approach.

Here are some of the options I'm considering.
Option 1:
Prod Webserver and Prod DB - $20 droplet
Test Webserver and Test DB - $10 droplet

Or, is the recommended approach to run the Prod webserver and DB in separate droplets?

Option 2:
Prod Webserver - $10 droplet
Prod DB - $10 droplet
Test Webserver and Test DB - $10 droplet

Any other ideas or advice would be greatly appreciated.

1 Answer

I think it various a lot on your traffic levels and what you have running and the kind of load issues it's causing. So it's very hard to say. You could do Production and then Test, 2 droplets, and if resource usage becomes high later, move the DB to another droplet. Bonus points for doing it automatically through the API.

Another thing, I have not done so myself yet to test the performance, but if running on Amazon was giving you performance issues, make sure you pick a region that supports local networking. That way, if/when you split the DB out to another droplet, have it pair up with the primary droplet through local networking and you should see a noticeable increase in performance.

Have another answer? Share your knowledge.