How to connect AWS Lambda to MariaDB SkySQL with IPv4 address
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?
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.
How to connect AWS Lambda to MariaDB SkySQL with IPv4 addressasked a month ago
AWS Lambda not able to connect to public RDS instanceasked a month ago
S3 object and lambda function in step machine with the asynchronous express workflowsAccepted Answerasked 4 months ago
lambda take few seconds to return responseasked 2 months ago
How to make Lambda + API Gateway obey REQUEST_URI?asked 2 months ago
How to add python libraries to lambda using the CDK?Accepted Answerasked 2 years ago
Can not connect EC2 Instance via My Ip RDP but Anywhere-IPv4 addressasked 5 months ago
How to delete an AWS Pinpoint Endpoint via Amplify JS?asked 2 months ago
Calling on-prem Web API from AWS LambdaAccepted Answerasked 2 months ago
Cloud9 - AWS Resources vs AWS Toolkit - API Gateway -> Lambda Testingasked a month ago