CODEWITHSUNDEEP
amazon-ec2
Nishant
Nishant

Reputation: 1

Connecting MySQL installed on AWS EC2 instance with AWS Glue

I have installed MySQL 5.7.25 on my AWS EC2 instance running Ubuntu 18.04 AMI. I want to connect this MySQL instance with AWS Glue but I have been unable to do so. I have associated my EC2 instance with an elastic ip and tried connecting the MySQL instance by using a JDBC url with AWS Glue, but every time my connection is refused. Is there any way to connect the two?

Upvotes: 0

Views: 525

Answers (2)

Yannick Arthur DOUNGMO
Yannick Arthur DOUNGMO

Reputation: 161

Before using AWS Glue, you should first use DMS to migrate your database. If your target database has a different schema than the source database, that's what we call heterogeneous database migrations, you need AWS SCT.

One example of heterogeneous database migration is moving from an Oracle Database to PostgreSQL. As you see, the schema structure, data types, and database code of source databases are quite differents.

Upvotes: 0

Jilson
Jilson

Reputation: 609

When creating the JDBC connection in aws glue, 1. Use JDBC url with private ip of your Ec2 instance(with mysql installed)

jdbc:mysql://ec2_instance_private_ip:3306/database_name

  1. Select the correct vpc and subnet where you Ec2 instance(with mysql installed) is located.
  2. Select the same security group used for your Ec2 instance(with mysql installed)

Upvotes: 2

Related Questions