How to connect AWS Lambda to MariaDB SkySQL with IPv4 address

0

What I'm doing is using AWS Lambda with Serverless-Express to host my Express API via AWS. I've done that for the most part, but my endpoints that attempt to query my MariaDB SkySQL database are not working, and from the CloudWatch logs it looks like the database connection is timing out.

I think the issue is that SkySQL isn't recognizing AWS Lambda as having proper permissions to access the database. In my SkySQL database I have to manually add IPv4 addresses that are allowed to query the database. My question is, how do I get the IPv4 address(es), and/or is there a better way to do this?

질문됨 2년 전304회 조회
1개 답변
1

Hi, @Ronkillo123

MariaDB SkySQL assumes you are on the internet.

Your Lambda function can be integrated into your VPC.
Lambda integrated into the VPC enables outbound communication to the Internet via a NAT gateway / NAT instance.

Since you can attach an Elastic IP address to NAT, the IP address will be fixed.

https://aws.amazon.com/premiumsupport/knowledge-center/internet-access-lambda-function/?nc1=h_ls

profile picture
전문가
iwasa
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠