|
Pervasive DataExchange Product Information
Pervasive DataExchange is the replication solution from Pervasive
Software, designed to provide data portal solutions, data
continuity solutions, and data synchronization solutions to
users of the Pervasive database products.
DataExchange installs a component to your database engine
called the Replication Event Handler that captures all changes
to all data files in your configured replication environment.
These changes are stored in a set of data files that helps
define your replication network. You can configure a single
replication network for multiple databases and directories,
or you can configure multiple replication networks so that
each database or directory stands alone.
At specific intervals, which can be configured from continuous
to monthly or anything in between, the Replication Engine
reads the database for a list of all changes since the last
synchronization. The compiled change list is then compressed
and encrypted and finally sent to the target engine where
they are applied to the target database.
Bundled with this product are tools to configure and maintain
the replication network. A full suite of log files provides
feedback on the state of the replication processes, and the
system can be configured for proactive alerts via Email if
the replication process is not able to complete within a given
period of time.
The product line is divided into two "editions",
named the Real-Time Backup Edition and the Data Synchronization Edition.
Real-Time Backup Edition
The Real-Time Backup Edition of DataExchange (RTBE) is specifically
designed to provide companies with a low-cost, easy-to-install
solution for fault tolerance on a primary database server.
It is an ideal solution for building a hot-site that receives
periodic updates to the database on a daily, hourly, or even
continuous basis. This edition runs exclusively at the Btrieve
layer and does not require DDF's. This edition is ideal for
the following scenarios:
- On-Site, Hot-Spare Server:
Get the maximum uptime from your local LAN by replicating data to a local server. This scenario offers an extremely
rapid recovery from a hardware failure of your primary database server. After such a failure, simply change a few
application settings (or just the server name), and you're ready to rock!
- Reporting Servers: Reporting servers are wonderful for large environments, since they can remove the CPU-intensive reporting processes from the primary database server during the day, when performance is a premium. Many companies copy the entire database from their primary to reporting server, but this can take hours for a large database. The DXSE can pump database changes to a reporting server on a set interval, as frequently (or infrequently) as you wish. Replicating daily may work for most environments on a reporting server, and it minimizes the amount of replication traffic and overhead. Some sites replicate twice daily to their reporting server, so that reports run after lunch will reflect that morning's changes. Finally, some sites replicate continuously to their reporting server, providing access to all of the most current and accurate data, but eliminating the overhead of reporting from the production server.
-
- Off-Site Data Center:
Threats ranging from natural disasters, disease, terrorism, theft, and internal sabotage can all cause problems
for your business. Protect yourself by shipping the data off to your off-site location continuously through the
day. If a problem occurs within the primary data center, you'll immediately have a known-good copy of the data
ready to roll!
The RTBE package includes a single DataExchange license for use on only two servers (the primary and the backup). DataExchange 2.x also provides a one-user license count for Pervasive PSQL v9 WorkGroup or Client/Server Engine (for the backup server) for management use. You can then use a batch file to place your permanent license from the primary server on standby for use on the secondary server. DataExchange 3.x does not provide an additional license for PSQL v10 license -- both servers must be fully licensed for PSQLv10.
Two core restrictions exist in the RTBE release: 1) Data synchronization is restricted to one-way replication only, and 2) The replication network is limited to only two database servers. You can upgrade your RTBE software to a SYNC version at a later time at no charge, but you'll need to purchase the other licenses at that time to remain compatible.
The RTBE package is available in several different SKU's, one for a Workgroup Engine and several for the Server Engine, stratified by user count (which must meet or exceed your database user count). User counts available are 6U, 10U, 20U, 50U, and Unlimited. You can also stack licenses to exactly match your Pervasive.SQL database license.
Data Synchronization Edition
The Data Synchronization Edition of DataExchange (SYNC) is designed to provide companies a more flexible mechanism for distributing database updates between multiple servers or sites. It provides all the functionality and removes some of the restrictions of the Real-Time Backup Edition in that it allows for full, two-way replication between multiple sites, and it allows the piping of data to a secondary server for use as a web portal server. This edition is ideal for the following scenarios:
- Tiered Hot Backup Configurations:
The Data Synchronization edition can be configured to run a single-database backup, as described above with the
Real-Time Backup Edition. However, it also offers the flexibility to replicate to multiple servers concurrently,
locally and at remote sites, at different intervals. Thus, you can maintain BOTH an on-site hot-spare server AND
an off-site copy of the data for optimal protection.
- Web Portal Servers:
Web servers also need updated data, but having this information accessible from outside of the enterprise firewall
can be just asking for trouble, especially if the web server is ever compromised. Replicating the production data
to a web server database engine provides access to your current data from the Internet while protecting your data
assets. With the two-way SYNC solution, you can allow changes on the web site to replicate back into the primary database.
- Multi-Site Databases: Although not all applications are compatible with multi-site updating, if you build such an app, DataExzchange SYNC can replicate the data for you between sites, keeping everyone up to date. This is ideal for the custom software developer looking for an advanced solution.
The SYNC package includes a single DataExchange license for use on one server. Each server is licensed based on the user count in use on that server. Each additional server that will participate in the replication network (for any purpose) requires its own license that matches its database license as well. In addition, each server must also have a valid PSQL database engine license on it.
The SYNC package is sold in varying SKU's. There is one SKU specifically for use with WorkGroup Engines (although this can only replicate with a server SYNC edition). The server engine SKU's are stratified by user count similarly to the RTBE above, in 6U, 10U, 20U, 50U, and Unlimited.
Please note that the SQL-based replication has been discontinued from thus product, and ONLY the Btrieve-level replication is supported at this time. Contact Pervasive for details about additional deployment options.
The current versions of DataExchange are v2.7, v2.8, v2.9, and v3.0:
- DataExchange v2.7 is supported on Pervasive.SQL V8 Windows Server database engines only. If you have Pervasive.SQL V8, you can NOT upgrade to 2.8 at this time -- you must upgrade to PSQLv9 first. This release became unsupported as of December 31, 2006.
- DataExchange v2.8 is supported on Pervasive PSQL v9.1 and newer server database engines on Windows servers only. (There is no DataExchange for Linux or NetWare yet.) This release becomes unsupported as of October 1, 2010.
- DataExchange v2.9 is supported on Pervasive PSQL v10.0, but ONLY as an upgrade from a PSQLv9 installation. (DataExchange v3.0 for new PSQLv10 installations is expected to be released with Service Pack 1.) This product currently works with 32-bit versions of PSQLv10 only.
- DataExchange v3.0 was released in August 2008 and will work ONLY on Pervasive PSQL Summit v10.10. (It will NOT work on v10.00). This tool is currently supported on Windows 32-bit platforms ONLY. DXv3 will NOT work on a PSQLv10 64-bit engine.
- DataExchange v4.0 is currently in beta and due to be released soon. It requires PSQL v11 (also currently in Beta). There is both a 32bit and 64-bit implementation of this product, so you need to be sure about the platform and bit level when you order.
Users of DataExchange v2.x can freely migrate to a newer 2.x version as you upgrade your database engine. However, if you upgrade to PSQLv10.10 or higher, you will be required to get the DataExchange v3.0 product, which is a PAID upgrade. See the pricing link below for details.
If you are considering the use of DataExchange in your environment, check out these time-savers!
Contact Goldstar Software if you have additional questions!
|
