Flexible scheduling method and device for database

A scheduling method and technology of a scheduling device, applied in the database field, can solve problems such as poor stability of database services, complex calculation process, high migration cost, etc., and achieve the effects of avoiding complex calculation process, improving execution efficiency, and reducing the number

Inactive Publication Date: 2017-01-18
ALIBABA GRP HLDG LTD
View PDF8 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The embodiment of the present application provides a database elastic scheduling method and device to solve the problems of complex calculation process, high migration cost, and poor stability of database services caused by jitter in existing elastic scheduling schemes

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Flexible scheduling method and device for database
  • Flexible scheduling method and device for database
  • Flexible scheduling method and device for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the application. However, the present application can be implemented in many other ways different from those described here, and those skilled in the art can make similar promotions without violating the connotation of the present application. Therefore, the present application is not limited by the specific implementations disclosed below.

[0077] In this application, a database flexible scheduling method and a database flexible scheduling device are respectively provided, which will be described in detail in the following embodiments.

[0078] Please refer to figure 1 , which is a flow chart of an embodiment of a database elastic scheduling method of the present application. The method comprises the steps of:

[0079] Step 101, acquiring performance parameter values ​​of database servers and database instances participating in flexible scheduling. ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The application discloses a flexible scheduling method and device for database comprising following steps: obtaining the performance parameter values of a database server and database instances that participate in the flexibility scheduling; selecting a database server whose performance parameter value exceeds a preset capacity upper limit; selecting a database instance from the database server and migrating it to a database server capable of accepting; determining whether or not a predetermined scheduling termination condition is satisfied, and if not, turning to and executing the step of selecting the database server whose selection performance parameter value exceeds the preset capacity upper limit. The application provides a flexible scheduling device for database at the same time. The use of the flexible scheduling method for database provided in this application avoids the jitter caused by the real-time change of the performance of the database instance, on the other hand can reduce the number of migrating database instances, reduce the migration cost, and use the heuristic method to avoid the complicated calculation process, effectively improve the efficiency of the implementation.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a database flexible scheduling method. The present application also relates to a database flexible scheduling device. Background technique [0002] With the advancement of cloud computing technology in full swing, database technology is also facing changes from traditional stand-alone services to cluster services, and even data center-level service. In the process of database service, in order to realize the automatic operation, maintenance and management of massive database instances, database elastic scheduling has become an essential technical means to solve and support database cloudification. The flexible database scheduling generally refers to calculating how database instances are distributed to database servers, that is, the combination of database instances, according to certain trigger conditions and constraints, and based on preset scheduling objective...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 王恒陈旭
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products