Invention Grant
- Patent Title: System and method for supporting live addition of a tenant in a connection pool environment
-
Application No.: US15644502Application Date: 2017-07-07
-
Publication No.: US10742748B2Publication Date: 2020-08-11
- Inventor: Jean De Lavarene , Saurabh Verma , Vidya Hegde , Chandra Sekhar Krishna Mahidhara , Aramvalarthanathan Namachivayam
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Tucker Ellis LLP
- Main IPC: H04L29/08
- IPC: H04L29/08 ; G06F9/54 ; G06F16/27 ; H04L12/24 ; H04L29/06

Abstract:
Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for live addition of a tenant. When a pluggable database (PDB), for use by a tenant, is added to a multi-tenant database, it can generate an event to notify the connection pool. The connection pool environment consumes this PDB-add event, and dynamically configures a new tenant to access the shared pool. Since the new tenant addition is based on receipt of an event from the database, the connection pool does not require manual configuration for that tenant. Once a tenant is added, it can borrow connections from the pool in the same manner as existing tenants, and can also share existing pool properties, such as, for example a maximum pool size, or maximum number of connections per tenant.
Public/Granted literature
- US20180048717A1 SYSTEM AND METHOD FOR SUPPORTING LIVE ADDITION OF A TENANT IN A CONNECTION POOL ENVIRONMENT Public/Granted day:2018-02-15
Information query