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.

Computerworld's IT Salary Survey 2017 results
Shop Tech Products at Amazon