Thursday, May 10, 2012

Innovator-C: Approaching 400 Days of Up Time

IBM Informix Dynamic Server Version 11.70.FC2IE -- On-Line (Prim) -- Up 398 days 01:11:10 -- 2084080 Kbytes

Put into production over a year ago in April 2011, Innovator-C has just been cruising along with no problems and no signs of slowing down.

Just a single socket, quad core Intel machine with 2GB allocated to Informix and a couple of internal drives mirrored RAID1 using cooked chunks, Innovator-C is able to handle an average of 700,000 new session requests, 4 million commits, 900K rollbacks and 3.5 billion ISAM calls per day. This is just what our production load throws at it, I don't know what the actual limits are. Judging from CPU usage and current response times, Innovator-C running on this lower end hardware can handle much more.

Makes me question why someone would choose a different free or low cost engine for smaller installations, especially considering there is a well defined upgrade path to Growth and Ultimate as your need for speed increases. It definitely can't be because of technical reasons. Most likely they don't even know Innovator-C is a free for production option. Heck, there were people at IIUG2012 that didn't know Innovator-C was a free for production option and these are the Informix Fanatics!

You might have noticed the On-Line (Prim) in my 'onstat -' above, Innovator-C comes complete with full HDR Primary/Secondary support so even the smallest of systems can have enterprise class redundancy, even though I haven't had a need for it since the engine is so stable.

May 14, 2012 Update:

IBM Informix Dynamic Server Version 11.70.FC2IE -- On-Line (Prim) -- Up 402 days 00:41:51 -- 2084080 Kbytes

Made it past the 400 day mark during Mother's Day weekend, our busiest time of the year. Of course, Informix handled the 2x spike in volume without any problems. Yawn.