Migrate MyISAM tables to InnoDB using replication to avoid a long down time
1
vote
1
answer
393
views
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?
Asked by Ela
(500 rep)
Jan 14, 2023, 02:39 PM
Last activity: Jan 14, 2023, 08:12 PM
Last activity: Jan 14, 2023, 08:12 PM