@ jvanmeter Thanks!
I write not match: update sym_trigger set source_table_name='!test' where trigger_id='ep'; but report error: 2023-04-12 09:30:41,802 ERROR [yz-ep] [TriggerRouterService] [yz-ep-job-8] Could not find any database tables matching '!test' in the datasource that is configured
Mysql table contain virtual filed sync to target node report error: Failed sql state and code: HY000 (3105) I see that the reason for the error is that mysql virtual column does not allow data insert, but symmetricsds captured virtual column data synchronization to the target node。 sym_trigger: insert into sym_trigger (trigger_id, source_table_name, channel_id, last_update_time, create_time) values ('ep', '*', 'ep', current_timestamp, current_timestamp); target node desc table: mysql> desc drug_stock_hosp;...
I know you mean . I should use 'bin/symadmin --engine cd-001 reload-node 002' to do initial load.
@evanmiller The official website document description sync triggers job will auto trigger each night at midnight ,but the new tables on source not sync target database。I currently in used wildcard triggers.
@Evan Miller The official website document description sync triggers job will auto trigger each night at midnight ,but the new tables on source not sync target database。I currently in used wildcard triggers.
@ evanmiller The official website document description sync triggers job will auto trigger each night at midnight ,but the new tables on source not sync target database。I currently in used wildcard triggers.
@pmarzullo64 I think will auto sync to target database when the new table was created in source database. other than use "bin/symadmin reload-node": https://www.symmetricds.org/doc/3.6/user-guide/html-single/user-guide.html#d4e86 SymmetricDS will install or update its database triggers at start-up time and on a regular basis when a scheduled sync triggers job runs (by default, each night at midnight). The sync triggers job detects changes to your database structure or trigger configuration when deciding...