Questions tagged [distributed-databases]

The tag has no usage guidance.

17 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
636 views

Upgrading Remote Distributor in SQL Server Replication

I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2. Script ...
2
votes
0answers
122 views

Distributing MS Access Database

I develop an application that saves records in MS Access DB. Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is ...
2
votes
0answers
402 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
2
votes
1answer
455 views

Distribute records on different MySQL databases - MySQL Proxy alternative

My scenario is the following: Right now I am using one big MySQL database with multiple tables to store user data. Many tables contain auto increment columns. I would like to split this into 2 or ...
1
vote
0answers
10 views

details on how to connect to geographically close datacenter

I am reading a book about distributed systems. One of the options of data replication mentioned is the use of a "multi leader" approach and place each leader in a different datacenter. The main point ...
1
vote
0answers
214 views

Error on cassandra-3.11.3-1.noarch centos7

I've a cluster consisting of 5 cassandra nodes. The cassandra version used is cassandra-3.11.3-1.noarch The keyspace strategy and is defined as follows: CREATE KEYSPACE my_keyspace WITH ...
1
vote
0answers
13 views

Is a distributed database needed for a low-data use, quick read, low write, AP system?

this may not be the proper place to ask this question, but I was not welcome posting it on StackOverflow so I thought this may be a good place. If this is the wrong place, please refer me to the right ...
1
vote
0answers
62 views

NuoDB - Where's the catch?

I've been reading on the promise of an ACID compliant database management system without sacrificing horizontal scaling capabilities. Where is the catch? Which part of the CAP theorem did they choose ...
1
vote
0answers
146 views

Git as distributed and decentralized storrage with regard to ACID and CAP

When using Git to store documents distributed and decentralized it can be considered as a database. How would the ACID properties and the CAP theorem correspond to git in this case? I think one has ...
1
vote
0answers
92 views

What's an example of a Distributed Database Query?

Since I may not come across or get a chance to use a distributed database system. I would like to understand an example of a Distributed Database Query. I know that in a distributed system, you have ...
1
vote
0answers
56 views

Is it possible to have a partition to distribute transaction load horizontally in SQL Server 2016?

In Cassandra, you can have a partition key to align partitions to particular server nodes. My understanding is that you can distribute transactional responsibility horizontally in SQL Server 2016 (...
1
vote
0answers
250 views

Implementing a unique primary key for distributed databases

I've got an issue to find a way to create a global primary key to a given relation (namely "Patient") In a distributed database there are three local sub-systems: surgery department, emergency ...
1
vote
0answers
37 views

Does the consistency part of the CAP theorem apply to updates and not first-time writes?

Using this definition of the CAP theorem: Consistency All database clients see the same data, even with concurrent updates. Availability All database clients are able to access some version of ...
0
votes
1answer
34 views

NON-Random UUID keys in custom distributed DB

Is there any reason other than security for using random (or even semi-random) UUIDs as primary keys to database records? Is there any reason why I should not WANT to be able to use the UUID to ...
0
votes
0answers
34 views

SQL Server Horizontal Partition on DDB

Hi i need to have three databases each one on one sql server that are on connected by network. The main concern is we need to have horizontal partition for a table by the id, How do we do that in ...
0
votes
1answer
64 views

generate unique primary key for all clients from the local database and NOT the server

I'm using MySQL Innodb database to work as a distributed database among many places and also each place will work offline but at the end all the data will be centralized in one server, I want to ...
0
votes
1answer
72 views

Machine learning database Big data

Which databases can I use for storing object features for machine learning use case, in case of Big data? To explain a bit more - object features basically represent an object in a form of an array ...