25 points by db_design_noob 1 year ago flag hide 18 comments
john_doe 1 year ago next
I'm currently working on a project that requires a distributed database design. I'm looking for some personal experiences, advice, or resources to help guide me through the process. Any thoughts?
database_expert 1 year ago next
I've worked with several distributed databases, including Apache Cassandra and MongoDB. It really depends on your specific use case. I recommend checking out the docs for each and determining which one fits your needs best.
database_expert 1 year ago next
CockroachDB is a great choice if you need strong consistency and transactions. It's a bit more complex to set up than some other options, but it's very powerful.
jane_doe 1 year ago prev next
I've used CockroachDB for a few projects with good results. We've had to do some complex queries, and it handles them well.
john_doe 1 year ago next
I'll take a look at CockroachDB. Transactions are a requirement for us, so that sounds like a good option.
another_user 1 year ago prev next
I second the recommendation for MongoDB. I've used it for several projects that required high availability and horizontal scalability.
john_doe 1 year ago next
I've heard good things about MongoDB. I'll add it to my list of options to check out.
database_enthusiast 1 year ago prev next
Have you considered looking at Apache Cassandra or Amazon DynamoDB as well?
john_doe 1 year ago next
I haven't looked into DynamoDB, but I've heard of Cassandra. I'll add both to my list.
tech_guru 1 year ago next
If you go with Cassandra, check out DataStax's distribution of it. They have a lot of great tools for management and monitoring.
john_doe 1 year ago next
Thanks for the recommendation! I'll definitely check out DataStax's distribution.
database_expert 1 year ago prev next
I highly recommend taking a look at Cassandra. It's a great choice if you need high availability and scalability, and it's pretty easy to set up and manage.
database_expert 1 year ago prev next
One thing to keep in mind is that distributed databases can have some trade-offs. For example, some have limited query functionality or may not support transactions. Be sure to do your research and determine what you're willing to compromise on.
john_doe 1 year ago next
Good point. I'll keep that in mind as I'm evaluating my options.
more_comments 1 year ago prev next
One resource I found really helpful was the distributed database section of Martin Kleppmann's book 'Designing Data-Intensive Applications'. It has a lot of good information on the different types of distributed databases and their trade-offs.
john_doe 1 year ago next
Thanks for the recommendation! I'll check out the book.
helpful_user 1 year ago next
The book is great! I highly recommend it. It covers a lot of the complexities of distributed systems and how to design your applications to work well with them.
john_doe 1 year ago next
Thanks for the encouragement! I'm excited to dive in.