August 9, 2009, 8:50 pm
These days InnoDB is the ‚Äúgold standard‚Äù for storage engines in MySQL‚Äìboth in terms of performance and durability. InnoDB has been around long enough that we kind of take it for granted. It‚Äôs been years since arguments like ‚ÄúMySQL doesn‚Äôt even have real transactions!‚Äù held any water. While I‚Äôve written about some of InnoDB‚Äôs shortcomings, the reality is that it works remarkably well for the vast majority of users. And InnoDB‚Äôs early design was modeled after Oracle, so its success is hardly shocking.
But can we do better? What if someone decided to build a new transactional storage engine from the ground up, using the lessons learned from InnoDB (and other databases) over the last decade and taking modern hardware architecture into account...?