Questions tagged [data-replication]
Maintaining a set of identical copies of the same data
37 questions
-2
votes
1
answer
227
views
What is the difference between Eventual Consistency, Strong Eventual Consistency, and Causal Consistency?
I read articles about CRDTs and frequently come across the terms 'Strong Eventual Consistency,' 'Eventual Consistency,' and 'Causal Consistency.' What is the relationship between these consistency ...
- 11
1
vote
2
answers
162
views
Database per Tenant using SQL Server [closed]
I am looking to create an application which will have following architecture:
Site Database (Which will run on-prem or cloud). If multiple sites then multiple database instances for each site. In ...
3
votes
3
answers
432
views
How to reliably determine changes in a DB table since some sort of "checkpoint"?
My scenario is fairly typical, but I can't figure out a good solution. I have a DB table (in reality several unrelated tables, but let's focus on one) where there is a fair deal of activity going on. ...
- 5,440
0
votes
0
answers
56
views
How to handle multi-region writes for a joint user registration?
UserA and UserB are signing up for some joint service together. They both have to independently agree to T&Cs before sign-up is complete. Once complete they both receive an email to sign-in.
A 1 ...
0
votes
0
answers
94
views
Data Replication Without Messages
We have a legacy API service and database at my workplace.
My team works on a mobile app that uses this API for some particular data. You can think of this as DDD - our service shares some entities ...
- 101
0
votes
1
answer
105
views
Data backup/slave node with replicated data, to be writeable while master is offline
I'm developing and designing a system which runs mostly on intranet of client companies. The system consists of one main database which is MariDB, for now one web-application as system management and ...
- 11
1
vote
1
answer
1k
views
Full, 2-way table synchronization
I need to synchronize tables of data between two different systems. This is a multi-master setup; data can get changed in either system. After a synchronization runs I'd like the data in each table to ...
- 171
0
votes
0
answers
72
views
What is best approach to designing a local-to-cloud cloud-to-local Infrastructure?
I plan to have a cloud web application(CWA) and several local web application(LWA), let's assume 3 LWAs and 1 CWA. CWA === LWA.
This web application would consist of a database server, file storage ...
- 109
2
votes
1
answer
213
views
Can passive and active replication handle byzantine failures?
Currently studying about replication and I was wondering:
In Passive replication, we have an agreement stage where the Primary replica manager (RM) waits for ack from the backup RM, wouldn't it be ...
- 131
8
votes
2
answers
4k
views
What's the difference between active-active failover and master-master replication?
As we may know, there are two main high availability patterns: fail-over and replication.
In active-active failover, both servers are managing traffic.
In master-master replication, both masters serve ...
- 189
1
vote
0
answers
74
views
Partial database synchronisation across multiple databases
Currently we are looking for a solution to sync databases across multiple locations. We a location hierarchy such as Country -> State -> District -> Center. To increase speed and reliability of the ...
- 11
0
votes
1
answer
107
views
How to keep user inputs consistent with assumed inputs to slow computations at the backend?
Background:
I'm writing a clinical trials simulator. The user defines future trial options, eg a trial with 100 placebo patients, 200 treatment patients, "optimistic" outcome scenario, etc. There can ...
- 853
2
votes
1
answer
111
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,896
2
votes
0
answers
123
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 ...
- 269
0
votes
1
answer
1k
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.
...
- 109