WO2018192286A1

WO2018192286A1 - Database switching method, master server and slave server

Info

Publication number: WO2018192286A1
Application number: PCT/CN2018/074160
Authority: WO
Inventors: 倪冬冬; 田龙辉
Original assignee: 中国银联股份有限公司
Priority date: 2017-04-18
Filing date: 2018-01-25
Publication date: 2018-10-25
Also published as: TW201839636A; TWI669620B; CN107066354B; CN107066354A

Abstract

Disclosed are a database switching method, master server and slave server, the method comprising: acquiring state information of each database from each group of databases of at least two groups of databases, wherein each group of databases comprises one main database and at least one standby database, and each group of databases corresponds to one or more of four function types comprising an addition function, a deletion function, a modification function and a query function, and the state information comprises a normal state and an abnormal state; sending information of each database to a master server, the information of each database being used to enable the master server to determine, according to the state information of each database, whether to perform switching between databases having the same database group identifier, wherein the information of each database comprises a database identifier, a database group identifier and state information of a database.

Description

Method for switching database, primary server and secondary server

This application claims priority to Chinese Patent Application No. 200910253569.2, entitled "A database switching method, master server and slave server", filed on April 18, 2017, the entire contents of which are incorporated by reference. Combined in this application.

Technical field

The embodiments of the present invention relate to the field of communications, and in particular, to a method for switching a database, a primary server, and a secondary server.

Background technique

With the rapid development of information technology, data is exploding, and the database for managing data is becoming more and more important. When an abnormality occurs in the database, maintenance of data is required to stop the data, and even data loss in the database due to database anomalies may cause economic losses that are difficult to estimate for enterprises and users. Therefore, it is necessary to take appropriate measures to ensure the high availability of the database cluster. Here, high availability refers to improving the high availability of the system by reducing the database abnormality caused by daily maintenance operations or sudden abnormalities. For example, when an abnormality occurs in a database, the request related to the database can be transferred to other databases that can be in a normal state, so as to ensure the safe and efficient operation of the core business systems of the company and the enterprise.

The solution in the prior art is to select the node of the primary server in the database cluster, or the selection of multiple primary server boundary nodes in the same data and service processing, but if the database abnormality is caused by high frequency transactions or a large amount of data processing After switching to the normal working database, there will still be a database exception problem. Therefore, it is necessary to continuously switch the database, and it is necessary to continuously maintain an abnormal database, which seriously affects the operating efficiency and security of the system.

Summary of the invention

The embodiment of the invention provides a database switching method, a master server and a slave server, which are used for independent monitoring and switching between database groups by simple configuration, and contribute to high availability of the system.

In a first aspect, an embodiment of the present invention provides a method for switching a database, including: obtaining, from a server, status information of each database in each group of at least two groups of databases; wherein each group of databases includes a primary database and At least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes a normal status And an abnormal state; the slave server sends the information of each database to the primary server, where the information of each database is used to cause the primary server to determine that the group identifier of the database is the same according to the state information of each database Whether the switching is performed between the databases; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database.

In the embodiment of the present invention, the state information of each database in each group of the at least two groups of databases is obtained from the server; wherein each of the groups of databases includes a primary database and at least one standby database, where each database corresponds to Any one or more of the four functional types; the four functional types include an add function, a delete function, a change function, and a query function; the status information includes a normal status and an abnormal status; and is classified according to a function type of the database. At least two database groups form at least two sets of databases independent of each other, and data between each group is independent of each other; information of each database in each group database of at least two groups of databases is sent to the main service, the primary server According to the status information of each database, it is determined whether the databases in the same group are switched; thus, the data between the same group identifiers can be switched, and the independent monitoring and switching between the database groups is realized through simple configuration, and thus Helps the high availability of the system.

Optionally, the query function corresponds to at least one set of databases; each of the at least one set of databases corresponds to at least one service type.

Optionally, each group of the at least one group of databases respectively corresponds to at least one type of service, including: a service type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases; and/or; a service type whose transaction quantity is greater than a quantity threshold Corresponding to a set of databases.

Optionally, before the obtaining, by the server, status information of each database in each of the two groups of databases, the method further includes: the slave server periodically detecting each of the at least two groups of databases Status information of the database; the slave server performs an update operation on the historical state information of the database according to the state information of each database; the slave server acquires each database in each group of the at least two groups of databases The status information includes: obtaining, by the server, status information of each database after the update, and the status information of each database after the new is the slave server according to the status information of each database to the database The historical status information is obtained by the update operation.

Optionally, the slave server periodically detects status information of each database in each of the at least two groups of databases, including: if the slave server determines that the total duration of the last update operation is not greater than the first pre- Setting the duration, starting from the last update operation, starting to detect the status information of each database of the at least two groups of databases after the first preset duration; if the slave server determines the total duration of the last update operation If it is greater than the first preset duration, the state information of each database of the at least two groups of databases is detected after the end of the last update operation.

In a second aspect, an embodiment of the present invention provides a method for switching a database, including: a primary server receiving information of each database in each group of at least two groups of databases sent from a server; and the information of each database includes a database The identifier of the database, the group identifier of the database, and the state information of the database; the primary server determines, according to the state information of each database, whether to switch between databases with the same group identifier of the database.

Optionally, the primary server determines, according to the status information of each database, whether to switch between databases with the same group identifier of the database, including: the primary server exists in a database that determines that the group identifier of the database is the same. When at least one database state information is the database in a normal state, the database in which the database state information is an abnormal state switches the database in which the database state is a normal state.

Optionally, after the primary server receives the information of each database sent from the server, the method includes:

When the primary server determines that the length of the information for transmitting each database is not greater than the second preset duration, the primary server determines, according to the status information of each database, whether the database with the same group identifier of the database is performed. Switching; when the primary server determines that the duration of transmitting the information of each database is greater than the second preset duration, the primary server sends a request for obtaining information of each database to the secondary server.

In a third aspect, an embodiment of the present invention provides a slave server for switching a database, including: an acquiring unit, configured to acquire state information of each database in each group of databases in at least two groups of databases; wherein each group of databases Included as a primary database and at least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; The status information includes a normal status and an abnormal status; the sending unit is configured to send the information of each database to the primary server, where the information of each database is used to cause the primary server to determine according to status information of each database Whether the group of the database identifies the same database is switched; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the state information of the database.

Optionally, the method further includes: a detecting unit, configured to: periodically detect state information of each database in each of the at least two groups of databases; and further include an updating unit, configured to: according to each database The status information is used to update the historical status information of the database; the obtaining unit is configured to: obtain status information of each updated database, and the status information of each new database is the update The unit obtains an update operation on the historical state information of the database according to the state information of each database.

Optionally, the detecting unit is configured to: if it is determined that the total duration of the last update operation is not greater than the first preset duration, start from the last update operation, and start the detection after the first preset duration State information of each database of at least two groups of databases; if the slave server determines that the total duration of the last update operation is greater than the first preset duration, detecting the at least two groups of databases from the end of the last update operation Status information for each database.

In a fourth aspect, an embodiment of the present invention provides a primary server for database switching, including: a receiving unit, configured to receive information about each database in each group of databases in at least two groups of databases sent from a server; The information includes the identifier of the database, the group identifier of the database, and the state information of the database. The determining unit is configured to determine, according to the state information of each database, whether to switch between databases with the same group identifier of the database.

Optionally, the determining unit is configured to: when determining that the database having the same group identifier of the database has at least one database in which the database state information is in a normal state, the database state information is an abnormal state database switch The database status is a database of normal status.

Optionally, the determining unit is configured to: when determining that the duration of the information for transmitting each database is not greater than a second preset duration, the determining unit determines the group of the database according to the state information of each database Identifying whether switching is performed between the same databases; when the determining unit determines that the duration of transmitting the information of each database is greater than the second preset duration, the determining unit sends the information of obtaining each database to the slave server. Request.

In a fifth aspect, an embodiment of the present invention provides an electronic device, including: a processor, a memory, a transceiver, and a bus interface, wherein a processor, a memory, a transceiver, and a bus interface are connected by a bus;

The processor is configured to read a program in the memory, and perform the following method: acquiring state information of each database in each group of at least two groups of databases; wherein each group of databases includes a primary database and At least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes a normal status And abnormal state;

The memory is configured to store one or more executable programs, and may store data used by the processor when performing operations;

The transceiver is configured to send information about each database to a primary server under control of the processor, where information of each database is used to cause the primary server to obtain status information according to each database Determining whether to switch between databases with the same group identifier of the database; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database.

In a sixth aspect, another electronic device is provided in the embodiment of the present invention, including: a processor, a memory, a transceiver, and a bus interface, wherein a processor, a memory, a transceiver, and a bus interface are connected by a bus;

The transceiver is configured to receive information about each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

The processor is configured to read a program in the memory, and perform the following method: determining, according to status information of each database, whether to switch between databases with the same group identifier of the database;

The memory is configured to store one or more executable programs, and may store data used by the processor when performing operations.

In a seventh aspect, an embodiment of the present application provides a non-transitory computer readable storage medium, where a computer storage medium stores instructions that, when run on a computer, cause the computer to perform any of the first aspect or the first aspect. A method in an implementation, or causing a computer to perform the method of the second aspect or any possible implementation of the second aspect.

In an eighth aspect, an embodiment of the present application provides a computer program product comprising instructions, when executed on a computer, causing a computer to perform the method in the first aspect or any possible implementation manner of the first aspect, or cause the computer to execute The method of any of the second aspect or any possible implementation of the second aspect.

DRAWINGS

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly described below.

1 is a schematic structural diagram of a communication system according to an embodiment of the present invention;

2 is a schematic flowchart of a method for switching a database according to an embodiment of the present invention;

FIG. 3 is a schematic structural diagram of a slave server according to an embodiment of the present disclosure;

4 is a schematic structural diagram of a main server according to an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure;

FIG. 6 is a schematic structural diagram of another electronic device according to an embodiment of the present invention.

detailed description

In order to make the objects, technical solutions and advantageous effects of the present invention more comprehensible, the present invention will be further described in detail below with reference to the accompanying drawings. It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

It should be understood that the technical solutions of the embodiments of the present invention can be applied to various communication systems, such as a Global System of Mobile Communication (GSM) system, a Code Division Multiple Access (CDMA) system, Wideband Code Division Multiple Access (WCDMA) General Packet Radio Service (GPRS) system, Long Term Evolution (LTE) system, LTE frequency division duplex (Frequency Division) Duplex (referred to as FDD) system, LTE Time Division Duplex (TDD), Universal Mobile Telecommunication System (UMTS), Worldwide Interoperability for Microwave Access (WiMAX) communication System, and future 5G communication systems.

FIG. 1 is a schematic block diagram showing a communication system to which an embodiment of the present invention is applied. As shown in FIG. 1, the communication system includes a database cluster 101, a slave server 102, and a master server 103. The primary server and the secondary server are connected by wireless connection or wired connection or other means, and the server is connected to each database in the database cluster through a wireless connection or a wired connection or the like.

The database cluster 101 includes at least two groups of databases, a database group 104 and a database group 105. The

database groups

104 and 105 respectively include a primary database and at least one standby database. The database group 104 includes a primary database 104a and a standby database 104b. The database group 105 includes a primary database. Database 105a and standby database 105b. The PSY is used for data synchronization between the primary database and the standby database to ensure synchronization of data in the primary database and the standby database. Each set of databases corresponds to any one or more of the four functional types; the four functional types include an add function, a delete function, a change function, and a query function; for example, the database cluster includes two sets of

databases

104 and 105, the two sets of databases. The query function corresponds to a group of databases 104, and the adding function, deleting function, and changing function correspond to another group of databases 105; wherein each type of database corresponds to at least one set of data, and the query function corresponds to at least one set of databases; at least one Each group of databases in the group database corresponds to at least one type of service, wherein the types of services include: cash withdrawal, consumption, and query balance.

The slave module is deployed from the server 102. The slave module includes a database detection process HCS_DB106a~HCS_DB106d, a database group monitoring process HCS_MON_AGENT107a and an HCS_MON_AGENT107b, and a database information sending process UDP_SEND108. The database detecting process HCS_DB106 is used to detect the status of all databases connected to the slave server. Information, each data corresponding to a database detection process HCS_DB is used to detect the status information of the data; that is, in the system, the database detection process HCS_DB 106a is used to detect the database status information of the database 104a; the HCS_DB 106b is used to detect the database status information of the database 104b. The HCS_DB 106c is used to detect the database state information of the database 105a, and the HCS_DB 106d is used to detect the database state information of the database 105b; each group of databases starts a database group monitoring process HCS_MON_AGENT to obtain the information of the database of each group, that is, the HCS_MON_AGENT 107a is used to acquire the database group. The database information of 104, HCS_MON_AGENT 107b is used to obtain the database information of the database group 105; the information sending process of the database UDP_SEND 108 is used to serve the main service HCS_MON_AGENT107a ~ 103 transmits information database HCS_MON_AGENT107b each retrieved database group monitoring process.

The database monitoring and switching master module is deployed on the primary server 103. The database monitoring and switching master module includes a receiving process Infcollection 109 and a decision process Infdecision 110. The receiving process Infcollection 109 is configured to receive information of a database sent from the server; the decision process Infdecision 110 is configured to determine whether the database needs to be switched according to the received information of the database sent from the server.

Based on the system architecture shown in FIG. 1 , FIG. 2 exemplarily shows a flow chart of a method for switching a database according to an embodiment of the present invention. As shown in FIG. 2 , the database switching method provided by the embodiment of the present invention includes the following steps. :

Step S201: Obtain state information of each database in each group of the at least two groups of databases from the server; wherein each group of databases includes a primary database and at least one standby database, and each group of databases corresponds to any one of four functional types. Or any of a variety of; four types of functions include adding functions, deleting functions, changing functions, and query functions; status information includes normal status and abnormal status;

Step S202, the information of each database is sent from the server to the primary server, where the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

Step S203, the primary server receives information of each database in each of the at least two groups of databases sent from the server;

Step S204: The primary server determines, according to the status information of each database, whether to switch between databases with the same group identifier of the database.

In the embodiment of the present invention, the status information of each database in each group of the at least two groups of databases is obtained from the server; wherein each group of databases includes a primary database and at least one standby database, and each group of databases corresponds to four functional types. Any one or more of the four types of functions include adding functions, deleting functions, changing functions, and query functions; status information includes normal status and abnormal status; and dividing into at least two database groups according to the function type of the database to form mutual Independent at least two groups of databases, each of which is independent of data; information of each database in each of the at least two groups of databases is sent to the primary service, and the primary server determines based on the status information of each database Whether to switch between databases in the same group; thus, data between the same group identifier can be switched, and independent monitoring and switching between database groups can be realized through simple configuration, thereby contributing to high availability of the database.

In the embodiment of the present invention, the status information of each database in each group of the at least two groups of databases is obtained from the server, and each group of databases corresponds to any one or more of the four types of functions, and the four functions include adding functions. , delete function, change function and query function; among them, the database query function is used frequently. Optionally, the query function corresponds to at least one set of databases; each of the at least one set of databases corresponds to at least one type of service.

In the embodiment of the present invention, the query function corresponds to at least one set of databases, and the add function, the delete function, and the change function correspond to at least another set of databases; each set of databases corresponds to at least one service type, and the service type includes cash withdrawal, transfer, consumption, pre-authorization. Or the account settlement, etc.; the set of databases corresponding to the query function includes at least one set of databases, and the database corresponding to the query function may also be divided into multiple sets of databases according to the service type; optionally, the function of adding, deleting, and changing functions is correspondingly A set of databases, which can also correspond to a set of databases or groups of databases based on the type of business.

Optionally, the query function corresponds to at least one group of databases, each of the at least one group of databases corresponding to at least one type of service, including: a transaction type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases; and/or; A business type with a quantity greater than the quantity threshold corresponds to a set of databases.

In the embodiment of the present invention, the query function corresponds to a set of databases, and the set of databases includes a primary database and at least one standby database. In the group of databases corresponding to the query function, the group can continue to be divided into multiple groups, for example, a service type whose transaction frequency is greater than the frequency threshold corresponds to a group of databases, and a service type whose transaction frequency is not greater than the frequency threshold corresponds to another group of databases; In the group of databases corresponding to the function, the service type whose transaction quantity is greater than the quantity threshold corresponds to a group of databases, and the service type whose transaction quantity is not greater than the quantity threshold corresponds to another group of databases; or in the group of databases corresponding to the query function, the transaction frequency is greater than The service type of the frequency threshold and the number of transactions is greater than the quantity threshold corresponds to one set of databases, and the other corresponds to another set of databases.

Optionally, any one or more of the plurality of function types corresponding to the group of databases, wherein each group of databases corresponds to at least one type of service, and the group of databases corresponding to any one or more of the plurality of types of functions may be selected according to the type of the service. The grouping continues, for example, the service type whose transaction frequency is greater than the frequency threshold corresponds to a group of databases; and/or; the service type whose transaction quantity is greater than the quantity threshold corresponds to a group of databases. In this way, in the construction of the original communication system, the pressure of the database can be reduced, especially when there is a high frequency transaction causing the database to collapse, the grouping method can effectively solve the pressure problem for a large amount of data processing of the same kind.

Optionally, before obtaining, by the server, status information of each database in each group of the at least two groups of databases, the method further includes: periodically detecting, by the server, status information of each database in each group of the at least two groups of databases; The slave server updates the historical state information of the database according to the state information of each database; and obtains, from the server, state information of each database in each group of the at least two groups of databases, including: obtaining each database after the update from the server The status information, and the status information of each new database is obtained by the server updating the historical status information of the database according to the status information of each database.

In the embodiment of the present invention, a plurality of databases are associated from the server, and the database detection process HCS_DB on the server is used to periodically detect the state information of each data associated with the slave server, assuming that the database detection process HCS_DB probes the database period. For T, the database detection process HCS_DB performs a probe on the associated database every cycle T, and the slave server updates the history state information of the database according to the state information of each database. The update operation takes a certain amount of time to complete. The time to start the database probe process HCS_DB next time is determined according to the time of the update operation process.

Optionally, the server periodically detects status information of each database in each group of the at least two groups of databases, including: if the slave server determines that the total duration of the last update operation is not greater than the first preset duration, then Starting from an update operation, starting to detect status information of each database of at least two groups of databases after a first preset duration; if the slave server determines that the total duration of the last update operation is greater than the first preset duration, then updating from the previous update At the end of the operation, the status information of each database of at least two groups of databases is detected. In this way, it can ensure that the database detection process HCS_DB can detect the state information of the database in time, and can ensure that the database detection process HCS_DB does not waste network resources. In the embodiment of the present invention, the first preset duration may be equal to the period T.

In the embodiment of the present invention, after the database detection process HCS_DB on the server performs the detection of the database, the historical state information of the database is updated according to the state information of each database; after the database detection process HCS_DB updates the state information of the database, The server starts the database group monitoring process HCS_MON_AGENT to obtain the status information of the updated database. The database group monitoring process HCS_MON_AGENT determines whether the time for obtaining the state information of the updated database is greater than the third preset duration, wherein the third preset duration may be the same as the period. When it is determined that the third preset duration is not greater than the third preset duration, the historical state information of the database in the database group monitoring process HCS_MON_AGENT is updated according to each database state information acquired; after the update is completed, the next acquisition of each of the at least two groups of databases is performed. Status information of each database in the database; determining the database group identifier corresponding to each database obtained according to the mapping relationship between the identifier of the preset database and the database group identifier. When the determination is greater than the third preset duration, the database group monitoring process HCS_MON_AGENT re-acquires the database state information after the database detection process HCS_DB is updated, until the database group monitoring process HCS_MON_AGENT determines that the time of obtaining the updated database state information is not greater than the third pre- When the duration is set, the historical state information of the database in the database group monitoring process HCS_MON_AGENT is updated according to each database state information acquired, and after the sleep T duration, the next database in each group of at least two groups of databases is acquired next time. Status information.

In the embodiment of the present invention, the database detection process HCS_DB is detecting the corresponding data state information, and the corresponding database state information to be updated is in the protection zone, and the database group monitoring process HCS_MON_AGENT cannot read the database state information in the protection zone. By determining whether the time for obtaining the state information of the updated database is greater than the third preset duration, the latest state information in the state information of the database may be obtained in time.

In the embodiment of the present invention, the information sending process UDP_SEND of the database on the server sends information of each database in each of the at least two groups of databases updated in the database group monitoring process HCS_MON_AGENT to the primary server, on the primary server. The receiving process Infcollection receives information of each database in each of the at least two sets of databases in the updated database.

Optionally, after the primary server receives the information of each database sent from the server, the method further includes: determining, by the primary server, whether the duration of the process of receiving the process from the server to the primary server is greater than a second preset duration, and the primary server determines to transmit each database. When the duration of the information is not greater than the second preset duration, the primary server determines whether to switch between databases with the same group identifier of the database according to the state information of each database. The primary server sends a request for obtaining information of each database to the secondary server when determining that the information of each database is transmitted for each database to be longer than the second predetermined duration. In this way, it is possible to prevent the primary server from obtaining the history database information due to the link interruption between the primary server and the secondary server.

In the embodiment of the present invention, when the primary server receives the information of each database in each of the at least two groups of databases sent from the server and the transmission time is less than the second preset duration, the decision process Infdecision on the primary server each The status information of the database determines whether the database has the same group ID for the switch. An embodiment of the present invention provides an optional implementation manner: when the primary server determines that at least one database whose state information is in a normal state exists in a database having the same group identifier of the database, the database state information is an abnormal state database. Switch the database whose database status is normal. In the embodiment of the present invention, independent monitoring and switching of multiple groups of databases is realized by a simple configuration, and multiple groups of databases are not interfered with each other. When it is determined that the database status information is abnormal, it can be automatically switched to the database of other normal status of the group.

In the embodiment of the present invention, the primary server determines whether there is a database in which the database state information is an abnormal state in the database with the same group identifier of the database, and if so, whether there is a database in which the database state information is in a normal state in the database having the same group identifier. If it exists, the database whose database state information is abnormal is switched to the data whose database state information is normal. If there is no abnormal database in the same database with the same group ID, the database will not be processed. If the database has the same group ID, the database will not be processed. That is, the switching of the database is only performed in the group, and no switching is performed between different groups. In this way, independent monitoring and switching between multiple groups of databases can be realized, thereby contributing to high availability of the system.

In order to facilitate the understanding of the problem, a specific example is used to illustrate the switching process of the primary server. Suppose the primary server receives database information of two groups of databases. The information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database. For example, group 1 includes two databases, and the identifiers of the database are 1A and 1B, respectively. Indicates the primary database, 1B indicates the standby database, the status information of the primary database 1A is the normal state, and the state information of the standby database 1B is the abnormal state; then the standby database 1B is switched to the primary database 1A; the group 2 includes two databases, the identification of the database 2A and 2B, 2A represents the primary database, 2B represents the standby database, the status information of the primary database 2A is abnormal, and the state of the standby database 2B is abnormal; no switching is performed. Even if the database in the normal state in the group 1 does not perform the switching operation, the database switching is not performed, so that the high-availability independent monitoring and switching of the multiple groups of databases can be guaranteed.

FIG. 3 is a schematic structural diagram of a slave server for database switching according to an embodiment of the present invention.

Based on the same concept, an embodiment of the present invention provides a slave server. As shown in FIG. 3, the slave server 300 includes an obtaining unit 301, a sending unit 302, and a detecting unit 303 and an updating unit 304. among them:

An obtaining unit, configured to obtain state information of each database in each group of databases in at least two groups of databases; wherein each group of databases includes a primary database and at least one standby database, and each group of databases corresponds to any one of four functional types Or a plurality of types; the four function types include an add function, a delete function, a change function, and a query function; the status information includes a normal state and an abnormal state; and a sending unit is configured to send information of each database to the primary server, each database The information is used to enable the primary server to determine whether to switch between databases with the same group identifier of the database according to the status information of each database; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the state information of the database.

Optionally, the query function corresponds to at least one set of databases; each of the at least one set of databases corresponds to at least one type of service.

Optionally, each group of the database in the at least one group of databases respectively corresponds to at least one type of service, including: a service type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases; and/or; a service type whose transaction quantity is greater than a quantity threshold corresponds to a Group database.

Optionally, the method further includes: a detecting unit, configured to: periodically detect state information of each database in each group of the at least two groups of databases; and further include: an updating unit, configured to: use the state information of each database to the database The history status information is updated; the obtaining unit is configured to: obtain status information of each database after the update, and the status information of each database after the update is an update unit according to the status information of each database to the history of the database The status information is obtained by the update operation.

Optionally, the detecting unit is configured to: if it is determined that the total duration of the last update operation is not greater than the first preset duration, start from the last update operation, and start detecting the at least two groups of databases after the first preset duration Status information of each database; if the slave server determines that the total duration of the last update operation is greater than the first preset duration, the status information of each database of at least two groups of databases is detected after the end of the last update operation.

It can be seen from the foregoing that, in the embodiment of the present invention, status information of each database in each group of databases in at least two groups of databases is obtained from a server; wherein each group of databases includes a primary database and at least one standby database, each The group database corresponds to any one or more of the four function types; the four function types include an add function, a delete function, a change function, and a query function; the status information includes a normal state and an abnormal state; and the at least according to the function type of the database is divided into at least Two database groups form at least two groups of databases independent of each other, and data between each group is independent of each other; information of each database in each group database of at least two groups of databases is sent to the main service, and the main server is based on The status information of each database determines whether the data is switched between the databases in the same group; thus, the data between the same group identifiers can be switched, and the independent monitoring and switching between the database groups can be realized through simple configuration, and thus Helps the high availability of the system.

FIG. 4 is a schematic structural diagram of a main server for database switching according to an embodiment of the present invention.

Based on the same concept, an embodiment of the present invention provides a primary server. As shown in FIG. 4, the primary server 400 includes a receiving unit 401 and a decision unit 402. among them:

a receiving unit, configured to receive information about each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

The determining unit is configured to determine, according to the state information of each database, whether to switch between databases with the same group identifier of the database.

Optionally, the determining unit is configured to: when the database having the same group identifier of the same database has at least one database whose state information is in a normal state, the database state information is an abnormal state, and the database switching database state is a normal state. database.

Optionally, the determining unit is configured to: when determining that the duration of the information for transmitting each database is not greater than the second preset duration, the determining unit determines, according to the state information of each database, whether the database with the same group identifier of the database is performed. Switching; when the decision unit determines that the duration of transmitting the information of each database is greater than the second preset duration, the decision unit sends a request for obtaining information of each database to the slave server.

Based on the same concept, the present application provides an electronic device that can be used to perform the above-described method flow from the server side. FIG. 5 is a schematic structural diagram of an electronic device provided by the present application. The electronic device includes a processor 501, a memory 502, a transceiver 503, and a bus interface 504; wherein the processor 501, the memory 502, the transceiver 503, and the bus interface 504 are connected to one another via a bus 505.

The memory 502 is for storing a program; specifically, the program may include program code, and the program code includes computer operation instructions. The memory 502 may include a volatile memory such as a random-access memory (RAM); the memory may also include a non-volatile memory such as a flash memory (flash) Memory), hard disk drive (HDD) or solid-state drive (SSD); the memory 502 may also include a combination of the above types of memory.

The memory 502 stores the following elements, executable modules or data structures, or a subset thereof, or an extended set thereof:

Operation instructions: include various operation instructions for implementing various operations.

Operating system: Includes a variety of system programs for implementing various basic services and handling hardware-based tasks.

The bus 505 can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, and the like. For ease of representation, only one thick line is shown in Figure 5, but it does not mean that there is only one bus or one type of bus.

The bus interface 504 can be a wired communication access port, a wireless bus interface, or a combination thereof, wherein the wired bus interface can be, for example, an Ethernet interface. The Ethernet interface can be an optical interface, an electrical interface, or a combination thereof. The wireless bus interface can be a WLAN interface.

The processor 501 can be a central processing unit (CPU), a network processor (NP) or a combination of a CPU and an NP. It can also be a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD) or a combination thereof. The PLD may be a complex programmable logic device (CPLD), a field-programmable gate array (FPGA), a general array logic (GAL) or any combination.

The processor 501 is configured to read a program in the memory 502, and perform the following method: acquiring state information of each database in each group of at least two groups of databases; wherein each group of databases includes one master a database and at least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes Normal state and abnormal state;

The memory 502 is configured to store one or more executable programs, and may store data used by the processor 501 when performing operations;

The transceiver 503 is configured to send information about each database to a primary server under control of the processor 501, where the information of each database is used to make the primary server according to each database The status information determines whether a switch is performed between databases having the same group identifier of the database; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database. .

Optionally, the processor is configured to periodically detect state information of each database in each of the at least two groups of databases; and historical state of the database according to status information of each database The information is updated; the status information of each database after the update is obtained, and the status information of each database after the update is historical status information of the database by the update unit according to the status information of each database. Get the update operation.

Optionally, the processor is configured to: if it is determined that the total duration of the last update operation is not greater than the first preset duration, start from the last update operation, and start the detection after the first preset duration State information of each database of at least two groups of databases; if it is determined that the total duration of the last update operation is greater than the first preset duration, detecting each database of the at least two groups of databases from the end of the last update operation status information.

It should be understood that the division of each unit above is only a division of a logical function, and the actual implementation may be integrated into one physical entity in whole or in part, or may be physically separated. In the embodiment of the present application, the sending unit 302 can be implemented by a transceiver, and the obtaining unit 301, the detecting unit 303, and the updating unit 304 can be implemented by a processor. As shown in FIG. 5, the electronic device 500 can include a processor 501, a transceiver 503, and a memory 502. The memory 502 can be used to store a program/code pre-installed at the time of shipment of the electronic device 500, and can also store a code or the like for execution of the processor 501.

It can be seen from the foregoing that, in the embodiment of the present invention, in the embodiment of the present invention, state information of each database in each group of databases in at least two groups of databases is obtained from a server; wherein each group of databases includes one master a database and at least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes Normal state and abnormal state; according to the function type of the database, it is divided into at least two database groups to form at least two groups of databases independent of each other, and the data between each group is independent of each other; The information of each database is sent to the main service, and the main server determines whether to switch between the databases in the same group according to the status information of each database; thus, the data between the same group identifiers can be switched, through simple configuration. Implement independent monitoring and switching between database groups, which in turn helps the system Availability.

Based on the same concept, the present application provides another electronic device that can be used to execute the method flow on the main server side described above. FIG. 6 is a schematic structural diagram of another electronic device provided by the present application. The electronic device includes a processor 601, a memory 602, a transceiver 603, and a bus interface 604; wherein the processor 601, the memory 602, the transceiver 603, and the bus interface 604 are connected to one another via a bus 605.

The memory 602 is for storing a program; specifically, the program may include program code, and the program code includes computer operation instructions. The memory 602 may include a volatile memory such as a random-access memory (RAM); the memory may also include a non-volatile memory such as a flash memory (flash) Memory), hard disk drive (HDD) or solid-state drive (SSD); the memory 602 may also include a combination of the above types of memory.

Memory 602 stores the following elements, executable modules or data structures, or subsets thereof, or their extended sets:

The bus 605 can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, and the like. For ease of representation, only one thick line is shown in Figure 6, but it does not mean that there is only one bus or one type of bus.

The bus interface 604 can be a wired communication access port, a wireless bus interface, or a combination thereof, wherein the wired bus interface can be, for example, an Ethernet interface. The Ethernet interface can be an optical interface, an electrical interface, or a combination thereof. The wireless bus interface can be a WLAN interface.

The processor 601 can be a central processing unit (CPU), a network processor (NP) or a combination of a CPU and an NP. It can also be a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD) or a combination thereof. The PLD may be a complex programmable logic device (CPLD), a field-programmable gate array (FPGA), a general array logic (GAL) or any combination.

The processor 601 is configured to read a program in the memory 602, and perform the following method: determining, according to status information of each database, whether to switch between databases with the same group identifier of the database;

The memory 602 is configured to store one or more executable programs, and may store data used by the processor 601 when performing an operation;

The transceiver 603 is configured to receive, under the control of the processor 601, information of each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, The group ID of the database and the status information of the database.

Optionally, the processor 601 is configured to: when the database in which the at least one database state information is in a normal state exists in a database in which the group identifier of the database is the same, the database state information is an abnormal state database switch. The database status is a database of normal status.

Optionally, the processor 601 is configured to: when determining that the duration of the information for transmitting each database is not greater than the second preset duration, determine, according to the state information of each database, a database with the same group identifier of the database. Whether switching is performed between; when it is determined that the duration of transmitting the information of each database is greater than the second preset duration, a request to acquire information of each database is sent to the slave server.

It should be understood that the division of each unit above is only a division of a logical function, and the actual implementation may be integrated into one physical entity in whole or in part, or may be physically separated. In the embodiment of the present application, the receiving unit 401 can be implemented by a transceiver, and the determining unit 402 can be implemented by a processor. As shown in FIG. 6, the electronic device 600 can include a processor 601, a transceiver 603, and a memory 602. The memory 602 can be used to store a program/code pre-installed when the electronic device 600 is shipped from the factory, or a code for the execution of the processor 601, and the like.

It can be seen from the foregoing that, in the embodiment of the present invention, in the embodiment of the present invention, state information of each database in each group of databases in at least two groups of databases is obtained from a server; wherein each group of databases includes one master a database and at least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes Normal state and abnormal state; according to the function type of the database, it is divided into at least two database groups to form at least two groups of databases independent of each other, and the data between each group is independent of each other; The information of each database is sent to the main service, and the main server determines whether to switch between the databases in the same group according to the status information of each database; thus, the data between the same group identifiers can be switched, through simple configuration. Implement independent monitoring and switching between database groups, which in turn helps the system High availability.

Those skilled in the art will appreciate that embodiments of the invention may be provided as a method, system, or computer program product. Thus, embodiments of the invention may be in the form of an entirely hardware embodiment, an entirely software embodiment, or a combination of software and hardware. Moreover, embodiments of the invention may take the form of a computer program product embodied on one or more computer usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) including computer usable program code.

Embodiments of the invention are described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or FIG. These computer program instructions can be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing device to produce a machine for the execution of instructions for execution by a processor of a computer or other programmable data processing device. Means for implementing the functions specified in one or more of the flow or in a block or blocks of the flow chart.

The computer program instructions can also be stored in a computer readable memory that can direct a computer or other programmable data processing device to operate in a particular manner, such that the instructions stored in the computer readable memory produce an article of manufacture comprising the instruction device. The apparatus implements the functions specified in one or more blocks of a flow or a flow and/or block diagram of the flowchart.

These computer program instructions can also be loaded onto a computer or other programmable data processing device such that a series of operational steps are performed on a computer or other programmable device to produce computer-implemented processing for execution on a computer or other programmable device. The instructions provide steps for implementing the functions specified in one or more of the flow or in a block or blocks of a flow diagram.

It is apparent that those skilled in the art can make various modifications and variations to the embodiments of the present invention without departing from the spirit and scope of the application. Thus, it is intended that the present invention cover the modifications and variations of the embodiments of the invention.

Claims

A method for switching a database, comprising:

Obtaining, from the server, status information of each database in each group of the at least two groups of databases; wherein each of the groups of databases includes a primary database and at least one standby database, and each of the groups of databases corresponds to any one of four functional types Or any of the plurality of types; the four function types include an add function, a delete function, a change function, and a query function; the status information includes a normal status and an abnormal status;

Sending, by the server, the information of each database to the primary server, where the information of each database is used to enable the primary server to determine, according to the status information of each database, whether the database with the same group identifier of the database is The switching is performed; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database.
The method of claim 1 wherein said query function corresponds to at least one set of databases; each of said at least one set of databases corresponds to at least one type of service.
The method of claim 2, wherein each of the at least one set of databases corresponds to at least one type of service, respectively:

A service type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases;

and / or;

A business type with a transaction quantity greater than the quantity threshold corresponds to a set of databases.
The method according to claim 1, wherein before the obtaining, by the server, the status information of each of the databases in each of the two sets of databases, the method further comprises:

The slave server periodically detects status information of each database in each of the at least two groups of databases;

And the slave server performs an update operation on the historical state information of the database according to the state information of each database;

And obtaining, by the server, status information of each database in each group of the at least two groups of databases, including:

Obtaining, from the server, status information of each database after the update, and the status information of each new database is that the slave server performs historical state information of the database according to status information of each database. The update operation was obtained.
The method of claim 4, wherein the slave server periodically detects status information of each database in each of the at least two groups of databases, including:

If the slave server determines that the total duration of the last update operation is not greater than the first preset duration, starting from the last update operation, starting to detect each of the at least two groups of databases after the first preset duration Status information of the database;

If the slave server determines that the total duration of the last update operation is greater than the first preset duration, the status information of each database of the at least two groups of databases is detected after the last update operation ends.
A database switching method, characterized in that it comprises

The primary server receives information of each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

The primary server determines, according to the status information of each database, whether to switch between databases with the same group identifier of the database.
The method of claim 6, wherein the primary server determines whether to switch between databases having the same group identifier of the database according to the status information of each database, including:

When the primary server determines that the database in which the database state information is in a normal state exists in the database having the same group identifier of the database, the database in which the database state information is in an abnormal state switches the database state to a normal state. database.
The method according to claim 6, wherein after the primary server receives the information of each database sent from the server, the method includes:

When the primary server determines that the length of the information for transmitting each database is not greater than the second preset duration, the primary server determines, according to the status information of each database, whether the database with the same group identifier of the database is performed. Switch

When the primary server determines that the duration of the information for transmitting each database is greater than the second preset duration, the primary server sends a request for obtaining information of each database to the secondary server.
A slave server for database switching, characterized in that it comprises:

An obtaining unit, configured to acquire state information of each database in each group of the at least two groups of databases; wherein each of the groups of databases includes a primary database and at least one standby database, where each database group corresponds to four functional types Any one or more of the following; the four functional types include an add function, a delete function, a change function, and a query function; the status information includes a normal status and an abnormal status;

a sending unit, configured to send, to the primary server, the information of each database, where the information of each database is used to cause the primary server to determine, according to the status information of each database, a database with the same group identifier of the database Whether to perform handover; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database.
The slave server of claim 9, wherein the query function corresponds to at least one set of databases; each of the at least one set of databases corresponds to at least one type of service.
The slave server according to claim 10, wherein each of the at least one group of databases corresponds to at least one type of service, respectively:

A service type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases;

and / or;

A business type with a transaction quantity greater than the quantity threshold corresponds to a set of databases.
The slave server according to claim 9, further comprising a detecting unit, configured to:

Periodically detecting status information of each database in each of the at least two groups of databases;

Also included is an update unit for:

Updating the historical state information of the database according to the state information of each database;

The obtaining unit is configured to:

Obtaining status information of each database after the update, and the status information of each database after the update is obtained by the update unit performing an update operation on the historical state information of the database according to the state information of each database. .
The slave server according to claim 12, wherein the detecting unit is configured to:

If it is determined that the total duration of the last update operation is not greater than the first preset duration, starting from the last update operation, starting to detect status information of each database of the at least two groups of databases after the first preset duration If it is determined that the total duration of the last update operation is greater than the first preset duration, the state information of each database of the at least two groups of databases is detected from the end of the last update operation.
A master server for database switching, characterized in that it comprises

a receiving unit, configured to receive information about each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

And a determining unit, configured to determine, according to the state information of each database, whether to switch between databases with the same group identifier of the database.
The master server according to claim 14, wherein the decision unit is configured to:

When it is determined that at least one database in which the database state information is in a normal state exists in a database having the same group identifier of the database, the database in which the database state information is an abnormal state switches the database in which the database state is a normal state.
The master server according to claim 14, wherein the decision unit is configured to:

When determining that the duration of the information for transmitting each database is not greater than the second preset duration, the determining unit determines, according to the state information of each database, whether to switch between databases with the same group identifier of the database;

The determining unit sends a request for acquiring information of each database to the slave server when determining that the duration of the information for transmitting each database is greater than a second preset duration.
An electronic device, comprising: a processor, a memory, a transceiver, a bus interface, wherein a processor, a memory and a transceiver are connected by a bus;

The processor is configured to read a program in the memory, and execute the following method: acquiring state information of each database in each group of at least two groups of databases; wherein each group of databases includes a master a database and at least one standby database, each set of databases corresponding to any one or more of four functional types; the four functional types including an add function, a delete function, a change function, and a query function; the status information includes Normal state and abnormal state;

The transceiver is configured to send information about each database to a primary server, where the information of each database is used to enable the primary server to determine a database with the same group identifier of the database according to status information of each database. Whether the switching is performed; wherein the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

The memory is configured to store one or more executable programs, and may store data used by the processor when performing operations.
The electronic device of claim 17, wherein the query function corresponds to at least one set of databases; each of the at least one set of databases corresponds to at least one type of service.
The electronic device according to claim 18, wherein each of the at least one set of databases corresponds to at least one type of service, respectively:

A service type whose transaction frequency is greater than a frequency threshold corresponds to a group of databases;

and / or;

A business type with a transaction quantity greater than the quantity threshold corresponds to a set of databases.
The electronic device according to claim 17, wherein the processor is configured to:

Periodically detecting status information of each database in each of the at least two groups of databases; performing update operations on historical state information of the database according to status information of each database; acquiring each database after update Status information, the state information of each database after the new is obtained by the processor performing an update operation on the historical state information of the database according to the state information of each database.
The electronic device according to claim 20, wherein the processor is configured to:

If it is determined that the total duration of the last update operation is not greater than the first preset duration, starting from the last update operation, starting to detect status information of each database of the at least two groups of databases after the first preset duration If it is determined that the total duration of the last update operation is greater than the first preset duration, the state information of each database of the at least two groups of databases is detected from the end of the last update operation.
An electronic device, comprising: a processor, a memory, a transceiver, and a bus interface, wherein a processor, a memory, a transceiver, and a bus interface are connected by a bus;

The transceiver is configured to receive information about each database in each of the at least two groups of databases sent from the server; the information of each database includes an identifier of the database, a group identifier of the database, and status information of the database;

The processor is configured to determine, according to the status information of each database, whether to switch between databases with the same group identifier of the database.
The electronic device according to claim 22, wherein the processor is further configured to:

When it is determined that at least one database in which the database state information is in a normal state exists in a database having the same group identifier of the database, the database in which the database state information is an abnormal state switches the database in which the database state is a normal state.
The electronic device according to claim 23, wherein the processor is further configured to:

When determining that the duration of the information for transmitting each database is not greater than the second preset duration, the decision unit determines, according to the state information of each database, whether to switch between databases with the same group identifier of the database; When the duration of transmitting the information of each database is greater than the second preset duration, a request for acquiring information of each database is sent to the slave server.
A non-transitory computer readable storage medium, wherein the non-transitory computer readable storage medium stores computer instructions for causing the computer to perform the method of any one of claims 1 to 5. Or the computer instructions are for causing the computer to perform the method of any of claims 6-8.
A computer program product, comprising: a computing program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions, when the program instructions are executed by a computer, The computer executes the method of any one of claims 1 to 5; or causes the computer to perform the method of any of claims 6-8.