Report this

What is the reason for this report?

Should I put my MySQL database on a separate server?

Posted on November 13, 2014

Hi. I currently use a droplet with 2GB of RAM running Ubuntu. It runs fine, but of course MySQL consumes all the RAM it can find. Apache is set to run 12 threads at about 90MB each.

Would it make sense to rather put the DB on a separate droplet in the same datacenter and reduce the size of the web server droplet to 1GB?

Hugh



This textbox defaults to using Markdown to format your 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.

install swap on the droplet and you should be good to go

you should not need a separate droplet just for mysql

OK, here is what I have at the moment.

Since separating the DB and Apache onto two separate droplets, my web server has become a happy chappie. it seldom swaps now, and just runs smooth as silk.

I have added a few virtual hosts to apache since then, the traffic load has increased heaps, and still it runs beautifully.

The DB server hardly ever breaks a sweat.

Love it!

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.