Projects:Store Server Replicating Transactional Tables Research
Introduction
This project is a research/prototype project to validate if it makes sense to replicate transactional data from one server to another.
The approach to replicate transactional data is very different from the current approach in which only master data is replicated and transactions are replayed on multiple servers.
For more information see this presentation.
The tasks in this project are:
- add all relevant transactional tables to the synced tables window
- implement a preference-controlled approach to the synchronized mode. So that a transaction is not replicated through import entry but always executed only on one server
- implement a generic approach for recomputing balance/computed data such as inventory levels after replication transactional data.