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
1 answer

Symmetricds change source base dir for file sync dynamically

We have a corp node and many store nodes for file sync. We have sync files from each store nodes to corp node. The source directory be different in different stores. Can we change the base dir of a file trigger dynamic using something like bean…
Binyamin Melepat
  • 59
  • 11
2
votes
1 answer

SymmetricDS - conflict resolution

I am trying to implement multi-master bidirectional synchronization for one central node and many clients using SymmetricDS. Clients are communicating only with central node (star topology). I have problem with dealing with conflicts in primary…
user2275785
  • 199
  • 1
  • 19
2
votes
1 answer

SymmetricDS and Azure SQL Server

I need help connecting Azure database using SymmetricDS 3.5.1. I can't seem to the configuration correct. I get an error saying "Cannot create PoolableConnectionFactory" with the message either "socket closed" (when I don't specify ssl parameter) or…
hewstone
  • 4,425
  • 2
  • 23
  • 24
1
vote
1 answer

SymetricDS: How to define a trigger that matches all the tables except on

I have defined a SymmetricDS trigger that covers all my tables, like this: INSERT INTO sym_trigger (trigger_id, source_schema_name, source_table_name, channel_id, sync_on_update, sync_on_insert, sync_on_delete, sync_on_update_condition,…
Yonoss
  • 1,242
  • 5
  • 25
  • 41
1
vote
1 answer

SymmetricDS two way sync conflict resolution with two tables and two queries

Let's say we have two MySQL tables. CREATE TABLE A ( id BINARY(16) PRIMARY KEY, name VARCHAR (128) NOT NULL UNIQUE, ) ENGINE=InnoDB; CREATE TABLE B ( id BINARY(16) PRIMARY KEY, A_id BINARY(16) NOT NULL, info VARCHAR (128) NOT…
Predrag Manojlovic
  • 379
  • 5
  • 16
1
vote
1 answer

SymmetricDS sync to same node

I am trying track changes to a table via SymmetricDS (v3.7.32), use two specific columns and route them to another table on the same node. I've added the trigger, router and trigger_router records, and my trigger seems to be working as I can see the…
G-Man
  • 184
  • 2
  • 14
1
vote
1 answer

Sync only especifics columns in SymmetricDS

This is my table: ITEM_PRECO_VENDA ( ID_ITEM, ID_LOJA, PRECO, CUSTO, CIDADE) I want to replicate only the column CIDADE, how can i do this? Please, help.
Facundo
  • 11
  • 2
1
vote
1 answer

Synchronizing with CORP and being a host using symmetricds

I have a question regarding SymmetricDS and trying to get a project to work. So far I've managed to get Corp to sync with Stores and Stores with Corp This is working as intended, changes in Store are replicated to Corp, which will broadcast the…
RedNet
  • 416
  • 5
  • 12
1
vote
1 answer

Can we implement symmetricds in databases which are identical but, tables have different PK id for same tables

Can I implement symmetricDS in identical databases? My scenerio I have to databases: Database A Database B Whatever data change happens in either one of them should reflect in the other: Current situation: Even though the DB are identical, database…
Mukund
  • 1,107
  • 2
  • 18
  • 40
1
vote
1 answer

Replication for partitioned table in PostgreSQL

I want to replicate a partitioned table in PostgreSQL using SymmetricDS. Do I have to configure sym_trigger for individual partitioning table or just the partitioned table?
Maly Mohsem Ahmed
  • 41
  • 4
1
vote
0 answers

Why SymmetricDS Server runnning false

I have installed SymmetricDS and started by running bin/sym_service start but when I check the status it shows the server running is false. What is happening here?
Maly Mohsem Ahmed
  • 41
  • 4
1
vote
1 answer

Source node goes down what will happen in SymmetricDS?

If the 'Source' node gets down and the 'Target' nodes are up, can the 'Target' node does act as a 'Source' node in SymmetricDS for PostgreSQL
Maly Mohsem Ahmed
  • 41
  • 4
1
vote
0 answers

Node3 is not getting involved in mutli-master-replication of 3nodes using symmetric-ds 3.10.0

I am trying to create multi-master replication for 3 nodes (servers) using symmetric ds 3.10.0. After configuring all the 3 nodes, the bi-directional replication is working perfectly between 1st and 2nd nodes. But the bi-directional replication is…
svkvvenky
  • 1,122
  • 1
  • 15
  • 21
1
vote
1 answer

Symmetric ds skipping batches issue

I'm facing an Skipping batches issues with my symmetric ds setup,don't know the exact reason behind this because its not having the same pattern but when this event happened the data getting mismatched/missing between server & client…
Suraj Sawant
  • 29
  • 4
1
vote
0 answers

Symmetricds: add column runtime

I'm using Symmetricds between a client and a server. The client can have a different structure (less columns). In this case, I want to empty one column, and to use the latest created column on the server. EG. Client has only column A. Server has…
Emanuele
  • 723
  • 4
  • 15
1 2 3
…
19 20