How to access MySQL running on an EC2 instance from Lambda?

Question

Is it possible to use Lambda(triggered by AWS IoT) to read/write to a MySQL server running on an EC2 instance? If so how would you do that? All info I see on internet seems to relate specifically to Amazon RDS rather than EC2 instances.

Thanks, Marcus

You would access it exactly same as RDS, by connecting to it using mysql client. — Marcin
– Marcin, Commented Nov 14, 2020 at 4:03

jingx · Accepted Answer · 2020-11-14 04:51:14Z

1

You need to connect the Lambda to the subnet where the MySQL server is running. See https://docs.aws.amazon.com/lambda/latest/dg/configuration-vpc.html.

Once that is done, you can connect to it using the server's private IP, as you normally would any MySQL server.

answered Nov 14, 2020 at 4:51

jingx

4,0574 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to access MySQL running on an EC2 instance from Lambda?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related