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 in Spring Boot Application

I am interested in using SymmetricDS in a Spring Boot application. Are there any examples that demonstrate how to do this?
Brandon E Taylor
  • 24,881
  • 6
  • 47
  • 71
2
votes
2 answers

symmetricds: sym_data table in master node is filled but sym_data_event is empty

We have a problem, sym_data table in master node is filled with data but sym_data_event is empty and sym_outgoing_batch is empty too. No any error in log file, symmetricds version is 3.4.2. One day ago all works fine and symmetricds config files not…
Artem Mosh
  • 21
  • 2
2
votes
1 answer

symmetricds on Docker and Kubernetes for Google Container Engine Deployment

I am deploying symmetricds on google container engine, so i have build symmetricds war file and create docker tomcat image like below :- FROM tomcat ENV JAVA_OPTS="-Dcom.sun.management.jmxremote.port=1109…
Anchit Pancholi
  • 1,174
  • 4
  • 14
  • 40
2
votes
1 answer

How to configure bi-directional sync in SymmetricDS?

Has anyone achieved a bidirectional configuration with SymmetricDS? There are many things to configure, and i got most of them: server.properties: #XXXXXXX nombre de la cabana #SSSSSSS ip del servidor engine.name=XXXXXXXXXXX # The class name for…
Iñaki Berra
  • 21
  • 4
2
votes
1 answer

SymmetricDS Two Way Synchronization Double Insert

I have server node and client node. They do two way synchronization on a table and also both have sync_on_incoming_batch = 1. Let say, table structure is (id, name). The scenario is: server insert data (1, 'a') client insert data (1, 'b') server…
Yosua Lijanto Binar
  • 670
  • 1
  • 8
  • 27
2
votes
1 answer

How to sync different table structure in SymmetricDS?

How to synchronize different table structure in SymmetricDS? Let say, I want to sync this tables: (Server Node) Student | Id, Name (Branch Node) Person | Id, Name, Birth Date Thank you.
Yosua Lijanto Binar
  • 670
  • 1
  • 8
  • 27
2
votes
1 answer

SymmetricException: Could not find the properties file

I'm Configuring symmtricDS into my windows server for Postgresql Database synchronization. Version : symmetric-server-3.7.28, Refering below URL for the configuration http://www.symmetricds.org/doc/3.5/html/tutorial.html#tutorial-install 2.1.…
Harsha Mullangi
  • 474
  • 1
  • 6
  • 27
2
votes
1 answer

impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.

I am srikanth, In my project I want to replicate data between "sqlite" and "mysql"... sym tables are created in "mysql" database.. But data is not replication.. i got following exception in "symmetric log file", "org.jumpmind.db.sql.SqlException:…
srikanthg
  • 71
  • 1
  • 8
2
votes
1 answer

how to force pull data at 1st registration in symmetricds

I created android symmetricds client. After register process, I don't see any data pulled by symmetricds client. The data will push by server or pull by client after I modified data in server. I'm using postgresql. What I want to do, client…
Indrajaya
  • 83
  • 4
2
votes
1 answer

How to distinguish changed data in CSV transferred over FTP using SymmetricDS

I am trying to transfer changed data to FTP server using SymmetricDS. And, i am able to transfer it successfully. The CSV file thus generated contains changed ROW_DATA i.e In case of 'UPDATE' event, a row with updated values is there and for an…
Hemant
  • 179
  • 4
2
votes
1 answer

SymmetricDS exceptions

I'm running two instances of SymmetricDS with MySQL. I have to start and stop synchronizations, for that I use: update sym_channel set enabled=0/1; For some reason when they synchronize (enabled=1), I get the following error: Caused by:…
SMSk
  • 693
  • 8
  • 25
2
votes
0 answers

SymmetricDS messes up with tripple foreign key

I have a database which is supposed to be synchronized using SymmetricDS. There are following queries, building the base: CREATE TABLE `defectstdreference` ( `std_doc_id` bigint(20) NOT NULL COMMENT 'Идентификатор НТД', `improve_notice_doc_id`…
SMSk
  • 693
  • 8
  • 25
2
votes
0 answers

SymmetricDS: Transporting row from a node to another

As you could see in this other question, I'm using SymmetricDS to synchronize a structure of tables. After solving the problem of the linked question, I've found another issue, in the same structure: The red rectangles show which tables need…
brevleq
  • 2,081
  • 10
  • 53
  • 97
2
votes
1 answer

SymmetricDS - Can't synchronize row with foreign key

I have two tables, let call it table A and B. Table A has a foreign key of table B. My system creates first a row in table B, and in another screen user can create a row in table A that is related to the created row in table B. These two rows need…
brevleq
  • 2,081
  • 10
  • 53
  • 97
2
votes
1 answer

symmetricDS android and server setup

I have been trying to setup symmetric server on my laptop and sync sqlite db with mysql database. The android is same as explained in below example : http://jumpmind.com/blog/synchronizing-android-applications-part1 and for symmetric server setup i…
coolswap11
  • 101
  • 1
  • 8
1 2
3
…
19 20