Hello,
I'm currently working on a HA setup with geographically separated proxies.
Each proxy is in a different data center with an MPLS link between them.
The proxies access a locally connected PostgreSQL database that is
replicated from a master in the primary data center. Note that the
replicated dbs are read only. Everything works great for read only queries
but registrations seem to pose a problem as they must use the primary db
directly to deal with the writes. If I set userloc to db mode 2 the
secondary proxies wipe out the entries in the database. If I use db mode 3
everything works great but all of the secondary proxies must use the primary
database directly and a network link failure will cause a service
disruption. Is there any way I can use separate read and write databases
without p_userloc? Is there a better way to replicate registrations
maintaining availability and scalability? And advice is appreciated.
Thanks,
Spencer
Connected by DROID on Verizon Wireless