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
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:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.