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 :).
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
