I'm migrating an API from SLS to SST and have loca...
# helps
Seth Geoghegan
10/27/2021, 1:03 PMI'm migrating an API from SLS to SST and have local development working! 🎉 However, I'm having issues when I deploy and I believe it's related to my RDS database being within a VPC.
Seth Geoghegan
10/27/2021, 1:03 PMMy assumption is that this works locally for me because I am running a VPN
Seth Geoghegan
10/27/2021, 1:04 PMand my local lambdas are hitting a local postgres I have installed in Docker
Seth Geoghegan
10/27/2021, 1:04 PMwhich, works surprisingly well
t
thdxr
10/27/2021, 1:04 PMThis is one of the reasons I switched to data API
thdxr
10/27/2021, 1:04 PMAvoids VPN
s
Seth Geoghegan
10/27/2021, 1:04 PMbut once I deploy to the cloud, I'm faced with 10 second timeouts in my lambdas which I assume is due to the VPC
t
thdxr
10/27/2021, 1:05 PMDoes it eventually work?
thdxr
10/27/2021, 1:05 PMI ran into this as well
s
Seth Geoghegan
10/27/2021, 1:05 PMI'm my brief investigation into Data API, it appear that it only applies to Aurora Serverless?
Seth Geoghegan
10/27/2021, 1:06 PMI haven't bumped up the timeout yet, but it's certainly work a try
t
thdxr
10/27/2021, 1:06 PMOh right you're not on serverless
s
Seth Geoghegan
10/27/2021, 1:06 PM😢
t
thdxr
10/27/2021, 1:06 PMI meant if you keep retrying
thdxr
10/27/2021, 1:06 PMIf not can you verify your lambdas are in a VPC?
s
Seth Geoghegan
10/27/2021, 1:06 PMThey are not, which is what I'm just now learning
t
thdxr
10/27/2021, 1:07 PMAh yeah that's probably it then
s
Seth Geoghegan
10/27/2021, 1:07 PMI've been reading about that this morning, and it sounds pretty awful to set up
Seth Geoghegan
10/27/2021, 1:08 PMthere's a lot needed to support the non-serverless RDS
t
thdxr
10/27/2021, 1:08 PMIt's pretty easy in SST. You have to import the vpc then can pass it into the function
s
Seth Geoghegan
10/27/2021, 1:08 PMhmm, that's definitely worth a try
Seth Geoghegan
10/27/2021, 1:08 PMI'm already provisioning my RDS DB in CDK via SST
Seth Geoghegan
10/27/2021, 1:09 PMwow, that's a lot of acronyms...
Seth Geoghegan
10/27/2021, 1:10 PMand in doing so, I'm already importing an existing VPC
Copy code
const vpc = ec2.Vpc.fromLookup(this, 'VPC', {
vpcName: process.env.VPC_NAME,
});r
Ross Coundon
10/27/2021, 1:30 PMYeah, it's pretty horrid. It's one the reasons we're migrating from MySQL to DynamoDB. Also, if your lambda needs to access RDS and the internet, you're looking at a permanent running NAT Gateway which means additional cost 😞
s
Seth Geoghegan
10/27/2021, 1:31 PMFortunately, this is an internal service with no need for a public facing interface.
Seth Geoghegan
10/27/2021, 1:32 PMBut yeah, this is super lame 😆
Seth Geoghegan
10/27/2021, 1:33 PMThis service has well known access patterns, which makes it ideal for DynamoDB
t
thdxr
10/27/2021, 1:33 PMThe NAT Gateway was what made me jump to dynamo
thdxr
10/27/2021, 1:34 PMThe RDS DB already exists? Is that why you can't easily use serverless?
s
Seth Geoghegan
10/27/2021, 1:40 PMThat's a great question. The RDS database does already exist in this service and I've been doing my best to leave everything as-is while I convert from SLS to SST. The service has been running internally for a year or so ingesting data, but isn't currently used to support any customer facing features. They are finally getting ready to do something useful with this service, so I'm getting it ready for active development and deployment.
Seth Geoghegan
10/27/2021, 1:41 PMLuckily, it looks like I wont need to worry about saving historical data that's been collected over the past year. Thus, I'll have the freedom to change a few things in the persistence layer. However, there are cultural hurdles to overcome 🙂
Seth Geoghegan
10/27/2021, 1:43 PMI know you've been spending time investigating SQL DB options in serverless apps. Within the AWS ecosystem, is Aurora Serverless your current recommendation? The AWS docs imply Aurora v1 isn't good for production workloads and v2 is still in preview.