Introducing DataExchange
This guide contains information about DataExchange and its capabilities. It is intended to help you design databases for replication, implement the design, replicate data, monitor and maintain replication schedules, and troubleshoot replication issues. DataExchange is designed to avoid replicating corrupt data, spreading viruses, or deleting desired data. It can greatly lessen risk of data loss and down time in the event of system failures, hardware failures, or site disasters.
The following topics introduce you to DataExchange, its editions, and its components:
DataExchange Technical Overview
DataExchange is the Zen database replication solution. It copies data between two or more Zen databases to maintain warm backup systems, drive data into reporting servers, or synchronize remote databases.
The DataExchange technology works by capturing and sharing changes from one Zen database to other databases in a DataExchange replication network. The Zen Engine is augmented with DataExchange, which adds two software components to a Zen database, the Replication Event Handler and the replication engine.
• The Replication Event Handler (REH) plugs directly into the Zen database engine. Specifically, the REH is a set of DLLs that operate within the database engine, so if the database is running, the replication event handler is running as well. The database engine activates the REH when there is a change event (insert, update, delete). The REH then makes note of the event in one of its private control tables.
• The replication engine is a separate process that performs the actual replication task. It reads the control tables to determine what records have changed since the last replication session. It then groups these changes into packets and shares them with the other replication engines participating in a DataExchange replication network. These other engines then apply the updates to their own databases. The replication process occurs either continuously, at scheduled intervals, or on demand. The replication engine does not require constant network connectivity, so DataExchange is suitable for scenarios with intermittent connectivity, like remote users with dialup connections.
DataExchange focuses on the two types of data replication:
• Providing continuous access to data (Real-Time Backup)
• Synchronizing databases (Data Synchronization)
While both capabilities are useful, one typically surfaces as the primary driver for implementing data replication technology in a specific environment.
Notification Agent
The notification agent, or agent for short, is another component installed by DataExchange. Its purpose is to send email if a replication failure occurs. The agent requires the basic Simple Mail Transfer Protocol (SMTP) to communicate with a mail server.
For more information, see
dxagent.
Replication-Specific Files
DataExchange adds its own tables on the machine where replication executes. It uses two types of tables: system configuration and replication control. Configuration tables record information such as the databases being replicated, the sites to which data is replicated, and replication schedules.
Control tables shadow data files and track the replication state of each record in the data. Each data table or file has a control table counterpart. Similarly, each data record has a companion control table record. Through the control tables, the replication engine determines what records need to be replicated when.
DataExchange tables for replication configuration and control can reside with the files to be replicated or separately in their own database. The choice of location depends on your replication needs.
DataExchange Editions
DataExchange is available in two editions: Real-Time Backup and Data Synchronization. The following table compares the two editions.
Real-Time Backup Edition
DataExchange Real-Time Backup Edition is optimized for maintaining a backup server. It pairs high performance with minimal installation and maintenance. This edition supports 1-way replication between a primary server and a backup server.
Real-Time Backup solutions can be on- or off-site, depending on your needs. On-site backups can protect your data from hardware failures. Off-site backups can add protection against catastrophic loss, such as fire, flood or theft.
Data Synchronization Edition
DataExchange Data Synchronization Edition is designed for both one- and two-way replication scenarios. Its real-time data replication ensures all users see the same up-to-the-minute information.
DataExchange Components
DataExchange consists of the following primary components:
• Replication engine – Used for distributing and applying captured database changes
• Replication Event Handler (REH) – Used for recording or monitoring database change events
• DataExchange Agent – Used to provide notification in the event of a replication failure
• DataExchange utilities – Used to perform the tasks necessary for replication, such as design and activation
• DataExchange documentation – Provides concepts, instructions, and examples
DataExchange Utilities
DataExchange utilities help you configure and manage the replication process.
Documentation
DataExchange User's Guide includes conceptual and procedural information related to installation and configuration and design and deployment of a replication network. This guide covers both the Real-Time Backup and the Data Synchronization editions of the product. Many procedures for the two editions are identical or nearly so. Where differences occur, they are noted.
Where to Install DataExchange
DataExchange must be installed on the same system as Zen Enterprise Server. See also
Preparing to Install DataExchange.