woolyg Posted July 3, 2008 Share Posted July 3, 2008 Hi, I'm completely new to this, so please excuse any silliness - I'm starting to look into hosting my site on a dedicated network and have a couple of questions, so if anyone can help that would be great. 1. Is it possible to run a MySQL box, separate from the web server, to handle query processing? 2. If so, is there any noticeable lag in display/performance for the person viewing the site, internal network issues aside? 3. Would this kind of setup cause security issues? 4. Could this be done using 2 windows boxes? Thanks, WoolyG Link to comment https://forums.phpfreaks.com/topic/113158-mysql-box-separate-from-web-server/ Share on other sites More sharing options...
fenway Posted July 4, 2008 Share Posted July 4, 2008 1. Yes, and it's often a good idea, since webservers and databases have opposite load requirements. 2. Assuming the box isn't too far away and is equally reliable, no. 3. It shouldn't. 4. I suppose. Link to comment https://forums.phpfreaks.com/topic/113158-mysql-box-separate-from-web-server/#findComment-581451 Share on other sites More sharing options...
woolyg Posted July 4, 2008 Author Share Posted July 4, 2008 Thanks Fenway. Link to comment https://forums.phpfreaks.com/topic/113158-mysql-box-separate-from-web-server/#findComment-581454 Share on other sites More sharing options...
mwasif Posted July 6, 2008 Share Posted July 6, 2008 It is better to have skip-name-resolve in MySQL configuration file when running webserver and MySQL server on separate machines. Link to comment https://forums.phpfreaks.com/topic/113158-mysql-box-separate-from-web-server/#findComment-582743 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.