Page 1 of 1

Web Server vs MySql Server

PostPosted: Sun Apr 19, 2015 10:34 pm
by chasejordan1
Why is it everyone says the Sql server needs to be the beast of the cluster, but it seems the Web Server is always running at the highest load and has the most activity.

I was running identical Web and Sql servers, and the web server always had the most activity and was using more ram and Cpu usage vs the Sql server?

For me I do have an integrated Avatar program that uses the web form of Vicidial and maybe that is it. But for me it seems I should make my Web Server the beast in comparison to the Sql server.

Thoughts.

Re: Web Server vs MySql Server

PostPosted: Mon Apr 20, 2015 4:38 pm
by mflorell
You can have multiple web servers, but only one master database server.

We have one client using 4 x load balanced apache web servers. You don't have to have a large single web server, in fact it is better to split a large load across multiple web servers because then there is less chance of running out of Linux ports.

Re: Web Server vs MySql Server

PostPosted: Tue Apr 21, 2015 10:05 pm
by chasejordan1
I didn't think of it that way. "linux ports"

Thanks

Re: Web Server vs MySql Server

PostPosted: Tue Apr 21, 2015 10:47 pm
by mflorell
If you ever start to heavily use the Agent API, linux ports will become very important :)

We have seen several large clients have a lot of problems related to running out of available ports on their web servers. This is easily solved by adding another web server.