Re:Scalable SQL: How do large-scale sites and applications r...
by zwischenzug on Friday April 22, 2011 @05:01PM
(#2475427)
Actually, the db we use had similar problems. Schema changes require at least _some_ downtime, if only to lock the tables. The trouble is less the number of transactions than the linkage between each transaction and other transactions' liabilities in the system. In effect, serious DB's are in effect in-memory updates (some of our bigger customers run with no logical log write to disk on commit (really!)) running on 128-core Sun boxes (principal and failover). You can get through a lot of tps and the saving on dev cost and maintenance through this monolithic simplicity is great.
Re:Scalable SQL: How do large-scale sites and applications r...
by adw on Friday April 22, 2011 @09:38PM
(#2476014)
If it's financial sector (and it likely is), IBM's DB2 has a large userbase.
Re:Scalable SQL: How do large-scale sites and applications r...
by zwischenzug on Sunday April 24, 2011 @03:48PM
(#2479476)
Not fast enough (I hear).
The reason I ask is because I am a pretty highly skilled Oracle guy, and some of the numbers I have seen around financial systems just seem so fast and big volume transactions per second. Maybe I could get Oracle to do them, but then the zero downtime scares me somewhat as until very recently, keeping Oracle up all the time, even through application upgrades is fairly tricky!