Magento Forum

   
Server hardware requirements and distibution of load between Mysql and Apache (PHP)? 
 
Vilpenstylen
Member
 
Total Posts:  54
Joined:  2008-05-29
 

Has anyone been evaluating how the server load is distributed between Mysql and Apache (PHP) in a production environment?

I am am yet to decide if I will go with dedicated servers for both Mysql and Apache or have just one server. If Mysql isn’t eating that much CPU time then it might be a waste of resources?

Does anyone have an estimate on this matter?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Vilpenstylen
Member
 
Total Posts:  54
Joined:  2008-05-29
 

I have done some tests with ab and top, which show that most processing (95%) is done by apache2 processes, but I feel I am not getting very reliable restulta because I lack a realistic database with lots of products and categories. Can anyone check with a busy magento site and top how the load is distributed in a production environment?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Vilpenstylen
Member
 
Total Posts:  54
Joined:  2008-05-29
 

I let Httrack crawl my site with demo data in and I still get the same results: Mysql eats a fraction of CPU time compared to Apache. Can someone else confirm this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1155
Joined:  2008-04-24
 

How many products will you have in your store?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Vilpenstylen
Member
 
Total Posts:  54
Joined:  2008-05-29
 

In the beginning perhaps 50, I am not sure yet, so very few products.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1155
Joined:  2008-04-24
 

Then I would say one server is more than enough. That way you will also avoid the overhead involved with running remote SQL queries, which can be significant.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top