From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Connection pooling and bulk heads
From the course: Advanced SQL for Application Development
Connection pooling and bulk heads
- [Narrator] Now a common pattern used with database applications is something called bulkheads and we do that when we need to kind of isolate sets of resources and this is commonly used when we're working with connections, so a common problem, as we've noted, is connection pool exhaustion, and here the idea is that we have a lot of clients or database clients attempting to connect to the database and to make connections, you have access to a data structure called a connection, and oftentimes, those connections are maintained in pools and if we have a single pool of connections, then any client that attempts to access the database has to allocate a connection from that pool. Now, if that pool is exhausted, then any client trying to connect is going to fail, so one thing we can do is to create multiple pools and then have different clients tap into different pools and that allows us to isolate workloads, so for example…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.