right database for the right job
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
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
Does anyone have any suggestions as to whether or not i shuold switch over to another database and if so, which one.
Thanks
Mal
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
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
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" ...
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
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
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.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
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
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.
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
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas
hedge wrote: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.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
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...