Our senior sysadmin, Nathan March, has been compiling some notes on MySQL and InnoDB for internal use, but we thought they might be of some use and interest to a broader audience. We’ve split Nathan’s insights up into three posts which we’ll be posting daily. First up, Nathan talks about the distinctions between MyISAM and InnoDB, two of MySQL’s storage engines:
I initially started writing this for sysadmins but thought it might be of use to programmers on the whole to help give some insight into MySQL’s storage engine, how they work and why they do certain things. Hopefully this will help demystify things a little on how InnoDB and replication work internally.