The speed of MySQL, according to your article ["MySQL Breaks Into the Data Center," QuickLink 41750], is due to its simplicity -- one file for schema, one file for data, one file for index. This also reveals its weakness -- no separate transaction log, no separate rollback log, no file duplication. All your eggs in one basket. For those for whom low cost and high speed are more important than security, integrity, availability and recovery, MySQL looks good. For those for whom it is not, a slower, more complex, safer DBMS is required.
David P. Vernon
Senior technical solution specialist
IBM Life Sciences