I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a larger VPS.
I have two options:
I can upgrade the current VPS doubling it's memory.
I can keep the current VPS, add a second same sized VPS, and move MariaDB to it.
The additional costs for either option would be the same. As a rule of thumb which solution is likely to provide overall better performance and stability?
I don't think the possible duplicate is in fact duplicate. That question in very broad and is more about general solutions for capacity planning. What I'm trying to understand is the relative merits of two possible solutions and how to better evaluate between them. The specify capacity issue (memory shortage) is mostly ancillary to my question.