View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

Monitoring Symmetric DS Replication Data

Contents


Bulbgraph.png   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:

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.


Outgoing-Batches-Window.png


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.


Outgoing-Data-Events-Window.png


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.


Incoming-Batches-Window.png


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

Retrieved from "http://wiki.openbravo.com/wiki/Monitoring_Symmetric_DS_Replication_Data"

This page has been accessed 301 times. This page was last modified on 15 December 2016, at 09:30. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.