Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Autonomous capacity expansion and shrinkage method for cloud native MySQL cluster

A cluster and container technology, applied in the field of database control, can solve the problem of time-consuming and achieve the effect of improving efficiency

Pending Publication Date: 2022-03-08
INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER +2
View PDF14 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the above problems, the purpose of the present invention is to provide a method for independent expansion and contraction of cloud-native MySQL clusters, so as to solve the problem that users need to manually adjust resource configurations and database parameter configurations when expanding and shrinking database clusters, which consumes a lot of time. technical problem

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
  • Autonomous capacity expansion and shrinkage method for cloud native MySQL cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0022] figure 1 Is the general flow chart of the present invention, and this method comprises the steps:

[0023] 1) First, multiple resource indicators of the container resource and multiple performance indicators of the database are collected.

[0024] 2) If the resource index exceeds the pre-configured resource threshold range, modify the resource limit of the container resource based on the resource index, and adjust the performance parameters of the database.

[0025] That is, when the resource index of the container source exceeds the pre-configured resource threshold range, the container resource limit is adjusted based on the resource index, and the corresponding parameters of the database are automatically adjusted.

[0026] 3) If the performance index exceeds the pre-configured performance threshold range, automatically modify the resource limit of the container resource or automatically adjust the number of nodes of the database cluster based on the performance ind...

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 discloses an autonomous capacity expansion and shrinkage method for a cloud native MySQL cluster. The method comprises the steps of collecting a plurality of resource indexes of container resources and a plurality of performance indexes of a database; if the resource index exceeds the pre-configured resource threshold range, modifying the resource limitation of the container resource based on the resource index, and adjusting the performance parameter of the database; and if the performance index exceeds the pre-configured performance threshold range, automatically modifying the resource limitation of the container resource or automatically adjusting the number of nodes of the database cluster based on the performance index. The technical problem that when a database cluster needs to be expanded and shrunk in the prior art, a user needs to manually adjust resource configuration and manually adjust database parameter configuration, and a large amount of energy and time of the user are consumed is solved.

Description

technical field [0001] The invention relates to the technical field of database control, and relates to a database control method, in particular to a method for autonomous expansion and contraction of a cloud-native MySQL cluster. Background technique [0002] MySQL database, as one of the most popular open source relational databases, has been widely recognized for its stability, ease of use, and high performance. However, due to its open-source nature and very flexible usage, it is difficult for users to ensure a unified environment and consistent version in their database architecture and use, and cannot achieve one-click deployment. Scaling and shrinking often require users to spend a lot of energy and time. As the current mainstream distributed architecture solution based on container technology, Kubernetes is very mature in the convenient arrangement of stateless application deployment and capacity expansion, but its support for stateful applications such as databases ...

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
IPC IPC(8): G06F9/445G06F16/21
CPCG06F9/4451G06F16/211
Inventor 邹昊东王凌刘小磊汤铭戚林成杜元翰贺敬伟张世杰
Owner INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com