I have a project that has a central database and local database. The idea is the central database will be sync with local database. Central database is deployed in a cloud service, then I have local database per location(branch). I was able to sync the database when I update the central both local database are being updated.
The problem is when I update 1 of the local database the update is being sent to the central, but not in the other local database. Is there something I am missing in the configuration?
By the way I am running the symmetricDS using docker.
Here is my sym_node data:
enter image description here
Then here is my sym_trigger data:
“database_sync”,
“source_catalog_name” => null,
“source_schema_name” => null,
“source_table_name” => “*”,
“channel_id” => “heartbeat”,
“reload_channel_id” => “reload”,
“sync_on_update” => 1,
“sync_on_insert” => 1,
“sync_on_delete” => 1,
“sync_on_incoming_batch” => 0,
“name_for_update_trigger” => null,
“name_for_insert_trigger” => null,
“name_for_delete_trigger” => null,
“sync_on_update_condition” => null,
“sync_on_insert_condition” => null,
“sync_on_delete_condition” => null,
“custom_before_update_text” => null,
“custom_before_insert_text” => null,
“custom_before_delete_text” => null,
“custom_on_update_text” => null,
“custom_on_insert_text” => null,
“custom_on_delete_text” => null,
“external_select” => null,
“tx_id_expression” => null,
“channel_expression” => null,
“excluded_column_names” => null,
“included_column_names” => null,
“sync_key_names” => null,
“use_stream_lobs” => 0,
“use_capture_lobs” => 0,
“use_capture_old_data” => 1,
“use_handle_key_updates” => 1,
“stream_row” => 0,
“time_based_column_name” => null,
“create_time” => “2024-05-30 23:17:18”,
“last_update_by” => null,
“last_update_time” => “2024-05-30 23:17:18”,
“description” => null
)
);
?>
Leander Abergas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.