CODEWITHSUNDEEP
mysqldatabasesymmetricds
Varun Jain
Varun Jain

Reputation: 507

symmetricds bi-directional not working

i am using MySQL and trying symmetricds to replicate the database. I am following this quick start guide.

I used sample file as it was given in sample folder and just provide my database details in crop.properties and store.properties file. On direction sync is working , like when i insert row in corp database it reflect these changes in store database, but when i insert something in store database then i won't sync corp database

Could you please help me in resolving issue with database not sync from store to corp?

I was checking the database i can see three trigger with all the corp user database table, But when i check store database then there is not trigger attached to store user database table i have attached image of store database. store does not showing any trigger (Except sym_ tables triggers ).

Should is show trigger in client also? Please advise. image of corp database, trigger attached with user table

image of corp database

image of store database, no trigger attached with user table :-

image of store database

Upvotes: 1

Views: 655

Answers (1)

Boris Pavlović
Boris Pavlović

Reputation: 64632

your assumption is correct. the store database should be having triggers on tables that are supposed to be synced from store to corp

check if the corp db is correctly configured. check for sym_trigger, sym_trigger_router and sym_router if there are any config that defines syncing from the store to the corp

Upvotes: 1

Related Questions