[Pgcluster-general] Failover of PGReplicate

[a.mitani at sra-europe.com]

Thank you, Tom.
That's my point exactly.

--------------
At.Mitani


> I've done some experiments (and made failover work, at least for a
> while). It seems that when the "primary" replicator restores (i.e. the
> situation Josef described), it doesn't get active again till the
> "secondary" goes down :)
>
> Now I understand Mitanis answer... the "secondary" becomes master and
> the "primary" becomes a slave (when restored), and this only changes if
> the current master goes down. So, there's no primary/secondary/...
> scheme, only a single current replicator and N idle replicators waiting
> to be useful is master falls.
>
> Regards,
> --
> Tom;
>
> Tom疽 A. Rossi escribi?
>> Sorry, as I see it, the question hasn't been answered. He asked if the
>> "secondary" node should detect that the "primary" is up again, and
>> then restore the original behavior (i.e. root replication server
>> getting active again in the whole replication schema).
>>
>> Regards,
>> --
>> Tom;
>>
>> a.mitani at sra-europe.com escribi?
>>> Hi,
>>>
>>> The replication server is used for queueing queries.
>>> Therefore, all cluster db must connect same replication server.
>>>
>>> Replication server has not primary / secondary order.
>>> It has just active / stand-by mode.
>>>
>>> Regards,
>>> -------------------
>>> At.Mitani
>>>
>>>
>>>> Lets say I have 2 nodes, each running PGReplicate and ClusterDB. The
>>>> node
>>>> running the primary PGReplicate fails and the ClusterDB on the second
>>>> node
>>>> automatically fails over the PGReplicate of the first node. However,
>>>> when
>>>> I restart node1, the ClusterDB of node2 seems to remain connected to
>>>> PGreplicate of node2, and thus any changes done on node 2 are no
>>>> longer
>>>> reflected on node1, and viceversa.
>>>>
>>>> Is ClusterDB supposed to realise that the primary replicator has been
>>>> restored so that all clusterDBs access the same replicator?
>>>>
>>>> regards,
>>>> Josef
>>>>
>>>> _______________________________________________
>>>> Pgcluster-general mailing list
>>>> Pgcluster-general at pgfoundry.org
>>>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Pgcluster-general mailing list
>>> Pgcluster-general at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Pgcluster-general mailing list
>> Pgcluster-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>