CN108932295A - Primary database method for handover control, device, computer equipment and storage medium - Google Patents
Primary database method for handover control, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN108932295A CN108932295A CN201810551550.0A CN201810551550A CN108932295A CN 108932295 A CN108932295 A CN 108932295A CN 201810551550 A CN201810551550 A CN 201810551550A CN 108932295 A CN108932295 A CN 108932295A
- Authority
- CN
- China
- Prior art keywords
- database
- primary database
- candidate
- computer room
- domain name
- 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/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/1415—Saving, restoring, recovering or retrying at system level
- G06F11/142—Reconfiguring to eliminate the error
-
- 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/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1435—Saving, restoring, recovering or retrying at system level using file system or storage system metadata
-
- 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/16—Error detection or correction of the data by redundancy in hardware
- G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
- G06F11/2015—Redundant power supplies
Abstract
This application involves a kind of primary database method for handover control, device, computer equipment and storage mediums.The method includes:Obtain configuration file;The computer room state parameter of main equipment room where inquiring current primary database according to the configuration file;Candidate computer room mark when the computer room state parameter meets computer room fault condition, in the computer room logo collection that is recorded in the configuration file, after determining the computer room mark for rejecting the main equipment room;According to the configuration file, the candidate corresponding from the candidate computer room mark is selected from database from database;Current primary database is switched to the selected primary database from database, after being switched.It can effectively ensure that primary database can be by successful access using this method.
Description
Technical field
This application involves database technical fields, more particularly to a kind of primary database method for handover control, device, calculating
Machine equipment and storage medium.
Background technique
With the development of database technology, gradually appear by primary database and the data-base cluster constituted from database,
Read and write abruption function is realized, the performance of database is effectively increased.Wherein, primary database supports terminal that data are written, and will
The data of write-in are synchronized to respectively from database, to guarantee the data consistency of master-slave database.Thus, when primary database failure
Or where primary database when server failure, primary database switching is carried out in time, to guarantee the data write-in of data-base cluster
It is normally the problem of meriting attention.
Currently, data-base cluster is typically deployed in same computer room, when primary database failure occurs can in computer room into
Row primary database switching, to guarantee that terminal being capable of successful access primary database.But when computer room level faults occur, cause
It can not achieve the primary database switching in computer room, it cannot be by successful access so as to cause primary database.
Summary of the invention
Based on this, it is necessary to which in view of the above technical problems, providing one kind can guarantee primary database by the master of successful access
Database method for handover control, device, computer equipment and storage medium.
A kind of primary database method for handover control, the method includes:
Obtain configuration file;
The computer room state parameter of main equipment room where inquiring current primary database according to the configuration file;
When the computer room state parameter meets computer room fault condition, the computer room identification sets that are recorded in the configuration file
Candidate computer room mark in conjunction, after determining the computer room mark for rejecting the main equipment room;
According to the configuration file, the candidate corresponding from the candidate computer room mark is selected from database from data
Library;
Current primary database is switched to the selected primary database from database, after being switched.
A kind of primary database switching control, described device include:
Module is obtained, for obtaining configuration file;
Enquiry module, the computer room state for main equipment room where inquiring current primary database according to the configuration file are joined
Number;
Determining module, for being remembered in the configuration file when the computer room state parameter meets computer room fault condition
Candidate computer room mark in the computer room logo collection of record, after determining the computer room mark for rejecting the main equipment room;
Selecting module, for identifying corresponding candidate from database from the candidate computer room according to the configuration file
It is middle to select from database;
Switching module, for current primary database to be switched to the selected master from database, after being switched
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 configuration file;
The computer room state parameter of main equipment room where inquiring current primary database according to the configuration file;
When the computer room state parameter meets computer room fault condition, the computer room identification sets that are recorded in the configuration file
Candidate computer room mark in conjunction, after determining the computer room mark for rejecting the main equipment room;
According to the configuration file, the candidate corresponding from the candidate computer room mark is selected from database from data
Library;
Current primary database is switched to the selected primary database from database, after being switched.
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 configuration file;
The computer room state parameter of main equipment room where inquiring current primary database according to the configuration file;
When the computer room state parameter meets computer room fault condition, the computer room identification sets that are recorded in the configuration file
Candidate computer room mark in conjunction, after determining the computer room mark for rejecting the main equipment room;
According to the configuration file, the candidate corresponding from the candidate computer room mark is selected from database from data
Library;
Current primary database is switched to the selected primary database from database, after being switched.
Above-mentioned primary database method for handover control, device, computer equipment and storage medium, according to current primary database institute
Main equipment room state is judged in the computer room state parameter of main equipment room, when the computer room state parameter of main equipment room meets computer room fault condition
When, then determine main equipment room failure, then primary database is switched to the slave database in the computer room except main equipment room, to guarantee main number
According to library can be by successful access.Selected the computer room mark except the computer room mark of main equipment room as candidate machine according to configuration file
Room mark, and then the corresponding candidate slave data from the primary database being chosen for use as after switching in database are identified from candidate computer room
Library, and current primary database is switched to the slave database of selection.In this way, where primary database when main equipment room failure, it can
The primary database switching between computer room is realized, to guarantee that primary database can be by successful access.
Detailed description of the invention
Fig. 1 is the application scenario diagram of primary database method for handover control in one embodiment;
Fig. 2 is the flow diagram of primary database method for handover control in one embodiment;
Fig. 3 is the flow diagram of primary database method for handover control in another embodiment;
Fig. 4 is the structural block diagram of primary database switching control in one embodiment;
Fig. 5 is the structural block diagram of primary database switching control 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 method for handover control provided by the present application, can be applied in application environment as shown in Figure 1.Monitoring
Management server 102 is communicated by network with primary database 104.Primary database 104 is by network and respectively from database
(1062,1064 and 1066) are communicated.Wherein, it primary database 104 and is respectively belonged to from database (1062,1064 and 1066)
Data-base cluster, primary database 104 and is deployed in main equipment room 110 from database 1062, monitoring management server 102, from number
It is deployed in from computer room 120 according to library 1064 and from database 1066.Main equipment room 110 and from special line can be passed through between computer room 120
Network is communicated.
It is appreciated that application environment shown in Fig. 1, only partial computer equipment relevant to application scheme,
The restriction for being applied to the application environment to application scheme is not constituted.It may include than as shown in the figure in specific application environment
More or fewer computer equipments, the communication between each computer equipment is not also limited by diagram, as long as suitable for this Shen
Please the application environment of scheme belong to the application protection scope.For example, can be more or less from the quantity of database,
It is also not necessarily limited to one from the quantity of computer room, monitoring management server can also be more than one.
In one embodiment, it as shown in Fig. 2, providing a kind of primary database method for handover control, applies in this way
It is illustrated, includes the following steps for monitoring management server in Fig. 1:
S202 obtains configuration file.
Wherein, configuration file is the preconfigured text comprising each corresponding metadata of database in data-base cluster
Number of packages evidence.The cluster that data-base cluster is made of multiple databases.Data-base cluster is constituted by primary database and from database.
Metadata is the data for descriptive data base relevant information, such as the corresponding network address of database, port, domain name, principal and subordinate
Role identification and computer room mark.Metadata can be used for uniquely determining database.Configuration file includes data base set group identification sum number
According to the corresponding metadata of database each in the cluster of library.For respectively further including respectively from database from database, configuration file
Priority tag, candidate from Database Identification and non-candidate from Database Identification etc. as primary database.
Specifically, monitoring management server obtains configuration file from local according to predetermined period.Monitoring management server
Configuration file can be obtained when receiving the computer room state parameter acquisition instruction of terminal transmission, according to acquired configuration text
Part is corresponding to obtain computer room state parameter.
In one embodiment, configuration file can be pre-generated by monitoring management server and be stored in local, can also
To be to be generated and sent by other computer equipments to monitoring management server, and then be stored in this by monitoring management server
Ground can also be and be formed and stored in computer equipment local by other computer equipments.
In one embodiment, MHA (Master High Availability, height are deployed on monitoring management server
Master library can be used) component, the primary database method for handover control that each embodiment provides in the application is realized by MHA component.
S204, the computer room state parameter of main equipment room where inquiring current primary database according to configuration file.
Wherein, primary database is the database that can be written into data.Primary database has read-write properties, and terminal can be to master
Data are written in database.Computer room state parameter is to indicate that computer room is in the parameter of normal condition or malfunction.Computer room state ginseng
Count the overall operation state for indicating each database in computer room.The overall operation state of each database refers to computer room in computer room
In multiple databases as a whole, the operating status of database in the computer room is described from whole angle.
Computer room is in normal condition and shows to be in normal operation in each equal normal operation of database or the computer room in computer room
The quantity of database reach preset quantity threshold value.Computer room is in malfunction and shows that computer room grade occurs for the database in the computer room
Other failure.Computer room level faults can be the equal operation troubles of each database or the respective operation of multiple databases in computer room
Parameter is all satisfied fault verification condition.Computer room is in malfunction and can be due to power supply supply problem or network connectivity problem etc.
Reason and cause database in computer room cannot normally be accessed or database where the operation exception of server lead to database
It cannot normally be accessed.
It specifically, include the specified circuit for obtaining the computer room state parameter of current primary database place main equipment room in configuration file
Diameter parameter.When monitoring management server gets configuration file, specified path parameter is obtained according to configuration file, and then according to institute
The computer room state parameter of main equipment room where the current primary database of the specified path parameter query of acquisition.
S206, when computer room state parameter meets computer room fault condition, the computer room logo collection that is recorded in configuration file
In, the candidate computer room mark after determining the computer room mark for rejecting main equipment room.
Wherein, computer room fault condition be it is preset for judge computer room whether the condition of failure.Computer room fault condition
Specifically can be one or more of computer room state parameter match with default computer room malfunction parameter or one or
Multiple computer room status parameter values reach preset state parameter threshold.Default computer room malfunction parameter is preset for table
Show that computer room is in the parameter of malfunction.Computer room status parameter values are the inquired corresponding numerical value of computer room state parameter.In advance
If state parameter threshold value is preset for being compared with computer room status parameter values, and then determines the threshold value of computer room state
Numerical value.
Computer room mark is used for unique identification computer room.Computer room mark can be by number, letter and the characters such as symbol extremely
A kind of character string of few composition.Computer room logo collection identifies the set formed by multiple computer rooms.Candidate computer room mark is can
The computer room of selection identifies.Candidate computer room mark corresponds to the candidate from database of the optional primary database as after switching.Candidate machine
Room identifies the slave database in corresponding candidate computer room to be candidate from database.
Specifically, the computer room state parameter inquired is compared by monitoring management server with computer room fault condition, when
When computer room state parameter meets computer room fault condition, show main equipment room failure where primary database.Monitoring management server according to
Configuration file obtains the computer room logo collection recorded in configuration file, and removal master is filtered out from acquired computer room logo collection
Computer room mark except the computer room mark of computer room, by the computer room filtered out mark as identified candidate computer room mark.
S208, according to configuration file, the candidate corresponding from candidate computer room mark is selected from database from database.
Wherein, it is candidate from database be after the completion of may be selected as switching for primary database the primary database of data-base cluster from
Database.It is each from database in corresponding candidate computer room that candidate from database is that candidate computer room identifies.Specifically, monitoring management
Server according to configuration file determine the corresponding candidate of candidate computer room mark from database, further, according to configuration file from
From database, the slave database of selection is used as the master data of data-base cluster after switching to identified candidate for selection from database
Library.
In one embodiment, monitoring management server according to configuration file from each candidate screened from database it is candidate from
Database Identification is corresponding candidate from database, selects from database from database from the candidate filtered out.Wherein, it is candidate from
Database Identification is used to identify accordingly from the optional primary database as after switching of database.
In one embodiment, monitoring management server determines that rejecting is non-from each candidate according to configuration file from database
Candidate is from the corresponding candidate candidate from after database of Database Identification from database, and then from identified candidate from database
It is middle to select from database.Wherein, non-candidate is from Database Identification for after identifying and accordingly cannot being selected as switching from database
Primary database.
In one embodiment, monitoring management server becomes primary database from database according to candidate each in configuration file
Priority tag selection priority it is high from database.Wherein priority tag is for identifying accordingly from database respectively from number
According to the priority orders for the primary database being selected as in library after switching.
In one embodiment, in configuration file further include each incremental data from database relative to current primary database
Amount.Monitoring management server according to each candidate selected from database from the corresponding incremental data amount of database from candidate from
Database.
In one embodiment, the selection gist that monitoring management server can in summary in one or more embodiments
It is selected from database from database from candidate.For example, monitoring management server can be filtered out according to configuration file it is candidate from
Database Identification is corresponding candidate from database, selects from database from number further according to priority tag from the candidate filtered out
According to library.
Current primary database is switched to the selected primary database from database, after being switched by S210.
Wherein, the primary database after switching refers to the primary database of data-base cluster after the completion of primary database switching.At this
In embodiment, primary database switching, which refers to, substitutes current primary database by the primary database after switching.In other words, primary database
Before switching, the primary database of data-base cluster is current primary database, after the completion of primary database switching, the master of data-base cluster
Database is the primary database after switching.
Specifically, monitoring management server is configured to the primary database after switching from database for selected, utilizes this
Primary database after switching substitutes primary database of the current primary database as data-base cluster.After the completion of configuration, after switching
Primary database substitutes the write operation that current primary database receives terminal.In other words, monitoring management server executes switching behaviour
Before work, terminal writes data into current primary database, and after the completion of switching, terminal writes data into the primary database after switching.
Above-mentioned primary database method for handover control judges according to the computer room state parameter of main equipment room where current primary database
Primary database is then switched to except main equipment room by main equipment room state when determining main equipment room failure according to computer room state parameter
Slave database in computer room, can be by successful access with guarantee primary database.The computer room of main equipment room is selected according to configuration file
Computer room mark except mark is selected from database as candidate computer room mark, and then from the corresponding candidate of candidate computer room mark
Slave database as the primary database after switching, and current primary database is switched to the slave database of selection.In this way, as master
Where database when main equipment room failure, can be realized the primary database switching between computer room, thus guarantee primary database can by
Function access.
In one embodiment, above-mentioned primary database method for handover control further includes:It is determined according to configuration file current main
Database;Designated field data is written to current primary database;When determining write-in failure, according to configuration file, determine from master
The computer room of computer room identifies corresponding candidate from slave database selected in database.
Wherein, designated field data is preassigned field value.Designated field data specifically can be current time pair
The timestamp answered, such as 25 minutes and 10 seconds 11 points of on May 21st, 2018.
Specifically, monitoring management server obtains configuration file from local, according to principal and subordinate's role identification in configuration file
It determines the current primary database in data-base cluster, and obtains network address and the end of current primary database according to configuration file
Mouthful, to access current primary database according to acquired network address and port, and then designated word is written to current primary database
Segment data.Monitoring management server obtains designated field data according to predetermined period, and the designated field data write-in that will acquire
Current primary database.When determining write-in failure, the computer room mark of main equipment room is determined as candidate computer room by monitoring management server
Mark is selected from database from database, the slave data of selection according to configuration file from the corresponding candidate of candidate computer room mark
Library is used as the primary database after switching.
In one embodiment, when monitoring management server receives specific field write instruction, based on the received
The specified corresponding acquisition designated field data of specific field write-in, and current primary database is written into acquired designated field data
In.
In one embodiment, when determining write-in failure, monitoring management server takes according to configuration file query monitor
Business device, pre-generated write-in control instruction is sent to the monitoring server inquired.Monitoring server refers to according to write-in control
It enables and obtains designated field data, and current primary database is written into acquired designated field data, when determining write-in failure,
The prompt information of write-in failure is indicated to monitoring management server feedback.Monitoring management server, which receives, indicates write-in failure
When prompt information, selected from database from database according to configuration file from the corresponding candidate of the computer room of main equipment room mark.
In one embodiment, when monitoring management server fails to current primary database write-in designated field data,
Show current primary database operation troubles, monitoring management server is determined as the computer room mark of main equipment room is corresponding from database
Candidate is from database, and according to configuration file from the identified candidate primary database after being chosen for use as switching in database
From database, in the present embodiment, monitoring management server is selected from database from database according to configuration file from candidate
Method, select the method from database similar from database from candidate with above-mentioned.
In above-described embodiment, the fortune of current primary database is determined by the way that designated field data is written to current primary database
Row state determines current primary database operation troubles when determining write-in failure, then after being chosen for use as switching in main equipment room
The slave database of primary database, and carry out primary database switching.The operating status of primary database is monitored by this kind of mode, so as to
It is switched in time when primary database operation troubles, to ensure that the master data in data-base cluster can be visited successfully
It asks.
In one embodiment, above-mentioned primary database method for handover control further includes:When determining write-in failure, inquiry is worked as
The corresponding network address with external equipment of preceding primary database;Out code is sent to band external equipment according to network address;Closing refers to
Order is used to indicate band external equipment and closes server where current primary database.
Wherein, with external equipment be arranged in current primary database hardware device on the server.Band external equipment passes through
The power supply of server where controlling it independently of the dedicated management channel except data network.Band external equipment is logical by dedicated management
Road control server power supply is similar to the direct pluggable server power supply of user, can reach and not control service by operating system
The effect of device power supply.Out code is the instruction for triggering power supply shutoff operation, and out code is used to indicate band external equipment and closes
The power supply of server where closing current primary database.
It specifically, include the corresponding network address with external equipment of current primary database in configuration file.When the main number of judgement
When according to library operation troubles, monitoring management server obtains the corresponding network with external equipment of current primary database according to configuration file
Address, according to the out code of acquired network address server to where sending the current primary database of closing with external equipment.
When band external equipment receives out code, the power supply of server where closing current primary database by dedicated management channel.
In above-described embodiment, in current primary database operation troubles, current primary database institute is closed by band external equipment
It in the power supply of server, effectively prevents in primary database handoff procedure, part terminal is because of service where current primary database
Device system is seemingly-dead and data still can be written to current primary database, so as to cause the inconsistent problem of data.In other words, exist
By the power supply of server where closing it with external equipment when current primary database operation troubles, data base set can effectively ensure that
The consistency of data in group.
In one embodiment, above-mentioned primary database method for handover control is executed by monitoring process;After step S210, on
Stating primary database method for handover control further includes:Generate primary database handover report;Primary database handover report is pushed into end
End;Close monitoring process.
Wherein, primary database handover report is the corresponding report file generated when primary database switching is completed, for describing
The relevant information of primary database switching.In primary database handover report include the corresponding network address of current primary database, port,
Domain name, cluster identity and computer room mark, and the corresponding network address of primary database after switching, port, domain name, cluster identity
It is identified with computer room.
Specifically, monitoring management server creation is used for the monitoring process in monitoring host computer room, and passes through created monitoring
Process executes the correlation step of above-mentioned primary database method for handover control.After the completion of primary database switching, pass through monitoring process
Corresponding primary database handover report is generated, primary database handover report generated is pushed into terminal, and terminate current fortune
Capable monitoring process.
In one embodiment, monitoring management server creates the monitoring process for monitoring current primary database, passes through
The monitoring process created executes the operating status of the current primary database of above-mentioned monitoring, and in current primary database operation troubles
Switch the correlation step of primary database.
In above-described embodiment, when primary database switch complete when trigger primary database handover report, and by terminal to
Family shows the primary database handover report, so that user understands primary database handover process.
In one embodiment, before step S210, above-mentioned primary database method for handover control further includes:To domain name supervising
Server sends domain name illegal command;Domain name illegal command is used to indicate the net that domain name supervising server deletes current primary database
Mapping relations between network address and corresponding domain name;After step S210, above-mentioned primary database method for handover control further includes:To
Domain name supervising server sends domain name switching command;After domain name switching command is used to indicate the foundation switching of domain name supervising server
Mapping relations between the network address of primary database and the domain name of current primary database.
Wherein, domain name supervising server is the service for managing the mapping relations between the network address and domain name of each database
Device.Domain name supervising server can parse according to correspondence mappings relationship according to the domain name received and obtain corresponding network address.
Domain name supervising server is for receiving terminal or the domain name of other computer equipments, with obtaining corresponding network according to domain name mapping
Location, and correspondence feeds back to terminal or other computer equipments.Domain name illegal command is that triggering is deleted between domain name and network address
The instruction of correspondence mappings relationship.Domain name illegal command is used to indicate the network that domain name supervising server deletes current primary database
Mapping relations between location and domain name, so that domain name is invalid, i.e., terminal cannot be visited successfully by the domain name of current primary database
Ask the current primary database.
Domain name switching command is to trigger the instruction switched over to the domain name of the primary database after switching.Domain name switching command
Specifically trigger the instruction that the domain name of the primary database after switching is updated according to the domain name of current primary database.Domain name switching command
Domain name supervising server is used to indicate to establish between the domain name of current primary database and the network address of the primary database after switching
Mapping relations so that terminal according to the domain name of current primary database be may have access to switching after primary database.Mapping relations
Refer to the corresponding relationship between domain name and network address, according to known domain name according to mapping relations with can corresponding to determining network
Location.
Specifically, when determining main equipment room failure or primary database operation troubles, the switching of monitoring management server triggers
Primary database.Before switching primary database, monitoring management server generates domain name illegal command, and domain name generated is invalid
Instruction is sent to domain name supervising server.Domain name supervising server inquires current master data according to the domain name illegal command received
Mapping relations between the network address and domain name in library, and then delete inquired mapping relations.When mapping relations delete at
When function, domain name supervising server is to monitoring management server feedback successful prompt information in vain.
In one embodiment, domain name supervising server obtains current primary database according to the domain name illegal command received
Network address and domain name, and then according to acquired network address and the corresponding mapping relations of inquiry of the domain name.Domain name supervising clothes
Business device can obtain the network address and domain name of current primary database by parsing the domain name illegal command received, can also root
The network address and domain name of current primary database are obtained from monitoring management server according to the domain name illegal command received.
Further, when primary database, which switches, to be completed, monitoring management server generates domain name switching command, and will give birth to
At domain name switching command be sent to domain name supervising server.Domain name supervising server is according to the domain name switching command received point
The domain name of current primary database and the network address of the primary database after switching are not obtained, and establish acquired current master data
Mapping relations between the domain name in library and the network address of the primary database after switching.
In one embodiment, monitoring management server can be obtained currently by parsing the domain name switching command received
The domain name of primary database and the network address of the primary database after switching can also take according to domain name switching command from monitoring management
The domain name of current primary database and the network address of the primary database after switching are obtained in business device.
In one embodiment, domain name supervising server according to domain name switching command establish current primary database domain name and
Before mapping relations between the network address of primary database after switching, delete switching after primary database network address and
Mapping relations between corresponding domain name.It, can also when domain name supervising server establishes new mapping relations according to domain name switching command
The mapping relations between network address and domain name to retain the primary database after switching.In this way, after the completion of primary database switching,
The domain name of primary database before terminal can still switch according to primary database after the switching is from the primary database after the switching
Read data.
It is a in one embodiment, DNS (Domain Name System, domain name system are deployed on domain name supervising server
System), when domain name supervising server receives domain name illegal command or domain name switching command, above-mentioned deletion is executed by DNS and is had
Mapping relations and the correlation step for re-establishing mapping relations.When domain name supervising server receives the domain name of terminal transmission, by
DNS obtains corresponding network address according to mapping relations parsing.
In above-described embodiment, before switching primary database, by domain name supervising server by the domain name of current primary database
It is invalid to be set to, so that current primary database cannot be by successful access, to guarantee data consistency.Primary database switching is completed
When, the network of the primary database after the domain name and switching of current primary database are further re-established by domain name supervising server
The domain name of primary database after switching is updated to the domain name of current primary database, to protect by the mapping relations between address
Demonstrate,prove terminal according to existing domain name can successful access switching after primary database.
In one embodiment, the candidate data for being used to back up current primary database from database;Step S210 includes:Root
It is updated according to the incremental data of current primary database selected from database;In current primary database and selected from database
When data are consistent, it is updated to read-write properties parameter from the read only attribute parameter of database by selected, the master after being switched
Database;According to the incremental data of the primary database after switching, each candidate data from database are updated respectively;After switching
Primary database and when each candidate consistent from database data, primary database after establishing switching respectively and each candidate from database
Master-slave relationship.
Wherein, incremental data refers to variance data of the database relative to another database.Incremental data is specific
Refer to the data not yet backed up in primary database from database.Read-write properties parameter is intended to indicate that the ginseng of readable writeable attribute
Number.Read-write properties parameter is for indicating associated databases while supporting data write operation and data read operation.Read only attribute
Parameter is used to indicate the parameter of read only attribute.Read only attribute parameter for indicating that associated databases only support data read operation,
Without supporting data write operation.Read-write properties parameter and read only attribute parameter specifically can be by number, letter and symbol etc.
The character string of at least one of character composition, such as 1 corresponding read-write properties parameter, 0 corresponding read only attribute parameter.Master-slave relationship
Refer to primary database and from principal and subordinate's corresponding relationship between database.The data meeting changed in primary database after master-slave relationship is established
It backs up to from database, to realize primary database and be synchronized from the data between database.
Specifically, each data for being used to back up primary database in the data-base cluster from database in data-base cluster.
From candidate from database, selection is after database according to configuration file for monitoring management server, by the data of current primary database
It is compared with selected from the data of database, determines current primary database relative to the selected increment from database
Data, and the selected data from database are updated according to identified incremental data, by the increment of current primary database
Quantity backs up to selected from database.When update complete when, current primary database and selected from database data one
It causes, monitoring management server is updated to read-write properties parameter from database read only attribute parameter for selected, after obtaining switching
Primary database.
Further, the data of the primary database after switching and candidate are rejected institute by monitoring management server from database
Each candidate after the slave database of selection is compared respectively from the respective data of database, determines the master data after switching respectively
Library is relative to each candidate incremental data from database.For each candidate from database, monitoring management server is according to determining
Incremental data update corresponding candidate data from data respectively, identified incremental data is backed up into phase respectively
That answers is candidate from database.When updating completion, the primary database and each candidate after switching are consistent from database data, build respectively
Primary database after vertical switching and each candidate from the master-slave relationship between database, in order to the number of the primary database after switching
It is each candidate from database according to backing up to respectively.
In above-described embodiment, when carrying out master data switching, updated according to the incremental data of current primary database selected
From database, to guarantee data consistency, and update when the two data are consistent it is selected from data base read-write permission so that
Primary database after the switching obtained must be switched can be successfully written to data.After primary database after being switched, by each time
It selects and is updated to from the data of database consistent with the primary database after switching, and master-slave relationship is re-established, in order to switch
The data successful synchronization of primary database afterwards is to respectively from database.
In one embodiment, above-mentioned primary database method for handover control further includes:It obtains corresponding to candidate computer room mark
It is each candidate from the corresponding configuration information of database;Step S208 includes:According to the configuration information of acquisition from candidate computer room
The corresponding candidate of mark screens from database from database;Selected from the slave database filtered out according to configuration file from
Database.
Wherein, configuration information is intended to indicate that the information of candidate each configuration item from database.Configuration information ratio such as whether
There are binary log files.Configuration information can be stored in local from server where database by candidate, can also be by supervising
Control management server is stored in local, can also be stored in other computer equipments.
In one embodiment, the computer room that monitoring management server obtains main equipment room respectively identifies corresponding each candidate from number
According to the corresponding configuration information in library, and according to acquired configuration information from the computer room of main equipment room mark it is corresponding it is candidate from
Screening is selected from the slave database filtered out from database from database further according to configuration information in database.
In above-described embodiment, according to each candidate first from database progress to candidate from the corresponding configuration information of database
Step screening, selects to can be improved the screening from database from database from the slave database filtered out further according to configuration file
Efficiency.
As shown in figure 3, in one embodiment, providing a kind of primary database method for handover control, this method is specifically wrapped
Include following steps:
S302 obtains configuration file.
S304, the computer room state parameter of main equipment room where inquiring current primary database according to configuration file.
S306, when computer room state parameter meets computer room fault condition, the computer room logo collection that is recorded in configuration file
In, the candidate computer room mark after determining the computer room mark for rejecting main equipment room.
S308, according to configuration file, the candidate corresponding from candidate computer room mark is selected from database from database;It waits
Select the data for being used to back up current primary database from database.
S310 determines current primary database according to configuration file.
Designated field data is written to current primary database in S312.
S314, when determining write-in failure, according to configuration file, determine from the computer room of main equipment room mark it is corresponding it is candidate from
Slave database selected in database;Candidate is used to back up the data of current primary database from database.
S316 sends domain name illegal command to domain name supervising server;Domain name illegal command is used to indicate domain name supervising clothes
Business device deletes the mapping relations between the network address of current primary database and corresponding domain name.
S318 updates selected from database according to the incremental data of current primary database.
S320, current primary database with it is selected consistent from database data when, by selected from database
Read only attribute parameter is updated to read-write properties parameter, the primary database after being switched.
S322 updates each candidate data from database according to the incremental data of the primary database after switching respectively.
When S324, primary database after switching and each candidate consistent from database data, the master after switching is established respectively
Database and each candidate master-slave relationship from database.
S326 sends domain name switching command to domain name supervising server;Domain name switching command is used to indicate domain name supervising clothes
Business device establishes the mapping relations between the network address of primary database and the domain name of current primary database after switching.
In above-described embodiment, main equipment room state is judged by the computer room state parameter of main equipment room where obtaining primary database,
By the way that the operating status that designated field data judges primary database is written to primary database, when judgement main equipment room failure or master data
Primary database switching is carried out when the failure of library, primary database switching carries out the domain name switching of primary database when completing, to guarantee to lead
Database can be by successful access.
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 switching control 400, including:It obtains
Module 401, enquiry module 402, determining module 403, selecting module 404 and switching module 405, wherein:
Module 401 is obtained, for obtaining configuration file.
Enquiry module 402, the computer room state parameter for main equipment room where inquiring current primary database according to configuration file.
Determining module 403, the machine for being recorded in configuration file when computer room state parameter meets computer room fault condition
Candidate computer room mark in room logo collection, after determining the computer room mark for rejecting main equipment room.
Selecting module 404, for according to configuration file, the candidate corresponding from candidate computer room mark to select from database
From database.
Switching module 405, for current primary database to be switched to selected from database main number after being switched
According to library.
As shown in figure 5, in one embodiment, above-mentioned primary database switching control 400 further includes:Primary database is true
Cover half block 406, writing module 407 and from database determining module 408.
Primary database determining module 406, for determining current primary database according to configuration file.
Writing module 407, for designated field data to be written to current primary database.
From database determining module 408, for according to configuration file, determining from main equipment room when determining write-in failure
Computer room identifies corresponding candidate from slave database selected in database.
In one embodiment, switching module 405 are also used to inquire current primary database pair when determining write-in failure
The network address with external equipment answered;Out code is sent to band external equipment according to network address;Out code is used to indicate band
External equipment closes server where current primary database.
In one embodiment, method is executed by monitoring process;Switching module 405 is also used to generate primary database switching
Report;Primary database handover report is pushed into terminal;Close monitoring process.
In one embodiment, primary database switching control 400 further includes:Domain name switching module 409.
Domain name switching module 409, for sending domain name illegal command to domain name supervising server;Domain name illegal command is used for
Instruction domain name management server deletes the mapping relations between the network address of current primary database and corresponding domain name;To domain name pipe
It manages server and sends domain name switching command;Domain name switching command is used to indicate domain name supervising server and establishes the master data after switching
Mapping relations between the network address in library and the domain name of current primary database.
In one embodiment, the candidate data for being used to back up current primary database from database;Switching module 405, also
It is selected from database for being updated according to the incremental data of current primary database;Current primary database and it is selected from
When database data is consistent, it is updated to read-write properties parameter from the read only attribute parameter of database by selected, is switched
Primary database afterwards;According to the incremental data of the primary database after switching, each candidate data from database are updated respectively;When cutting
Primary database after changing and when each candidate consistent from database data, primary database after establishing switching respectively and each candidate from number
According to the master-slave relationship in library.
In one embodiment, it obtains module 401 and is also used to obtain the corresponding each candidate of candidate computer room mark from data
The corresponding configuration information in library;Selecting module 404, be also used to according to the configuration information of acquisition from candidate computer room mark corresponding to
Candidate from database screening from database;It is selected from the slave database filtered out from database according to configuration file.
Specific restriction about primary database switching control may refer to above for primary database switching control
The restriction of method, details are not described herein.Modules in above-mentioned primary database switching control can be fully or partially through
Software, hardware and combinations thereof are realized.Above-mentioned each module can be embedded in the form of hardware or independently of the place in computer equipment
It manages in device, can also be stored in a software form in the memory in computer equipment, in order to which processor calls execution or more
The corresponding operation of modules.
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 method for handover control 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 configuration file;It is inquired according to configuration file
The computer room state parameter of main equipment room where current primary database;When computer room state parameter meets computer room fault condition, configuring
Candidate computer room mark in the computer room logo collection recorded in file, after determining the computer room mark for rejecting main equipment room;According to configuration
File, the candidate corresponding from candidate computer room mark select from database from database;Current primary database is switched to institute
The slave database of selection, the primary database after being switched.
In one embodiment, following steps are also realized when processor executes computer program:It is determined according to configuration file
Current primary database;Designated field data is written to current primary database;When determining write-in failure, according to configuration file, really
It is fixed to identify corresponding candidate from slave database selected in database from the computer room of main equipment room.
In one embodiment, following steps are also realized when processor executes computer program:When determining write-in failure,
Inquire the corresponding network address with external equipment of current primary database;Out code is sent to band external equipment according to network address;
Out code is used to indicate band external equipment and closes server where current primary database.
In one embodiment, method is executed by monitoring process;Realizing when processor executes computer program currently to lead
Database be switched to it is selected from database, the step of primary database after being switched after, processor executes computer
Following steps are also realized when program:Generate primary database handover report;Primary database handover report is pushed into terminal;Close prison
Control process.
In one embodiment, current primary database is switched to selected by realization when processor executes computer program
From database, the step of primary database after being switched before, processor also realizes following steps when executing computer program:
Domain name illegal command is sent to domain name supervising server;Domain name illegal command is used to indicate domain name supervising server and deletes current master
Mapping relations between the network address of database and corresponding domain name;Processor is realized when executing computer program will current main number
Be switched to according to library it is selected from database, the step of primary database after being switched after, processor executes computer journey
Following steps are also realized when sequence:Domain name switching command is sent to domain name supervising server;Domain name switching command is used to indicate domain name
Management server establishes the mapping relations between the network address of primary database and the domain name of current primary database after switching.
In one embodiment, the candidate data for being used to back up current primary database from database;By current primary database
It is switched to selected from database, the primary database after being switched includes:More according to the incremental data of current primary database
It is new selected from database;Current primary database with it is selected consistent from database data when, by selected from number
It is updated to read-write properties parameter according to the read only attribute parameter in library, the primary database after being switched;According to the master data after switching
The incremental data in library updates each candidate data from database respectively;Primary database after switching and each candidate from database
Primary database and each candidate master-slave relationship from database when data are consistent, after establishing switching respectively.
In one embodiment, following steps are also realized when processor executes computer program:Obtain candidate computer room mark
Corresponding is each candidate from the corresponding configuration information of database;According to configuration file, corresponding from candidate computer room mark
Candidate selects from database from database, including:According to the configuration information of the acquisition candidate corresponding from candidate computer room mark
It screens from database from database;It is selected from the slave database filtered out from database according to configuration file.
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 configuration file;Current primary database institute is inquired according to configuration file
In the computer room state parameter of main equipment room;When computer room state parameter meets computer room fault condition, the machine that is recorded in configuration file
Candidate computer room mark in room logo collection, after determining the computer room mark for rejecting main equipment room;According to configuration file, from candidate computer room
The corresponding candidate of mark selects from database from database;Current primary database is switched to it is selected from database,
Primary database after being switched.
In one embodiment, following steps are also realized when computer program is executed by processor:It is true according to configuration file
Settled preceding primary database;Designated field data is written to current primary database;When determining write-in failure, according to configuration file,
It determines from the computer room of main equipment room and identifies corresponding candidate from slave database selected in database.
In one embodiment, following steps are also realized when computer program is executed by processor:Fail when determining to be written
When, inquire the corresponding network address with external equipment of current primary database;It sends to close to band external equipment according to network address and refer to
It enables;Out code is used to indicate band external equipment and closes server where current primary database.
In one embodiment, method is executed by monitoring process;Realizing when computer program is executed by processor will be current
Primary database be switched to it is selected from database, the step of primary database after being switched after, computer program is located
Reason device also realizes following steps when executing:Generate primary database handover report;Primary database handover report is pushed into terminal;It closes
Close monitoring process.
In one embodiment, current primary database is switched to selected by realization when computer program is executed by processor
Slave database, the step of primary database after being switched before, also realized when computer program is executed by processor following
Step:Domain name illegal command is sent to domain name supervising server;Domain name illegal command is used to indicate the deletion of domain name supervising server
Mapping relations between the network address and corresponding domain name of current primary database;Realizing when computer program is executed by processor will
Current primary database be switched to it is selected from database, the step of primary database after being switched after, computer program
Following steps are also realized when being executed by processor:Domain name switching command is sent to domain name supervising server;Domain name switching command is used
It is established between the network address of primary database and the domain name of current primary database after switching in instruction domain name management server
Mapping relations.
In one embodiment, the candidate data for being used to back up current primary database from database;By current primary database
It is switched to selected from database, the primary database after being switched includes:More according to the incremental data of current primary database
It is new selected from database;Current primary database with it is selected consistent from database data when, by selected from number
It is updated to read-write properties parameter according to the read only attribute parameter in library, the primary database after being switched;According to the master data after switching
The incremental data in library updates each candidate data from database respectively;Primary database after switching and each candidate from database
Primary database and each candidate master-slave relationship from database when data are consistent, after establishing switching respectively.
In one embodiment, following steps are also realized when computer program is executed by processor:Obtain candidate computer room mark
Corresponding each candidate is known from the corresponding configuration information of database;According to configuration file, corresponding to candidate computer room mark
Candidate from database selection from database, including:According to the configuration information of the acquisition time corresponding from candidate computer room mark
Choosing is screened from database from database;It is selected from the slave database filtered out from database according to configuration file.
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 method for handover control, the method includes:
Obtain configuration file;
The computer room state parameter of main equipment room where inquiring current primary database according to the configuration file;
When the computer room state parameter meets computer room fault condition, the computer room logo collection that is recorded in the configuration file
In, the candidate computer room mark after determining the computer room mark for rejecting the main equipment room;
According to the configuration file, the candidate corresponding from the candidate computer room mark is selected from database from database;
Current primary database is switched to the selected primary database from database, after being switched.
2. the method according to claim 1, wherein the method also includes:
Current primary database is determined according to the configuration file;
Designated field data is written to the current primary database;
When determining write-in failure, according to the configuration file, determine from the computer room of main equipment room mark it is corresponding it is candidate from
Slave database selected in database.
3. according to the method described in claim 2, it is characterized in that, the method also includes:
When determining write-in failure, the corresponding network address with external equipment of the current primary database is inquired;
Out code is sent to the band external equipment according to the network address;The out code is used to indicate the band peripheral hardware
Standby server where closing the current primary database.
4. the method according to claim 1, wherein the method is executed by monitoring process;
It is described current primary database is switched to it is selected described from database, after the primary database after being switched, institute
The method of stating further includes:
Generate primary database handover report;
The primary database handover report is pushed into terminal;
Close the monitoring process.
5. the method according to claim 1, which is characterized in that described to be switched to current primary database
It is selected described from database, before the primary database after being switched, the method also includes:
Domain name illegal command is sent to domain name supervising server;Domain name illegal command is used to indicate domain name management service
Device deletes the mapping relations between the network address and corresponding domain name of the current primary database;
It is described current primary database is switched to it is selected described from database, after the primary database after being switched, institute
The method of stating further includes:
Domain name switching command is sent to domain name management server;Domain name switching command is used to indicate domain name management
Reflecting between the network address for the primary database that server is established after the switching and the domain name of the current primary database
Penetrate relationship.
6. the method according to claim 1, which is characterized in that the candidate is from database for backing up
The data of the current primary database;It is described to be switched to current primary database selected described from database, switched
Primary database afterwards includes:
It is updated according to the incremental data of the current primary database selected described from database;
The current primary database with it is selected described consistent from database data when, will be selected described from database
Read only attribute parameter be updated to read-write properties parameter, the primary database after being switched;
According to the incremental data of the primary database after the switching, each candidate data from database are updated respectively;
Primary database after the switching and when each candidate consistent from database data, the main number after establishing the switching respectively
According to library and each candidate master-slave relationship from database.
7. according to the method described in claim 6, it is characterized in that, the method also includes:
The corresponding each candidate of the candidate computer room mark is obtained from the corresponding configuration information of database;
It is described according to the configuration file, the candidate corresponding from the candidate computer room mark from database selection from data
Library, including:
It is screened from database from data according to the configuration information of acquisition from the corresponding candidate of the candidate computer room mark
Library;
It is selected from the slave database filtered out from database according to the configuration file.
8. a kind of primary database switching control, which is characterized in that described device includes:
Module is obtained, for obtaining configuration file;
Enquiry module, the computer room state parameter for main equipment room where inquiring current primary database according to the configuration file;
Determining module, for being recorded in the configuration file when the computer room state parameter meets computer room fault condition
Candidate computer room mark in computer room logo collection, after determining the computer room mark for rejecting the main equipment room;
Selecting module, for according to the configuration file, the candidate corresponding from the candidate computer room mark to select from database
It selects from database;
Switching module, for current primary database to be switched to the selected master data from database, after being switched
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 |
---|---|---|---|
CN201810551550.0A CN108932295B (en) | 2018-05-31 | 2018-05-31 | Main database switching control method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810551550.0A CN108932295B (en) | 2018-05-31 | 2018-05-31 | Main database switching control method and device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108932295A true CN108932295A (en) | 2018-12-04 |
CN108932295B CN108932295B (en) | 2023-04-18 |
Family
ID=64449632
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810551550.0A Active CN108932295B (en) | 2018-05-31 | 2018-05-31 | Main database switching control method and device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108932295B (en) |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110069365A (en) * | 2019-04-26 | 2019-07-30 | 腾讯科技(深圳)有限公司 | Manage the method and corresponding device, computer readable storage medium of database |
CN110119392A (en) * | 2019-03-25 | 2019-08-13 | 福建天晴数码有限公司 | The method of application switching database IP, storage medium |
CN110413685A (en) * | 2019-04-12 | 2019-11-05 | 财付通支付科技有限公司 | Database service switching method, device, readable storage medium storing program for executing and computer equipment |
CN110442650A (en) * | 2019-08-09 | 2019-11-12 | 中国工商银行股份有限公司 | Database switching method, device, system, electronic equipment and storage medium |
CN110471909A (en) * | 2019-08-26 | 2019-11-19 | 上海达梦数据库有限公司 | A kind of data base management method, device, server and storage medium |
CN111367934A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data consistency checking method, device, server and medium |
CN111367885A (en) * | 2020-02-28 | 2020-07-03 | 京东方科技集团股份有限公司 | Database management system, database management method, storage medium, and electronic device |
CN111526038A (en) * | 2020-03-26 | 2020-08-11 | 口碑(上海)信息技术有限公司 | Service request distribution method and device, computer equipment and readable storage medium |
CN112560028A (en) * | 2020-12-24 | 2021-03-26 | 深圳昂楷科技有限公司 | Method and device for protecting key file and server |
CN112749045A (en) * | 2021-01-11 | 2021-05-04 | 深圳市伊欧乐科技有限公司 | Database cluster switching method, device, storage medium and apparatus |
CN112749148A (en) * | 2019-10-31 | 2021-05-04 | 北京国双科技有限公司 | Database switching method and device |
CN113162815A (en) * | 2020-10-22 | 2021-07-23 | 广州市汇聚支付电子科技有限公司 | Flow switching method, system, equipment and medium |
CN115134213A (en) * | 2021-03-25 | 2022-09-30 | 中国移动通信集团安徽有限公司 | Disaster recovery method, device, equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130124916A1 (en) * | 2011-11-16 | 2013-05-16 | Microsoft Corporation | Layout of mirrored databases across different servers for failover |
CN104486155A (en) * | 2014-12-15 | 2015-04-01 | 北京趣拿软件科技有限公司 | Database cluster monitoring method and system |
CN106874135A (en) * | 2017-02-20 | 2017-06-20 | 北京百度网讯科技有限公司 | Method, device and equipment for detecting computer room failure |
-
2018
- 2018-05-31 CN CN201810551550.0A patent/CN108932295B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130124916A1 (en) * | 2011-11-16 | 2013-05-16 | Microsoft Corporation | Layout of mirrored databases across different servers for failover |
CN104486155A (en) * | 2014-12-15 | 2015-04-01 | 北京趣拿软件科技有限公司 | Database cluster monitoring method and system |
CN106874135A (en) * | 2017-02-20 | 2017-06-20 | 北京百度网讯科技有限公司 | Method, device and equipment for detecting computer room failure |
Cited By (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110119392B (en) * | 2019-03-25 | 2022-02-11 | 福建天晴数码有限公司 | Method and storage medium for switching database IP (Internet protocol) application |
CN110119392A (en) * | 2019-03-25 | 2019-08-13 | 福建天晴数码有限公司 | The method of application switching database IP, storage medium |
CN110413685A (en) * | 2019-04-12 | 2019-11-05 | 财付通支付科技有限公司 | Database service switching method, device, readable storage medium storing program for executing and computer equipment |
CN110413685B (en) * | 2019-04-12 | 2024-03-12 | 财付通支付科技有限公司 | Database service switching method, device, readable storage medium and computer equipment |
CN110069365A (en) * | 2019-04-26 | 2019-07-30 | 腾讯科技(深圳)有限公司 | Manage the method and corresponding device, computer readable storage medium of database |
CN110442650A (en) * | 2019-08-09 | 2019-11-12 | 中国工商银行股份有限公司 | Database switching method, device, system, electronic equipment and storage medium |
CN110471909A (en) * | 2019-08-26 | 2019-11-19 | 上海达梦数据库有限公司 | A kind of data base management method, device, server and storage medium |
CN110471909B (en) * | 2019-08-26 | 2022-03-08 | 上海达梦数据库有限公司 | Database management method, device, server and storage medium |
CN112749148A (en) * | 2019-10-31 | 2021-05-04 | 北京国双科技有限公司 | Database switching method and device |
CN111367885A (en) * | 2020-02-28 | 2020-07-03 | 京东方科技集团股份有限公司 | Database management system, database management method, storage medium, and electronic device |
CN111526038A (en) * | 2020-03-26 | 2020-08-11 | 口碑(上海)信息技术有限公司 | Service request distribution method and device, computer equipment and readable storage medium |
CN111367934B (en) * | 2020-03-31 | 2023-10-31 | 中国建设银行股份有限公司 | Data consistency checking method, device, server and medium |
CN111367934A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data consistency checking method, device, server and medium |
CN113162815A (en) * | 2020-10-22 | 2021-07-23 | 广州市汇聚支付电子科技有限公司 | Flow switching method, system, equipment and medium |
CN112560028A (en) * | 2020-12-24 | 2021-03-26 | 深圳昂楷科技有限公司 | Method and device for protecting key file and server |
CN112749045A (en) * | 2021-01-11 | 2021-05-04 | 深圳市伊欧乐科技有限公司 | Database cluster switching method, device, storage medium and apparatus |
CN115134213A (en) * | 2021-03-25 | 2022-09-30 | 中国移动通信集团安徽有限公司 | Disaster recovery method, device, equipment and storage medium |
CN115134213B (en) * | 2021-03-25 | 2023-09-05 | 中国移动通信集团安徽有限公司 | Disaster recovery method, device, equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108932295B (en) | 2023-04-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108932295A (en) | Primary database method for handover control, device, computer equipment and storage medium | |
CN108897658B (en) | Method and device for monitoring master database, computer equipment and storage medium | |
US5274802A (en) | Method for restoring lost databases by comparing existing database and generic database, and generating cellular switch commands to update the generic database | |
CN109032824A (en) | Database method of calibration, device, computer equipment and storage medium | |
CN107911249B (en) | Method, device and equipment for sending command line of network equipment | |
CN108322533A (en) | Configuration and synchronization method between distributed type assemblies node based on operation log | |
CN104951474A (en) | Method and device for acquiring MySQL binlog incremental logs | |
CN103152390B (en) | The node configuration method of distributed memory system, device, node and system | |
CN108900572B (en) | Main database domain name switching control method, computer equipment and storage medium | |
CN108965383B (en) | File synchronization method and device, computer equipment and storage medium | |
CN109460438A (en) | Message data storage method, device, computer equipment and storage medium | |
CN110647425A (en) | Database recovery method and device | |
CN104182354A (en) | Video managing method and device | |
CN108628705B (en) | Database recovery method and device, computer equipment and storage medium | |
JP2019204527A (en) | Processing method and processing device of data position of storage equipment, computer equipment, and computer-readable storage medium | |
US7281165B2 (en) | System and method for performing product tests utilizing a single storage device | |
CN111966531B (en) | Data snapshot method and device, computer equipment and storage medium | |
CN107291575B (en) | Processing method and equipment for data center fault | |
CN110659156A (en) | Data processing method and device of web server and storage medium | |
CN112115166B (en) | Data caching method and device, computer equipment and storage medium | |
CN115080309A (en) | Data backup system, method, storage medium, and electronic device | |
CN110569231B (en) | Data migration method, device, equipment and medium | |
CN108319679B (en) | Method and device for generating primary key | |
US6711588B1 (en) | File management method for file system | |
CN110928945B (en) | Data processing method and device for database and data processing system |
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 |