Zero3X Posted December 27, 2011 Share Posted December 27, 2011 Say I have a script on server A which connects to a database and performs (for example) 10 queries a minute. If this database was stored on server B would server A benefit? Would the RAM or bandwidth use of server A be reduced? Quote Link to comment https://forums.phpfreaks.com/topic/253902-benefits-of-having-mysql-on-a-remote-server/ Share on other sites More sharing options...
The Little Guy Posted December 27, 2011 Share Posted December 27, 2011 Apache is on server A, and MySQL is on server B, they now have the ability to take a higher load. if MySQL is bogging down server B, it won't affect Apache on server A, unless you have a script trying to talk to MySQL on server B. Lets say you are running a intensive script that is using 90+% CPU server B will/may become very slow and almost unresponsive. If this happens and Apache is on the same server, it will have a harder time trying to answer incoming requests. By splitting the two up, Apache can respond almost instantly in the same situation. But if your web script that is running from Apache (server A) needs to talk to MySQL (server B) it will slow down. Quote Link to comment https://forums.phpfreaks.com/topic/253902-benefits-of-having-mysql-on-a-remote-server/#findComment-1301657 Share on other sites More sharing options...
ManiacDan Posted December 27, 2011 Share Posted December 27, 2011 The only reason do split into two servers is to alleviate load problems (or for some very obscure security reasons). If you don't have any load problems (which you shouldn't at 1 query every 6 seconds) then you don't need to split them. Splitting unnecessarily will actually hurt, since you'll be increasing your page load times waiting for DB connections across the network. Quote Link to comment https://forums.phpfreaks.com/topic/253902-benefits-of-having-mysql-on-a-remote-server/#findComment-1301664 Share on other sites More sharing options...
fenway Posted December 29, 2011 Share Posted December 29, 2011 Depends how 'remote' it is. Quote Link to comment https://forums.phpfreaks.com/topic/253902-benefits-of-having-mysql-on-a-remote-server/#findComment-1302191 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.