Hi all! I'm newbie on slony-i, i'm usingdrug version 2.1.2, i have 2 database on 2 server name: S_1 and S_2, im want set slony cluster in some table: P_1, P_detail_1, P_result_1 on S_1; and P_2, P_detail_2, P_result_2 on S_2. <div>
I'm has set 2 replication set:</div><div>C_1: master: P_1, P_detail_1 ; slave: P_2, P_detail_2</div><div>C_2: master: P_reault_2; slave P_result_1</div><div>the cluster install is ok, replacation on 2 cluster is ok.</div>
<div>Now i'm develop my solution: on C_1, when P_detail_2 is update, i set a trigger to insert if new value or update if old value to P_result_2, and new insert or update value will be replication to P_result_1 by C_2, and when P_result_1 is update, i set a trigger to update to P_1 or P_detail_1. This solution will make a cycle in 2 datebase.</div>
<div>But when i'm set up trigger it make a big proplem, when P_detail_2 update by C_1, my trigger is fire, it make insert or update ok, but it not replication to P_result_1 (C_2 im tested ok). im view in catalog of replication C_2 (S_2 to S_1) in table sl_log_1 store log when my trigger run.</div>
<div>Someone have idea for my solution, please help, im have thank you a lot :).</div>