[Pgpool-hackers] Enhancing show pool_nodes
Guillaume Lelarge
guillaume at lelarge.info
Thu Oct 6 16:36:49 UTC 2011
On Thu, 2011-10-06 at 10:10 +0900, Tatsuo Ishii wrote:
> Currently show pool_nodes SQL command shows:
>
> id | hostname | port | status | lb_weight
>
> I would like to add info whether the node is primary, master or
> standby because there's no way to know from exisiting pgpool-II UI.
> The new column name would be "class" (plese say no, if you have better
> idea about naming). The value will as follows:
>
> Raw mode:
> "master" or ""
>
> Native replication mode:
> "master" or "slave"
>
> Streaming replication mode:
> "primary" or "standby"
>
> Master slave mode with slony:
> "master" or "slave"
>
> Comments or opinions?
I guess it would be better to have the same vocabulary. So I would vote
"master"/"slave" for each replication mode, and "master" for raw mode.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
More information about the Pgpool-hackers
mailing list