Re: [Slony1-general] master and slave on the same host

[marco perugini]

hi brad! first of all thanks for your feedback. now i want to be sure i well understand your answer: i'm replicating db1 from cluster A [provider] to cluster B [subscriber]; now i want to replicate another db [ie db2] from cluster B [which should become a provider too] to another db server [called C in my first mail]. in this scenario i don't have multiple provider but a sort of replication's chain for 2 different dbs: db1 from A to B and db2 from B to C. so can B's slon process be provider and subscriber at the same time? however i'm using slony 2.0.0. thanks in advance! marco Brad Nicholson ha scritto: On Tue, 2009-04-28 at 14:53 +0200, marco perugini wrote: Dear all I have a little question, about a real scenario. I have this in my network: - A database cluster, call A, where live master instance of Slony; - A database cluster, call B, where live slave instance of Slony; - A simple database, call C, where i'd like to have a replication. So, at now A is master and replicate a schema (call S1) over the database B, the slave. I need to create another schema (call S2) in B that must replicate over the simple database C(S2 schema slave). My question is: can I have a Master process of Slony (for instance in B) where is live a slave process? If yes, how can i configure it. If No, how can I do with this environment? Thanks everybody for help. Regards, marco Yes, you can do this. You would use one set for S1, making the node on cluster A the provider, and Cluster C a replica. You would create another set for S2, making the node on Cluster B the provider and cluster C the replica. The same set of slons will service this cluster. A couple words of warning with this configuration though -I'm not sure if you want to have Cluster B also be a replica of of the set S1. If this the case, you will not be able to rely on pg_dump for dumping cluster B if you are using a version of Slony prior to 2.0.x. This will be a mixed cluster (a provider and a replica), the catalogs are corrupted (by design) on a replica. -We have found the multiple provider clusters to be highly error prone. There is no problem when replicating data (we've never had a problem with regular operation), but config changes often don't behave as intended, and often result in lost nodes. -- 4IT S.r.l. Marco Perugini | system administrator --------------------------------------------------------- Via Udine 30-36, 00161 Roma Phone +39 06 97601680 Mobile +39 339.39.81.246 Fax +39 06 97601683 m.perug...@4it.it www.4it.it “Il presente messaggio e gli eventuali allegati sono di natura confidenziale. Qualora vi fosse pervenuto per errore, vi preghiamo di cancellarlo immediatamente dal vostro sistema e di avvisare il mittente. Grazie.” “This electronic mail transmission and any accompanying attachments contain confidential information. If you have received this communication in error, please immediately delete the E-mail and either notify the sender. Thank you.”

_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general