For those of you who have any interest in such things...
This is our Database Server.
Of the pair that run the forums right now, the Database server is doing most of the "Heavy Lifting".
As you can see over the last 6 hours we are cruising along at about
30% of our capacity.
Over a 24 hour period you can see the normal rise and fall of the load as members sign in and out over the day.
This last image is the IMPORTANT ONE.
This shows what this ELASTICITY we have been talking about looks like in real time.
This is the Forum server
This graph shows
THREE different servers.
One the far left was the first server we loaded up and started.
We ran that one for 2 days to establish a baseline of performance.
We were burning about 45% of capacity with occasional spikes to 100%
Then we flipped the switch for the first time and brought on a bigger server and you can clearly see where the third cluster of spikes only reaches to about 65% and the small spikes before it contracted.
Then following that third spike, we brought on an even BIGGER server and took the spikes from 65% down to 35%, and really hammered the normal load down to about 10%.
And that is what we plan on doing as we roll into the fall.
As the daily load on SnoWest begins to climb this Fall & Winter, we are now able to adjust our server configurations in REAL TIME (about 2 minutes) to double or quadruple our processing power !
Gone are the days of SLOWEST.:face-icon-small-hap:face-icon-small-hap