We are working on testing a cluster of MySQL servers to serve as the database back-end for multiple WeBWorK servers. Our current choice, Percona Xtradb Cluster, requires InnoDB as the db engine.
It appears the recommendation to use MyISAM instead of InnoDB has to do with performance, but I was unable to find specifics as to why this would be, or if it is still an issue. The most recent relevant forum post I could find was several years old.
Is anyone else using InnoDB in production, and what performance issues have you run into using it?
I see it mentioned in a few threads in regard to UTF-8, but we are more concerned about performance.
Michigan State University