Database switching method and system, and computer readable storage medium
A technology for switching systems and databases, which is applied in computing, electrical digital data processing, and special data processing applications. Ensure the data consistency between the original master database and the new master database
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0034] Such as figure 1 As shown, a database switching method provided in an embodiment of the present invention, the database switching method of this embodiment includes:
[0035] Step S110, in the nodes of the distributed database, acquire the state of the master database from the resource manager corresponding to the master database.
[0036] The technical solution in this embodiment can be realized on the cluster manager in the distributed data, and the structure of the distributed database is as follows figure 2 Shown:
[0037] 1. Cluster manager: Receive related requests from upper-level business for distributed database clusters, manage distributed database clusters, coordinate resource managers to report database status, and notify resource managers to perform commands such as switching, backup, and redistribution.
[0038] 2. Explorer. It is usually used as the upper agent of the database, and it is a local database monitoring program that performs complex operat...
Embodiment 2
[0059] Such as image 3 As shown, a database switching method provided in an embodiment of the present invention, the database switching method of this embodiment includes:
[0060] Step S310, in the nodes of the distributed database, obtain the state of the master database from the resource manager corresponding to the master database.
[0061] Step S320, notifying the proxy server of the information that the node no longer receives new services.
[0062] Step S330, when the abnormal state of the master database is acquired, the log information of the master database is acquired from the resource manager corresponding to the master database.
[0063] In this embodiment, after the cluster manager confirms that the proxy server has successfully stopped the failed node server, it obtains the database log information it manages from each resource manager, and the resource manager sends the log information to the cluster manager after the database playback is completed. , the cl...
Embodiment 3
[0084] Such as Figure 5 As shown, a database switching method provided in an embodiment of the present invention, the database switching method of this embodiment includes:
[0085] Step S510, in the node of the distributed database, obtain the state of the master database from the resource manager corresponding to the master database.
[0086] Step S520, notifying the proxy server of the information that the node no longer receives new services.
[0087] Step S530, when the status of the master database cannot be obtained from the resource manager corresponding to the master database, log information of the backed up master database is obtained from a preset log server.
[0088] In this embodiment, if the original master resource manager is down, the cluster manager sends a supplementary data request to each slave resource manager, and each slave resource manager uses the log information stored on the binlog server to synchronize data. After the completion of data suppleme...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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