Pgpool-II 4.2 development: Difference between revisions

From pgpool Wiki
Jump to navigation Jump to search
Pengbo (talk | contribs)
745 edits
Created page with "Last update: 2019/06/24 Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column. {| class="wikitable" ! ! ID..."
 
No edit summary
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Last update: 2019/06/24
Last update: 2019/11/01


Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
Line 13: Line 13:
! Overview
! Overview
! Status
! Status
|-style="background:silver"
|-style="background:beige;text-align:center;"
| <s>001</s>
| colspan="10" | Feature
| <s>[FEATURE] Cert authentication between Pgpool-II and PostgreSQL</s>
|-style="background:white"
| 001
| [FEATURE] Cert authentication between Pgpool-II and PostgreSQL
|  
|  
|  
|  
Line 22: Line 24:
|
|
|
|
| Removed from 4.1. 2018/11/29
|  
|-style="background:beige"
|-style="background:white"
| 002
| 002
| [FEATURE] Add new child if it goes down
| [FEATURE] Add new child if it goes down
Line 33: Line 35:
| pgpool-hackers:1034
| pgpool-hackers:1034
|
|
|- style="background:silver"
|- style="background:white"
| <s>003</s>
| 003
| <s>[FEATURE] Make PCP set configuration command public </s>
| [FEATURE] Make PCP set configuration command public
|  
|  
|  
|  
Line 42: Line 44:
|
|
|
|
| Removed from 4.1. 2018/11/29
|  
|- style="background:silver"
|- style="background:white"
| <s>004</s>
| 004
| <s>[FEATURE] Seamless Application Failover</s>
| [FEATURE] Seamless Application Failover
|  
|  
|  
|  
Line 51: Line 53:
|  
|  
|
|
| <s>Similar to Oracle's "Transparent Application Failover".</s>
| Similar to Oracle's "Transparent Application Failover".
| Removed from 4.1. 2018/11/29
|  
|-style="background:beige"
|-style="background:white"
| 005
| 005
| [FEATURE] Enhancing pool_process and pool_pools
| [FEATURE] Enhancing pool_process and pool_pools
Line 61: Line 63:
| Small
| Small
|
|
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
| [https://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
|  
|  
|-style="background:silver"
|-style="background:white"
| <s>006</s>
| 006
| <s>[FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE)</s>
| [FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE)
|  
|  
|
|
Line 71: Line 73:
|  
|  
|
|
| <s>[http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]</s>
| [https://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
| Removed from 4.1. 2018/11/29
|  
|-style="background:silver"
|-style="background:white"
| 007
| 007
| [FEATURE] shared relation cache
| [FEATURE] Support for LDAP authentication
| 2018/11/20
| 2018/11/29
| 2019/02/29
|  
| High
| High
| Large
| Medium
| Hoshiai
| Hoshiai
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]]
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46917d5458a82c75e98b247a74b7ee1827666159 commit]
|-style="background:beige"
| rowspan="3" | 008
| [FEATURE] Enhance performance: performance regression test
| 2018/11/20
|
| High
| Small
| Usama
|
|
|
|-style="background:white"
| 008
| [FEATURE] Add IPv6 sppport for Pgpool-II
| 2019/01/17
|  
|  
|-style="background:beige"
| Low
| [FEATURE] Enhance performance: performance for simple query
| 2018/11/20
|
|
| XLarge
| Usama
|
|  
|  
|-style="background:silver"
| Ishii
| [FEATURE] Enhance performance: performance for extended query
| 2019/01/17
|
|
|
|
|-style="background:white"
| 009
| [FEATURE] Fault injection for watchdog
| 2019/09/18
|  
|  
| High
| Medium
| Ishii
| Ishii
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-September/003434.html [pgpool-hackers: 3434]]
|
|-style="background:white"
| 010
| [FEATURE] using volatility categories to determine whether a function is read only or not
| 2019/09/19
|  
|  
| (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=702f7c86f9b8f82f61e47235505715891ffe1b23 commit] <br>
(2) Enhance performance for extended query message: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003230.html [pgpool-hackers: 3230]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=778f611e201d6df88ed90d01e49af77daf9f2926 commit] <br> (3) Eliminate select(2) calls in certain cases to enhance performance in simple and extended query: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003247.html [pgpool-hackers: 3247]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=cf5fe7eb89a11e3ada3833343c7ed6551ce7c662 commit]
|-style="background:beige"
| rowspan="3" | 009
| [Documentation] Review and improve the current document
| 2018/11/20
|  
|  
| High
| Extra Large
| Hoshiai
|
|  
|  
|-style="background:silver"
| [Documentation] Update the examples to latest version.
| 2018/11/20
|  
|  
| High
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-September/003438.html [pgpool-hackers: 3438]]
|
|-style="background:white"
| 011
| [FEATURE] add the process status of pgpool for extended query
| 2019/10/17
|  
|  
| Peng
|  
|  
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0c9f716714dce156fe74469a933046b39896a072 commit] [http://www.pgpool.net/docs/latest/en/html/example-cluster.html doc]
|-style="background:beige"
| [Documentation] Add a "Quik start" guid.
| 2018/11/20
|  
|  
| High
| Hoshiai
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-October/003460.html [pgpool-hackers: 3460]]
|
|-style="background:white"
| 012
| [FEATURE] Implement log process
| 2019/11/01
|  
|  
| Usama
|  
|  
|  
|  
|-style="background:beige"
| 010
| [FEATURE] Master watchdog sets quarantine state to primary node
| 2018/11/26
|  
|  
| Normal
|
| Small
|
| Usama
|-style="background:white"
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002756.html [pgpool-hackers: 2756]] <br>[https://www.pgpool.net/pipermail/pgpool-general-jp/2018-March/001503.html [pgpool-general-jp: 1504]]
| 013
| [FEATURE] Check if the PID or socket file exists at startup.
| 2019/11/01
|  
|  
|-style="background:silver"
| 011
| [FEATURE] limiting number of frontends differently
| 2018/11/26
| 2018/12/04
|  
|  
|  
|  
| Ishii
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-November/003153.html [pgpool-hackers: 3153]]
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc commit]
|-style="background:beige"
| 012
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list
| 2018/11/29
| 2019/06/30
| Normal
| Small
| Peng
| Peng
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003157.html [pgpool-hackers: 3157]]
| Implementation is done. TODO: Test & Doc.
|-style="background:beige"
| 013
| [FEATURE] Support for LDAP authentication
| 2018/11/29
|
| High
| Medium
| Usama
|
|
|
|
|-style="background:silver"
|-style="background:white"
| 014
| 014
| [FEATURE] Support for PostgreSQL 12.
| [FEATURE] Simplify WATCHDOG host configurations.
| 2018/11/29
| 2019/11/01
|
|
|  
|  
| High
| Small
| Ishii
| recovery.conf <br> pgpool_setup <br> pgppol-recovery extension
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=fda13a93a1025b498bb2a674fb49406d9e3e509c pgpool-recovery extension] <br> [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=23fb4c1250f0464a867f2ac69006d74f134213e3 pgpool_setup]
|-style="background:beige"
| 015
| [FEATURE] Import PostgreSQL 12 parser.
| 2018/11/29
| 2019/07/31
| High
| Medium
| Peng
| Peng
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-December/003480.html [pgpool-hackers: 3480]]
|  
|  
| Start after PostgreSQL beta release.
|-style="background:white"
|-style="background:silver"
| 015
| 016
| [FEATURE] Add internal process application name
| [FEATURE] Statement level load balancing
| 2019/11/01
| 2018/12/06
| 2019/03/31
| High
| Large
| Peng
|
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb commit]
|-style="background:beige"
| 017
| [FEATURE] Add IPv6 sppport for Pgpool-II
| 2019/01/17
|  
|  
| Low
|  
|  
| Ishii
|
|
|-style="background:silver"
| 018
| [FEATURE] Add new columns to "show pool_nodes" command
| 2019/04/22
| 2019/04/24
| High
| Medium
| Ishii
| Discussion: [https://www.pgpool.net/pipermail/pgpool-hackers/2019-April/003315.html [pgpool-hackers: 3315]]
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35cb1dc2d9d9f4887bd0407f150558660b7826e1 Commit]
|-style="background:silver"
| 019
| [FEATURE][Document] Add new performance section
|  
|  
|
| High
| Medium
| Ishii
|  
|  
|
|
|-style="background:beige"
| 020
| [FEATURE] auto failback
| 2019/5/23
| 2019/7/5
|
| Medium
| Hoshiai
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003328.html [pgpool-hackers: 3328]]
|
|
|-style="background:beige"
|-style="background:beige;text-align:center;"
| 021
| colspan="10" | Bug Fix
| [FEATURE] allow to use md5 password in health_check_password and sr_check_password
|-style="background:white"
| 2019/5/30
| 101
| 2019/6/10
| [https://www.sraoss.jp/pipermail/pgpool-general/2019-December/006849.html [pgpool-general: 6791] Re: VIP and quorum ]
|  
|  
| Medium
| Ishii
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003334.html [pgpool-hackers: 3334]]
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=dc9742678dd04719a08a747d40cd4c0781fce49a commit]
|-style="background:beige"
| 022
| [FEATURE] Routing relcache queries to load balance node
|  
|  
|  
|  
|  
|  
| Medium
| Usama
| Ishii
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]]
|
|
|-style="background:beige"
| 023
| [FEATURE] Support ECDH key exchange with SSL
|
|
|
| Medium
| Hoshiai
|  
|  
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=51bc494aaa7fd191e14038204d18effe2efb0ec8 commit]
|-style="background:beige;text-align:center;"
| colspan="10" | Roadmap
|-style="background:white"
|-style="background:white"
| 201
| 201

Latest revision as of 00:19, 1 December 2020

Last update: 2019/11/01

Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.

ID Registered/start Date Target Date Priority Implementation Person in charge Overview Status
Feature
001 [FEATURE] Cert authentication between Pgpool-II and PostgreSQL
002 [FEATURE] Add new child if it goes down 2015/09/03 - Low Small pgpool-hackers:1034
003 [FEATURE] Make PCP set configuration command public
004 [FEATURE] Seamless Application Failover Similar to Oracle's "Transparent Application Failover".
005 [FEATURE] Enhancing pool_process and pool_pools 2018/02/13 Low Small [pgpool-hackers: 2721]
006 [FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE) [pgpool-hackers: 2721]
007 [FEATURE] Support for LDAP authentication 2018/11/29 High Medium Hoshiai
008 [FEATURE] Add IPv6 sppport for Pgpool-II 2019/01/17 Low Ishii
009 [FEATURE] Fault injection for watchdog 2019/09/18 High Medium Ishii [pgpool-hackers: 3434]
010 [FEATURE] using volatility categories to determine whether a function is read only or not 2019/09/19 [pgpool-hackers: 3438]
011 [FEATURE] add the process status of pgpool for extended query 2019/10/17 Hoshiai [pgpool-hackers: 3460]
012 [FEATURE] Implement log process 2019/11/01
013 [FEATURE] Check if the PID or socket file exists at startup. 2019/11/01 Peng
014 [FEATURE] Simplify WATCHDOG host configurations. 2019/11/01 Peng [pgpool-hackers: 3480]
015 [FEATURE] Add internal process application name 2019/11/01
Bug Fix
101 [pgpool-general: 6791 Re: VIP and quorum ] Usama
Roadmap
201 Feature Agreement
202 Feature Freeze
202 Code Freeze
Retrieved from "https://pgpool.net/mediawiki/index.php?title=Pgpool-II_4.2_development&oldid=3387"