I have a web-server running Apache with wsgi (Python) and Mysql database. The server is dual core, with 4GB RAM.
The time has come for a system upgrade, and the new server will be Xeon E3-1230 (Quad core) with 8GB of RAM.
I've been thinking to split the system and run DB on one of them, and the rest on the other.
What are the considerations when deciding whether the new (and stronger) server should run the DB or the Apache (With lot's of python code)?