CN108897658A - Primary database monitoring method, device, computer equipment and storage medium - Google Patents
Primary database monitoring method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN108897658A CN108897658A CN201810549605.4A CN201810549605A CN108897658A CN 108897658 A CN108897658 A CN 108897658A CN 201810549605 A CN201810549605 A CN 201810549605A CN 108897658 A CN108897658 A CN 108897658A
- Authority
- CN
- China
- Prior art keywords
- write
- primary database
- data
- field data
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application involves a kind of primary database monitoring method, device, computer equipment and storage mediums.The method includes：Obtain the corresponding configuration file of data-base cluster；The primary database in the data-base cluster is determined according to the configuration file；Designated field data is written to the primary database；When determining write-in failure, the first write-in control instruction is sent to the first monitoring server；The first write-in control instruction is used to indicate first monitoring server and the designated field data is written to the primary database；Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；When the prompt information indicates write-in designated field data failure, triggering switching primary database.It can be avoided the wasting of resources caused by causing primary database to switch because of network connectivity problem using this method.
Description
Technical field
This application involves database technical fields, set more particularly to a kind of primary database monitoring method, device, computer
Standby and storage medium.
Background technique
With the development of database technology, there is data-base cluster technology, as its name suggests, data-base cluster is exactly by extremely
Lack the cluster of two or more databases composition.Read and write abruption may be implemented in data-base cluster, i.e., includes master in data-base cluster
Database and from database, primary database is read-write, read-only from database, respectively from the number of database real-time synchronization primary database
According to guarantee the data consistency of master-slave database, so as to improve the system performance of database.It can be seen that effectively supervising
It controls the operating condition of primary database and guarantees that the read-write function of data-base cluster is vital.
Currently used primary database monitoring method is that (Master High Availability, High Availabitity are soft based on MHA
Part) realize, MHA monitoring management server detects the operating status of primary database by connection primary database, when connection is lost
It loses, determines primary database operation troubles.
However, current primary database monitoring method, exists due between MHA monitoring management server and primary database
Network connectivity problem leads to frequent switching primary database, so as to cause the wasting of resources.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of primary database monitoring that can be avoided the wasting of resources
Method, apparatus, computer equipment and storage medium.
A kind of primary database monitoring method, the method includes：
Obtain the corresponding configuration file of data-base cluster；
The primary database in the data-base cluster is determined according to the configuration file；
Designated field data is written to the primary database；
When determining write-in failure, the first write-in control instruction is sent to the first monitoring server；The first write-in control
System instruction is used to indicate first monitoring server and the designated field data is written to the primary database；
Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；
When the prompt information indicates that designated field data failure is written, triggering switching primary database.
A kind of primary database monitoring device, described device include：
Module is obtained, for obtaining the corresponding configuration file of data-base cluster；
Determining module, for determining the primary database in the data-base cluster according to the configuration file；
Writing module, for designated field data to be written to the primary database；
Sending module, for sending the first write-in control instruction to the first monitoring server when determining write-in failure；Institute
It states the first write-in control instruction and is used to indicate first monitoring server to the primary database write-in designated word number of segment
According to；
Receiving module, for receiving the corresponding with the first write-in control instruction of the first monitoring server feedback
Prompt information；
Switching module, for triggering switching master when the prompt information indicates that designated field data failure is written
Database.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device realizes following steps when executing the computer program：
Obtain the corresponding configuration file of data-base cluster；
The primary database in the data-base cluster is determined according to the configuration file；
Designated field data is written to the primary database；
When determining write-in failure, the first write-in control instruction is sent to the first monitoring server；The first write-in control
System instruction is used to indicate first monitoring server and the designated field data is written to the primary database；
Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；
When the prompt information indicates that designated field data failure is written, triggering switching primary database.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
Following steps are realized when row：
Obtain the corresponding configuration file of data-base cluster；
The primary database in the data-base cluster is determined according to the configuration file；
Designated field data is written to the primary database；
When determining write-in failure, the first write-in control instruction is sent to the first monitoring server；The first write-in control
System instruction is used to indicate first monitoring server and the designated field data is written to the primary database；
Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；
When the prompt information indicates that designated field data failure is written, triggering switching primary database.
Above-mentioned primary database monitoring method, device, computer equipment and storage medium, it is true according to acquired configuration file
The primary database in data-base cluster is determined, by the way that the corresponding operation for determining primary database of designated field data is written to primary database
State.When determining write-in failure, show the possible operation troubles of primary database, sends the first write-in control to the first monitoring server
System instruction, designated field data is written to the primary database by the first monitoring server, to further determine that master data
The operating status in library.When received prompt information indicates write-in designated field data failure, i.e. the first monitoring server is to master
When designated field data failure is written in database, primary database operation troubles is determined, then trigger switching primary database to ensure to count
According to the normal operation of library cluster.It can effectively avoid causing frequent switching to operate normally because of network connectivity problem by this kind of mode
Primary database the problem of, so as to avoid the waste of resource.
Detailed description of the invention
Fig. 1 is the application scenario diagram of primary database monitoring method in one embodiment；
Fig. 2 is the flow diagram of primary database monitoring method in one embodiment；
Fig. 3 is the flow diagram of primary database monitoring method in another embodiment；
Fig. 4 is the structural block diagram of primary database monitoring device in one embodiment；
Fig. 5 is the structural block diagram of primary database monitoring device in another embodiment；
Fig. 6 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Primary database monitoring method provided by the present application, can be applied in application environment as shown in Figure 1.Wherein, number
It is communicated according between library cluster 102, the first monitoring server 104 and monitoring management server 106 by network.Data base set
Group 102 can be communicated with the first monitoring server 104 and monitoring management server 106 respectively by private line network.First
Monitoring server 104 can pass through outer net VPN (Virtual Private Network, Virtual Private Network) and monitoring management
Server 106 is communicated.Primary database 1020 in data-base cluster 102 can respectively by private line network with from database
(1022,1024 and 1026) are communicated, wherein can be customized according to the actual situation from quantity database.
Each database in data-base cluster 102 can be deployed in the same computer room or be deployed in different computer rooms,
It is such as deployed in principal and subordinate's two-shipper room.Monitoring management server 106 can exist independently of data-base cluster 102, can also be by number
It is deployed on monitoring management server 106 according at least one database portion in library cluster 102.Monitoring management server 106 can be with
Different computer rooms are deployed in from primary database 1020.
In one embodiment, as shown in Fig. 2, providing a kind of primary database monitoring method, it is applied to Fig. 1 in this way
In monitoring management server for be illustrated, include the following steps：
S202 obtains the corresponding configuration file of data-base cluster.
Wherein, data-base cluster is the cluster being made of multiple databases.Data-base cluster includes primary database and from number
According to library.Primary database has read-write attribute, for example terminal can be written data to primary database or read from primary database
It fetches evidence, from the specific read only attribute of database, for example terminal cannot be to being successfully written data from database but can be since data
Data are read in library.The data in primary database can be synchronized to local from database, to realize each number in data-base cluster
According to the consistency of data in library.In the present embodiment, include in a data-base cluster primary database and at least one from
Database.
Configuration file is the pre-set file data about database each in data-base cluster.Configuration file includes number
According to primary database in library cluster identity and data-base cluster and respectively from the corresponding IP (Internet of database
Protocol, network address), port, domain name, computer room name and principal and subordinate's role identification etc..For each from number in data-base cluster
According to library, configuration file further includes the priority tag, candidate from Database Identification or non-that primary database is respectively switched to from database
Candidate is from Database Identification etc..
Specifically, monitoring management server obtains the corresponding configuration file of data-base cluster from local.Monitoring management service
Device can also be by sending configuration file acquisition request to the server of storage configuration file, to receive the corresponding inquiry of the server
And the configuration file fed back.Monitoring management server can obtain the corresponding configuration file of data-base cluster according to predetermined period.
Monitoring management server can also be in the primary database monitoring instruction for receiving terminal transmission, master data based on the received
Library monitoring instruction is corresponding to obtain the corresponding configuration file of specified database cluster.
S204 determines the primary database in data-base cluster according to configuration file.
Specifically, monitoring management server obtains each database in data-base cluster respectively according to configuration file and respectively corresponds to
Principal and subordinate's role identification, and then according to the corresponding master data determined in the data-base cluster of acquired each principal and subordinate's role identification
Library.
In one embodiment, monitoring management server obtains each database in data-base cluster according to configuration file respectively
Corresponding network address sends the acquisition of master-slave synchronisation state to each database according to acquired network address respectively and refers to
It enables, and then according to the corresponding primary database determined in the data-base cluster of master-slave synchronisation state of the corresponding feedback of each database.Tool
Body, corresponding master-slave synchronisation state is respectively inquired and feeds back from database root according to the master-slave synchronisation state acquisition instruction received,
And primary database is then without corresponding feedback result.Whether monitoring management server corresponds to feedback master-slave synchronisation according to each database
State determines primary database.
Designated field data is written to primary database in S206.
Wherein, designated field data is the corresponding field value of preassigned field.Designated field data specifically can be
Timestamp, such as the corresponding timestamp of current time.Designated field data is also possible to specified character string, such as by primary database
Mark and number composition character string M0, which can be invariable, can also according to write-in number increase and
Variation, for example be for the first time M0, second is M1, and so on.
Specifically, it after monitoring management server is according to the corresponding primary database determined in data-base cluster of configuration file, presses
It repeats that designated field data is written to primary database according to predetermined period.In other words, monitoring management server is according to predetermined period
Update the designated field data in primary database.The finger of primary database can be written in designated field data by monitoring management server
Determine in table.The designated field data that record monitoring management server is written every time in the specified table, can be recorded with cover type, can also
Successively to be recorded according to write sequence.
In one embodiment, when monitoring management server receives the primary database monitoring instruction of terminal transmission, according to
The primary database monitoring instruction received obtains designated field data, and master data is written in accessed designated field data
Library.
For example, monitoring management server the current time corresponding time can be written into primary database every 3 seconds
Stamp can also obtain current time when receiving primary database monitoring instruction, and by the corresponding update of time stamp of current time
To primary database, to record the timestamp in primary database.
S208 sends the first write-in control instruction to the first monitoring server when determining write-in failure；First write-in control
System instruction is used to indicate the first monitoring server and designated field data is written to primary database.
Wherein, write-in, which unsuccessfully refers to, is not successfully written designated field data in primary database.Write-in unsuccessfully shows to supervise
Control management server is not successfully updated the designated field data of primary database.First monitoring server is for monitoring master data
The server of library operating status.First write-in control instruction is to trigger the control instruction of designated field data write operation.First
Write-in control instruction is used to indicate the first monitoring server and designated field data is written into primary database.
Specifically, when monitoring management server fails to primary database write-in designated field data, show primary database
Currently possible operation troubles, monitoring management server triggers generate the first write-in control instruction, and the first write-in of generation is controlled
System instruction is sent to the first monitoring server.When first monitoring server receives the first write-in control instruction, according to receiving
The first write-in control instruction obtain designated field data, by acquired designated field data write-in primary database, with into
One step determines the operating status of primary database.
In one embodiment, the first write-in control instruction includes designated field data, and the first monitoring server receives
When the first write-in control instruction, parses the first write-in control instruction and obtain designated field data, by specific field obtained
Primary database is written in data.In one embodiment, the first write-in control instruction includes the network address of primary database, the first prison
Control server parsing institute it is received first write-in control instruction obtain primary database network address, according to the network address access
Primary database, and then designated field data library is written in primary database.
In one embodiment, it when the first monitoring server receives the first write-in control instruction, is specified from local obtain
Field data, or designated field data is obtained from monitoring management server according to the first write-in control instruction.For example, the first prison
Control server obtains current time corresponding timestamp when receiving the first write-in control instruction, the timestamp of acquisition is used as specified
Field data.
In one embodiment, when determining to be written successfully, show that primary database is in normal operating condition, monitoring management
Server continues that designated field data is written to the primary database according to predetermined period.For example, predetermined period such as 3 seconds,
When determining to be written successfully, designated field data is written to primary database again after waiting 3 seconds in monitoring management server, with monitoring
Operating status of the primary database after 3 seconds.
In one embodiment, when monitoring management server fails to primary database write-in designated field data, monitoring
Designated field data is written to primary database again in management server, when determining write-in failure again, monitoring management server
Above-mentioned the step of designated field data is written to primary database is repeated according to this.Monitoring management server calculates write-in failure
Number sends the first write-in control instruction to the first monitoring server when the number of write-in failure reaches preset times.
S210 receives the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback.
Wherein, prompt information is the information for prompting designated field data write-in success or not.Prompt information specifically may be used
To be made of at least one of characters such as number, letter and symbol, such as 0 or 1, prompt information is 0 expression write-in failure,
Prompt information is that 1 expression is written successfully.
Specifically, designated word is written to primary database according to the first write-in control instruction received in the first monitoring server
Segment data determines to primary database write-in designated field data success or failure as a result, according to determining that it is corresponding that result generates
Prompt information, and prompt information generated is fed back into monitoring management server.When judgement write-in designated field data success
When, the first monitoring server indicates the write-in successful prompt information of designated field data to monitoring management server feedback, when sentencing
Surely when the failure of write-in designated field data, the first monitoring server corresponds to the prompt of feedback representation write-in designated field data failure
Information.
S212, when prompt information indicates write-in designated field data failure, triggering switching primary database.
Wherein, switching primary database, which refers to, is switched to the current primary database in data-base cluster from the data-base cluster
The slave database of middle selection, obtains new primary database.In other words, switching primary database refers to and will select from data-base cluster
Slave database be configured to new primary database, current primary database is substituted as the main number of data-base cluster using the new primary database
According to library, the write operation of terminal is received by the new primary database.Switching primary database specifically can be the readable of primary database
It writes attribute and new primary database is switched to by the current primary database of data-base cluster.Before primary database switching, terminal or monitoring
Data are written to the current primary database of data-base cluster in management server, after the completion of primary database switching, terminal or monitoring pipe
It manages server and data is written to new primary database.
For example, data-base cluster is formed by primary database and from database.The current master data of the data-base cluster
Library is A, includes B, C and D from database, switching primary database refer to selected from database B, C and D any one (assuming that choosing
The slave database selected is B) it is used as new primary database, and current primary database A is switched to the slave database B of selection, master data
After the completion of the switching of library, the primary database of the data-base cluster is selected from database B.
Specifically, when the prompt information of the first monitoring server feedback indicates write-in designated field data failure, show
In monitoring management server in the case where primary database write-in designated field data failure, the first monitoring server is to master data
Designated field data failure is written in library, and then shows primary database operation troubles.Monitoring management server is from data-base cluster
Each selection from database from database, and the primary database in data-base cluster is switched to it is selected from database,
To realize the switching of primary database.
Triggering switching primary database when monitoring management server monitors primary database failure by the above method, by cutting
The transfer of change owner database realizing primary database failure, ensure that the read-write attribute of primary database in data-base cluster, thus
It ensure that terminal can successfully write data into the primary database in data-base cluster.
In one embodiment, when monitoring management server switching primary database is completed, triggering switching primary database domain name.
Specifically, the primary database in data-base cluster is switched to new primary database by current primary database by monitoring management server
When, the domain name of current primary database is switched into new primary database.In other words, monitoring management server switching primary database is complete
The domain name of new primary database is updated to the domain name of current primary database by Cheng Shi.After the completion of the switching of primary database domain name, terminal root
It can the new primary database of successful access according to the domain name of current primary database.
Above-mentioned primary database monitoring method determines the primary database in data-base cluster according to acquired configuration file,
By the way that the corresponding operating status for determining primary database of designated field data is written to primary database.When determining write-in failure, table
The possible operation troubles of bright primary database sends the first write-in control instruction to the first monitoring server, to take by the first monitoring
Device be engaged in primary database write-in designated field data, to further determine that the operating status of primary database.It is mentioned when received
When showing that information indicates write-in designated field data failure, i.e. the first monitoring server loses to primary database write-in designated field data
When losing, primary database operation troubles is determined, then trigger switching primary database to ensure the normal operation of data-base cluster.By this
Kind mode can effectively avoid the problem that the primary database for causing frequent switching to operate normally because of network connectivity problem, to avoid
The waste of resource.
In one embodiment, above-mentioned primary database monitoring method further includes：Designated field data is written to primary database
Shi Qi, cumulative calculation are successfully written the write-in waiting time of designated field data；When write-in waiting time, which reaches default, to be waited
When long, write-in failure is determined.
Wherein, write-in waiting time is to wait the cumulative time length for being successfully written designated field data.When write-in waits
It is long refer to when designated field data is written to primary database in beginning from, to only this period when being successfully written the designated field data
Length.Default waiting time is the preset duration threshold value for waiting and being successfully written designated field data.Default waiting time
It is the foundation for determining write-in designated field data failure.Specifically, the write-in that waiting time is used for and practical calculating obtains is preset
Waiting time compares, and then determines write-in result.
Specifically, monitoring management server from being written designated field data to primary database, successfully write by cumulative calculation
Enter the write-in waiting time of designated field data, and compares the write-in waiting time obtained is calculated with default waiting time
Compared with.When write-in waiting time reaching default waiting time, it is specified to show that monitoring management server starts to be written to primary database
The designated field data is not successfully written when reaching default waiting time after field data yet, monitoring management server then determines to write
Enter failure.
In the above-described embodiments, by the way that default waiting time is arranged, reach the default waiting time when write-in waiting time
When, then determine write-in failure, triggering following failure determines process.This kind of mode can effectively avoid because of monitoring management server and
It is connected to the network temporary derangement between primary database, and triggers further primary database operation troubles confirmation process, reduces really
Process is recognized, to save the system resource of confirmation process occupancy.
In one embodiment, when determining write-in failure, the first write-in control instruction is sent to the first monitoring server
Including：When determining write-in failure, network address and the port of the first monitoring server are inquired；It is remote according to network address and port
The first monitoring server of Cheng Denglu；The first write-in control instruction is sent to the first monitoring server of Telnet.
Wherein, network address is the logical address for determining the first monitoring server position in a network.Port is net
Network equipment room is connected with each other the logic interfacing of communication.In the present embodiment, monitoring management server is according to the network address
The corresponding network site for determining the first monitoring server, and then can successful access first monitoring server according to port.
Specifically, when monitoring management server fails to primary database write-in designated field data, monitoring management service
Device inquires network address and the port of the first monitoring server according to configuration file.When the network for inquiring the first monitoring server
When address and port, Remote Login request is sent to the first monitoring server according to the network address and port.When receiving
When one monitoring server corresponds to the log-in instruction of feedback for Remote Login request, Telnet to the first monitoring server, and
To the first monitoring server of Telnet send first write-in control instruction so that the first monitoring server according to this first
Control instruction is written, designated field data is written to primary database.
In one embodiment, monitoring management server obtains the network address of the first monitoring server according to configuration file
And port, and corresponding login account and password, it is built according to the network address and port got and the first monitoring service net
Vertical connection.The success of monitoring management server connect with the first monitoring server establish after, according to accessed login account with
Password is remotely logged into the first monitoring server.
In one embodiment, monitoring management server is in communication with each other by outer net VPN and the first monitoring server.Specifically
Ground, monitoring management server take by the first monitoring server of outer net VPN Telnet, and by outer net VPN to the first monitoring
Business device sends the first write-in control instruction.It can tentatively judge that monitoring management server is written to primary database by this kind of mode
The reason of specific field fails is network connectivity fai_lure or primary database fortune between monitoring management server and primary database
Row failure.
In one embodiment, when monitoring management Server remote logs in the failure of the first monitoring server, monitoring management
Designated field data is written to primary database according to predetermined period in server, i.e. monitoring management server continues to execute the main number of monitoring
According to the correlation step in library.
In above-described embodiment, when tentatively determining primary database operation troubles, the first monitoring server of Telnet, and
The first write-in control instruction is sent to first monitoring server, to further determine that primary database by the first monitoring server
Whether operation troubles, effectively prevent mistake switch caused by the wasting of resources.
In one embodiment, step S210 includes：When designated word number of segment is written to primary database in the first monitoring server
According to failure number reach preset times when, receive the first monitoring server feedback with first write-in control instruction it is corresponding,
Indicate the prompting message of write-in designated field data failure.
Wherein, preset times are preset amount thresholds.Preset times are that the first monitoring server determines that write-in is lost
The foundation lost, for being compared with the write-in frequency of failure for calculating acquisition to determine that result is written.Preset times can basis
Actual conditions are customized, such as 3 times.
Specifically, when the first monitoring server receives the first write-in control instruction of monitoring server transmission, according to the
One write-in control instruction obtains designated field data, will be in acquired designated field data write-in primary database.When judgement is write
When entering unsuccessfully, designated field data library is written to primary database again in the first monitoring server.When determining write-in failure again,
First monitoring server repeats the above-mentioned correlation step to primary database write-in designated field data.First monitoring server
The number of cumulative calculation write-in failure, and the number for calculating the write-in failure obtained is compared with preset times.Work as write-in
When the number of failure reaches preset times, the first monitoring server then determines the write operation for corresponding to the first write-in control instruction
For write-in failure, triggering generates the prompt information for indicating write-in designated field data failure, and the prompt information of generation is sent
To monitoring management server.
In one embodiment, designated field data is the corresponding timestamp of current time.First monitoring server repeats
When executing the above-mentioned step that designated field data is written to primary database, the designated field data of real-time update write-in.Specifically,
Before designated field data is written to primary database in first monitoring server, the corresponding timestamp of current time is obtained, will be obtained
The timestamp taken is used as designated field data and primary database is written.
In one embodiment, the first monitoring server adds up meter from being written designated field data to primary database
Calculate the write-in waiting time for being successfully written designated field data.Reach default waiting time when calculating the write-in waiting time obtained
When, the first monitoring server then determines to trigger write operation next time when time write-in designated field data failure.
In above-described embodiment, when the first monitoring server fails to primary database write-in designated field data, by multiple
Write operation is repeated, then determines primary database operation troubles when the number of accumulative write-in failure reaches preset times, and
The prompt information of corresponding feedback write-in failure.Master data caused by being reduced by this kind of mode because of the erroneous judgement of primary database operation troubles
Library switching, so as to avoid the waste of resource.
In one embodiment, step S212 includes：When prompt information indicates write-in designated field data failure, inquiry
Second monitoring server；The second write-in control instruction is sent to the second monitoring server；Second write-in control instruction is used to indicate
Designated field data is written to primary database in second monitoring server；When specific field is written in the second monitoring server feedback representation
When the prompting message of data failure, triggering switching primary database.
Wherein, the second monitoring server is the server for monitoring primary database operation.Second write instruction is to be used for
Trigger the control instruction of write operation.It is appreciated that term " first " used in the present embodiment and " second " can be used for retouching
Various elements are stated, but these elements should not be limited by these terms, these terms are only used to by first element and another element
It distinguishes.For example, the first monitoring server can be known as the second monitoring in the case where not departing from the range of the present embodiment
Server, and similarly, the second monitoring server can be known as to the first monitoring server, the first monitoring server and the second monitoring
Both servers are all monitoring servers, but are not same monitoring servers.Similarly, the first write-in control instruction and second is write
Entering control instruction all is write-in control instruction, but is not the same write-in control instruction.
Specifically, when the prompt information of the corresponding feedback of the first monitoring server indicates write-in designated field data failure,
Monitoring management server inquires the second monitoring server according to configuration file, generates the second write-in control instruction.When inquiring
When two monitoring servers, the second write-in control instruction generated is sent to the second monitoring server by monitoring management server.
Second monitoring server obtains designated field data according to the second write-in control instruction received, by acquired specific field
Primary database is written in data.When determining write-in failure, the second monitoring server, which generates, indicates write-in designated field data failure
Prompt information, and the prompt information of generation is fed back into monitoring management server.Monitoring management server is according to receiving
The corresponding triggering switching primary database of prompt information.
In one embodiment, monitoring management server obtains the network address of the second monitoring server according to configuration file
And port, and according to the second monitoring server of network address and port Telnet got, and then to the of Telnet
Two monitoring servers send the second write-in control instruction.
In one embodiment, when monitoring management server fails to primary database write-in designated field data, monitoring pipe
It manages server and preset monitoring server is inquired according to configuration file, generate corresponding write-in control instruction, and the write-in generated
Control instruction is respectively sent to each monitoring server inquired.Each monitoring server will be according to the write-in control instruction received
Primary database is written in the corresponding designated field data obtained, and successful to monitoring management server feedback write-in designated field data
Or the prompt information of failure.The prompt information of the corresponding feedback of each monitoring server of monitoring management server statistics, and then calculate and connect
Ratio of the prompt information of write-in designated field data failure in the total prompting messages received is indicated in the prompt information received
Rate.When the ratio of calculating reaches pre-set ratio threshold value, monitoring management server determines primary database operation troubles, triggering switching
Primary database.
In above-described embodiment, when preliminary judgement primary database operation troubles, successively pass through the first monitoring server and the
The specific field time is written further to detect the operating status of primary database, when further to primary database in two monitoring servers
When designated field data failure is written in testing result, then primary database operation troubles, triggering switching primary database are determined.Pass through
This kind of mode improves the accuracy of primary database operation troubles judgement, avoids primary database caused by operation troubles is judged by accident and cuts
It changes, so as to avoid the waste of resource.
In one embodiment, the step of switching primary database includes：Close primary database；According to configuration file from data
It selects in the cluster of library from database；Configure the slave database of selection to the primary database of data-base cluster；Configuration is established respectively
Primary database and data-base cluster in respectively from the master-slave relationship between database.
Wherein, it closes primary database and refers to the server closed where primary database, to reach the effect for closing primary database
Fruit.Closing primary database, which specifically can be through triggering primary database shutdown command, closes primary database place server.It is main
Data cannot be then written in database again after closing, i.e., terminal, which cannot succeed, is written data to primary database, to ensure that data
Consistency.Primary database will be established in data-base cluster and from the corresponding relationship between database by establishing master-slave relationship and referring to, main
Then the data changed in primary database can be synchronized to local from database after relationship foundation.
Specifically, when determining primary database operation troubles by the above method, monitoring management server triggers generate master
Database shutdown command, server where remotely closing primary database based on primary database shutdown command generated.Further
Ground, from each in data-base cluster, selection, and will choosing from database from database according to configuration file for monitoring management server
The read only attribute parameter for the slave database selected is set as read-write properties parameter, configures database for the slave database of the selection
The primary database of cluster.Primary database configuration after the completion of, monitoring management server will be removed in data-base cluster it is selected from
Each slave database that primary database is respectively configured as from database of database.Monitoring management server is distinguished by this kind of mode
Establish primary database and respectively from the master-slave relationship between database.
In one embodiment, configuration file include respectively from the corresponding configuration information of database in data-base cluster,
For example the priority tag, candidate from Database Identification or non-candidate from Database Identification of primary database is respectively switched to from database
Deng.Monitoring management server corresponds respectively in data-base cluster according to what configuration file recorded respectively from the configuration information of database
Respectively selecting from database from database.
For example, monitoring management server rejects non-candidate according to configuration file from database mark from data-base cluster
Know it is corresponding from database, then from the slave database filtered out random selection from database.Monitoring management server can also be with
According to respectively being selected from data-base cluster from the priority tag that database is switched to primary database from database, it can selection
Priority is higher from database.Monitoring management server can also be selected from database from candidate from Database Identification is corresponding
It selects from database.Monitoring management server can also be according to the incremental number respectively between database and the primary database of operation troubles
According to least from database from database, such as selection incremental data to select.
In one embodiment, monitoring management server configures the slave database of selection to the master data of data-base cluster
When library, the domain name for the primary database that the domain name of the primary database of configuration is updated to be turned off.In other words, terminal is according to having closed
The domain name for the primary database closed i.e. may have access to switching after the completion of primary database, in this way, primary database switching after the completion of, terminal without
Domain name need to be changed can successful access primary database.
In above-described embodiment, the primary database of operation troubles is closed when switching primary database, first to guarantee in handoff procedure
Incremental data will not be written in the primary database of operation troubles, to guarantee data consistency.Further, primary database operation event
It is directly selected to be used as the primary database after switching from database according to configuration file when barrier, handoff procedure can be effectively reduced in this way
In required synchronization data volume, switching efficiency is improved, to ensure that primary database can be by successful access.In addition, passing through
Master-slave relationship is re-established, the data of primary database can be synchronized to local from database, to guarantee data consistency.
In one embodiment, above-mentioned primary database monitoring method further includes：When prompt information indicates write-in specific field
When data failure, triggering generates corresponding warning information；Warning information is pushed into designated terminal.
Wherein, warning information is the information of triggering alarm.Warning information specifically can be by words such as number, letter and symbols
The character string of at least one of symbol composition.Specifically, when the prompt information received indicates write-in designated field data failure
When, show primary database operation troubles, monitoring management server, which then triggers, generates corresponding warning information, and by announcement generated
Alert information pushes to designated terminal by short message or Email.When monitoring management server determines primary database operation troubles,
The networking telephone can also be triggered, is alerted by the networking telephone.
In one embodiment, when the prompt information by the first monitoring server feedback received indicates write-in designated word
When segment data fails, monitoring management server triggers generate warning information.In one embodiment, when what is received is supervised by second
When controlling the prompt information of server feedback indicates write-in designated field data failure, monitoring management server triggers generate alarm letter
Breath.
In one embodiment, when primary database operation troubles, monitoring management server generates corresponding operation troubles
Log, and by operation troubles log recording in local.
In one embodiment, in the monitoring management server statistics data-base cluster primary database operation troubles time
Number shows that multiple databases in the data-base cluster may when the number of primary database operation troubles reaches preset threshold
Operation troubles occurs, so as to cause the operation troubles of data-base cluster rank, triggering generates warning information, and by the warning information
It is sent to designated terminal, so that the corresponding user of the designated terminal takes counter-measure in time, to avoid the data base set
The problem of operation troubles of pocket transmission cluster rank.
In above-described embodiment, warning information is triggered when primary database operation troubles, and feed back to designated terminal, to pass through
The designated terminal shows the prompt information of primary database operation troubles to user.
As shown in figure 3, in one embodiment, provide a kind of primary database monitoring method, this method specifically include with
Lower step：
S302 obtains the corresponding configuration file of data-base cluster.
S304 determines the primary database in data-base cluster according to configuration file.
Designated field data is written to primary database in S306.
S308, to primary database be written designated field data when from, cumulative calculation is successfully written writing for designated field data
Enter waiting time.
S310 determines write-in failure when write-in waiting time reaching default waiting time.
S312 inquires network address and the port of the first monitoring server when determining write-in failure.
S314, according to the first monitoring server of network address and port Telnet.
S316 sends the first write-in control instruction to the first monitoring server of Telnet；First write-in control instruction
It is used to indicate the first monitoring server and designated field data is written to primary database.
S318, when the first monitoring server reaches preset times to the number of primary database write-in designated field data failure
When, receive, the expression write-in designated field data failure corresponding with the first write-in control instruction of the first monitoring server feedback
Prompting message.
S320 inquires the second monitoring server when prompt information indicates write-in designated field data failure.
S322 sends the second write-in control instruction to the second monitoring server；Second write-in control instruction is used to indicate the
Designated field data is written to primary database in two monitoring servers.
S324, when the prompting message of the second monitoring server feedback representation write-in designated field data failure, triggering is cut
Change owner database.
In above-described embodiment, the operating condition of primary database is monitored by the way that designated field data is written to primary database,
When determining write-in failure, show the possible operation troubles of primary database, triggers further operation troubles confirmation process, work as confirmation
Switching primary database is then triggered when primary database operation troubles.It is avoided by this kind of mode because network connectivity problem is frequently touched
Primary database switching is sent out, the problem of so as to cause the wasting of resources.
It should be understood that although each step in the flow chart of Fig. 2 and Fig. 3 is successively shown according to the instruction of arrow,
But these steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly state otherwise herein, these
There is no stringent sequences to limit for the execution of step, these steps can execute in other order.Moreover, in Fig. 2 and Fig. 3
At least part step may include that perhaps these sub-steps of multiple stages or stage are not necessarily same to multiple sub-steps
One moment executed completion, but can execute at different times, and the execution in these sub-steps or stage sequence is also not necessarily
Be successively carry out, but can at least part of the sub-step or stage of other steps or other steps in turn or
Alternately execute.
In one embodiment, as shown in figure 4, providing a kind of primary database monitoring device 400, including：Obtain module
401, determining module 402, writing module 403, sending module 404, receiving module 405 and switching module 406, wherein：
Module 401 is obtained, for obtaining the corresponding configuration file of data-base cluster.
Determining module 402, for determining the primary database in data-base cluster according to configuration file.
Writing module 403, for designated field data to be written to primary database.
Sending module 404, for sending the first write-in control to the first monitoring server and referring to when determining write-in failure
It enables；First write-in control instruction is used to indicate the first monitoring server and designated field data is written to primary database.
Receiving module 405, for receiving the prompt corresponding with the first write-in control instruction of the first monitoring server feedback
Information.
Switching module 406, for triggering switching master data when prompt information indicates write-in designated field data failure
Library.
In one embodiment, writing module 403, be also used to primary database be written designated field data when from, add up
Calculate the write-in waiting time for being successfully written designated field data；When write-in waiting time reaching default waiting time, determine
Write-in failure.
In one embodiment, sending module 404 are also used to inquire the first monitoring server when determining write-in failure
Network address and port；According to the first monitoring server of network address and port Telnet；To the first prison of Telnet
It controls server and sends the first write-in control instruction.
In one embodiment, receiving module 405 are also used to that designated word is written to primary database when the first monitoring server
When the number of segment data failure reaches preset times, the corresponding with the first write-in control instruction of the first monitoring server feedback is received
, indicate write-in designated field data failure prompting message.
In one embodiment, switching module 406 are also used to indicate write-in designated field data failure when prompt information
When, inquire the second monitoring server；The second write-in control instruction is sent to the second monitoring server；Second write-in control instruction is used
Designated field data is written to primary database in the second monitoring server of instruction；When the write-in of the second monitoring server feedback representation refers to
When determining the prompting message of field data failure, triggering switching primary database.
In one embodiment, switching module 406 are also used to close primary database；According to configuration file from data base set
It selects in group from database；Configure the slave database of selection to the primary database of data-base cluster；The master of configuration is established respectively
Respectively from the master-slave relationship between database in database and data-base cluster.
As shown in figure 5, in one embodiment, above-mentioned primary database monitoring device 400 further includes alarm module 407.It accuses
Alert module 407 is used for when prompt information indicates write-in designated field data failure, and triggering generates corresponding warning information；It will accuse
Alert information pushes to designated terminal.
Specific about primary database monitoring device limits the limit that may refer to above for primary database monitoring method
Fixed, details are not described herein.Modules in above-mentioned primary database monitoring device can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 6.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is used for storage configuration file.The network interface of the computer equipment is used to pass through network with external terminal
Connection communication.To realize a kind of primary database monitoring method when the computer program is executed by processor.
It will be understood by those skilled in the art that structure shown in Fig. 6, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, the processor realize following steps when executing computer program：Obtain the corresponding configuration file of data-base cluster；
The primary database in data-base cluster is determined according to configuration file；Designated field data is written to primary database；When judgement is written
When failure, the first write-in control instruction is sent to the first monitoring server；First write-in control instruction is used to indicate the first monitoring
Designated field data is written to primary database in server；Receive the first monitoring server feedback is written control instruction pair with first
The prompt information answered；When prompt information indicates write-in designated field data failure, triggering switching primary database.
In one embodiment, following steps are also realized when processor executes computer program：Refer to primary database write-in
From when determining field data, cumulative calculation is successfully written the write-in waiting time of designated field data；Reach when write-in waiting time
When default waiting time, write-in failure is determined.
In one embodiment, when determining write-in failure, the first write-in control instruction is sent to the first monitoring server
Including：When determining write-in failure, network address and the port of the first monitoring server are inquired；It is remote according to network address and port
The first monitoring server of Cheng Denglu；The first write-in control instruction is sent to the first monitoring server of Telnet.
In one embodiment, the prompt corresponding with the first write-in control instruction for receiving the first monitoring server feedback is believed
Breath includes：When the first monitoring server reaches preset times to the number of primary database write-in designated field data failure, connect
Receive the prompt that is corresponding with the first write-in control instruction, indicating write-in designated field data failure of the first monitoring server feedback
Message.
In one embodiment, when prompt information indicates write-in designated field data failure, triggering switching primary database
Including：When prompt information indicates write-in designated field data failure, the second monitoring server is inquired；To the second monitoring server
Send the second write-in control instruction；It is specified to primary database write-in that second write-in control instruction is used to indicate the second monitoring server
Field data；When the prompting message of the second monitoring server feedback representation write-in designated field data failure, triggering switching master
Database.
In one embodiment, the step of switching primary database includes：Close primary database；According to configuration file from data
It selects in the cluster of library from database；Configure the slave database of selection to the primary database of data-base cluster；Configuration is established respectively
Primary database and data-base cluster in respectively from the master-slave relationship between database.
In one embodiment, following steps are also realized when processor executes computer program：When prompt information expression is write
When entering designated field data failure, triggering generates corresponding warning information；Warning information is pushed into designated terminal.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program realizes following steps when being executed by processor：Obtain the corresponding configuration file of data-base cluster；It is true according to configuration file
Determine the primary database in data-base cluster；Designated field data is written to primary database；When determining write-in failure, to the first prison
It controls server and sends the first write-in control instruction；First write-in control instruction is used to indicate the first monitoring server to primary database
Designated field data is written；Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；When
When prompt information indicates write-in designated field data failure, triggering switching primary database.
In one embodiment, following steps are also realized when computer program is executed by processor：It is written to primary database
From when designated field data, cumulative calculation is successfully written the write-in waiting time of designated field data；It is reached when write-in waiting time
When to default waiting time, write-in failure is determined.
In one embodiment, when determining write-in failure, the first write-in control instruction is sent to the first monitoring server
Including：When determining write-in failure, network address and the port of the first monitoring server are inquired；It is remote according to network address and port
The first monitoring server of Cheng Denglu；The first write-in control instruction is sent to the first monitoring server of Telnet.
In one embodiment, the prompt corresponding with the first write-in control instruction for receiving the first monitoring server feedback is believed
Breath includes：When the first monitoring server reaches preset times to the number of primary database write-in designated field data failure, connect
Receive the prompt that is corresponding with the first write-in control instruction, indicating write-in designated field data failure of the first monitoring server feedback
Message.
In one embodiment, when prompt information indicates write-in designated field data failure, triggering switching primary database
Including：When prompt information indicates write-in designated field data failure, the second monitoring server is inquired；To the second monitoring server
Send the second write-in control instruction；It is specified to primary database write-in that second write-in control instruction is used to indicate the second monitoring server
Field data；When the prompting message of the second monitoring server feedback representation write-in designated field data failure, triggering switching master
Database.
In one embodiment, the step of switching primary database includes：Close primary database；According to configuration file from data
It selects in the cluster of library from database；Configure the slave database of selection to the primary database of data-base cluster；Configuration is established respectively
Primary database and data-base cluster in respectively from the master-slave relationship between database.
In one embodiment, following steps are also realized when computer program is executed by processor：When prompt information indicates
When designated field data failure is written, triggering generates corresponding warning information；Warning information is pushed into designated terminal.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of primary database monitoring method, the method includes：
Obtain the corresponding configuration file of data-base cluster；
The primary database in the data-base cluster is determined according to the configuration file；
Designated field data is written to the primary database；
When determining write-in failure, the first write-in control instruction is sent to the first monitoring server；The first write-in control refers to
Order is used to indicate first monitoring server and the designated field data is written to the primary database；
Receive the prompt information corresponding with the first write-in control instruction of the first monitoring server feedback；
When the prompt information indicates that designated field data failure is written, triggering switching primary database.
2. the method according to claim 1, wherein the method also includes：
From when designated field data is written to the primary database, the write-in that cumulative calculation is successfully written designated field data is waited
Duration；
When said write waiting time reaching default waiting time, write-in failure is determined.
3. the method according to claim 1, wherein it is described when determine write-in failure when, to the first monitoring service
Device sends the first write-in control instruction：
When determining write-in failure, network address and the port of the first monitoring server are inquired；
According to the first monitoring server described in the network address and port Telnet；
The first write-in control instruction is sent to the first monitoring server of Telnet.
4. according to the method described in claim 3, it is characterized in that, described receiving first monitoring server feedback with institute
Stating the corresponding prompt information of the first write-in control instruction includes：
When first monitoring server reaches default to the number that the designated field data failure is written in the primary database
When number, the expression write-in corresponding with the first write-in control instruction of reception the first monitoring server feedback are specified
The prompting message of field data failure.
5. method according to any one of claims 1 to 4, which is characterized in that described when the prompt information indicates write-in
When the designated field data fails, triggering switching primary database includes：
When the prompt information indicates that designated field data failure is written, the second monitoring server is inquired；
The second write-in control instruction is sent to second monitoring server；The second write-in control instruction is used to indicate described
The designated field data is written to the primary database in second monitoring server；
When the prompting message of the designated field data failure is written in the second monitoring server feedback representation, triggering switching
Primary database.
6. according to the method described in claim 5, it is characterized in that, the step of switching primary database include：
Close the primary database；
It is selected from the data-base cluster from database according to the configuration file；
The primary database of the data-base cluster will be configured to described in selection from database；
It is established in the primary database and the data-base cluster of configuration respectively respectively from the master-slave relationship between database.
7. according to the method described in claim 6, it is characterized in that, the method also includes：
When the prompt information indicates that designated field data failure is written, triggering generates corresponding warning information；
The warning information is pushed into designated terminal.
8. a kind of primary database monitoring device, which is characterized in that described device includes：
Module is obtained, for obtaining the corresponding configuration file of data-base cluster；
Determining module, for determining the primary database in the data-base cluster according to the configuration file；
Writing module, for designated field data to be written to the primary database；
Sending module, for sending the first write-in control instruction to the first monitoring server when determining write-in failure；Described
One write-in control instruction is used to indicate first monitoring server and the designated field data is written to the primary database；
Receiving module, for receiving the prompt corresponding with the first write-in control instruction of the first monitoring server feedback
Information；
Switching module, for triggering switching master data when the prompt information indicates that designated field data failure is written
Library.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810549605.4A CN108897658B (en) | 2018-05-31 | 2018-05-31 | Method and device for monitoring master database, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810549605.4A CN108897658B (en) | 2018-05-31 | 2018-05-31 | Method and device for monitoring master database, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108897658A true CN108897658A (en) | 2018-11-27 |
| CN108897658B CN108897658B (en) | 2023-03-21 |
Family
ID=64343465
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810549605.4A Active CN108897658B (en) | 2018-05-31 | 2018-05-31 | Method and device for monitoring master database, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108897658B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110196883A (en) * | 2019-05-29 | 2019-09-03 | 贝壳技术有限公司 | A kind of method of data synchronization and device on business on line without influence |
| CN110377664A (en) * | 2019-07-22 | 2019-10-25 | 腾讯科技（深圳）有限公司 | Method of data synchronization, device, server and storage medium |
| CN110633280A (en) * | 2019-09-11 | 2019-12-31 | 北京亚信数据有限公司 | Batch data acquisition method and device, readable storage medium and computing equipment |
| CN111190766A (en) * | 2019-12-12 | 2020-05-22 | 北京淇瑀信息科技有限公司 | HBase database-based cross-machine-room cluster disaster recovery method, device and system |
| CN111241144A (en) * | 2018-11-28 | 2020-06-05 | 阿里巴巴集团控股有限公司 | Data processing method and system |
| CN111522870A (en) * | 2020-04-09 | 2020-08-11 | 咪咕文化科技有限公司 | Database access method, middleware and readable storage medium |
| CN113364129A (en) * | 2021-06-25 | 2021-09-07 | 广西电网有限责任公司 | High-availability method for data processing service of power grid monitoring system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667181A (en) * | 2008-09-05 | 2010-03-10 | 华为技术有限公司 | Method, device and system for data disaster tolerance |
| CN106202075A (en) * | 2015-04-29 | 2016-12-07 | 中兴通讯股份有限公司 | A kind of method and device of data base's active-standby switch |
| CN106909568A (en) * | 2015-12-23 | 2017-06-30 | 北京奇虎科技有限公司 | A kind of changing method and device of data-base cluster MDL |
-
2018
- 2018-05-31 CN CN201810549605.4A patent/CN108897658B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667181A (en) * | 2008-09-05 | 2010-03-10 | 华为技术有限公司 | Method, device and system for data disaster tolerance |
| CN106202075A (en) * | 2015-04-29 | 2016-12-07 | 中兴通讯股份有限公司 | A kind of method and device of data base's active-standby switch |
| CN106909568A (en) * | 2015-12-23 | 2017-06-30 | 北京奇虎科技有限公司 | A kind of changing method and device of data-base cluster MDL |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111241144A (en) * | 2018-11-28 | 2020-06-05 | 阿里巴巴集团控股有限公司 | Data processing method and system |
| CN111241144B (en) * | 2018-11-28 | 2024-01-26 | 阿里巴巴集团控股有限公司 | Data processing method and system |
| CN110196883A (en) * | 2019-05-29 | 2019-09-03 | 贝壳技术有限公司 | A kind of method of data synchronization and device on business on line without influence |
| CN110377664A (en) * | 2019-07-22 | 2019-10-25 | 腾讯科技（深圳）有限公司 | Method of data synchronization, device, server and storage medium |
| CN110633280A (en) * | 2019-09-11 | 2019-12-31 | 北京亚信数据有限公司 | Batch data acquisition method and device, readable storage medium and computing equipment |
| CN111190766A (en) * | 2019-12-12 | 2020-05-22 | 北京淇瑀信息科技有限公司 | HBase database-based cross-machine-room cluster disaster recovery method, device and system |
| CN111522870A (en) * | 2020-04-09 | 2020-08-11 | 咪咕文化科技有限公司 | Database access method, middleware and readable storage medium |
| CN111522870B (en) * | 2020-04-09 | 2023-12-08 | 咪咕文化科技有限公司 | Database access method, middleware and readable storage medium |
| CN113364129A (en) * | 2021-06-25 | 2021-09-07 | 广西电网有限责任公司 | High-availability method for data processing service of power grid monitoring system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108897658B (en) | 2023-03-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108897658A (en) | Primary database monitoring method, device, computer equipment and storage medium | |
| CN104980293B (en) | A kind of OAM message is quickly sent and the method and device of detection processing | |
| CN108932295A (en) | Primary database method for handover control, device, computer equipment and storage medium | |
| CN108900572B (en) | Main database domain name switching control method, computer equipment and storage medium | |
| EP2568733A1 (en) | Method and apparatus for collecting mobile communication data | |
| CN109510726A (en) | Network visualization implementation method, device, computer equipment and storage medium | |
| CN107888444A (en) | Service monitoring method, service monitoring device, computer equipment and storage medium | |
| CN106301840B (en) | Method and device for sending Bidirectional Forwarding Detection (BFD) message | |
| CN103699063A (en) | Device and method for acquiring off-line data of MES (Manufacturing Execution Method) system | |
| CN108924043A (en) | System monitoring method, gateway communication, gateway apparatus, service processing equipment | |
| CN111726414A (en) | Vehicle reported data processing method and vehicle data reporting system | |
| CN108353005B (en) | Method and device for monitoring a control system | |
| CN110730095B (en) | Cloud computing platform-oriented data security emergency drilling method and system | |
| CN113489149B (en) | Power grid monitoring system service master node selection method based on real-time state sensing | |
| CN109379239B (en) | Method and device for configuring access switch in OpenStack environment | |
| CN111211925B (en) | Alarm information synchronization method and device, computer equipment and storage medium | |
| CN110098976A (en) | Measurement method, device, computer equipment and the storage medium of network parameter | |
| CN112612687A (en) | User behavior data uploading method, device, equipment and medium | |
| JP4673532B2 (en) | Comprehensive alignment process in a multi-manager environment | |
| CN105306243A (en) | Stale data collection method, device and system | |
| EP4398534A1 (en) | Network monitoring method and apparatus, and computer storage medium | |
| CN111464393A (en) | Method and device for monitoring running state of block chain and storage medium | |
| CN106452905A (en) | Message processing method and device | |
| CN111258860B (en) | Data alarm method, device, computer equipment and storage medium | |
| CN109474442B (en) | Log processing method, electronic device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |