We have to migrate MyISAM tables to InnoDB but we are afread of a long down time. In our database we have 10 MyISAM tables where 2 of them are the biggest: ~26GB data + ~10GB indexes.
My question is: Can I set replication between primary server (with original engine's tables) and a replica where all tables were migrated to InnoDB? Then replica will be our main DB.
I read a few articles about migrating tables from MyISAM to InnoDB (like: http://mysql.rjweb.org/doc.php/myisam2innodb or https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html) and additional steps are required (like removing duplicated indexes and server configuration changes) but Will it work?