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.

270 questions
9
votes
4 answers

SymmetricDS in the wild (production)?

I've been looking at some options to synchronize data between a few POS (Point of Sales) devices and the server. SymmetricDS seems to be one of the options with a business friendly license. Being a Codehaus project does guarantee a certain degree of…
Ryan Fernandes
  • 7,732
  • 7
  • 32
  • 52
7
votes
1 answer

How to load CSV file into Database with SymmetricDS

I'm currently using SymmetricDS 3.8.27. I have a comma separated file that includes data for a database table. Is it possible to replicate that data from the CSV file into a MySql database table using SymmetricDS? If so, what are the steps I need to…
Klementina Stojanovska Chirico
  • 73
  • 3
4
votes
1 answer

Some questions about SymmetricDS Embedded

I need to implement database synchronisation in a Javaapplication and I started to use SymmetricDS which is a mature tool and allows to synchronise differents DBMS. I played a little with SymmetricDS but I can't achieve my needs, so I have a few…
jbrtrnd
  • 3,675
  • 5
  • 23
  • 41
4
votes
1 answer

Running SymmetricDS as a Service on CentOS

I have successfully installed SymmetricDS on CentOS 6.3 64 bits. I can launch it : ../bin/sym --port 8080 --server Now I am trying to launch it as a service. I followed the instructions of…
gpasse
  • 3,940
  • 7
  • 38
  • 70
4
votes
2 answers

Can SymmetricDS be used for iOS

SymmetricDS has an android sqlite implementation that is awesome. I was wondering if i could do the same with iOS . I couldn't find anything on their website or on google (basic search spent around an hour). Also, I was hoping someone could tell me…
SandeepRM
  • 41
  • 4
4
votes
1 answer

SymmetricDS system tables on a different schema other than public

Is there a way to have SymmetricDS system tables to be put on any other schema say 'replication' other than the default "Public" schema in PostgreSQL? I don't want to mix the symmetric system tables with my tables that is present in the Public…
ivanceras
  • 1,305
  • 3
  • 16
  • 27
3
votes
1 answer

SymmetricDS: sync client nodes to each other

I have symmetricDS configured so that there is one master node in the cloud, and then two "store" (client) nodes in remote locations. If I insert data in the cloud, it is syncd to both clients. If I insert data in a client, it is syncd to the…
D2TheC
  • 1,903
  • 17
  • 19
3
votes
1 answer

SymmetricDS Syncing is not syncing perfectly

I have a 3 server running SymmetricDS. Say i have node 1 which is master, node 2.node 3 are child. When some data is being inserted into node 2 it's being synced to node 1 and similarly node 3's data is being syncing with node 1. But node 2 data is…
nixon1333
  • 487
  • 1
  • 9
  • 20
3
votes
1 answer

Data Pass Through in SymmetricDS

I'm feeling a little stupid, and my searches for answers haven't yielded anyone else having this problem. Imagine that I have NodeHQ, Node1 and Node2. I have created triggers to synchronize TableA between the 3 like so: Node1 <---> NodeHQ <--->…
user2085722
  • 43
  • 5
3
votes
2 answers

Create SYM Tables in SymmetricDS Embedded

I'm trying to embedded Symmetricds 3.7 in a java application which uses H2 database. The application is a client node and uses the class ClientSymmetricEngine from SymmetricDS API. The master node runs standalone symmetricds server and I was able to…
Prabal Kajla
  • 93
  • 9
3
votes
1 answer

symmetricds pro and registration

I'm trying to configure a replicated backup database using SymmetricDS pro v 3.7.23 I use 2 files : master.properties for main database: "external.id=server engine.name=server auto.config.registration.svr.sql.script=/symmetric-profile-standard-2-…
srikanthg
  • 71
  • 1
  • 8
3
votes
0 answers

Does SymmetricDS propagates updates to RedShift

Hello all :) SymmetricDS' blog talks about RedShift as target-only without going into details. Updates can be problematic in RedShift, performance-wise. Contexte is: A one-way replication from a MySQL instance to RedShift has already been set up…
BenoitParis
  • 2,363
  • 4
  • 25
  • 46
3
votes
2 answers

How to setup and run SymmetricDS reverse initial load (from store to corp)

I want build next structure: one parent (registration) node, several client nodes behind NAT. Client nodes push changes to parent. I take SymmetricDS example with corp and store, configure it and all work fine. Then I try put initial data to store…
tbicr
  • 20,912
  • 10
  • 72
  • 100
2
votes
1 answer

SymmetricDS and "registration

I'm trying to configure a replicated backup databse using SymmetricDS v 2.4. I use 2 files : master.properties for main database…
Łukasz Bownik
  • 5,859
  • 12
  • 38
  • 60
2
votes
1 answer

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
  • 116
  • 1
  • 8
1
2 3
…
17 18