> (IMHO) I would vote against InnoDB. I have used foreign key references in > MySQL for years without it. I simply enforce them in my code (PHP or C++ > or whatever). The rest of your advice (the part I cut out) is good, but... Are you a masochist? Why, why, WHY? You could also just write your own RDBMS in PHP...