View Issue Details

IDProjectCategoryView StatusLast Update
0003350SymmetricDSBugpublic2018-10-03 12:48
Reporterpgsql Assigned To 
Priorityurgent 
Status closedResolutionduplicate 
Product Version3.9.1 
Summary0003350: Regarding SymmetricDS Community Edition
DescriptionI am doing MS-SQL to Postgresql replication by symmetricds community edition. I have configured the symmetricds on both nodes and performed the replication. The steps I have followed for replication are given below, after performing below steps still data is not replicating. I am also attaching logs and screenshot of both the nodes after running symmetricds. Kindly check anyone and please give me solution what is wrong in it. :

1. Firstly Download the SymmetricDS Community edition from www.jumpmind.com website. Unzip the file symmetric-server-3.9.1zip on both Master Node(MS-SQL server) and Slave Node(Postgresql server).

2. On master node Copy the corp-000.properties file from symmetric-server-3.9.1\samples path and paste this file to symmetric-server-3.9.1\engines path. Follow same procedure on target node but copy store-001.properties file.

3. Now do the changes in the parameter of the corp-000.properties and store-001.properties files.

In corp-000.properties
engine.name = corp-000
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://hostip:port/databasename;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880
db.user=put the database user here
db.password=put the database password here
sync.url=http://hostip:31415/sync/corp-000
group.id=corp
external.id=000
In store-001.properties
engine.name=store-001
sync.url = http://hostip:31415/sync/store-001
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://hostip:port/databasename?protocolVersion=2&stringtyp e=unspecified
db.user=put the database user here
db.password=put the database password here
registration.url=http://masternodeip:31415/sync/corp-000
group.id=store
external.id=001
4. Create system tables on master node by running following command on master node:
symmetric-server-3.9.1/bin/symadmin --engine corp-000 create-sym-tables

5. Now Insert the values in the system tales:

         insert into SYM_NODE_GROUP
        (node_group_id)values(‘store’);

         insert into SYM_NODE_GROUP_LINK
        (source_node_group_id, target_node_group_id, data_event_action)values ('corp', 'store', 'P');
             
          Where P = Push

           insert into SYM_NODE_GROUP_LINK
(source_node_group_id, target_node_group_id, data_event_action)
      values ('store', 'corp', 'W');
    
          Where W = Wait for pull

          insert into SYM_ROUTER (router_id,
        source_node_group_id, target_node_group_id, create_time,
        last_update_time) values ('corp-2-store','corp', 'store',current_timestamp, current_timestamp);


        insert into SYM_CHANNEL (channel_id, processing_order, max_batch_size, max_batch_to_send,extract_period_millis, batch_algorithm, enabled, description)values ('patient_dtl', 10, 1000, 10, 0, 'default', 1, ‘Patient Details');

        insert into SYM_TRIGGER (trigger_id, source_table_name,
          channel_id, last_update_time, create_time)values ('patient_dtl', 'patient_dtl', 'patient_dtl', current_timestamp, current_timestamp);

        insert into SYM_TRIGGER_ROUTER(trigger_id, router_id, initial_load_order, create_time,last_update_time)values ('patient_dtl', 'corp-2-store', 1, current_timestamp,
current_timestamp);

The Setup and configuration is now completed.




6. We will now start both SymmetricDS nodes

On master node:
symmetric-server-3.9.1/bin/sym

On Slave Node:
symmetric-server-3.9.1/bin/
and run ./sym
This command on slave node system tables automatically. It begins polling the server node in order to register.


7. Registering a Node
Open registration for the slave node server by executing the below command on master node cmd:

symmetric-server-3.9.1/bin/symadmin –-engine corp-000 open-registration store 001

 The registration is now opened for a node group called “store” with an external identifier of “001”.

8. Sending an Initial Load
               Next, we will send an initial load of data to our store (that is, the slave node)

     Send an initial load of data to the client node server by executing following command on master node cmd:
          symmetric-server-3.9.1/bin/symadmin –-engine corp-000 reload-node 001
TagsNo tags attached.

Relationships

duplicate of 0003354 closedadmin Data is Not replicating in Community Edition 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-01-05 12:40 pgsql New Issue
2018-10-03 12:48 hanes Status new => closed
2018-10-03 12:48 hanes Resolution open => duplicate
2018-10-03 12:48 hanes Relationship added duplicate of 0003354