CONTROLLING THE USE OF COMPUTING RESOURCES IN A DATABASE AS A SERVICE

• US 20130139172A1
• Filed: 11/26/2012
• Published: 05/30/2013
• Est. Priority Date: 11/25/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: AN, Wen Hao, FAN, Li Ya, GAO, Bo, GUO, Chang Jie, REINWALD, Berthold, SUN, Wei, WANG, Ning, WANG, Zhi Hu
• Granted Patent: US 9,027,028 B2
• Time in Patent Office: Days
• US Class Current: 718/104
• CPC Class Codes: G06F 2209/504 Resource capping
• CPC Class Codes: G06F 2209/508 Monitor
• CPC Class Codes: G06F 9/5005 to service a request
• CPC Class Codes: G06F 9/5027 the resource being a machine, e.g. CPUs, Servers, Terminals
• CPC Class Codes: Y02D 10/00 Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

A method and apparatus controls use of a computing resource by multiple tenants in DBaaS service. The method includes intercepting a task that is to access a computer resource, the task being an operating system process or thread; identifying a tenant that is in association with the task from the multiple tenants; determining other tasks of the tenant that access the computing resource; and controlling the use of the computing resource by the task, so that the total amount of usage of the computing resource by the task and the other tasks does not exceed the limit of usage of the computing resource for the tenant.

Claims

1. A method for controlling use of a computing resource by multiple tenants in DBaaS service, comprising:

intercepting a task that is to access a computing resource, the task being an operating system process or thread;

identifying a tenant that is in association with the task from the multiple tenants;

determining other tasks of the tenant that access the computing resource; and

controlling the use of the computing resource by the task, so that a total amount of usage of the computing resource by the task and the other tasks does not exceed a limit of usage of the computing resource for the tenant.

2. The method of claim 1, wherein the limit of usage of the computing resource for the tenant is allocated when the tenant subscribes the DBaaS service.

3. The method of claim 2, further comprising:

in response to initiating at least one task for a database request, identifying a relationship of the at least one task with said multiple tenants,

wherein said task that is to access a computing resource is from the at least one task.

4. The method of claim 3, wherein each of the multiple tenants shares the computing resource of a same virtual machine or physical machine in one or ore of the following ways:

having exclusive use of a single database server;

sharing a common database server with other tenants of the multiple tenants wherein each of the sharing tenants has exclusive use of a database respectively;

sharing a common database on a database server with other tenants of the multiple tenants wherein each of the sharing tenants has exclusive use of a database schema respectively; and

sharing a common set of database tables of a database on a database server with other tenants of the multiple tenants.

5. The method of claim 4, wherein the computing resource is a central processing unit (CPU) and said controlling the use of the computing resource by the task comprises:

calculating a number of available time slices in unit time of CPU scheduling for the tenant according to a total number of time slices in unit time of CPU scheduling and a limit of usage of CPU for the tenant;

within each unit time of CPU scheduling, allocating time slices for execution to the task and the other tasks until the number of time slices allocated reaches the number of available time slices.

6. The method of claim 4, wherein the computing resource is memory and said controlling the use of the computing resource by the task comprises:

allocating memory for the task from a memory space reserved in accordance with a limit of usage of memory for the tenant, so that a total amount of usage of memory by the task and the other tasks will not exceed the limit of usage of the memory for the tenant.

7. The method of claim 6, wherein each tenant of the multiple tenants has exclusive use of a single database server and the task is a process of the operating system.

8. The method of claim 4, wherein each tenant of the multiple tenants share a common physical machine and the computing resource is disk input/output, and wherein said controlling the use of the computing resource by the task comprises:

dividing the task and the other tasks, based on disk space vicinity, into a plurality of basic disk input/output (BIO) tasks in association with the tenant; and

controlling a starting time of execution of each of the plurality of BIO tasks in accordance with a limit of usage of Disk_IO for the tenant, so that the total amount of usage of Disk_IO of the plurality of BIO tasks does not exceed the limit of usage of Disk_IO for the tenant.

9. An apparatus for controlling use of computing resources by multiple tenants in DBaaS service, comprising:

a task intercepting module, configure to intercept a task that is to access a computing resource, the task being an operating system process or thread;

a tenant identifying module, configured to identify a tenant that is in association with the task from the multiple tenants;

a task group determining module, configured to determine other tasks of the tenant that access the computing resource; and

a resource control module, configured to control the use of the computing resource by the task, so that a total amount of usage of the computing resource by the task and the other tasks does not exceed a limit of usage of the computing resource for the tenant.

10. The apparatus of claim 9, wherein the limit of usage of the computing resource for the tenant is allocated when the tenant subscribes the DBaaS service.

11. The apparatus of claim 10, further comprising:

a relation identifying module configured to identify a relationship of at least one task with said multiple tenants in response to initiating at least one task for a database request.

12. The apparatus of claim 11, wherein each of the multiple tenants shares the computing resource of a same virtual machine or physical machine in one or more of the following ways:

having exclusive use of a single database server;

sharing a common database server with other tenants of the multiple tenants wherein each sharing tenant have exclusive use of a database respectively;

sharing a common database on a database server with other tenants of the multiple tenants wherein each of the sharing tenants has exclusive use of a database schema respectively; and

sharing a common set of database tables of a database on a database server with other tenants of the multiple tenants.

13. The apparatus of claim 12, wherein the resource control module comprises a CPU resource controller which is configured to calculate a number of available time slices in unit time of CPU scheduling for the tenant according to a total number of time slices in unit time of CPU scheduling and a limit of usage of CPU for a tenant;

and

the CPU resource controller is further configured to, within each unit time of CPU scheduling, allocate time slices for execution to all CPU-accessing tasks of the tenant until the number of time slices allocated reaches the number of available time slices.

14. The apparatus of claim 12, wherein the resource control module comprises a memory resource controller which is configured to allocate memory for the task from a memory space reserved in accordance with a limit of usage of memory for the tenant, so that a total amount of usage of memory by the task and other memory-accessing tasks of the tenant do not exceed the limit of usage of the memory for the tenant.

15. The apparatus of claim 14, wherein each tenant of the multiple tenants has exclusive use of a single database server and the task is a process of an operating system.

16. The apparatus of claim 12, wherein the resource control module comprises a disk input/output resource controller which is configured to divide the task and the other tasks, based on disk space vicinity, into a plurality of basic disk input/output (BIO) tasks in association with the tenant;

and to control a starting time of execution of each of the plurality of BIO tasks in accordance with a limit of usage of Disk_IO for the tenant, so that a total amount of usage of Disk_IO of the plurality of BIO tasks does not exceed a limit of usage of Disk_IO for the tenant.

17. A computer program product for controlling use of a computing resource by multiple tenants in DBaaS service, the computer program product comprising:

a tangible computer-readable medium; and

computer program instructions for

intercepting a task that is to access a computing resource, the task being an operating system process or thread,

identifying a tenant that is in association with the task from the multiple tenants,

determining other tasks of the tenant that access the computing resource, and

controlling the use of the computing resource by the task, so that a total amount of usage of the computing resource by the task and the other tasks does not exceed a limit of usage of the computing resource for the tenant.