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.

165 questions
0
votes
0 answers

Distributed Transaction vs Message Queue

I am trying to implement distributed transactions in my current application which are working fine currently with MSDTC, the only problem is that MSDTC is only supported in windows. The alternative suggested at many places was to ditch the DTC and…
Vimalshah26
  • 23
  • 5
0
votes
3 answers

What would you recommend to read to a person who is going to write his own DB?

Since there are no answers to my previous question. I'm really thinking to implement a custom DB which will satisfy my requirements. Yes I know, sounds crazy. But what books, articles and etc. would you recommend to read? If it does matter the…
Insomniac
  • 3,084
  • 2
  • 20
  • 23
0
votes
0 answers

how would it be a entity relationship model example being distributed databases

I have tried looking for a entity relationship model using the schema of distributed database but I found diagrams as it: or I found entity relationship models but they are not using the schema of distributed database like this... I did next…
angel
  • 3,986
  • 10
  • 52
  • 82
0
votes
2 answers

Foreign key between two databases

I went through the previous answers to create a pseudo-foreign key to reference tables between two databases in Netbeans 8.1. This is the code I came up with, DELIMITER // CREATE OR REPLACE TRIGGER conf_track_FK AFTER INSERT OR UPDATE on…
Suraj Sachin
  • 1
0
votes
1 answer

Dynamically partitioning a table from main to remote mySQL server

I have a table in my DB which I need to partitionate based on a foreign key attribute. So the number of partitioned tables is the same as the number of different values present for the foreign key. EDIT: I have replication setp up, where a table in…
JuanV
  • 13
  • 4
0
votes
1 answer

mysql distributed primary key

I have different tables that need to share a pool of primary keys. E.g. table A has primary keys 0 to 9, table B has primary keys 10 to 19. Is there a way to tell mysql where to draw the primary key from? Like a stored procedure? It would be…
user3169506
  • 93
  • 1
  • 4
0
votes
1 answer

Configure hadoop/hbase in fully-distributed mode

I'm new in Hbase and I need to do some experiments with it in fully distributed mode. I am using ubuntu. I want create a cluster with two nodes (a master and a slave) and according to what I read, HBase runs under a Hadoop Distributed File System…
Pedro Cunha
  • 301
  • 4
  • 15
0
votes
0 answers

what's the difference between mysql master/slave mode and master/master mode?

It's easy to understand that master-slave mode, for example, firstly, inserting a row means that binlog will be copied to slave's machine, and secondly, ack will tell master to write the data into master's machine. But what's master/master mode do?
egraldlo
  • 133
  • 2
  • 10
0
votes
1 answer

How to change connectionsPerHost and threadsAllowedToBlockForConnectionMultiplier configuration in mongdb through mongo shell?

I need to change threadsAllowedToBlockForConnectionMultiplier and connectionsPerHost values in mongodb from their default value through mongo shell instead of a program. How can I go about it?
Siddharth
  • 1,816
  • 2
  • 23
  • 39
0
votes
1 answer

how to set up an horizantal Partiting Distributed database Enviroment between two servers

suppose that i have a database for employees and i want to distribute the queres on two different servers at differnt location , let's say location a & location b . I'm wondering how to distribute a table into two servers interconnected by network…
Abo gaseem
  • 5
  • 5
0
votes
0 answers

Distributed Configuration Problems with OrientDB: Failures, Exceptions and no Replication

I've tried to configure distributed db's with replication mechanism in OrientDB. I used the tutorial: (https://github.com/orientechnologies/orientdb/wiki/Tutorial%3A-setup-a-distributed-database) One DB is on my local host: 192.168.2.100 and the…
user3422749
  • 62
  • 8
0
votes
1 answer

Distributed Mutual Exclusion: Coterie Formation

I have been studying distributed mutual exclusion algorithms based on the concept of Quorums. Quoting: A Coterie C is defined as a set of sets, where each set g ∈ C is called a quorum. The following properties hold for quorums in a coterie: 1)…
sg1
  • 337
  • 1
  • 3
  • 20
0
votes
1 answer

Making backup from database to another server

I have a host on a server and that contains an SQL Server Database. I have another server in another country and i want have a backup from the database every 5 minutes or after each transaction only insert new row to another database. After some…
Saman Gholami
  • 3,093
  • 5
  • 28
  • 63
0
votes
1 answer

Who do large key-value stores scale better horizontally than document databases?

In this presentation there was a chart that showed the following horizontal scalability ceiling as data gets larger: key-value > column family > document database > graph database http://youtu.be/UodTzseLh04?t=13m36s In other words, as data gets…
Sridhar Sarnobat
  • 19,595
  • 12
  • 74
  • 93
0
votes
0 answers

Fault Tolerant Write-only Highly Distributed Database

Scenario: I have a database that accepts writes from a set of geographically distributed clients over unreliable links. The clients just do write operations, and possible reads on the data of their own last 2 to 3 write operations. Older data is…
Samveen
  • 3,412
  • 34
  • 49
1 2 3
…
10
11