US 11,983,151 B2
Resilience based database placement in clustered environment
Nagarajan Muthukrishnan, Foster City, CA (US); Binoy Sukumaran, Foster City, CA (US); Garret F. Swart, Palo Alto, CA (US); Sumanta Chatterjee, Menlo Park, CA (US); and Ravi Shankar Thammaiah, Redwood City, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on May 28, 2021, as Appl. No. 17/334,360.
Prior Publication US 2022/0382721 A1, Dec. 1, 2022
Int. Cl. G06F 16/21 (2019.01); G06F 11/20 (2006.01); G06F 11/34 (2006.01); G06F 16/25 (2019.01); H04L 67/1001 (2022.01)
CPC G06F 16/21 (2019.01) [G06F 11/203 (2013.01); G06F 11/3428 (2013.01); G06F 16/256 (2019.01); H04L 67/1001 (2022.05)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
identifying a plurality of alternative placements each of which assigns each pluggable database of a plurality of pluggable databases to a respective container database of a plurality of container databases, wherein:
a) for each alternative placement of the plurality of alternative placements, each container database of the plurality of container databases contains respective one or more pluggable databases of the plurality of pluggable databases;
b) each pluggable database of the plurality of pluggable databases has:
a respective operating amount of a resource and
a respective reduction limit for the resource;
for each alternative placement of the plurality of alternative placements;
a) calculating a respective resilience score for each pluggable database of the plurality of pluggable databases that is based on:
the container database of the pluggable database, and
the respective operating amount and reduction limit of the resource for the pluggable database;
b) calculating a respective resilience score for each container database of the plurality of container databases that is based on the respective resilience scores of the respective one or more pluggable databases of the container database for the alternative placement;
selecting, based on the respective resilience scores of the plurality of container databases for the plurality of alternative placements, a particular placement of the plurality of alternative placements; and
configuring, based on the particular placement of the plurality of alternative placements, the plurality of pluggable databases in the plurality of container databases;
wherein the method is performed by one or more computers.