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.

165 questions
3
votes
1 answer

How do I prevent malicious DHT clients that might want to alter/delete my DHT data?

Okay, so lets say I have a DHT running with 10 clients with a bunch of data in it. Wouldn't it be relatively easy for a malicious client to run an alternate version of my program, that could do potentially destructive actions to my data(such as…
thouliha
  • 4,762
  • 4
  • 32
  • 46
3
votes
2 answers

steps for making a non-distributed db to distributed db [talking about lmdb specifically]

I am dealing with lmdb and lmdb is really fast . But one problem with it is lmdb isn't distributed . Everytime i need to do some maintenance , lmdb has to taken down and sites is unavailable for few hours . I researching on making lmdb a…
igauravsehrawat
  • 2,959
  • 1
  • 28
  • 44
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
  • 53,386
  • 69
  • 224
  • 390
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
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,584
  • 4
  • 21
  • 41
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 =…
Deyi Kong
  • 469
  • 4
  • 15
2
votes
3 answers

Presto vs Impala: architecture, performance, functionality

Could you highligh major differences between the two in architecture & functionality in 2019? And how that differences affect performance? For some reason this excellent question was tagged as opinion-based. Extra-question: why Amazon decide to go…
VB_
  • 43,322
  • 32
  • 111
  • 238
2
votes
1 answer

Key-Value storage with realtime multimaster replication

Are there any opensource distributed key-value storage which satisfy following conditions. Almost real-time multimaster replication. (tie-breaker will be based on timestamp and not anything more complicated) Each node should be able to work with…
2
votes
1 answer

Accessibility of data using different APIs

Can I access the same data using different APIs? Example: Can I insert the data using YCQL and read it using YEDIS?
Ricardo Adam
  • 115
  • 5
2
votes
1 answer

How is YugaByte DB's replication model?

How similar or different is YugaByte DB's replication model compared to PostgreSQL master-slave replication?
2
votes
1 answer

application.properties configuration for distributed database pattern

I am trying to develop a microservice by using sprin and spring boot with postgresql database. I am here using distributted datbase. So for particular region I am using one DB, and for other region I am using different DB. Currently I only tried…
Jacob
  • 3,102
  • 4
  • 37
  • 77
2
votes
1 answer

Orient DB distributed replica on embedded server

We are setting a distributed OrientDB database on an embedded server (we are using OrientDB v.2.2.31). We would like to have a master-replica configuration, but we have encountered some issues in doing that. We have setted the…
2
votes
1 answer

How to shard only specific tables using vitess

I have created an unsharded keyspace with three tables. Now I would like to shard my keyspace for first two tables but don't want to shard the third table. How can this be done? Vitess documentation does not contain any info or example regarding…
manojadams
  • 2,004
  • 3
  • 24
  • 29
2
votes
0 answers

Communication link failure: JDBC

I have a MySqlConnection class for a distributed database in 3 cities. I want to access to 3 different IPs, but when the program tries to connect to a node, JDBC shows an exception of "Communications link failure". The code is the next one: public…
1
2
3
10 11