Monitoring Symmetric DS Replication Data
Contents |
 | This feature is available starting from 17Q1. |
Introduction
Symmetric DS continuously captures the changes in the database and replicates the changes to the nodes (Store Server) in the network. Within the OB solution we provide several windows to see the current and previous data being replicated by Symmetric DS. This wiki page gives an overview.
Note that Symmetric DS replicates data quite fast and Openbravo is a web application. So when viewing Symmetric DS data in an Openbravo window in the brower it might be possible that Symmetric DS already replicated the data or in another way changed it in the background.
Monitoring All Data Flow from the Central Server
There are 2 data flows/directions in the Openbravo multi-store-server environment:
- from the Central Server to the Store Servers
- from the Store Servers to the Central Server
Most replication will be from the central to the store servers. For both directions you can view/monitor the data flow and potential errors from the central server.
Outgoing data flow from the Central Server to the Store Servers can be monitored through the Outgoing Batch and Outgoing Data Events window.
Incoming data flow from the Store Servers to the Central Server can be monitored through the Incoming Batch window.
So with the provided windows Openbravo provides a complete view on all the data flows within the Openbravo multi-server architecture.
Symmetric DS Outgoing Batches
The Symmetric DS Outgoing Batches window provides a view on all outgoing batches. This includes batches which have already been replicated and batches in error or waiting to be synchronized.
The window shows the content of the Outgoing_Batch table of Symmetric DS. For detailed description of its fields see the Symmetric DS documentation or the online help within the Openbravo window.
Note: this window shows the content of a non-Openbravo table. This means that filtering in the window works slightly differently than with other Openbravo windows. Normally text filtering works only on exact matches (equals) so not as startswith/contains. In addition for numeric fields only the operators <, <=, > and >= are supported
Symmetric DS Outgoing Data Events
This window shows the captured data change that occurred to a row in the database. Entries in data are created by database triggers. It also shows data records which are not yet routed, in that case the batch id is not set.
The window shows the content of the [1] table of Symmetric DS. For detailed description of its fields see the Symmetric DS documentation or the online help within the Openbravo window.
Note: this window shows the content of a non-Openbravo table. This means that filtering in the window works slightly differently than with other Openbravo windows. Normally text filtering works only on exact matches (equals) so not as startswith/contains. In addition for numeric fields only the operators <, <=, > and >= are supported
Symmetric DS Incoming Batches
The incoming batch window is used for tracking the status of loading an outgoing batch from another node/server. Data is loaded and committed at the batch level. The status of the incoming batch is either successful (OK) or error (ER).
Note that the primary key/unique identifier of records in the incoming batch view is the combination of batch id and node id (store). So batch ids are not unique by themselves and you can see the same batch ids from different stores.
The window shows the content of the incoming_batch table of Symmetric DS. For detailed description of its fields see the Symmetric DS documentation or the online help within the Openbravo window.
Note: this window shows the content of a non-Openbravo table. This means that filtering in the window works slightly differently than with other Openbravo windows. Normally text filtering works only on exact matches (equals) so not as startswith/contains. In addition for numeric fields only the operators <, <=, > and >= are supported