CODEWITHSUNDEEP
amazon-web-servicesamazon-s3amazon-ec2aws-glue
Aldo Barrios
Aldo Barrios

Reputation: 11

Using AWS Glue with Mysql in my EC2 Instance

I am trying to connect my ec2 installed/mysql with Glue, the purpose is to xtract some information and moved to redshift, but i am receiving the following error:

Check that your connection definition references your JDBC database with correct URL syntax, username, and password. Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

This is the format that i am using jdbc:mysql://host:3306/database

I am using the same vpc, same SG, same subnet for the instance.

i know the user/password are correct because i am connected to the database with sql developer.

What i need to check? Is it possible to use AWS Glue with mysql in my instance?

Thanks in advance.

Upvotes: 1

Views: 1650

Answers (2)

Yannick Arthur DOUNGMO
Yannick Arthur DOUNGMO

Reputation: 161

Yes, It is possible to use AWS Glue with your MySQL running in your EC2 Instance but Before, you should first use DMS to migrate your databases.

More over, your target database (Redshift) has a different schema than the source database (MySQL), that's what we call heterogeneous database migrations (the schema structure, data types, and database code of source databases are quite differents), you need AWS SCT.

Check this out : enter image description here

As you can see, I'm not sure you can migrate straight from MySQL in an EC2 instance to Amazon Redshift.

Hope this helps

Upvotes: 0

Jilson
Jilson

Reputation: 609

In the JDBC connection url that you have mentioned, use the private ip of the ec2 instance(where mysql is installed) as host.

jdbc:mysql://ec2_instance_private_ip:3306/database

Upvotes: 0

Related Questions