Battling mysql storage engines

Usually storage engines are of little interest for WordPress plugin developers. But if you try to use foreign keys you better be sure, that you have the right constellation of engines between the tables of your plugin and the ones from WordPress. This post highlights some of the details of the different engines in this regard and shows you how to select the correct engine for your tables.