I am curious if anyone else has Discourse running on AWS through an EC2 instance and RDS setup? We have run into an issue where the amount of I/O requests is through the roof and creating significant cost. We are currently processing 5.5 billion monthly I/O requests, which seems like a lot for a forum of maybe a 1,000 active users.

This forum here is ran on EC2 / RDS, so we are quite familiar with it. My first question will be: why are you using Aurora? Why wasn’t standard PostgreSQL on RDS adequate?

That is a good question. I’m not sure why that decision was made in retrospect. I assume the cost would be cheaper for standard PostgreSQL, but also trying to determine if there is a setup issue causing more I/O requests than there should be.

I’d check RDS Performance Insights for clues.

Ok. Also my developer noted: “Aurora was done to not provision/allocate space beforehand and better management”

[image] Chris Palmquist: Also my developer noted: “Aurora was done to not provision/allocate space beforehand and better management” It’s part of the trade-off. No need to handle disk space alerts in exchange for paying more for the service. I tested Aurora (couple of years ago) and it didn’t pass all Discourse tests at the time. We run hundreds of Discourse instances in AWS, but we use PostgreSQL RDS in all of those.

[image] Falco: I tested Aurora (couple of years ago) and it didn’t pass all Discourse tests at the time. We run hundreds of Discourse instances in AWS, but we use PostgreSQL RDS in all of those. Thanks for the feedback here. We just completed migrating from Aurora to standard Postgre SQL.

Aurora I/O

Product Support Self-hosting

pqMMA (Chris Palmquist) January 16, 2023, 5:14pm 7

Thanks for that insight. I will definitely dig into migrating (if possible).

Topic		Replies	Views
Installation on AWS using RDS Self-hosting hosting	6	4921	April 11, 2022
Installing Discourse on AWS Self-hosting	6	2231	June 4, 2018
£3 Discourse hosting questions Self-hosting hosting	21	3858	September 21, 2016
Digital Ocean Alternative Self-hosting hosting	5	2915	March 20, 2018
[Paid] Migration from digital ocean to AWS Marketplace	2	2847	July 12, 2018

Aurora I/O

Related topics