A method and system for business segmentation and optimization of database cluster

A technology of cluster business and database, which is applied in the field of database cluster business segmentation optimization, can solve the problems that the application system cannot achieve business segmentation, achieve the effect of optimizing business segmentation, improving user experience, and improving business operation speed

Active Publication Date: 2019-08-16
SHENZHEN POWER SUPPLY BUREAU
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, the above scenario is an idealized situation, and it is often impossible to achieve business segmentation without dependencies in real application systems

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
  • A method and system for business segmentation and optimization of database cluster
  • A method and system for business segmentation and optimization of database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings.

[0034] Such as figure 1 Shown here is a method for segmentation optimization of database cluster services provided in an embodiment of the present invention, which is implemented on at least two servers for running database cluster services, and the method includes:

[0035] Step S1: Designate a server as a master node and designate servers other than the master node as slave nodes, and obtain the current CPU load capacity of the master node and the waiting services included in the database cluster business operation;

[0036] The specific process is to specify the master and slave servers of the database cluster business and respectively serve as the master and slave nodes, and the main indicator to measure whether each node can dynamically accommodate services is whe...

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 invention provides a method for optimizing database cluster service separation. The method is achieved on at least two severs for database cluster service operation and comprises the steps that one server is assigned as a master node, the server except for the master node is assigned as a slave node, and the current CPU load capacity and a waiting service included in the master node are acquired; when the current CPU load capacity of the master node is larger than a preset first threshold value, the service affinity matrix of the master node is determined and calculated according to the waiting service of the master node, and when the calculated value is smaller than a preset second threshold value, the waiting service of the master node is dynamically expanded to the slave node; the service affinity matrix is formed by affinity between all services of the current nodes, and the affinity is the number of times of locking of all the services of the current nodes on the same object among different living examples. By means of the method, service separation can be optimized, contention of resources in a system can be reduced, the service operation speed can be increased, and user experience can be improved.

Description

Technical field [0001] The present invention relates to the technical field of databases, in particular to a method and system for segmentation optimization of database cluster business. Background technique [0002] The development of database technology has always provided a solid foundation for the process of enterprise informatization, and it is a key area of ​​IT infrastructure construction. With the accumulation of data and the development of demand for enterprise-level applications, it has led to the demand for database processing capabilities in applications year by year increase. In scenarios where the performance of a single host cannot meet a large number of business requests, the cluster database provides timely support for the horizontal expansion of enterprise applications. While meeting the performance and scalability requirements of the enterprise business system, it also has high availability. It has gradually become a standard configuration in enterprise critic...

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 Patents(China)
IPC IPC(8): G06F9/50
CPCG06F9/5088G06F2209/5017G06F2209/508
Inventor 张华兵何子龙陈瑞黄建华
Owner SHENZHEN POWER SUPPLY BUREAU
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap