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 PDF

Info

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
Application number
CN201810551550.0A
Other languages
Chinese (zh)
Other versions
CN108932295B (en
Inventor
卢坚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kang Keyi Information Technology (shenzhen) Co Ltd
Original Assignee
Kang Keyi Information Technology (shenzhen) Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kang Keyi Information Technology (shenzhen) Co Ltd filed Critical Kang Keyi Information Technology (shenzhen) Co Ltd
Priority to CN201810551550.0A priority Critical patent/CN108932295B/en
Publication of CN108932295A publication Critical patent/CN108932295A/en
Application granted granted Critical
Publication of CN108932295B publication Critical patent/CN108932295B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1415Saving, restoring, recovering or retrying at system level
    • G06F11/142Reconfiguring to eliminate the error
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1415Saving, restoring, recovering or retrying at system level
    • G06F11/1435Saving, restoring, recovering or retrying at system level using file system or storage system metadata
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16Error detection or correction of the data by redundancy in hardware
    • G06F11/20Error 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/2015Redundant 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

Primary database method for handover control, device, computer equipment and storage medium
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.
CN201810551550.0A 2018-05-31 2018-05-31 Main database switching control method and device, computer equipment and storage medium Active CN108932295B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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