I'm very new to MySQL. My main interest is Data Modeling. Need advice in regard to choosing MySQL storage engine:
I'm siding with InnoDB because I'm doing a project for my little company and security/reliability is a serious issue. Plus it supports transactions. The downside is it doesn't support fulltextindexing (which in my project might be kind of useful). What would you advice?