Questions tagged [distributed-databases]
The distributed-databases tag has no summary.
82 questions
0
votes
1
answer
52
views
Unable to Delete Database - Chunks Stuck in "Recovering" State
I'm encountering an issue where I cannot properly delete a database because some chunks are in "recovering" state.
Environment:
DolphinDB Version: 3.00.2.4, Single mode
OS: Centos 7.7
What ...
- 3
0
votes
0
answers
25
views
Designing scalable sensor data storage: wide table vs single table per sensor in DolphinDB
I'm designing a system to store large volumes of sensor data (10,000+ sensors) and evaluating different schema approaches in DolphinDB.
Current Context:
Data Volume: 10,000+ sensors, continuous time-...
- 1
0
votes
0
answers
27
views
How to update complex data structure in RocksDB?
I have been working with RocksDB for a while, and in my use case, complex data structures are stored as values in the database — for example, a Map that may itself contain nested maps.
1. Update ...
0
votes
1
answer
67
views
Strict Serializable vs Serializable Transaction Latency and Throughput
Is the transaction latency and throughput performance in the distributed database with a consistency level of strict serializable significantly lower than serializable?
I'm already trying to ...
- 1
0
votes
1
answer
101
views
I need to move from sqlite to a distributed setup. What are my options?
I have an sqlite db that has grown to 30gb and I'm still pushing data to it everyday. I have a couple services that write to it using libsqlite3. Soon it will become too big to keep locally. What is ...
- 103
0
votes
0
answers
27
views
Distributions when only one physical node
Working on Azure Synapse, we have for now around 30 tables on a dev environment.
I want to optimize the tables before replicating them in qal and prod env.
As far as I understand, we only have one ...
1
vote
2
answers
240
views
Safe upgrade routine for Cassandra
I've been tasked with upgrading an Ubuntu based Cassandra cluster - having no prior experience with Cassandra.
I've tried digging through the docs but have been unable to find any instructions on how ...
- 113
0
votes
1
answer
6k
views
The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log
Can someone help me with the issue I'm dealing with? I had to force failover from my primary datacenter to my secondary datacenter and I forgot to disable the log backup job. Meanwhile the new ...
- 1
0
votes
1
answer
57
views
Should I create 2 different databases if they would keep 70% similar data?
I am writing a microservices based NodeJS-Cassandra application and I haVe few services they would need 70% similar data( like username, avatar, videos, etc.) and I am just wondering to know is it a ...
- 117
3
votes
1
answer
195
views
How do distributed databases follow unique constraints?
Lets say i have an application where user can register, and the username has to be unqiue value.
Now lets say i have N partitions and for each partition i have M replicas with multiple leaders.
Now i ...
- 131
1
vote
3
answers
827
views
What is the real advantage of using a UUID instead of an auto-incremented element?
I've been looking at resources to understand UUIDs. I now understand what they are, but I still don't really see where they are truly useful.
Most of the information I've found revolves around the ...
- 111
0
votes
1
answer
251
views
How repeatable read isolation level and others are implemented in distributed/replicated databases?
I'm studying distributed systems/DBs and I'm struggling understanding isolation levels when we talk about distributed systems.
Avoiding problems like dirty read, non-repeatable read, phantom reads, ...
- 1
9
votes
3
answers
8k
views
Why is it more difficult to horizontally scale a relational database than a NoSQL database like MongoDB?
Is the main reason for the difficulty in horizontally scaling / distributing an RDBMS because of an adherence to ACID transactions? Is it the fact that multiple tables are so interconnected, or ...
- 201
1
vote
1
answer
791
views
Multi master vs leader-follower
Sorry if I ask this basic question. I am reading different articles and trying to understand how it works.
Lets suppose I have two master DB(MySQL) in two different availability zone and two different ...
- 11
0
votes
1
answer
437
views
Shortest paths on huge graphs: Neo4J or OrientDB?
Kia Ora,
I have a program that very frequently requires finding the fastest path (both the node sequence and total cost/length) on graphs containing ~50k nodes. Per run, I require on the order of ...
