I store text data in InnoDB and MyISAM tables simultaneously in a 1-to-1 relationship for full-text search indexing. The way I do it is - for every insert/update/delete of text columns in the InnoDB table, I sync the data in MyISAM table too. I thought if InnoDB supports full-text indexing in future, all I have to do is just blow off the MyISAM table. Is this an ideal approach or is it a better approach to store the text data in just the MyISAM table (instead of both)?
Secondly, I have 4 text columns in a single full-text index. Will the performance improve if I consolidate/duplicate the data from all the 4 columns into another column and create the full-text index on that single column instead of indexing on 4 different columns?