Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

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:  1158
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:  1158
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