Migrate to Galera Cluster

mfc166

Hello!
I want to migrate the Ostikket database to the Galera cluster. To do this, all tables must be in innodb format. And the ost__search table is in the MyISAm format. I can’t convert the table, I get the error /* SQL error (1214): The used table type doesn't support FULLTEXT indexes */

Any ideas?

KevinTheJedi

mfc166

InnoDB does support FULLTEXT indexes but you have to make sure MySQL is at least v5.6.x or above.

References:

https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html

Cheers.