'Is there a library to share Oracle Connection Pools across multiple servers?
Are there open-source solutions to share Oracle connection pools across server instances so application instances don't suck up limited connections? For example say I have a limit of 100 connections and 10 servers. I create 2 pools of 50, is there a way to share those pools of 50 across 5 servers?
Solution 1:[1]
If by "5 servers" you mean 5 application servers, then you could look at using DRCP (Database Resident Connection Pooling) where the connection pool management is done via the database, and thus multiple app servers can all make use of a common connection pool.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Connor McDonald |