How to handle data migration refreshing to MySQL InnoDB cluster

user619241

I need to handle existing MySQL database migration to MySQL InnoDB cluster. The existing MySQL database are still changing on daily basis. There is no way to replication from existing MySQL database to new InnoDB cluster. The MySQL versions are incompatible - the existing MySQL database is on early 5.x, the new InnoDB database is on 8.x. I plan to do one-time bulk data loading to InnoDB cluster from existing database. How do I keep refreshing new InnoDB data from existing MySQL database?

Thank you!

Xinhuan

Dave Stokes-MySQL Community Team-Oracle

You could load the binary logs made after the backup but that also may not be compatible with the new cluster - you will have to test.

there is not a really easy to use way to keep two separate database in sync without replication.