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 http://www.aliyun.com/zixun/aggregation/22.html "> 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://sourceforge.net/projects/symmetricds/files/latest/download