Connecting to mysql database store hosted in AWS EC2 from another AWS account using glue connection.

Question

I have two AWS accounts say S1 and S2. In S1 AWS account i created and EC2 instance and within that instance i hosted mysql database containing some tables. Now i want to connect to this data store from other AWS account S2 using AWS glue connection. I created connection in S2 AWS account using JDBC and other related credentials but when i test my connection it fails. Can you please guide me how can i successfully create connection. Thank you.

Answer

Hi Imran,

First you need to have network connectivity between the two accounts. For this I would advice looking at [VPC Peering](https://docs.aws.amazon.com/vpc/latest/peering/what-is-vpc-peering.html), [AWS PrivateLink](https://docs.aws.amazon.com/vpc/latest/userguide/endpoint-services-overview.html) or using a robust enterprise networking through [AWS Transit Gateway](https://docs.aws.amazon.com/vpc/latest/tgw/tgw-getting-started.html).
After establishing network connectivity, you need to use Glue mode [route through your VPC](https://docs.aws.amazon.com/glue/latest/dg/connection-VPC-disable-proxy.html) the traffic and provide the proper JDBC connection string depending on the networking alternative you chose.

This steps should enable you to connect to your database in other account!

Connecting to mysql database store hosted in AWS EC2 from another AWS account using glue connection.

Contenuto pertinente