Hi there, I'm already applying Slony-I in a small single-master / single-slave application test environment (non-commercial) and I have some question considering the applicability of Slony-I / Slony-II in some more general situations.
These questions are: Ability to provide WAN replication. - Is it possible to use Slony-I in wide-are network (WAN) enviroment ? The bandwidth on the master-master link is 34 Mbit/sec, on the master-slave link 10 MBit/sec. Both sides will have a latency of 30msec. Robustness concerning network drop out. - Can (slave) nodes which are not continuosly connected to network be used ? Satellite Connection. This scenario considers the replication between master and slave nodes communicating over satellite. - Is Slony (-I, maybe the sucessor -II) capable for Replication over satellite network (latency 850msec, bandwith 2 MBit/sec) ? Data consistency. In this scenario, the two master nodes are unconnected, changes are made and new primary-key values are generated at both sites. - How will the upcoming Slony-II act by time the master nodes are reconnected ? How about conflict resolution in the case of newly introduced, equal PK-values at each (unconneted) site ? Is there any design proposal ? I'd like to appreciate any response to my open questions. Thank you very much, Martin ----------------------------------------- IABG mbH Sitz der Gesellschaft: Ottobrunn, Registergericht: Amtsgericht Muenchen, HRB 5499 Geschaeftsfuehrung: Prof. Dr.-Ing. Rudolf F. Schwarz Vorsitzender des Aufsichtsrats: General a. D. Wolfgang Altenburg _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
