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
1
vote
1 answer

How to apply a global query on the distibuted database tables that I have created

I have created 4 tables(Mumbai, Bangalore, Pune, Delhi) with customer information In all 4 tables, I have a bill amount table column in my table, I want to display the sum of bill Amounts of all tables from Highest to lowest. I have used the…
Glen Veigas
  • 85
  • 1
  • 12
1
vote
1 answer

itgendid012: Last part of the SQL statement has not been recognized on distributed Exact Online query

When I connect to a distributed database containing one Exact Online country (alias 'eol') and SQL Server (alias 'sqlserver'), I get an error when executing the following query to get the RGS balances from the current company over 2017: select *…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
1
vote
1 answer

How to update master table while updating materialized view

I have three sites,one site contians the employees table, while the other sites have materialized view of employees table . This is how i created the materialized views on the other sites. CREATE MATERIALIZED VIEW employeesMV REFRESH FAST FOR…
Húsàm Shüjáàdiiñ
  • 43
  • 7
1
vote
1 answer

Getting error while trying to merge shards using vitess

I have sharded a single table from a single shard(0) into two shards(-80 and 80-). After sharding I deleted the shard 0, its tablets and recreated the shard 0 again. I am trying to merge shards -80 and 80- to 0 but getting the following error while…
manojadams
  • 2,314
  • 3
  • 26
  • 30
1
vote
0 answers

Where to begin to learn Bloomberg's distributed DB Comdb2?

I plan to learn from its source code about how it provides perfect availability,no concurrency, Single System Image. Besides their wiki, is there any developer group where people could ask development related question? Is there design document to…
user3053227
  • 63
  • 2
  • 8
1
vote
2 answers

Join to 1 row table takes too much time

I am trying to read all product codes (mal_no columns) and quantity data (adet columns) from a table ( which is "hso" table and indexed by mal_no, all the tables below have indexes for mal_no) but even if it has only 1 row of data it keeps running…
acayipadam
  • 11
  • 1
1
vote
2 answers

cassandra getendpoints with partition key has space

my partition keys are id(int) and name(text). Below command works fine until there is no space in name(text). nodetool getendpoints test testtable2 1:aaa; if am using nodetool getendpoints test testtable2 3:aac cc; it throws an error as :nodetool:…
Sid
  • 173
  • 2
  • 15
1
vote
1 answer

Synchronizing keyspaces in new cassandra datacenter

I have a question about a potential scenario and wanted to know if our assumption is correct. (using cassandra 3.x with DSE 5.x) We've learned from the docs that in order to add a new (and fresh) datacenter to a cluster, we need to temporarily set…
NodeNodeNode
  • 744
  • 5
  • 23
1
vote
3 answers

Distributed Database Computing - Is it really possible within the RDBMS paradigm?

I am asking this in the context of NoSQL - which achieves scalability and performance without being expensive. So, if I needed to achieve massively parallel distributed computing across databases ... What are the various methodologies available…
GilliVilla
  • 4,998
  • 11
  • 55
  • 96
1
vote
1 answer

DistributedTransactions on Linux

I am new to Distributed databases and the initial roadblock am facing is to have a distributed transaction across heterogeneous databases where the control goes to Transaction Manager which is mostly the OS implementation (MSDTC in Windows). How are…
Vimalshah26
  • 23
  • 6
1
vote
1 answer

How to add second node in NosDB opensource?

I am trying NosDB, created database cluster on single node, and than added second node in my database cluster, but I am failing with error message, "Add-Shard : Login 'asif_mehmood' does not exist". Steps I perforemd: Installed NosDb…
Asif Mehmood
  • 71
  • 8
1
vote
1 answer

transaction rollback for multiple databases

I was asked a question recently during an interview. Question is: I have two different databases and I need to update tables on both databases. We want data consistency. I updated table in first database, then while updating second database I…
user1474111
  • 1,356
  • 3
  • 23
  • 47
1
vote
1 answer

Theoretical results of consensus protocol in primary-backup distributed system

I am picking up knowledge of consensus protocols in a distributed system. Such a distributed system does primary-backup on databases. I learned that "every consensus protocol can loop forever." from Leader election for paxos-based replicated key…
Patrick Chan
  • 76
  • 8
1
vote
1 answer

DynamoDb safe update

I am trying to update a counter in my simple database (one key, one numeric value). Atomic counters seem the natural solutions, but I need thread safe updates, i.e. I need to make sure that updates do not interfere with each other. This answer seem…
meto
  • 3,425
  • 10
  • 37
  • 49
1
vote
1 answer

Creating a database in Orientdb in distributed mode

Our system creates OrientDB databases programmatically and uses one database for each customer (before anyone jump on dismissing this design, the reasons are security, possibility to move certain customer/data between datacenters/regions and the…
Heintz
  • 41
  • 7
1 2 3
…
12 13