Option to disable Hikari connection pooling

[usmansaleem]

Provide option to disable Hikari connection pooling for slashing and pruning database so that external connection pooling such as pgBouncer can be utilized.

Task

• Create an experimental CLI flag (--Xslashing-protection-db-connection-pool-enabled)
• Ensure JDBC properties can be specified
• Either parse Hikari config file (datasource.*) or use separate properties file (--slashing-protection-db-pool-configuration-file and --slashing-protection-db-pool-configuration-file can be reused to specify PG Datasource properties.)
• Ensure pgBouncer can be utilised after disabling Hikari

Results:

Block Signing Load Testing
10 keys - 10 user/sec - 10 minutes
With pgBouncer - external connection pool (defaults)

================================================================================
---- Global Information --------------------------------------------------------
> request count                                       6000 (OK=6000   KO=0     )
> min response time                                      8 (OK=8      KO=-     )
> max response time                                    136 (OK=136    KO=-     )
> mean response time                                    11 (OK=11     KO=-     )
> std deviation                                          3 (OK=3      KO=-     )
> response time 50th percentile                         11 (OK=11     KO=-     )
> response time 75th percentile                         12 (OK=12     KO=-     )
> response time 95th percentile                         14 (OK=14     KO=-     )
> response time 99th percentile                         18 (OK=18     KO=-     )
> mean requests/sec                                     10 (OK=10     KO=-     )
---- Response Time Distribution ------------------------------------------------
> t < 800 ms                                          6000 (100%)
> 800 ms < t < 1200 ms                                   0 (  0%)
> t > 1200 ms                                            0 (  0%)
> failed                                                 0 (  0%)
================================================================================

With Hikari Internal connection pool (defaults)

================================================================================
---- Global Information --------------------------------------------------------
> request count                                       6000 (OK=6000   KO=0     )
> min response time                                      4 (OK=4      KO=-     )
> max response time                                    146 (OK=146    KO=-     )
> mean response time                                     6 (OK=6      KO=-     )
> std deviation                                          2 (OK=2      KO=-     )
> response time 50th percentile                          6 (OK=6      KO=-     )
> response time 75th percentile                          6 (OK=6      KO=-     )
> response time 95th percentile                          8 (OK=8      KO=-     )
> response time 99th percentile                         11 (OK=11     KO=-     )
> mean requests/sec                                     10 (OK=10     KO=-     )
---- Response Time Distribution ------------------------------------------------
> t < 800 ms                                          6000 (100%)
> 800 ms < t < 1200 ms                                   0 (  0%)
> t > 1200 ms                                            0 (  0%)
> failed                                                 0 (  0%)
================================================================================

With Hikari Internal Disabled - Without PgBouncer.

================================================================================
---- Global Information --------------------------------------------------------
> request count                                       6000 (OK=6000   KO=0     )
> min response time                                     12 (OK=12     KO=-     )
> max response time                                    188 (OK=188    KO=-     )
> mean response time                                    15 (OK=15     KO=-     )
> std deviation                                          3 (OK=3      KO=-     )
> response time 50th percentile                         15 (OK=15     KO=-     )
> response time 75th percentile                         15 (OK=15     KO=-     )
> response time 95th percentile                         17 (OK=17     KO=-     )
> response time 99th percentile                         22 (OK=22     KO=-     )
> mean requests/sec                                     10 (OK=10     KO=-     )
---- Response Time Distribution ------------------------------------------------
> t < 800 ms                                          6000 (100%)
> 800 ms < t < 1200 ms                                   0 (  0%)
> t > 1200 ms                                            0 (  0%)
> failed                                                 0 (  0%)
================================================================================