4 ms·
Ask HN: Do you self-host databases or use a managed service like RDS?
I felt AWS RDS is too costly for small usecases (5-10M rows). Does any of you manage self-host database here ? Any tools that can turn a self-hosted database into a managed database of sort with easy backup/restore etc.
- chrismeller 4y agoThis is the standard cloud/managed ROI argument. If you work for a company that falls into the target audience for the service, it will be a no-brainer. If you don’t… Crunchy Data’s Postgres operator for Kubernetes is basically a roll-your-own RDS.
- sianemo 4y agoWe self-host our Oracle instance because we really, genuinely like Oracle SQL and Oracle Cloud is the only cloud provider (that I'm aware of) that offers Oracle as a service, which is undiserable. Also, in general I personally like the fine control of being able to know the condition of our whole database, including state, deep profiling, and our backup situation, as someone with an old-school sysadmin mindset. However, it's relatively straightforward and well documented[0][1] to migrate to solutions like RDS from existing self-hosted installs if that's what's required. [0]https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-oracle-database-to-amazon-rds-for-oracle.html https://docs.aws.amazon.com/prescriptive-guidance/latest/pat... [1]https://aws.amazon.com/getting-started/hands-on/move-to-managed/migrate-postgresql-to-amazon-rds/ https://aws.amazon.com/getting-started/hands-on/move-to-mana...