Am sort of in a fix at the moment. Am at the stage of creating my database from my ER diagram of which certain tables rely on the InnoDB storage engine for referential integrity, transactions etc. By shockingly enough my ISP doesnt offer InnoDB table types due to the overhead caused from transaction tables.
What can i do? Change hosts? Revisit my ER diagram and make them all MyISAM? - this means i have to manually maintain integrity across related tables - seems more of a nightmare to me.
I need comments on what to do. Thanks and looking forward to feedbacks.