Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data-replication]

The tag has no usage guidance.

2
votes
1answer
41 views

How does client connect to replication server in oracle?

I have read couple of articles on google but not sure how DB client for example java application connect to clustered DB. All the articles I read says client will write at master node but will use ...
1
vote
0answers
62 views

Disaster Recovery Database Switchover options

Some info on the current setup: We're currently using database replication - transactional replication, to be specific - between 2 servers. For sake of this post, we are replicating from a PRIMARY to ...
0
votes
1answer
302 views

Keeping customer data in sync between master and multiple clients

We have a master system storing customer data. Data is replicated to client systems (channels) at night. During the day data can be updated by users/customers on the master as well as on the clients. ...
0
votes
1answer
43 views

design implementation for a postgres database in a not connected environment

I have several postgres DB, on distant sites, two in China, 1 in India , one in Korea, one in Germany, one in France and one in Mexico. All dbs, regardless of their site, have one table that is part ...
1
vote
2answers
133 views

Is caching data between independent but interacting systems okay?

We have two products let call them X and Y. Product-X is established and has numerous clients over continents whereas Product-Y's development was started a few years ago and it has yet to enjoy any ...
-1
votes
1answer
149 views

How can a multiplayer game manage state over a local network? [closed]

I would like to create a multiplayer mobile game where players play together over an ad-hoc network, with no internet connection required. Players should be able to join and leave mid-game, and the ...
0
votes
1answer
344 views

MongoDB capped collections

I'm not really sure if that is right "stack" to ask that question, well two questions actually. What's the potential use for capped collections? (besides logging) Capped collections cannot be sharded,...
1
vote
0answers
46 views

Notify external services about changes to data in a database (sanity check)

I'm working on a project which revolves around a database of about 750.000 entities. Let's just say these entities are musical works. Each musical work is associated with an album, one or more ...
0
votes
2answers
587 views

Did I beat the CAP Theorem with this master-slaves distributed system (with picture)?

I was watching this video about the CAP theorem, where the author explains well the trade-offs of distributed systems. However I disagree with the CAP theorem in the following aspect. Given the ...
1
vote
1answer
208 views

Why does MySQL slave receive two ROTATE events?

I am experimenting with the mysql-binlog-connector-java library for Java. When running sample queries and observing the sequence of replicated events I noticed that the ROTATE event is received twice (...
1
vote
0answers
455 views

Vector clock conflict resolution in event sourced system via local timestamp - is this safe?

We have an occasionally connected, event sourced system: a budgeting application where each client can pull other client's event store from a separate storage (network share, dropbox,...). It is our ...
1
vote
2answers
110 views

Name for Keeping Multiple Copies of a Variable

There is a bad practice in software engineering where a single piece of data is held by value in multiple places. For example, in an FPS, the location of the player could be held by the AI class, the ...
4
votes
1answer
260 views

In a master-slave replication mechanism, how do you avoid / cope with the fact that the master is a single point of failure? Is there a solution?

So master-slave replication is great, but it leaves the master as a single-point of failure. What is the strategy to solve this problem, if there is one? I'm looking for the computer science theory ...
5
votes
3answers
78 views

What are the theory behind implementing two mirrored HashMaps that can accept write operations? Do I need a broker to mediate conflicting writes?

So imagine two HashMaps that need to be mirrored across two different machines, A and B. Whenever I make a modification to machine A, machine B sees it and vice-versa. Problem is: These two hash maps ...
2
votes
2answers
846 views

Using ESB for database synchronisation / replication

We're starting to look at implementing an ESB / Microservices architecture. I (think) I know about the concepts, but there's one thing I don't seem to be able to get a good idea about: data ...
1
vote
1answer
96 views

Sequencing distributed tasks with a distributed DB

Background I have two separate processes, WriteIt() and ReadIt(). One creates records, and the other processes the records in a DB cluster. Once WriteIt() creates a record, it queues a ReadIt() ...
3
votes
1answer
2k views

how to decide when to use database replication vs. custom REST applications vs. message brokers (pub / sub)

We have a distributed solution that's currently under design. There are a few points of integration where some application needs data from someone else and vice versa. We could solve by either ...
3
votes
1answer
80 views

Is there a term for data being written not being immediately available to be read?

Here is a problem I've repeatedly observed over the years: a thread writes to something (database record, LDAP entry, etc.) very soon afterwards, the same thread tries to read the record it just ...
0
votes
1answer
814 views

Large volume report operations, how best to replicate transactional data

We are overhauling a legacy accounting app that has some large reports. One concern that has been raised is due to the transactional nature of the data, if we start a long running report how do we ...
3
votes
1answer
334 views

Filesystem superblocks and their backup copies

I'd like to understand how (modern) filesystems are implemented and having trouble to fully understand superblocks and their backups. I reference ext4 and btrfs, but the questions may also apply to ...
0
votes
1answer
561 views

database replication or custom solution like creating enterprise “bus”

I'd like some input on how to keep databases that are running on different servers throughout our organization synchronized. We have a registration system of sorts, and when user "John Doe" registers ...
0
votes
1answer
382 views

Geographically Distributed (Data & App) Architecture

Is there any design patterns (or best practices) for implementing a geographically distributed system (mostly a database)? Description: There is a network of warehouses and a central office. Now I ...
3
votes
1answer
120 views

MySQL setup for remote site failover

I'm designing a custom web-based inventory management and workflow system for a client of mine. One of their remote sites has fairly sketchy internet access, and needs to have no (or very little) ...
4
votes
2answers
3k views

Scalability: How does splitting a database table work on different replicated SQL Servers?

I would like to know more about the general concepts behind dividing data of a database into different servers. For example, suppose I have a SQL Server database which has a massive table. Assume one ...
9
votes
1answer
270 views

DVCS blessed repo replication among geographically distributed teams

My company is exploring the move from Perforce to a DVCS and we currently use lots of Perforce proxies because the software development teams are spread over Germany, China, USA and Mexico and ...