Container MySQL master-slave synchronization and performance acquisition implementation method and system

An implementation method and container technology, applied in the field of cloud computing, can solve problems such as MySQL performance collection monitoring, reduce the risk of data loss, and ensure smooth operation.

Active Publication Date: 2020-02-07
FENGHUO COMM SCI & TECH CO LTD
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Aiming at the above defects or improvement needs of the prior art, the present invention proposes a container-based MySQL master-slave synchronization and performance acquisition method and system, which can solve the problem of kubernetes-based MySQL master-slave system implementation and MySQL performance acquisition in the prior art. supervisory issues

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
  • Container MySQL master-slave synchronization and performance acquisition implementation method and system
  • Container MySQL master-slave synchronization and performance acquisition implementation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the purpose, technical solution and advantages of the present invention more clear, the present invention will be further described in detail below in conjunction with the accompanying drawings and examples. It should be understood that the specific examples described here are only used to explain the present invention, not to limit the present invention. In addition, the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not constitute a conflict with each other.

[0034] A kind of container MySQL master-slave synchronization and performance collection implementation method of an embodiment of the present invention, create MySQL master-slave database system on Kubernetes platform, this MySQL master-slave database system structure is as follows figure 1 As shown, it includes the main library (Master POD) and the slave library (slave POD). The main library inc...

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 relates to a container MySQL master-slave synchronization and performance collection implementation method and system. The method comprises the following steps: 1, preparing raw materials; the method comprises the following steps of: creating a MySQL master-slave database system on a Kubernetes platform; the MySQL master-slave database system comprises a master database and a slave database, wherein the main library comprises a mysql main node container, a data sending end container and a main library mysql-exporter container; wherein the main library mysql-exporter container isused for collecting a main library mysql performance parameter; wherein the slave library comprises a mysql slave node container, a data receiving end container and a slave library mysql-exporter container, and the slave library mysql-exporter container is used for collecting the performance parameters of the slave library mysql, so that the performance parameters of the master and standby nodes can be collected and monitored.

Description

technical field [0001] The present invention relates to the technical field of cloud computing, in particular to a method and system for implementing container MySQL master-slave synchronization and performance acquisition. Background technique [0002] In the field of cloud computing technology, the emergence of container technology has changed the running form of applications. The container orchestration system represented by kubernetes makes organizing and managing large-scale container applications more convenient and automated. At the same time, kubernetes is not limited to any programming language. It is not intrusive to existing programming languages, programming frameworks, middleware, etc. Existing applications can be easily migrated to the kubernetes platform. It is precisely because of the non-intrusiveness of the kubernetes platform that the existing MySQL data backup technology can be used to apply and monitor technology, and the Mysql master and backup clusters...

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): G06F16/27G06F16/28G06F11/34G06F11/30G06F11/14
CPCG06F16/27G06F16/284G06F11/3476G06F11/3409G06F11/3089G06F11/1458G06F11/1469G06F2201/80
Inventor 李志国于超舒添翼
Owner FENGHUO COMM SCI & TECH CO 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

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