Is it common practice to mix InnoDB and MyISAM tables on same server?
I have a movie clips and photos table in an application; these tables contain a tag column, which allows users to search for the movies/photos by tag; however, the whole database is designed using InnoDB tables specifically for data integrity.
Since the tables are not MyISAM, I cannot use the full-text feature (which sucks). I was thinking of changing those 2 tables into MyISAM tables; however, I read somewhere that combining MyISAM and InnoDB tables is a very bad idea.
I really would want to use the fulltext feature on those tables.
My questions are these:
- Is it really a bad idea (performance-wise, data integrity-wise, etc) to combine those 2 tables?
- Is there another way of achieving the same result (the results obtained using fulltext feature) in InnoDB tables?