AWS DMS RDS MySQL 8 Can't initialize character set unknown

Question

I am trying to run a replication task (CDC) between a AWS RDS MYSQL 8.0.11 database and a Redshift cluster using DMS.

I run into the error :

Error 2019 (Can't initialize character set unknown (path: compiled_in)) connecting to MySQL server

Replication Instance engine version : 3.1.3

Char sets used by the RDS MySQL instance :

-- SHOW VARIABLES LIKE '%char%';
‘character_set_client’,‘utf8mb4’
‘character_set_connection’,‘utf8mb4’
‘character_set_database’,‘utf8mb4’
‘character_set_filesystem’,‘binary’
‘character_set_results’,‘utf8mb4’
‘character_set_server’,‘utf8mb4’
‘character_set_system’,‘utf8’
‘character_sets_dir’,‘/rdsdbbin/mysql-8.0.11.R2/share/charsets/’

I also tried with a fresh RDS MySQL 8.0.15 and DMS engine 3.1.4, same result — Hugo
I just had a answer from AWS : they recommend using DMS 3.3 (Launched last week) — Hugo

user253684 user253684 · Accepted Answer · 2019-09-14T00:45:54

I donot think DMS supports MYSQL 8.X as yet. Supported versions are explained here.

AWS DMS RDS MySQL 8 Can't initialize character set unknown

2 Answers