View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000650 | Pgpool-II | General | public | 2020-09-22 15:43 | 2020-09-28 23:08 |
| Reporter | sridharpjava@gmail.com | Assigned To | pengbo | ||
| Priority | high | Severity | minor | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Product Version | 4.1.0 | ||||
| Summary | 0000650: Information request on pgpool-II | ||||
| Description | we are evaluating bitnami/postgresql-ha for our production deployment and this bitnami postgresql-ha solution uses pgpool-II. I have couple of questions related to pgpool-II. Kindly clarify. Question 1 : This bitnami postgresql ha solution is using pgpool and repmgr, however, the pgpool-II documentation states explicitly that this is not supported. https://www.pgpool.net/mediawiki/index.php/FAQ#Can_I_use_repmgr_with_Pgpool-II.3F . From the link please check the question "Can I use repmgr with Pgpool-II?" . we have not faced any issues in our testing ,do you think we can use this combination ? Question 2 : We are already using a JDBC Connection Pool manager (Hikari) in our application layer. Pgpool-II also manages a Connection Pool. Is it advisable to connect 1 connection pool to another one ? Will it impact any performance related issues ?? Question 3 : Was there any performance tests been done to pgpool ,we are planning to do performance with our application but just wanted to check from your experience if you had noticed any performance issues ? Thank you so much for your help in advance. | ||||
| Tags | No tags attached. | ||||
|
|
Please can you check my request and update the ticket?? |
|
|
Kindly can someone acknowledge the ticket?? |
|
|
Sorry for late response. > Question 1 : This bitnami postgresql ha solution is using pgpool and repmgr, however, the pgpool-II documentation states explicitly that this is not supported. https://www.pgpool.net/mediawiki/index.php/FAQ#Can_I_use_repmgr_with_Pgpool-II.3F . From the link please check the question "Can I use repmgr with Pgpool-II?" . we have not faced any issues in our testing ,do you think we can use this combination ? Someone reported that If Pgpool-II's failover is disabled, Pgpool-II may not be able to detect the primary or status of backend properly in some edge cases. Pgpool may work well with repmgr in your environment, but I am not sure if it can work properly in all cases because we have not tested Pgpool-II with repmgr. > Question 2 : We are already using a JDBC Connection Pool manager (Hikari) in our application layer. Pgpool-II also manages a Connection Pool. Is it advisable to connect 1 connection pool to another one ? Will it impact any performance related issues ?? I think in some case your application may receive an error message. This blog described the problem when using Tomcat JDBC connection pool and the solution: https://b-peng.blogspot.com/2020/07/connection-pooling-in-pgpool.html > Question 3 : Was there any performance tests been done to pgpool ,we are planning to do performance with our application but just wanted to check from your experience if you had noticed any performance issues ? So far we don't have any performance issues. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-09-22 15:43 | sridharpjava@gmail.com | New Issue | |
| 2020-09-23 16:38 | sridharpjava@gmail.com | Note Added: 0003571 | |
| 2020-09-25 17:33 | sridharpjava@gmail.com | Note Added: 0003574 | |
| 2020-09-28 23:08 | pengbo | Note Added: 0003575 | |
| 2020-09-28 23:08 | pengbo | Assigned To | => pengbo |
| 2020-09-28 23:08 | pengbo | Status | new => feedback |
