The Wrecking Bawl
Destructuring query language, one keyword at a time.
Site Sections
Home
Contact
Syndication
Login
Posts
120
Comments
117
Trackbacks
22
<< so long Max
|
Home
|
a couple great quotes >>
how do you handle huge databases?
I'm used to working with SQL Server databases that are somewhat small (10 GB or less, usually a lot less), so I'm curious how people deal with huge databases, like those that hold Amazon's transactions or whatever. Do you have to have the latest and greatest hardware running with clustered servers? Do you have to do a lot of database partitioning? How do you handle upgrades? Do you do then in the middle of the night so that you can take the db down briefly?
posted on Wednesday, August 22, 2007 4:55 AM
Print
Comments
#
re: how do you handle huge databases?
Nestor
8/22/2007 6:02 AM
Normally these are done with clustered servers for hardware to due with redundancy, sans for storage planning, clustered databases and load balancers for performances and partitioning for housekeeping. There're normally failovers as well to ensure 0 downtime.
Post Comment
Title
*
Name
*
Email
Url
Comment
*
Remember Me?
Enter the code shown above
Archives
November, 2009 (1)
July, 2009 (1)
June, 2009 (1)
April, 2009 (3)
March, 2009 (1)
February, 2009 (2)
August, 2008 (2)
June, 2008 (1)
May, 2008 (1)
April, 2008 (4)
February, 2008 (3)
January, 2008 (1)
December, 2007 (1)
November, 2007 (1)
October, 2007 (2)
September, 2007 (2)
August, 2007 (3)
July, 2007 (2)
June, 2007 (7)
May, 2007 (6)
April, 2007 (5)
March, 2007 (18)
February, 2007 (22)
January, 2007 (18)
December, 2006 (12)
Post Categories
all tech stuff
all the other stuff
C#
SQL Server
general .Net stuff
News
Copyright © 2005 Alex Bransky
This work is licensed under a
Creative Commons License