Re:Why companies move off Heroku (besides the cost)
by gingerlime on Thursday April 28, 2022 @01:38AM
(#31189112)
we’re using aiven.io and quite happy, although hard for me to compare. you can port across clouds, which is reassuring if we need to switch. Otherwise their support was helpful debugging a couple of db issues (in our own code). Wonder how they compare in this matrix if anyone knows?
no affiliation. just a customer.
Re:Why companies move off Heroku (besides the cost)
by mrkurt on Thursday April 28, 2022 @08:12PM
(#31199810)
aiven.io is quite good. They went broad instead of deep, so they're not as good at Postgres as the Postgres specific companies. But they're probably better Postgres than a PaaS can build by themselves.
Re:Why companies move off Heroku (besides the cost)
by gingerlime on Saturday April 30, 2022 @01:29AM
(#31213578)
that’s useful to know that others do postges better. We use their redis as well, so in some ways, breadth is useful for them and for us.
at the time we picked aiven, we couldn’t find any redis-specialized hosting with instances in GCP europe if I recall. so their breadth also plays in terms of locating near the customer servers (important for latency)
Re:Why companies move off Heroku (besides the cost)
by pech0rin on Wednesday April 27, 2022 @11:29PM
(#31188437)
What do you mean? RDS lets you run replicas
Re:Why companies move off Heroku (besides the cost)
by mrkurt on Thursday April 28, 2022 @12:25AM
(#31188721)
RDS will manage replicas for you. But you can't run your own non-rds replicas.
Re:Why companies move off Heroku (besides the cost)
by sandGorgon on Thursday April 28, 2022 @01:23AM
(#31189044)
correct. RDS does not even let you do a true, vanilla postgres backup to s3. the lock-in is complete
Re:Why companies move off Heroku (besides the cost)
by pech0rin on Thursday April 28, 2022 @02:12AM
(#31189241)
You can easily use pg_dump to do a "vanilla" backup to s3. Its a managed db service but if you wanted to run your own you can extract your data and move to a new db. The lock is not "complete" you are acting like you can't even extract your data.
Re:Why companies move off Heroku (besides the cost)
by 0xCMP on Thursday April 28, 2022 @02:36AM
(#31189375)
i believe they're taking about being able to ship wal to s3 so the back up is close to real time.
Re:Why companies move off Heroku (besides the cost)
by mrkurt on Thursday April 28, 2022 @08:17PM
(#31199841)
"Only export your data with pg_dump" is one of those misfeatures that makes RDS mediocre. They don't really expose much of the power of the underlying DB.
Re:Why companies move off Heroku (besides the cost)
by sandGorgon on Thursday April 28, 2022 @07:29AM
(#31191228)
you cannot ssh to RDS machine. so u need to get another EC2 machine and pg_dump over the network. the connection breaks - yes has happened to us multiple times.
RDS makes it very inconvenient to do anything other than use their managed services.
because RDS backup data storage is VERY EXPENSIVE even compared to s3. this is very deliberate.
Re:Why companies move off Heroku (besides the cost)
by dikei on Thursday April 28, 2022 @05:17AM
(#31190327)
Using pg_dump for migration of large DB is very difficult due to the downtime it might involve.
Re:Why companies move off Heroku (besides the cost)
by musicalmindz on Monday May 02, 2022 @12:41PM
(#31237464)
This is exactly the issue I have right now on Aurora. We have a 30TB db and there's no easy way to export it to S3 for backup. The closest we have found is this... https://docs.percona.com/percona-xtrabackup/2.4/xbcloud/xbcl...
Anyone else have any idea if there's a better option??
The good DBaaS give me a lot more power. This is true for Heroku PG, PlanetScale, Supabase, and Crunchy Data. Some of them let me fork a DB to run a PR against, some give me app level features that save me code, etc.
Most modern hosted DBs also let you run your own replicas.
I'm not really complaining about how well RDS works when your app is connected to it and it doesn't failover/go down for maintenance/etc. It works fine as a DB backend. That's just a baseline I don't think is very valuable anymore.