We had some weird situation last night where a EE site we manage fell over of it's own accord and is this morning reporting SQL errors:
Error Number: 1286
Unknown storage engine 'InnoDB'
Closer inspection reveals that all of the affected tables are set to use InnoDB whereas the unaffected tables are using MyISAM.
I'm not sure what best practice is but I'm guessing have different tables running on different engines is less than ideal and I'm not even sure how it happened but this is a fairly old site that's moved from host to host and started out on EE 1.x.
What are the repercussions of changing database engine for an ExpressionEngine table (if any) and why might this have happened in the first place (the table corruption)?