Alex Rivera | Logout

Foreign keys for myISAM and InnoDB tables

Asked 2012-11-22T00:12:02.640
10

I have a DB table that is myISAM, used for fulltext searching. I also have a table that is InnoDB. I have a column in my myISAM table that I want to match with a column in my InnoDB table. Can that be done? I cant seem to work it out!

mysql innodb
Edit
Report

1 Answer

3

I would recommend altering your DB architecture such that you have one set of tables designed with data integrity for writing (all InnoDB), and a second set designed for search - possibly on a different box, and possibly not even using MySQL, but maybe a search server like Solr or Sphinx, which should outperform a fulltext MySQL table. You could then populate your search DB periodically from your write DB.

answered 2012-11-22T00:26:33.930

Your Answer