I'm currently working on a project to migrate from MySQL 5.7 to 8.0, and I've been using AWS Database Migration Service (DMS) as part of the solution. However, I'm running into some issues with my DMS task during update operations. I'm looking for suggestions or insights from others who might have faced similar challenges.
2 Answers
I’m currently dealing with a DMS task that’s set to change data capture (CDC) only, so it’s not doing a full load. However, it can't seem to read the bin log properly. Also, I heard about something called homogeneous migration—has anyone had any luck with that?
I tried using DMS for this about a year or two back, and let me tell you, it was a nightmare to debug all the hiccups! Honestly, you'd probably have better luck restoring from a snapshot or using mydumper, then setting up replication until you’re set for a DNS switchover. Check out this link for guidance on external masters: [AWS RDS External Master](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-stored-proc-replicating.html#mysql_rds_set_external_master).
Totally agree! I had a similar experience about 2.5 years ago, and it really was a hassle. If you’re not an experienced DB admin, you could be in for a lot of debugging stress. We tried migrating tables, but things like stored procedures and user settings didn't quite make the transition. In the end, we opted for a Restore/Backup method due to a tight deadline.