| 词条 | SymmetricDS |
| 释义 |
| name = SymmetricDS | logo = | screenshot = | caption = | author = | developer = | released = November 2007 | latest release version = 3.9.15 | latest release date = {{Start date and age|2018|10|31}}[1] | operating system = Microsoft Windows, Linux, Mac OS X, Android | language = English | status = Active | license = GPL | website = http://www.symmetricds.org/ }}SymmetricDS is open source software for database and file synchronization with Multi-master replication, filtered synchronization, and transformation capabilities.[2] It is designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage.[3] Data synchronization occurs asynchronously from a scheduled job, with data changes being sent over a push or pull operation. It uses standard web protocols (HTTP) and database technologies (JDBC) in order to support a wide range of platforms and maximize its interoperability. It includes support for Oracle, MySQL, MariaDB, PostgreSQL, Greenplum, SQL Server, SQL Server Azure, HSQLDB, H2, Derby, DB2, Firebird, Informix, Interbase, SQLite, Sybase ASE, Sybase ASA, MongoDB, Amazon_Redshift, and VoltDB databases.[4] FunctionalitySymmetricDS runs either as a standalone server (using a built-in Jetty), within an application server (such as Apache Tomcat), or embedded into an application. Configuration is done through properties files and a collection of configuration tables at a central node. Both database tables and filesystems can be synchronized across a network of nodes. Configuration allows for selection of tables, columns (vertical filtering), and subsets of rows (horizontal filtering) to synchronize in one direction or both directions. Files are selected by base directory and whether to recurse into directories. Wildcard characters are used to match multiple tables and files. Tables can be grouped into channels that sync based on priority. Groups of nodes are linked together and assigned a transport method of push or pull. A push will connect to the node and send changes when they are ready, while a pull will periodically connect with a node to check if changes are available. Several network topologies are possible by linking node groups, including fan-in/out, multi-master, star, and multi-tier tree. A node can be prepared with an initial load of data to populate its database. Changes are grouped into batches and assigned for delivery to nodes using Routers. Routers can be configured or scripted to filter data and make decisions on which nodes should receive data. Batches are delivered during synchronization and tracked using a sequence number and status, with periodic retries designed to automatically recover from errors. Administration tools for command line and a web-based JMX console are included to manage nodes from a central location. Programming interfaces for Java and REST are included to extend and customize behavior. Prominent users
See also
References1. ^http://www.symmetricds.org/download 2. ^{{cite web|title=SourceForge Project Page|url=http://sourceforge.net/projects/symmetricds/|accessdate=Dec 10, 2013}} 3. ^{{cite web|title=Synchronize Databases with SymmetricDS|url=http://sourceforge.net/blog/synchronize-databases-with-symmetricds/|accessdate=Nov 23, 2012}} 4. ^{{cite web|title=SymmetricDS Manual: Database Notes|url=http://www.symmetricds.org/doc/3.5/html/databases.html|accessdate=Nov 16, 2013}} 5. ^{{cite web|title=OpenMRS: Database Synchronization with SymmetricDS|url=https://wiki.openmrs.org/display/projects/Database+Synchronization+with+Symmetric+DS|accessdate=Aug 22, 2012}} 6. ^{{cite web|title=Openboxes: Enabling Synchronization|url=http://code.google.com/p/openboxes/wiki/Synchronization|accessdate=Sep 18, 2012}} External links
1 : Data synchronization |
| 随便看 |
|
开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。