Cyril SCETBON cscetbon.ext at orange-ftgroup.com
Tue Aug 28 02:47:20 PDT 2007
Hi people,

My configuration did not change :-)

I got a [1 Master M1 + 1 Slave S1]. Another Slave S2 points to the 
Master M2 which is slave of M1 as follows :

                                M1(SET=1),ID=1 ------> 
S1(SET=1,ORIGIN=1),ID=2
                                 |
                                 |
                                V
                                M2(SET=1,ORIGIN=1),ID=3 ------> 
S2(SET=1,ORIGIN=3),ID=4

If M2 is down, S2 must replace it. How Can I do this ?
I thought about UNSUBSCRIBE SET=1 + SUBSCRIBE SET=1,ORIGIN=1 but I think 
it will truncate the tables and reimport all the data which will take 
time. Is there a way to tell S2 to replace M2 without retrieving again 
all the data from M1 ? FAILOVER(ID=3,BACKUP NODE=4) ?

thanks

-- 
Cyril SCETBON - Ingénieur bases de données
AUSY pour France Télécom - SCR/HDI/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon at jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat 
Bâtiment Marco Polo C2 
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************



More information about the Slony1-general mailing list