[pgpool-hackers: 657] Review: pgpool-II 3.5 road map

[Tatsuo Ishii]

Ahasan,

I have reviewed you proposal of 9.5 road map (#8, #9 #10 are my
additions).  It seems #4, #8, #10 are feasible. I think others need to
be studied or elaborated more.

1)  performance issue with prepared protocol.
    - testing pgpool for query latency and find out where we can make improvement.

    This is already on the TODO list for years now but nobody comes up
    with an idea to implement it. I think we will wait for someone
    thinks of nice idea.

2) Next steps for HA...Is there a way to provide automatic and
   seamless failover for active sessions.

   I have no idea how to implement it. Suppose failover happens while
   client is receiving SELECT result data from pgpool-II. We need to
   find a way to remember what data has been already sent and not to
   switch to different backend and to continue the session.

3) multi master communication. two independent pairs of pgpool needed
   to communicate.

   Can you please elaborate what needed for pgpool-II? Sounds vague to me.

4) parser integration with latest pg version

   Yes, we should integrate PostgreSQL 9.5's parser for pgpool-II 3.5.


5) Ability to re-issue queries when it failover to the stand-by node.
   Currently the user has re-issue queries

   Looks identical to #2.

6) Would like to see pgpool in separate sub modules that can be
   installed separately for each feature, along with a common-libs
   sub-package or so.

   I have no idea what this actually means. We will wait until someone
   comes up with more concrete idea.

7) Adding transaction based pooling to pgpool

   Probably we should try pgbouncer + pgpool-II combo first to see if
   it's actually useful.

8) Enhance pcp commands 

   http://pgpool.net/mediawiki/index.php/TODO#Enhance_pcp_commands

9) create separate process for health checking

   http://pgpool.net/mediawiki/index.php/TODO#Create_separate_process_for_health_checking

10) Create yum repository

Best regards,
--
Tarts Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp