right database for the right job

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

right database for the right job

Post by malcolmboston »

I am used to using MySQL but i am currently developing a large scale auction site that will ned to be highly scalable and very fast.

Does anyone have any suggestions as to whether or not i shuold switch over to another database and if so, which one.

Thanks
Mal
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post by infolock »

if you are willing to pay for it, MS-SQL is probably the best sql db out there.. although Oracle has quite a nifty security setup as well... are you looking for an open-source/free distribution or licensed version? it could vary depending on how much you are willing to spend(if any) and what kind of security you are wanting
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

i am looking for suggestions on both open-source and paid database systems.

It will need to be fast, that is the most important thing.

Isn't PostgreSQL good for this?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

the database used is only part of the speed though...

having a dedicated server or cluster for strictly database handling of the actual auction stuff (leaving logging in and other administrative junk to a seperate server) is equally important, if not more so. Gobs of RAM, CPU power, and ultra fast HD's (in RAID5 or higher) are also extremely important.

the RAID arrays should probably be in their own systems. The way a company I worked with used to do it is basically have a load balancing system spread out the queries onto the individual database servers, which would call their own (or slightly shared) RAID 48 or something system. Basically the company had RAID5 in RAID5 configurations, quite possibly with mirroring. The system was EXTREMELY fault tolerant. We could take down something like 3 of the RAID5 servers before the system would start to have "problems" ...
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

lol, sounds expensive.
Hpow much would a syste like this cost?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

each server was $15K .. quad processor, 4GB of RAM (back then mind you), 20 HD bays or something.. crazy stuff..

today, the frontend would probably be blade servers. As for the RAIDs themselves... I can't remember who's systems we used.
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

do any hosting companies offer anything like this?
and how much pm
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

not sure about today, but back then no.

I'd bet IBM does today.

Personally, for datacenters and things.. I only trust IBM and Dell.
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post by hedge »

infolock wrote:if you are willing to pay for it, MS-SQL is probably the best sql db out there.. although Oracle has quite a nifty security setup as well... are you looking for an open-source/free distribution or licensed version? it could vary depending on how much you are willing to spend(if any) and what kind of security you are wanting
You must be joking to rank ms-sql above Oracle. Oracle is in it's own category, it is clearly superior in performance, scaleability and functionality... it's downfall is price.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

forgot SGI too.. if you can afford it :D
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

obviously im gonna wait to see hopw the site pans out, but im thinking in terms of ebays success i will need a much much faster server.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Have a look at postgreSQL, malcomboston. It has triggers, stored procedures etc. Very fast, open source and a very mature product. PostgreSQL and Firebird are probably as close as you can get to Oracle-like functions with open source databases.

MySQL is still slowly introducing those more advanced features - it simply can't compare to Oracle, not in scope, functionality, adminstration etc.
ldomingues
Forum Commoner
Posts: 41
Joined: Fri Aug 06, 2004 1:15 pm
Location: Portugal

Post by ldomingues »

MySQL using MyISAM Tables can be as fast as Oracle (although Oracle has MUCH more features).

Sybase ASE for Linux is free (with some limitations such as 2 Gb database, etc.) - not as fast as Oracle, but very stable. You can buy support for a modest fee.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post by fractalvibes »

IBM's DB2 is an enterprise-class DBMS. Version 8.2 (Stinger) is the newest version. Like Oracle, not for the casual
user...very very full-featured. Not Cheap either.

fv
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post by infolock »

hedge wrote:
infolock wrote:if you are willing to pay for it, MS-SQL is probably the best sql db out there.. although Oracle has quite a nifty security setup as well... are you looking for an open-source/free distribution or licensed version? it could vary depending on how much you are willing to spend(if any) and what kind of security you are wanting
You must be joking to rank ms-sql above Oracle. Oracle is in it's own category, it is clearly superior in performance, scaleability and functionality... it's downfall is price.

not at all.. ms-sql is the fastest and best db out there. i think you are blinded by the saying "if it's the most expensive, it must be the best". do some research on the studies between the 2...
Post Reply