Hello Experts,
We have one non prod DB cluster in aurora postgres. We are seeing the daily cost for the RDS instance is appearing as ~$300 even we perform no activity on that database. Is there any way to further dig down and see what all queries or functions inside the database is actually contributing to these ~300$ amount?
We were initially thinking if the database backup is costing so much as the database size is ~15TB and we have 7 days backup retention set. But the cost explorer showing the cost under service "backup" as ~$2 only per day. And what should be the backup retention should we set, as it seems its occupying full DB snap each day in the storage and setting the retention for longer period (~35days for e.g.) is going to cost us more?
Videos
Difference between RDS and Aurora, when hosting Java application with PostgreSQL database.
Here i have my estimated pricing for using RDS. I suppose this is a separate server for actually hosting the database (hence the price) I found this alternative Aurora, which seemed a little bit better in regards to pricing.
This is much cheaper and also allows for almost the same amount of data (and up 1 million requests).
Can anyone explain to me the major differences in regards to these two services?
Hello, PM for Amazon RDS and Aurora here.
We recommend Amazon Aurora Serverless for bursty workloads that spike up/down frequently. Think an e-commerce website which gets a lot of traffic on weekends and nothing on weekdays. Our customers love not having to scale the database to account for the surge or drop in traffic.
Amazon RDS and "regular" Amazon Aurora are for workloads that need sustained throughput. Think a search website which gets traffic throughout the day/week etc.
Hope that helps!
Aurora is more than just serverless. Serverless is good for bursting or dynamic workloads. Regular aurora gives you managed updates, scaling, separate data and compute plane, etc. It is way more managed than RDS