Hi, all
Hope this is the right forum for this. I have recently installed Slony
1.2.13 on Postgres 8.3.1 for CentOS5. I work for an ISP with Wi-Max
presence in several areas in an African country. We are trying to
implement centralised customer billing and relationship management while
enabling each geographic area to have independence in terms of
Authorization and Authentication of customer devices... These latter
functions are carried out by a Motorola-developed application running on
a Postgres database.
This interfaces with the CRM and billing application on one hand for
authentication et al, and Wi-Max base stations for Accounting on the
other hand.. Obviously, with 3 (and soon more) areas in operation, these
have to all syncronise the accounting data with the head office database
(one of the 3) while sourcing Authentication and Authorisation details
from the same head office 'mothership'.
This suggests to me that while i can have all 3 in the same replication
set for the purposes of authentication/authorisation, I have to set up
separate replication sets for accounting data as follows:
1. Each satellite is the master node of a replication set with the head
office where, crucially
2. The head office also allows local updates to itself
Would this work without undue fuss, or do i have to find a more
intricate solution (e.g. creating a 4th database which will be slave to
all and master of the master, so to speak?)
Hope for some pointers from y'all.. I'm sure someone's done this before
Regards,
James T Mugauri
--
Systems Development Engineer
AfriConnect (Zambia) Limited
+260 (977) 77 1447
+260 (211) 23 2005
+260 (977) 69 6889
In every work of genius we recognize our own rejected thoughts; they come back
to us with a certain alienated majesty.
- Ralph Waldo Emerson
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general