seprate server for webserver email and database

Portal Home > Knowledgebase > Articles Database > seprate server for webserver email and database

Posted by mixmox, 05-08-2015, 01:28 PM
Hey check this config: server 1 to 14 : centos server 15: centos and SSD website content like php and also DNS server will host on server 1 mysql on server 15 as well server 10 - 14 are for storing backup how can i configure that mysql load from server 15, (mysql 5.6 has installed on server 15)
Posted by Srv24x7, 05-09-2015, 11:08 AM
Hi, Do you use any hosting control panel? You can configure remote MySQL and then use it. This way DB server is completely isolated. Do you have private network between the servers? connection could be even faster...
Posted by mixmox, 05-09-2015, 01:06 PM
no just using centos + mysql and nginx package i havent install any panel, we dot need at all
Posted by Srv24x7, 05-10-2015, 11:12 AM
Hi, Then its pretty easy on a plain server. Create a DB server and user the DB server IP in the configuration on the webserver.
Posted by mixmox, 05-11-2015, 09:58 AM
mm how i have separate server for css and php file ?
Posted by peet, 05-11-2015, 12:53 PM
Hi, You just needs to update the php database configuration to point to server 15 and add a user in server for the web server which is going to connect from. Also as others suggested, you have to use private n/w than over internet to connect to your database which will very much decide your application response time. And its not required to open up your database to public if you have a private n/w. All the best. Peet
Posted by Syslint, 05-11-2015, 01:11 PM
It will be good to use a private lan within this cluster and use the private lan ip for configuring mysql. You can give access to the central mysql server using the "Grant all privilege" querry .