How to setup separate MySQL and PHP VPS servers
Posted
by
Fazal
on Server Fault
See other posts from Server Fault
or by Fazal
Published on 2011-02-05T02:31:39Z
Indexed on
2011/02/05
7:27 UTC
Read the original article
Hit count: 533
Someone recommended I should have my MySQL server separate from my Apache/PHP server in case of hacking and such.
By visiting linode, slicehost and various articles here on serverfault I've managed to cobble together a decent set of instructions on how to do the Apache/PHP bit. I'm using Rackspace VPS and they provide an internal IP for each server.
If I setup a MySQL VPS, should I assume that I would just add the internal IP for the database host? And I guess that I would only need to open up my default ssh port and mysql ports and install phpmyadmin on there?
Ideally I would have webserver.mydomain.com and dbserver.mydomain.com (two 256mb VPS's) with servermin on webserver.mydomain.com and phpmyadmin on dbserver.mydomain.com.
If anyone has any guides or advice on how to setup this type of solution I'd be more then grateful!
© Server Fault or respective owner