| 翻訳と辞書 |
SymmetricDS
SymmetricDS is open source software for database and file synchronization with Multi-master replication, filtered synchronization, and transformation capabilities.〔(【引用サイトリンク】url=http://sourceforge.net/projects/symmetricds/ )〕 It is designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage.〔(【引用サイトリンク】url=http://sourceforge.net/blog/synchronize-databases-with-symmetricds/ )〕 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, and Sybase ASA databases.〔(【引用サイトリンク】url=http://www.symmetricds.org/doc/3.5/html/databases.html )〕 It is commonly deployed in industries where data is distributed across multiple locations, such as Retail〔(【引用サイトリンク】url=https://blogs.oracle.com/retail/entry/data_replication_for_stores )〕 and Oil and Gas.〔(【引用サイトリンク】url=http://blog.jmerari.com/2013/06/case-study-on-symmetricds.html )〕
==Functionality==
SymmetricDS 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.
抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』
■ウィキペディアで「SymmetricDS」の詳細全文を読む
スポンサード リンク
| 翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|