CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-redshiftaws-dms
Aldrin Machado
Aldrin Machado

Reputation: 97

MYSQL 8.0.19 (ON PREMISE) as source in AWS DMS?

Can someone please confirm if my on premise MYSQL 8.0.19 instance can be used as source in Aws Database migration service ,with target as aws redshift. The articles I read show only MySQL versions 5.5, 5.6, and 5.7 as supported.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.html

Wondering if support is provided as of MAY 2020.

PS: I ran into problem while setting task (AWS DMS FULL load) with mysql(on premise) 8.0.19 as source and redshift as target. The task is set but the table load fails with table error.

Upvotes: 0

Views: 331

Answers (1)

gaveeno
gaveeno

Reputation: 46

AWS DMS frustratingly still doesn't support MySQL 8 as a source as far as I know.

Here's a related support thread in the AWS Developer Forums: DMS task fails when migrating RDS MySQL 8 database . In that thread, an AWS staffer commented on January 28 that it should be supported with DMS version 3.4 (the current version is 3.3.2), however they haven't provided any details on when we can expect 3.4 to be available.

Upvotes: 0

Related Questions