MySQL storage engine dilemma

Posted by burntblark on Stack Overflow See other posts from Stack Overflow or by burntblark
Published on 2011-11-25T18:16:30Z Indexed on 2012/04/07 11:29 UTC
Read the original article Hit count: 172

Filed under:
|

There are two MySQL database features that I want to use in my application. The first is FULL-TEXT-SEARCH and TRANSACTIONS.

Now, the dilemma here is that I cannot get this feature in one storage engine. It's either I use MyIsam (which has the FULL-TEXT-SEARCH feature) or I use InnoDB (which supports the TRANSACTION feature). I can't have both.

My question is, is there anyway I can have both features in my application before I am forced to make a choice between the two storage engines.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql