Symmetricds Multi-Data synchronization/replication software

Source: Internet
Author: User
Keywords Data synchronization Symmetricds multi-master database network conversion
Tags aliyun application based channel data data filtering data synchronization direction

Symmetricds is a data synchronization/replication software based on a web-independent database. It is an open-source software that supports replication of multiple primary databases, filtering synchronization, network crossover in heterogeneous environments, and a single direction or two-way asynchronous data replication provided by multiple users. It uses web and database technology to replicate between real-time "> relational databases and tables." The software is designed to extend the size of the database, across the working Low-bandwidth connection, and during network outages.

By using database triggers, SYMMETRICDS can ensure that data changes are captured and retained by the number of atoms, supporting database vendors to provide the database dialect layer.

Symmetricds supports Oracle, MySQL, PostgreSQL, H2, HSQLDB, Derby, MS SQL Server, Firebird, IBM DB2, Informix, and InterBase databases.

You can set up synchronization to data push or data pull periodically, can sync two or more than two levels of nodes, divided into the following three ways:

From the General office remote areas of a few regional server synchronization
The registration node for multiple point of sale (POS) synchronizes with the storage server of the embedded database
Tens of thousands of storage server nodes synchronize with the zone nodes of the departmental database

Deployment options include the following:

Network application documents (WAR) deployed to application servers, such as Tomcat, Jetty, or JBoss
Independent services
Embed in the application

Symmetricds is written in Java and is licensed as an Open-source software under the GNU General Public License (LGPL).

Symmetricds Features:

Data channel-sync to separate channel
Sync in time-synchronize the data to ensure the arrival of the target. If the synchronization fails, the data for the same batch is retried until it succeeds or takes human intervention. All other data synchronization stops the failed channel.
Transactional awareness-record and playback of data updates
Centralized configuration-all configurations are downloaded from a central registry server
Multiple deployment options-standalone engines, Web applications, embedded software components
Data filtering and rerouting-support for localized passwords and sensitive data filtering/Routing
HTTP Transport-Pluggable transport defaults to representation State transfer (rest style) HTTP service
Payload compression-selectively compress data
Symmetric data protocol-a fast streaming media data format, rapid generation, analysis, and load
Plug-in APIs-by adding custom extensions and plug-in points
Host system synchronization-the same table can be synchronized from the host system while avoiding the update loop
Database version-the target database for the version specified data synchronization
Automatic database Creation-Select Allow database schema to be created and upgraded
Embedded-small enough to embed or boot in another application (ie, POS applications)
Multiple schemas-support for multiple database architectures natural data channels
Primary KEY update-capture "before" and "after" data is modified to allow updating of primary key data
Remote administration-Through the Java Management Extensions (JMX) Management Console
Remote database management-by synchronizing the infrastructure, SQL can be delivered and run at the remote database
Initial data loading-prepares data repositories for initial or restored loads on a satellite

Download Address: Http://

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.