[Pgpool-general] Applicability of PgPool-II / PgPool-HA in WAN

[Steeg Martin Dr.]

Hi there,
I have some question considering the applicability of SkyTools in
special situations.

Ability to provide WAN replication.
 - Is it possible to use PgPool-II (PgPool-HA) 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 two master nodes - which are not continuosly connected - be used
?

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 does PdPool-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 ?

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