Hacker News Reader

Comment by HorizonXP | Hacker News Reader

So, as someone who was in the midst of planning a migration of a multi-billion $ revenue platform to using CosmosDB...

Alternatives? LOL

Basically just looking for geo-redundant, high read & write throughput. Our intention was to leverage Azure Event Grid/Kafka Connect to have event streaming used to coordinate writes between Redis (cache), Cosmos (transactional DB), and our systems of record (legacy). Majority of read/writes would occur via our API, but some would occur via the systems of record, hence the use of a log-based architecture.

View on HN

Spanner offers that on GCP, and I believe CockroachDB offers something similar cross-cloud.

Do you have any specific requirements for which cloud provider you use, or any particular interface you really need?

Azure is our cloud provider. Interface is flexible, since our current implementation leverages Prisma ORM connected to Postgres & SQL Server. We're going to have to rebuild it anyway.

Vitess maybe? from what I have demoed and for being open source that’s the one I would choose. Unfortunately there isn’t a Postgres compatible one that is as mature yet and certainly not free.

Got it, thank you! CockroachDB is the only one I know offhand that does what you're looking for. Another comment mentioned Vitess, which might also work.

It seems like there are a lot of options for large scale analytics, but I don't know a lot for high throughout geo-redundant transaction processing.

Everything Azure Event* is crap, the drivers are so buggy.

Use Confluent and connect it with a managed postgres on aws or gcp. If you really need more, use Google Cloud Spanner.

EventHub is a perfectly acceptable product. It's basically Kafka. We used it at a fairly high scale with very few issues.

DynamoDB or Bigtable?

We're on Azure, otherwise those were my goto choices too.

Ravendb? I really like it's design and apis. Works well for my use cases.

What about Azure's Citus Postgres? I think it's called Hyperscale?

RavenDB can do that

Reply on news.ycombinator.com