Question
Should I put my MySQL database on a separate server?
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
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.
×
Here’s are two of the Wordpress sites on that server
Hugh
This is a great question. If you end up doing this, could you post your results for posterity?
My guess is that it depends on how much traffic your site gets. If your site(s) are low-traffic, it probably would not make one bit of difference, while high-traffic sites would really benefit…but that is all speculation.
It would be great to hear about your experience.
It’s been over a year I know but seeing that you had Wordpress at the time and having 12 apache threads at 90MB makes me think you did not have PHP-FPM enabled. I’m no expert but for what I’ve read it should help by reducing the apache threads size. Did you have PHP-FPM implemented? If not, have you tried it?