Linked by Eugenia Loli on Wed 15th Mar 2006 16:35 UTC
Databases "Within the past two years, Oracle, IBM and Microsoft have all released freely available versions of their flagship database servers, a move that would have been unheard of just a few years ago. While their respective representatives would argue the move was made in order to better accommodate the needs of all users, it's fairly clear that continued pressure from open source alternatives such as MySQL and PostgreSQL have caused these database juggernauts to rethink their strategies within this increasingly competitive market."
Thread beginning with comment 104746
To view parent comment, click here.
To read all comments associated with this story, please click here.
Joe User
Member since:
2005-06-29

a database approaching 1 Terabyte

Wow, can I ask you what kind of data you have in this DB? What kind of company?

Reply Parent Score: 1

Don T. Bothers Member since:
2006-03-15

It is an ERP database system. With only 200 users, the database already grows about 60 gigabytes per year. We plan to increase the number of employees, increase the number of transacations created per employee, and increase data-mining, analysis, and logging. This is our enterprise core database and it will need high availability and scalability. It will be an enterprise system. We will deploy a redundant fiber SAN, with either EMC or NetApp Storage Arrays. We will most likely deploy a RHEL (AMD64 -> Itanium or Power) solution or Solaris (AMD64 -> Sparc) solution since both provide a path to grow. Although these solutions are pricey, they are actually dwarfed by the cost of Oracle, DB2, or Sybase, especially as we start scaling more and more.

Reply Parent Score: 1

Joe User Member since:
2005-06-29

I suggest first a pretty good server such as you quad-Xeon or the like, with more RAM than the size of your DB. Then, install a few SCSI disks in RAID-5 or sthg, S.O. could be either RHEL or FreeBSD 6. And PostgreSQL has tablespace so you can distribute your data to several different RAID arrays. Then, maybe a small cluster or load balancing will be necessary.

Reply Parent Score: 1

dkkopp Member since:
2006-03-16

It sounds like one of those new Sun coolthreads machines might be right up your alley. Plus, you can get them to send you one for a free 60 day trial.

Reply Parent Score: 1