DynamoDB

Post by **Cakedaddy** » Fri Nov 15, 2024 1:15 am

Ok, so when I move the DB to AWS, my current ec2 bill will increase because it will be sharing the DB data? Or. . . since it was already doing the same thing via Supabase (current host), I shouldn't see an increase?

Post by **TheCatt** » Fri Nov 15, 2024 7:28 am

If you are spinning up a new ec2 instance, it will have costs. Above I think you said $15/month estimate?

Post by **thibodeaux** » Fri Nov 15, 2024 8:19 am

Cakedaddy wrote: ↑Fri Nov 15, 2024 1:15 am Ok, so when I move the DB to AWS, my current ec2 bill will increase because it will be sharing the DB data? Or. . . since it was already doing the same thing via Supabase (current host), I shouldn't see an increase?

I'm not 100% sure I understand you current setup but if you're saying you have an ec2 instance in AWS sending data outside, and you stop doing that, your data transfer cost at least should go down. There is still some cost to send data from an ec2 instance to a db INSIDE AWS but it is much lower (5-9x)

Post by **Cakedaddy** » Fri Nov 15, 2024 12:49 pm

I'm pretty sure my current ec2 is an apache webserver hosting my appsmith app. Supabase is my DB host site. The app will send queries to the DB, and then the web server displays the info on a page. Based on my bill, I'm not paying anything for data transfer. I'm paying $30 +/- $1 per month for an Amazon Elastic Compute Cloud running Linux/UNIX > On Demand Linux t3.medium Instance Hours. Also discovering I'm on a 12 month free tier for the ec2.
Per the email I receive each month: 750.0 Hrs for free for 12 months as part of AWS Free Usage Tier (Global-PublicIPv4:InUseAddress)

I've also learned that I can prepay for the year for the stuff I'm paying for now reducing my costs by about 30%.

I really wish the bill would include what I would be paying for stuff if I wasn't on the free tier.

Post by **Cakedaddy** » Fri Nov 15, 2024 1:04 pm

Here's my last bill. You can see that my usage is VERY low.

bill.jpg

Also learned that t3.medium is not included in the free tier, and that's why I'm paying for it.

Post by **thibodeaux** » Fri Nov 15, 2024 1:25 pm

"Global-PublicIPv4:InUseAddress" is what they charge you for having a public IP address; it's not data transfer.

If I'm reading that bill correctly, it DOES tell you what you're using under the free tier:
$0.000 per GB - data transfer out under the monthly global free tier: 1.167 GB
$0.000 per GB - regional data transfer under the monthly global free tier: 0.428 GB

The regional data transfer is surprising (it's broken out above: you're transferring data to several other regions) but overall your usage is so low as to amount to pennies if you were paying (it's less than a dime per GB).

Post by **TheCatt** » Fri Nov 15, 2024 1:51 pm

LightSail (from AWS) might make this whole thing easier on you than running your own ec2 servers.

It's designed for simple apps that do web serving + DB persistence with more fixed/predictable pricing. I briefly setup a wordpress site on it once, and it was easy. But haven't done more with it.

https://docs.aws.amazon.com/decision-gu ... r-ec2.html

Post by **Cakedaddy** » Fri Nov 15, 2024 3:41 pm

The regional stuff is interesting. . . I don't know where the DB server is, so that would be some of it. But overseas? Is there a way to block transfer to/from regions?

Post by **thibodeaux** » Fri Nov 15, 2024 4:38 pm

This is intra-AWS so it's not to the DB (that's not in AWS, right?). It's unclear what's actually going on, which you'd need to know in order to stop it. There's no config location where you can say "block transfer to other regions." Really AWS tends to be "off by default" on most things. Again, not sure what all has been setup in your account.

Post by **TheCatt** » Thu Nov 21, 2024 7:56 pm

TheCatt wrote: ↑Thu Nov 14, 2024 2:57 pm (Also, Aurora isn't truly serverless, and only scales down to 0.5 units, iirc, for Aurora 2)

https://aws.amazon.com/blogs/database/i ... erless-v2/

SCALE TO ZERO! That makes this product dramatically more useful for small/dev workloads.

It can take up to 15 seconds for the database to resume.

Little laggy on restart, but still.

Post by **Cakedaddy** » Fri Nov 22, 2024 3:23 am

Way too late to read all of that. But if it's saying that I won't have to pay for idle time, which is 99% of the month right now, but will have to wait 15 seconds when I do finally click on the app. . . that IS awesome. I'm sure there's a timeout once it's started back up. Like a 1 hour minimum or something. So I know it won't go down to billing me the 1% I'm implying above. But still. Even if it just goes to sleep over night and on the weekends, that's big.

Post by **TheCatt** » Fri Nov 22, 2024 5:55 am

Cakedaddy wrote: ↑Fri Nov 22, 2024 3:23 am I'm sure there's a timeout once it's started back up. Like a 1 hour minimum or something.

When you choose a minimum capacity of 0 ACUs, you can also specify the length of time for the instance to be idle (Period after inactivity) before it automatically pauses. You can specify between 300 seconds (5 minutes) and 86,400 seconds (24 hours) for the delay period with no database traffic before pause is initiated.