Database Forum / Informix Topics / April 2008
Hardware Recommendation
|
|
Thread rating:  |
sdhaya - 20 Apr 2008 06:03 GMT We are currently running our Credit Card Authorization host in a Intel based Dell 6600 platform, SCO Unix 5.0.6 with Informix 7.3x. We have been advised by the vendor to upgrade to Linux , Informix 10.x, Intel platform (32bit). Could you please share your thoughts on the best available intel platforms supporting linux/Informix 10.x.
Currently the application and Database are running on one server. We have also been recommended to split the application & Database into two servers. ( We retain the application on a Intel/Linux/ platform and move the database to Non Intel based platform with latest informix ).
Dhaya CB
Obnoxio The Clown - 20 Apr 2008 09:06 GMT sdhaya said:
> We are currently running our Credit Card Authorization host in a Intel > based Dell 6600 platform, SCO Unix 5.0.6 with Informix 7.3x. We have [quoted text clipped - 7 lines] > and move the database to Non Intel based platform with latest > informix ). It's really hard to make a useful comment given so little information about your application environment. To be able to say something useful, we'd need to know things like:
1. How many transactions you do per day and how many users you have? 2. What is your application written in? 3. How complex the transactions are? 4. What kind of performance problems you're having?
I've seen people upgrade their hardware when simply adding an index would have cured their performance problems.
 Signature Bye now, Obnoxio
"There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."
Harry Skelton - 20 Apr 2008 16:48 GMT > platform (32bit). Could you please share your thoughts on the best > available intel platforms supporting linux/Informix 10.x. I would suggest you go to the various Linux sites, the ones with the distributions, and look at their hardware compatibility list.
Dell does sell Linux certified machines. The only problem with running a Dell is the hardware tends to be proprietary. You may want to look at an HP or Linux specific hardware vendor. Like www.emperorlinux.com - although I have not looked at their web site, just something I searched for on the web.
I would also check with the folks at Informix to find what platform would make your database fly. They may only support one or two versions of Linux. No point of getting Ubuntu Heron (my favorite at the moment) when Informix may or may not run on it.
> Currently the application and Database are running on one server. We > have also been recommended to split the application & Database into > two servers. ( We retain the application on a Intel/Linux/ platform > and move the database to Non Intel based platform with latest > informix ). I say have one server with a NAS (network attached storage) device for backups. You could have a transaction by transaction backup to the NAS so you can replay the transactions should the server fail. This is something that requires a bit more forethought as a database administrator to determine both need, and costs involved.
If you get more than one "server", use one as a workstation/backup machine. You get the use out of the machine without it being an energy sucking doorstop. I replaced all the PC's in one site with server class machines, nice graphics cards, maxed out on memory, and then backed up the main server to the other backup servers on a daily basis. (One machine called Monday, the other Tuesday, et al.)
But I highly suggest that you review what Informix and your application will need before selecting the hardware. Sometimes you get limited on your hardware options by the software you are using.
On the hardware - get the maximum amount of memory you can get on the machine, get the best video card you can get (A stable release - doesn't have to be a $800 card), and get fast hard drives. Speed is more important than space when it comes to databases.
Then have your Linux vendor tweak the disk cache to use a gig or so of memory. Unless Informix (like Oracle) wants to play GOD and do its own memory management. If so, give it a GIG for cache....provided you loaded 4GIG in a machine.
Also, run a network with bandwidth in the Gigabytes. You may want to add more cards and run load balancing to speed up the transactions to the database.
...just my thoughts....
Ian Michael Gumby - 21 Apr 2008 01:56 GMT That's silly. First you certify to a kernel not a distro. Second. Dell hardware "proprietary" ? LOL...
> Date: Sun, 20 Apr 2008 11:48:34 -0400> From: skelton.harry@gmail.com> Subject: Re: Hardware Recommendation> To: informix-list@iiug.org> > sdhaya wrote:> > platform (32bit). Could you please share your thoughts on the best> > available intel platforms supporting linux/Informix 10.x.> > I would suggest you go to the various Linux sites, the ones with the > distributions, and look at their hardware compatibility list.> > Dell does sell Linux certified machines. The only problem with running > a Dell is the hardware tends to be proprietary. You may want to look at > an HP or Linux specific hardware vendor. Like www.emperorlinux.com - > although I have not looked at their web site, just something I searched > for on the web.> > I would also check with the folks at Informix to find what platform > would make your database fly. They may only support one or two versions > of Linux. No point of getting Ubuntu Heron (my favorite at the moment) > when Informix may or may not run on it.> > > Currently the application and Database are running on one server. We> > have also been recommended to split the application & Database into> > two servers. ( We retain the application on a Intel/Linux/ platform> > and move the database to Non Intel based platform with latest> > informix ).> > I say have one server with a NAS (network attached storage) device for > backups. You could have a transaction by transaction backup to the NAS > so you can replay the transactions should the server fail. This is > something that requires a bit more forethought as a database > administrator to determine both need, and costs involved.> > If you get more than one "server", use one as a workstation/backup > machine. You get the use out of the machine without it being an energy > sucking doorstop. I replaced all the PC's in one site with server class > machines, nice graphics cards, maxed out on memory, and then backed up > the main server to the other backup servers on a daily basis. (One > machine called Monday, the other Tuesday, et al.)> > But I highly suggest that you review what Informix and your application > will need before selecting the hardware. Sometimes you get limited on > your hardware options by the software you are using.> > On the hardware - get the maximum amount of memory you can get on the > machine, get the best video card you can get (A stable release - doesn't > have to be a $800 card), and get fast hard drives. Speed is more > important than space when it comes to databases.> > Then have your Linux vendor tweak the disk cache to use a gig or so of > memory. Unless Informix (like Oracle) wants to play GOD and do its own > memory management. If so, give it a GIG for cache....provided you > loaded 4GIG in a machine.> > Also, run a network with bandwidth in the Gigabytes. You may want to > add more cards and run load balancing to speed up the transactions to > the database.> > ...just my thoughts....> _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Use video conversation to talk face-to-face with Windows Live Messenger. http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Ref resh_messenger_video_042008
Neil Truby - 21 Apr 2008 03:16 GMT That's silly.
>> First you certify to a kernel not a distro. >> Second. Dell hardware "proprietary" ?
>> LOL... Not for Informix it seems. From http://www-306.ibm.com/software/data/informix/linux/ "The Linux distributions supported by IBM Informix products are listed in the table for each product. (Select the desired product tab at the top of this page.) Only the Linux distributions listed in the following product tables are supported. If you are running an IBM Informix product on a Linux distribution not listed here, it is not a supported environment ..."
Ian Michael Gumby - 21 Apr 2008 22:21 GMT > That's silly. > [quoted text clipped - 10 lines] > supported. If you are running an IBM Informix product on a Linux > distribution not listed here, it is not a supported environment ..." Ok, IBM has to certify that the product runs and that they support it. For example, Suse Enterprise Linux isn't the same as OpenSuse. (It is and it isn't.) But you can run IDS on OpenSuSE.
Going back to the original poster, I'd recommend vanilla hardware purchased off the shelf than custom built. You don't need a SAN if you have a 2U or 3U high box, you can put a RAID controller w a hot swap- able SAS backplane. Then run your RAID 10. configuration. You can buy a box from SuperMicro, Intel white box, IBM etc all read to do this. You don't need to go to a blade server.
Then run Enterprise SuSE (Why? Because the OS has support and its a supported OS for IDS.)
But hey! what do I know? I just build my hardware, load OpenSuSE, load IDS and pray that it works ... ;-)
Neil Truby - 22 Apr 2008 00:29 GMT >> That's silly. >> [quoted text clipped - 28 lines] > But hey! what do I know? I just build my hardware, load OpenSuSE, load > IDS and pray that it works ... ;-) I'm sure it'll work with most distros. But the point is that if you're a serious user you'll want a version that's supported. The last thing you'll want in an urgent support situation is having to argue with an eningeer who's telling you that your configuration is not supported.
If, however, you're just loading IDS up to run a kitchen inventory system at home you might take the risk ... ;-)
Ian Michael Gumby - 22 Apr 2008 14:07 GMT Neil, Well yeah... Original OP running 7.3 on SCO. What does that tell you? It tells me that the application isn't too complex or has a high load factor by today's standards. So you look at a simple dual core or quad core 2U high box w a hot swappable backplace to support either SAS or SATA disks and RAID 10. If this is an OLTP box, go with 2.5" SAS. In this configuration, you can buy off the shelf hardware from HP, IBM, DELL, SuperMicro and even Sun. Configure it with 2GB of memory per core. Then for OS, look at EnterpriseSuSE from Novell if you want Linux. (Sorry, I never really got in to redhat.) And you're done. No muss no fuss. You want to save a few quid, you can even go vanilla Intel boxes with 2 GB ethernet ports, video on the MB and then you just need a really good raid card. If you go with an Antec chassis you can fit the hot swapable raid SAS backplane in the front space where they have a couple of fans. Or if you're pinching pennies, go with a lease of an X-series from IBM. You'll still be paying it off when the hardware is old, but its cheaper on up front costs. The point was that you don't need to go the SAN route and your hardware isn't proprietary. Also I don't believe that the SAN is made by Dell, but that they OEM it. (But I could be wrong.) -G _________________________________________________________________ Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498 &ocid=T067MSN40A0701A
Mark Jamison - 21 Apr 2008 03:14 GMT Err Gumby, I take it you haven't messed with DELL's SAN solution? Or their idea of blade centers? Both most certainly have proprietary elements. Now if all you are doing is buying an Inspiron, or somehting else, then sure they have nearly nothing that is proprietary.
----- Original Message ---- From: Ian Michael Gumby <im_gumby@hotmail.com> To: Harry Skelton <skelton.harry@gmail.com>; informix-list@iiug.org Sent: Sunday, April 20, 2008 7:56:10 PM Subject: RE: Hardware Recommendation
That's silly. First you certify to a kernel not a distro. Second. Dell hardware "proprietary" ? LOL...
> Date: Sun, 20 Apr 2008 11:48:34 -0400 > From: skelton.harry@gmail.com [quoted text clipped - 61 lines] > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list ________________________________ Use video conversation to talk face-to-face with Windows Live Messenger. Get started!
|
|
|