Stack Overflow
Stack Overflow

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
2
votes
1 answer

How DynamoDB provisions throughput of reads independently of writes

Amazon DynamoDB allows the customer to provision the throughput of reads and writes independently. I have read the Amazon Dynamo paper about the system that preceded DynamoDB and read about how Cassandra and Riak implemented these ideas. I…
Jeff Walker Code Ranger
  • 4,634
  • 1
  • 43
  • 62
2
votes
1 answer

distributed database design pattern

I have multiple databases on different servers and one of the servers is across a WAN. The app needs to access data on all the servers and potentially join one tableA on ServerA (local) and TableB on ServerB (across WAN). What is the best design…
uomolupo
  • 77
  • 4
1
vote
1 answer

How to handle data migrations in distributed microservice databases

so im learning about microservices and common patterns and i cant seem to find how to address this one issue. Lets say that my customer needs a module managing customers, and a module managing purchase orders. I believe that when dealing with…
Kamil Bęben
  • 1,064
  • 8
  • 12
1
vote
1 answer

The relationship between Paxos family and data consistency

Paxos, a kind of consensus algorithm, plays a vital role in distributed database systems. It can be used to make the distributed system chooses the same proposal. Data consistency is a big problem in the database system. Others consisder that Paxos…
dengzeyuan
  • 13
  • 2
1
vote
1 answer

Strong consistency and replication factor

I am trying to improve my knowledge in distributed databases and the various levels of consistency that could be achieved. First, let me define some terms I will use (please, tell me if I am wrong): strong consistency: as reported by dr. Kleppmann…
roberto
  • 13
  • 2
1
vote
1 answer

How the hash function by partitioner in Cassandra is decided for a particular data set to ensure even distribution of data across multiple cluster?

As we know from Cassandra's documentation[Link to doc] that partitioner should be such that the data is distributed evenly across multiple nodes to avoid read hotspots. Cassandra offers various partitioning algorithms for that - Murmur3Partitioner,…
khush
  • 2,702
  • 2
  • 16
  • 35
1
vote
1 answer

What is being distributed in a distributed database?

What is being distributed in a distributed database? Processing logic : processing logic or processing elements are distributed Data : used by a number of applications may be distributed to a number of processing sites Control …
Arbaz Ali Khan
  • 21
  • 1
1
vote
1 answer

How to design a distributed write-heavy data store

It's actually an interview question I'm thinking of for 2 month and can't find a suitable architecture. The problem We want to build a small analytics system for fraud detection on orders. System has the following requirements Not allowed to use…
Andriy Shevchenko
  • 1,117
  • 6
  • 21
1
vote
1 answer

Do cross-partition queries break infinite CosmosDB horizontal scalability?

As I understand, when you perform a query that doesn't filter by one primary key, you perform a cross-partition query. For this to be executed, the query is sent to all physical partitions of your CDB collection, executed in parallel in each of…
Michael Tontchev
  • 909
  • 8
  • 23
1
vote
1 answer

Setting up a distributed database with TimescaleDB

I am working on a project that uses TimescaleDB as a database storage for data that is about 6 TB in size. It is setup as an instance on AWS EC2. If I understand clearly, TimescaleDB has the concept of Hypertables which basically performs chunking…
Alpha Bing
  • 31
  • 3
1
vote
1 answer

Are passwords for system users/roles stored in encrypted form in YugabyteDB YSQL and YCQL?

When we create users/roles (see examples below) how are the passwords stored persistently? Are these stored in some encrypted form, and not as plain text? # YSQL CREATE USER tester WITH PASSWORD 'test_password'; or, # YCQL CREATE ROLE IF NOT EXISTS…
Charlie O'Riely
  • 87
  • 6
1
vote
1 answer

How do i add to a existing value in cassandra?

I'm writing a streaming application which requires me to add or substract a incoming value to a pre-existing value in my cassandra table. I have seen the batch documentation of cql, but have not figured out a solution to my problem yet. here is a…
Kush Singh
  • 157
  • 3
  • 11
1
vote
1 answer

Scaling the System and its Database for 10k request handling. What's right Sharding or Microservice going for Distributed database

"Inability of MySQL to scale write requests beyond one node became a killer problem as data volumes grew leaps and bounds. MySQL’s monolithic architecture essentially forces application-level sharding.The development and operational complexity grows…
Amit Gupta
  • 633
  • 1
  • 8
  • 19
1
vote
1 answer

In YugabyteDB YSQL, how can we track the number of active connections on each server?

How can we track the active connections to a yb-tserver at a given time, and what client IP address the connection is originating from? Mostly need this for debugging purposes.
Charlie O'Riely
  • 87
  • 6
1
vote
2 answers

Can DDS be used over the internet for use in online gaming?

I was wondering if DDS could be used over the internet, and if it would be a good choice for online gaming. I have seen on the RTI website that they support WAN, but does that mean I can subscribe to a topic from another participant that is on the…
Blue7
  • 1,750
  • 4
  • 31
  • 55
1 2 3
…
12 13