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.
I'm has set 2 replication set:
C_1: master: P_1, P_detail_1 ; slave: P_2, P_detail_2
C_2: master: P_reault_2; slave P_result_1
the cluster install is ok, replacation on 2 cluster is ok.
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.
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.
Someone have idea for my solution, please help, im have thank you a lot :).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20121021/50a2c4f1/attachment.htm