Database management system and method

A management system and database technology, applied in database management system, database design/maintenance, database distribution/replication, etc., can solve the problem of inflexible database architecture and achieve the effect of expansion

Pending Publication Date: 2020-07-28
SF TECH
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Since all database clusters are managed by the configured MHA-manger and MHA-agent, when multiple database instances need to be deployed on a physical host, multiple MHA-agents are correspondingly deployed on the physical host, resulting in inconsistent database architecture. flexible

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
  • Database management system and method
  • Database management system and method
  • Database management system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the related application, not to limit the application. It should also be noted that, for the convenience of description, only the parts related to the application are shown in the drawings.

[0025] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0026] Understandably, in the MySQL cluster framework, such as figure 1 As shown, the management service (MHA-manger) is deployed on the management server, and an agent service (MHA-agent) is deployed for each database instance on each database server. When the management server m...

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 a database management system and method. The system comprises a first management, wherein the first management server comprises: a detection module which is used for detectingthe connectivity of a main server in the database cluster managed by the first management server, the connectivity of a physical host where the main server is located and/or the connectivity of a database instance of the main server through java database connection; and a switching module which is used for switching the slave server in the database cluster to the master server of the database cluster based on the detection result of the detection module. According to the embodiment of the invention, the direct interaction between the management server and the databases in the managed databasecluster is completed by utilizing java database connection, proxy services do not need to be deployed in the database instances, the management of the database cluster in which a plurality of databaseinstances are deployed on the master server and the slave server is realized, and the extension of the database architecture is realized.

Description

technical field [0001] This application generally relates to the technical field of database operation and maintenance management, and specifically relates to a database management system and method. Background technique [0002] With the expansion of enterprise scale and the complexity of business forms, the requirements for database management capabilities and storage capabilities within enterprises are getting higher and higher. Compared with the storage performance of the traditional Oracle database architecture and storage network (SAN), the high-availability database architecture (MySQL HA) of the SSD architecture has better storage performance. [0003] The high-availability database architecture requires that there must be at least three database servers in a database cluster, one master and two slaves, that is, one acts as the master server, one charges the backup server, and the other acts as the slave server. It is also required to configure a management server, ...

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): G06F16/21G06F16/27G06F16/25
Inventor 章爱国刘力孟祥晶高欢斌
Owner SF TECH
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