This is an automated archive.

The original was posted on /r/mysql by /u/Rareness_ on 2023-12-02 12:25:17+00:00.

Hi, we are planning to migrate our MySQL On-Premise to AWS RDS Database, we are choosing between two strategies - backup to S3 (however we cannot allow any downtime on MySQL On-premise), therefore mysqldump --single-transaction … or percona-xtrabackup in order not to lock any database during taking backup. Then restore that DB and apply DMS to replicate changes, during backup and restore of RDS. Or should we try to go with DMS in AWS, and then fully replicate the On-premise DB and then replicate the live changes. Our DB is pretty big (500GB) and InnoDB is being used.