Question
Should I put my MySQL database on a separate server?
- Posted on November 13, 2014
Asked by varange
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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!
install swap on the droplet and you should be good to go
you should not need a separate droplet just for mysql