MySQL's Strengths -- and Weaknesses

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

Tucson, Ariz.

dvernon@us.ibm.com

Join the discussion
Be the first to comment on this article. Our Commenting Policies