PLACEMENT GOAL-BASED DATABASE INSTANCE DYNAMIC CONSOLIDATION
First Claim
1. A computer-readable non-transitory storage medium configured with data and with instructions that when executed by at least one processor causes the processor(s) to perform a process for facilitating database instance consolidation, the process comprising the steps of:
- obtaining standardized database instance performance data for database instances running on source machines;
receiving at least one database instance isolation criterion;
applying at least one received database isolation criterion to automatically divide database instances into instance sets;
determining a resource usage for each instance set; and
automatically assigning instance sets to target machines based on instance set resource usage and target machine resource capacity, and utilizing at least one of the following;
dynamic programming, combinatorial optimization.
2 Assignments
0 Petitions
Accused Products
Abstract
Models and tools for facilitating database instance consolidation are described. One approach obtains standardized database instance performance data, receives instance isolation criteria which are applied to divide instances into sets, determines resource usage for each set, and assigns instance sets to target machines based on resource usage and capacity. Each instance set is associated with a virtual machine in some cases. A security isolation criterion indicates that specified instances shall not co-reside on a target machine; an organizational criterion indicates that specified instances shall be located together in a single data center; a compatibility criterion indicates that instances shall not reside in the same virtual machine, the same physical server, or the same server pool. Users iteratively reach an acceptable consolidation of instances at one or more data centers, such as an enhanced assignment of instances that is more efficient than a linear additive solution.
-
Citations
20 Claims
-
1. A computer-readable non-transitory storage medium configured with data and with instructions that when executed by at least one processor causes the processor(s) to perform a process for facilitating database instance consolidation, the process comprising the steps of:
-
obtaining standardized database instance performance data for database instances running on source machines; receiving at least one database instance isolation criterion; applying at least one received database isolation criterion to automatically divide database instances into instance sets; determining a resource usage for each instance set; and automatically assigning instance sets to target machines based on instance set resource usage and target machine resource capacity, and utilizing at least one of the following;
dynamic programming, combinatorial optimization. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A process for placement goal-based database instance consolidation, the process comprising the steps of:
-
gathering database instance performance data for database instances running on source machines; standardizing gathered performance data; entering into a user interface of a consolidation tool at least one database instance placement goal in the form of at least one isolation criterion; identifying target machine characteristics to the consolidation tool; commanding the consolidation tool to apply one or more database isolation criteria to the standardized performance data and the target machine characteristics; and getting from the consolidation tool an enhanced assignment of instances to target machines, namely, an assignment which is more resource efficient than an additive linear assignment. - View Dependent Claims (10, 11, 12, 13, 14, 15)
-
-
16. A computer system configured to assist database instance consolidation, the system comprising:
-
a logical processor; a memory in operable communication with the logical processor; at least one database instance isolation criterion residing in the memory; and database instance consolidation code residing in the memory and capable of automatically applying the database isolation criterion to divide database instances into instance sets and capable of automatically assigning instance sets to target machines by dynamic programming based on instance set resource usage and target machine resource capacity. - View Dependent Claims (17, 18, 19, 20)
-
Specification