hey guys hoping someone with Aurora experience might know th Serverless Stack #help

hey guys, hoping someone with Aurora experience mi...

Jeff Hanna

03/16/2022, 1:54 PM

hey guys, hoping someone with Aurora experience might know the answer here (not an SST issue/question) every once in a while I’m seeing 30s delays, I think caused by creating uuid-ossp extension

Copy code

info: ~~~creating connection ... {"timestamp":"2022-03-16 06:46:37"}
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
info: connected --- {"timestamp":"2022-03-16 06:47:07"}

is uuid-ossp implicitly required because I have uuid types in my db? any alternative or way to avoid these delays?

Frank

03/16/2022, 5:57 PM

Hey @Jeff Hanna r u using the standard Aurora or Aurora serverless?

Jeff Hanna

03/16/2022, 6:02 PM

hey Frank, thanks so much for jumping in. I’m on Aurora serverless

Frank

03/16/2022, 6:10 PM

I wonder if the 30s delays happens from when the cluster is resizing or resuming from auto-paused state.

Jeff Hanna

03/16/2022, 7:11 PM

ya, I was wondering if this create extension message was leading me down the wrong path I assumed that’s what the delay was for, but if you think not, then it could be anything else related to the cluster like sizing or auto-pause that is causing this

Jeff Hanna

03/16/2022, 7:28 PM

thank you Frank, I’ll look into auto-pause and how to prevent I feel like I’m a bit over my head now 😥 I don’t know if I really have the fundamentals of aurora serverless down enough yet I was hoping the defaults would be closer to production ready, I’m just using CDK with: 1. data API 2. backup retention 3. deletion protection 4. scaling

Jeff Hanna

03/16/2022, 7:54 PM

@Frank do you know by chance how to modify a cluster? it seems like once it’s deployed, some changes to the config don’t take effect I’m guessing there is another construct needed to make modifications like turning auto-pause to longer timeout or changing scaling config

Frank

03/17/2022, 2:20 AM

there’s a

scaling

prop in ServerlessCluster.

Frank

03/17/2022, 2:20 AM

Here’s how it is configured in the

RDS

construct https://github.com/serverless-stack/serverless-stack/blob/master/packages/resources/src/RDS.ts

Frank

03/17/2022, 2:22 AM

For prod usage, i’d turn off

autoPause

and use a relatively larger

minCapacity

so it doesn’t need to scale up as often

Jeff Hanna

03/17/2022, 2:36 AM

thank you! Ya that’s what I did today, but the changes weren’t being applied immediately, but then I checked after 5-10m and it looks like they are applied now so maybe just a delay on the dashboard

Jeff Hanna

03/17/2022, 2:36 AM

looks like everything working well now! Can’t thank you enough for the help 🙇

Frank

03/18/2022, 10:14 AM

Oh nice! Glad to be helpful 💪

Open in Slack

Previous Next