[Pgpool-hackers] Promoting any node as master with SR slaves follow

[Tatsuo Ishii]

>> 1) There seems to be a window between pcp_promote_node and subsequent
>>    pcp_recovery_node calls. Do you have any idea that is safe or not?
> In all tests I've done, it just works perfectly. I just have to valid
> that against nodes load.

Great. Probably promoting a standby node and in the same time shutting
down other standby nodes is most important and there should be no
window there.

>> 2) Your opinion that the node to be promoted should be chosen by more
>>    intelligent rules(for example, the least lagging node), rather than
>>    just the physical position in the configuration file seems to be
>>    valid IMO. I wonder if we could implment automatic failover which
>>    is based on the rule, rather than manually promoting a node by
>>    using pcp_promote_node. Any idea?
> Oh yes, of course this is why I'm doing the work. The pcp_promote_node
> command is just here for starting the work and manually promote a node
> for testing purpose :-)

Oh ok. Sounds great!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp