Diamond Notes

So multiple people have blogged about this announcement already.  The Innodb company has announced a new plug-in that can be a drop-in replacement for the current Innodb code in MySQL 5.1.  Evidently it is really easy also.  It has some interesting new features including non-blocking index creation if I am understanding things correctly.  That  to me seems to be the big new feature to me.

However, the reason why I am pointing this announcement out when others already have is that Peter Zaitsev did a talk today about the scalablitiy issues of Innodb dbs this afternoon.  I blogged during the talk here.  He pointed out (with benchmarks) multiple times that the 5.1 server (with Innodb tables) was actually not working as well as 5.0 currently does. If I understand correctly he didn’t have a chance to test the new plug-in (not for certain though — I was unclear about that).  They possibly could have fixed these regression issues in the new version but I would love to see tests of it.  Just a thought before we all get to excited :)  I like the idea personally that the Innodb plug-in isn’t so tightly coupled with the MySQL server. Good to see them releasing something.  Hope they continue!  Scaling improvements above 8 cores would be nice.