Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Apache Nifi: Is it a good practice to have shared DBCPConnectionPool?

Highlighted

Apache Nifi: Is it a good practice to have shared DBCPConnectionPool?

New Contributor

Is a good practice to share the same DBCPConnectionPool between several process groups or it is better to have one DBCPConnectionPool assigned to each process group?

I currently have 16 process groups that share the same DBCPConnectionPool which is at root level. There are 41 processors that are referencing that DBCPConnectionPool.

If it is a good practice, what is the recommended configuration so that performance is not affected?

I currently have it configured this way:

Max Wait Time: 500 millis.

Max Total Connections: -1

Minimum Idle Connections: 0

Max Idle Connections: 8

Max Connection Lifetime: -1

Time Between Eviction Runs: -1

Minimum Evictable Idle Time: 30 mins

Soft Minimum Evictable Idle Time: -1

Thanks in advance!

Don't have an account?
Coming from Hortonworks? Activate your account here