4 ms·
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 lookin
by HorizonXP 4y ago
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.
- rrdharan 4y agoDynamoDB or Bigtable?
- HorizonXP 4y agoWe're on Azure, otherwise those were my goto choices too.
- noahl 4y agoSpanner 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?
- HorizonXP 4y agoAzure 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.
- skunkworker 4y agoVitess 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.
- noahl 4y agoGot 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.
- ayende 4y agoRavenDB can do that
- robertlagrant 4y agoWhat about Azure's Citus Postgres? I think it's called Hyperscale?
- yellowfool 4y agoEverything 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.
- maltalex 4y agoEventHub is a perfectly acceptable product. It's basically Kafka. We used it at a fairly high scale with very few issues.
- HdS84 4y agoRavendb? I really like it's design and apis. Works well for my use cases.