Jean-Christophe Praud jc at praud.com
Tue Feb 5 08:59:03 PST 2008
St=E9phane A. Schildknecht a =E9crit :
> Jean-Christophe Praud a =E9crit :
>   =

>> Hi all,
>>
>> I'm new to Slony, here's my newbie question :
>>
>> I need to setup a cluster of separate servers, each handling a set of
>> users data.
>> The architecture I'm planning is :
>>
>> - 1 central server storing my whole users table (id, login, passwd,
>> id_of_users_server)
>> - n users servers containing the part of the central users table
>> - a user authenticate on the central server, then the application uses
>> the users server hosting this user
>>
>> As each users server will contain a part of the central users table,
>> modifications of each record of this table on the central server need to
>> be replicated to the good users server.
>>
>>
>> I don't plan to use inherited partitions for the central users table (I
>> need PK, FK and other constraints on this table). Can Slony be used to
>> do the partial replication from central to each users server ?
>>
>>
>>     =

> Hi,
>
> Not sure I understand everything, but if the question is "can slony
> replicate portions of table based on values", the answer is "no".
>
> Regards,
>   =

That's what I wanted to know. Thank you :)

Regards,

-- =

Jean-Christophe Praud         -      http://shub-niggurath.com
Conseil & D=E9veloppement Informatique      http://www.praud.com
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080205/=
f18e5b72/attachment-0001.htm


More information about the Slony1-general mailing list