1. two server, one on primary site, one secondary site
2. openvpn to communicate over the internet between the two site
3. one postgresql database on each site
4. we would set-up clustering between tabels of both databases.
Has anybody done something similar ??
Is this feasible regarding response time.
Our solution rocks on a single site,
but I fear we will get long response times.
We can live with a small lead time of the information being availble on the remote site.