Questions tagged [distributed-database]

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

188 questions
4
votes
1 answer

Distributed Key/Value store in C/C++ With pluggable storage

I am looking for a C/C++ based distributed key/value store which has a clean enough design so I can plug in my own in-memory storage engine. It is OK even if I have to do code changes to be able to do that. Does anyone have a recommendation? Or a…
user1461001
  • 693
  • 1
  • 7
  • 17
3
votes
1 answer

Multi Tenancy in ClickHouse

A lot of people don't want to use ClickHouse just to do analytics for their company or project. They want to use it as the backbone for SaaS data/analytics projects. Which most of the time would require supporting semi-structured json data, which…
3
votes
1 answer

Combine multiple Rocksdb databases

There is a use case for which I have to read huge Parquet file and convert into Rocksdb binary, So I decided to use spark (because everybody is familiar with it in my team). And from Rocksdb side I know it's not distributed and you can not…
Kaushal
  • 3,237
  • 3
  • 29
  • 48
3
votes
1 answer

How does YugaBytes performance compare between Redis client and Postgres client for simple Key-Value schema?

Given that YugaByte offers client drivers for Redis and Postgres, I was wondering about performance differences between the two if used in similar fashion. For example, assume a Postgres table with 2 columns, 1 VARCHAR as the primary key and 1 TEXT…
3
votes
1 answer

DynamoDB: Is adding an item using list_append atomic?

The FAQs for DynamoDB says: Q: Does DynamoDB support in-place atomic updates? Amazon DynamoDB supports fast in-place updates. You can increment or decrement a numeric attribute in a row using a single API call. Similarly, you can atomically add…
3
votes
2 answers

Cassandra Error: "Unable to complete request: one or more nodes were unavailable."

I am a complete newbie at Cassandra and am just setting it up and playing around with it and testing different scenarios using cqlsh. I currently have 4 nodes in 2 datacenters something like this (with proper IPs of…
user3376961
  • 867
  • 2
  • 12
  • 17
3
votes
1 answer

Difference between Transaction Co-ordinator and Transaction Manager

What is the difference between Transaction Co-ordinator and Transaction Manager in context of Distributed Database Management System?I tried finding it on Internet and the only information I got is that the Transaction manager manages(how?)…
Pranay Binju
  • 591
  • 1
  • 6
  • 14
2
votes
1 answer

Distributed database - Eventual Consistency Implications

I've been learning more about eventual consistency and distributed database, and I have a question. In my scenario, I have a distributed database that stores some listings users have posted (for example, a real estate listing site). My understanding…
Jeff Storey
  • 56,312
  • 72
  • 233
  • 406
2
votes
0 answers

looking for code that produces a Clustered Affinity Matrix used in database vertical partitioning

Before I spend time writing it myself, does anyone have pointers to implementations (in any language but Python, Java, C, C++ would be preferred) of algorithms that are used in database vertical partitioning? Specifically, I'm looking for code that…
user897865
  • 35
  • 4
2
votes
2 answers

What is meant by Distributed System?

I am reading about distributed systems and getting confused with what is really means? I understand on high level, it means that set of different machines that work together to achieve a single goal. But this definition seems too broad and loose. I…
2
votes
1 answer

Add on-premise CockroachDB node to a cluster hosted in Kubernetes

I'm planning to deploy a small Kubernetes cluster (3x 32GB Nodes). I'm not experienced with K8S and I need to come up with some kind of resilient SQL database setup and CockroachDB seems like a great choice. I wonder if it's possible to relatively…
Xkonti
  • 109
  • 1
  • 11
2
votes
2 answers

Which distributed SQL databases put data from different tables with the same tenant in the same node?

I’m designing a SQL data schema with many tables that have a compound primary key of (customer_id, id). The application will frequently need to run JOIN queries to assemble data. However, it should never run cross customer joins. (Strictly…
Calebmer
  • 2,972
  • 6
  • 29
  • 36
2
votes
1 answer

Why secondary indexes are less efficient in Cassandra?

I read in Cassandra documentation that creating secondary index is less efficient as because in worst case it need to touch all nodes in order to find out the data of that non-key column. But my doubt is even if we do not create secondary index,…
2
votes
2 answers

Distributed database synchronization

I am trying to understand at a conceptual level , how are databases synchronized when they are largely distributed. eg a rail/airline reservation system. Do each of the market leaders have their own proprietary solution to handle this scenario? Are…
Ricko M
  • 1,784
  • 5
  • 24
  • 44
2
votes
1 answer

How to use laravel notifications for serialized models in a cross database setup?

My current setup is that User and Notification are saved to my main database, Post is saved to a different database. User and Notification db connections are: protected $connection = "main"; and Post db connections is: protected $connection =…
HelloThere
  • 840
  • 10
  • 18
1
2
3
12 13