The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
18 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() ...
-2
votes
0answers
42 views

How do Airline booking sites collect data from various airlines? [closed]

Do they sync their data periodically? What kind of technical terms apply for search in such cases?
1
vote
1answer
70 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 ...
1
vote
1answer
57 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
40 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
80 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
124 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
172 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
87 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) ...
2
votes
2answers
678 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 ...
8
votes
1answer
217 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 ...