[winrid]

Absolutely not. Citus would have solved this problem. Or move to MySQL and use PlanetScale etc.

Second best option is ability to easily create prod environments, and then give those to your biggest customers (bigname.figma.com) etc. No single figma customer will go beyond an i3.metal for the DB, or the app.

[djtango]

So I just read the article - they were on RDS so Citus wasn't an option.

They also stated it was too risky to migrate data stores on the timeline they were working within

Those all seem like measured engineering decisions AFAICT

[winrid]

That doesn't sound right.

Do data dump from prod for initial sync and then setup replication from RDS to new cluster. Once synced do switch. Then you're off RDS and can shard on Citus.

[djtango]

a) they didn't want to move off RDS b) this is a pretty big hand wave over migrating your persistence store on a moving product and moving engineering teams

The coordination alone usually takes months

[winrid]

Yes, it takes months. They also spent months building this custom solution that they now need to maintain.

[raverbashing]

Yes but they probably wouldn't want to migrate off RDS.

[nathanappere]

This doesn't work with the constraint of "staying on AWS" though.

[winrid]

Yes it does.

[thibaut_barrere]

I do agree here. The choice to prefer X over Y for hosting (no matter X and Y) often makes sense, changing hosting providers can take a bit of time & it's hard to fully assess the reality of the quality of support / security (again, not specifically writing about RDS or Citus, both are very good teams) beforehand, so it usually is safer to have a long probing period to move safely, which takes time, something they visibly didn't have much.