View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003350 | SymmetricDS | Bug | public | 2018-01-05 12:40 | 2018-10-03 12:48 |
Reporter | pgsql | Assigned To | |||
Priority | urgent | ||||
Status | closed | Resolution | duplicate | ||
Product Version | 3.9.1 | ||||
Summary | 0003350: Regarding SymmetricDS Community Edition | ||||
Description | I 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 | ||||
Tags | No tags attached. | ||||