Stack Overflow
Stack Overflow

Questions tagged [symmetricds]

SymmetricDS is open source software for both file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment.

SymmetricDS is open source software for both file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one direction or bi-directional, asynchronous data replication. It uses web and database technologies to replicate data as a scheduled or near real-time operation. The software was designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.

296 questions
2
votes
2 answers

Active-Active PostgreSQL configuration with SymmetricDS

I'm having issues replicating data between 2 Postgres servers using SymmetricDS (open source version). Here's the relevant informations to understand my problem: I have deployed 3 servers with Vagrant: symmetricds.local…
blakelead
  • 1,780
  • 2
  • 17
  • 28
2
votes
2 answers

SymmetricDS Sample - client node refused to connect to server node

I am working on the example from the SymmetricDS tutorial. I am using the configuration files corp-000.properties and store-001.properties found in the samples directory of the download zip. I have placed them in the engine directory and edited them…
swm
  • 519
  • 1
  • 4
  • 20
2
votes
1 answer

SymmetricDS and SSH Connection

I am using SymmetricDS to synchronise data between a server (Windows 10 machine) and client (Ubuntu Machine - Google Compute Engine) database. This requires me to set up a connection between the two systems. I created a SSH tunnel using PuTTY on the…
Pieter Steyn
  • 502
  • 4
  • 14
2
votes
1 answer

One-way SymmetricDS sync between local machine and cloud instance

I'm trying to configure one-way data flow from Microsoft SQL Server running on a local machine to MariaDB running on a VPS in a cloud. Local machine doesn't have a public static IP address, but the VPS does. I managed to connect them, but no data is…
uson1x
  • 407
  • 3
  • 16
2
votes
2 answers

SymmetricDS installation

I'm implementing one-way (server to client) replication with SymmetricDS and I'm a bit confused about the configuration to apply to the client node. Should I install SymmetricDS and start the service on the destination server/node? The servers are…
Julian Leite
  • 114
  • 1
  • 2
  • 8
2
votes
1 answer

SymmetricDS Registration from Linux to Windows

I have SymmetricDS running between PostgreSQL nodes, on windows. The registration node runs on Windows and also on 5 clients. I am migrating to Linux, so I have attempted to launch a slave on Linux. However I get the following error which I am…
Wize
  • 1,040
  • 9
  • 20
2
votes
1 answer

SymmetricDS can not register client

When I start my client it can not register, the server says the following: WARN [http-nio-8080-exec-3] o.j.s.s.impl.RegistrationService - Cannot register a client node unless a node group link exists so the registering node can receive…
Gábor Csikós
  • 2,787
  • 7
  • 31
  • 57
2
votes
2 answers

SymmetricDS in Embedded mode in Spring boot app as client

I have a Spring boot app using SymmetricDS. When I want to start a server, and a clients with h2 databases, both in embedded mode. I created the config files what are read, but the client throws the following…
Gábor Csikós
  • 2,787
  • 7
  • 31
  • 57
2
votes
1 answer

Syncing a dynamic set of schemata using SymmetricDS

I am working on a desktop application that uses a local installation of MySQL to store data across multiple schemata. My goal is to use SymmetricDS to transfer those schemata to an Oracle database on a different machine. So far I managed to set up…
Fabian Bachl
  • 43
  • 3
2
votes
1 answer

Issue replicating updates to primary key data with SymmetricDS

I am replicating from MSSQL (SQL Server 13) to PostgreSQL (9.5) using SymmetricDS. The table that is replicating has a composite key of 7 different columns. Everything works perfect from an initial load to inserting and updating data. However, I run…
Andrew B
  • 21
  • 1
2
votes
2 answers

Unable to setup multiple instances of symmetricDS on a vm

Please I have two instances of symmetricds running on my vm using the commands: bin/sym --port 9000 bin/sym --port 4000 but I want to be able to run both instances through the linux service. I have tried installing the service using…
Ewomazino Ukah
  • 2,286
  • 4
  • 24
  • 40
2
votes
1 answer

How to implement offline sync in java MySQL?

I plan to implement offline sync on my java application. When machine is offline then use local DB data and restrict some feature like create/delete. I Got some idea after find a lot of search from google. But, still not clear exactly. My doubts are…
Siva
  • 112
  • 11
2
votes
1 answer

High Availability in SymmetricDS

To all those SymmetricDS nerds over there, this one's for you all. Right, so we have a main db, DB-01. We have 3 instances of our application running namely R1,R2,R3. Each instance has its own in-memory db namely D1,D2,D3 which it(application) is…
Phillip
  • 437
  • 1
  • 5
  • 16
2
votes
0 answers

How does SymmetricDS convert Oracle RAW to Postgres BYTEA?

I'm using SymmetricDS to replicate data from an Oracle DB to a Postgres DB, and let it create the schema in the Postgres slave. A column with type RAW in Oracle was converted to BYTEA in Postgres. Values are converted as such RAW: …
hanshenrik
  • 199
  • 1
  • 11
2
votes
3 answers

SymmetricDS Postgres target gives "Failed to read table" for all sym_* tables

I'm trying to setup a simple replication from MySQL to Postgres. Identical schemas. After following the steps in the Demo Tutorial with a slight change (using MySQL and Postgres drivers) I am still unable to get the replication working. A few…
hanshenrik
  • 199
  • 1
  • 11
1
2
3
…
19 20