I have a fair amount of data to work with. Right now in production we are using Apache as our web servers. You are correct that we are not clustering currently in production. Those servers are still running CFMX7 Standard single instance installs. Each of our 4 load-balanced production web servers have Apache and ColdFusion installed on them. Each CF request to Apache is handled by the instance of CF on that box. Using SeeFusion database logging and a collection of Excel reports based off of aggregated data I compile nightly I can keep track of: * The number of request each server processes in a day * The number of database calls from each server in a day * The average page load time per server * The number of requests per company (About 9 separate "sub companies" around the country use the site right now.) * The average number of active requests on a given server throughout the day * The memory usage on a given serer throughout the day * The longest running requests, and how long they took, and how much processing time was query related.
Over the month I compile trending reports of company usage, load balancer distribution, and average page time. I can see what percentage of traffic on each server comes from what company. I can also look at each company and see which servers process what percentage of their traffic. Being a title company, we start the month slow and our traffic builds to climax in the middle of the last week of the month. As far as load-balancer distribution, there is usually one server which will be processing over 50% of all page hits. Another server will be serving up around 10% of all pages. Generally the average request time will be a bit higher for the busiest server. When I look at month-long trends the pattern will flip randomly throughout the month so another server is "on top". Right now if I look at all the page requests that happened today so far I can see that I already have a lopsided number of unique IP address "stuck" to Web 9 as follows: Web 14: 104 unique users Web 1: 98 unique users Web 10: 94 unique users Web 9: 55 unique users Why does one of my servers only have half the users stuck to it than the rest of my servers? If I look at the number of pages requested from each unique user, I have people who have requested anywhere from 1 page to 800 pages today but over all there are no gaps or jumps in the those numbers-- there is a pretty even spread. So basically I have numbers coming out my ears, but nothing that would necessarily point out why one server will have so many users/traffic, and another server will only have half the usage. There is another complication which may or may not play in to this. Some of our remote offices connect to our WAN through some sort of tunnel which makes all of their HTTP requests come from the same IP. I don't know if our load balancer does sticky sessions solely on IP, or takes other info into account. ~Brad -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 11:27 AM To: CF-Talk Subject: Re: Targetting an instance Brad Wood wrote: > What's frustrating to me about this stuff is everyone around my company > wants to ditch the hardware load balancers. Basically we have had > ongoing load distribution problems which I blame on two main things: > 1) Using sticky connections on an internal app with too few users to > "average out" over time > 2) Poorly implemented load balancer configuration that doesn't make use > of any app-aware features. Basically pure RR. How much of this can you prove? EG, can you get a list of requests from your IIS logs, see to which instance they go (you aren't clustered in production yet, are you?) and how long they take? You might be able to see some pattern in the data if you split it based on for instance the user that did the request, the template they requested etc. And if you don't see a pattern, how should the LB see the pattern? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
