We are trying to implement MySQL clustering on our E-commerce database, but presently the tables are MyISAM based and some of the tables have full text search index on. In the wake of Clustering environment, one of the requirements is moving to InnoDB. However, that would pose the problem of switching off the "full text search indexing" on such tables where this is on today. What is the best way to approach towards InnoDB and a mitigation strategy for MyISAM tables with full text search on?
Also, I am curious to know the differences between various MySQL Indexing scehemes - Internal, MySQL, Unindexed and MSSQL.
Thanks in advance.