I'm evidencing an increase in the planning, confidence & execution for MyISAM to InnoDB migration.
How much can a single consultant observe? I agree Oracle should not go to PR based on my experience. But I find that:
- More companies are now familiar with InnoDB than there used to.
- More companies are interested in migration to InnoDB than there used to.
- More companies feel such migration to be safe.
- More companies start up with an InnoDB based solution than with a MyISAM based solution.
This is the way I see it. No doubt, the Oracle/Sun deal made its impact. The fact that InnoDB is no longer a 3rd party; the fact Oracle invests in InnoDB and no other engine (Falcon is down, no real development on MyISAM); the fact InnoDB is to be the default engine: all these put companies at ease with migration.
I am happy with this change. I believe for most installations InnoDB provides with a clear advantage over MyISAM (though MyISAM has its uses), and this makes for more robust, correct and manageable MySQL instances; the kind that make a DBA's life easier and quieter. And it is easier to make customers see the advantages.
I am not inclined to say "You should migrate your entire database to InnoDB". I don't do that a lot. But recently, more customers approach and say "We were thinking about migrating our entire database to InnoDB, what do you think?". What a change of approach.
And, yes: there are still a lot of companies using MyISAM based databases, who still live happily.