SymmetricDS has proven successful in multiple industries and use cases that require fast and reliable database replication across local and wide area networks. Our solutions excel in conditions where network bandwidth is limited or connectivity is intermittent. With a flexible configuration, there are many types of possible solutions, but here are some of the common ones.
Data from multiple databases across the enterprise are synchronized and combined, working across low-bandwidth connections and withstanding periods of network outage. Thousands of databases can be connected to a central one using one or more tiers of synchronization. Manage data from the central database and distribute it across the network, with each tier receiving a subset of data. Use secure web protocols with pull or push synchronization to cooperate with firewalls on a wide area network. Conflicts can be handled at central office or configured to resolve automatically using rules.
The operational database is replicated to a data warehouse or a reporting database to offset workload. The main application continues to use the operational database, while the secondary database is used for reporting and analysis. The data can be filtered and transformed to enhance reporting.
Data is transformed during replication between databases with different structure. Migrate data from one version of an application to an updated version while both are in operation. Filter sensitive data from a backend database and transfer the minimal data needed for a front-end database.
Critical database applications are protected by continuously replicating to a standby database. Changes are sent to the standby, which may be on a local or wide area network. In an emergency, the application is reconnected to the standby database. Once the production database is available again, SymmetricDS will replicate changes to it from the standby. The switch-over can also be used to perform planned maintenance and system upgrades. Since SymmetricDS is flexible enough to replicate between different databases and table layouts, some tables of the upgraded database may have new columns in old tables.