TWI669620B - Database switching method, server, storage medium, electronic device and product - Google Patents

Abstract

The data library switching method, the server, the storage medium, the electronic device and the product, obtain state information of each database in each group of at least two groups of databases; wherein each group of the database includes a main database And at least one standby database corresponding 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 abnormality Status; sending information of each database to the primary server, the information of each database is used to enable the primary server to determine the database with the same group identifier of the database according to the status information of each database Whether to switch; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database.

Description

Database switching method, server, storage medium, electronic device and product

The embodiments of the present invention belong to the field of communications, and in particular, to a method for switching a database, a server, a storage medium, an electronic device, and a product.

With the rapid development of information technology, data is exploding, and the database for managing data is becoming more and more important. When the database is abnormal, the maintenance data needs to stop the work, and even the data in the database is lost due to the abnormal database, which may bring difficult economic losses to the enterprise and users. Therefore, it is necessary to take appropriate measures to ensure the high availability of the database group. Here, high availability refers to improving the high availability of the system by reducing the abnormality of the database caused by routine maintenance operations or sudden abnormalities. For example, when an exception occurs in a database, the request related to the database can be transferred to other databases that can be in a normal state, thus ensuring 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 nodes of the main server in the database group, or to select multiple major server boundary nodes in the same data and service processing, but if the database abnormality is due to high frequency transactions or a large number of Data processing causes the database to be abnormal after switching to the normal working database. Therefore, it is necessary to continuously switch the database, and it is necessary to continuously maintain an abnormal database, which seriously affects the system. Operational efficiency Rate and security.

Embodiments of the present invention provide a method for switching a database, a server, a storage medium, an electronic device, and a product, which are used for independent monitoring and switching between database groups through simple configuration, thereby contributing to high availability of the system.

In a first aspect, an embodiment of the present invention provides a method for switching a database, including: a slave server acquiring state information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database, each of which 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 state and an abnormal state; the slave server sends the information of each database to the primary server, and the information of each database is used to enable the primary server to determine the database according to the status information of each database. Whether the group identifiers are switched between the same database; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database.

In the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database. Each group of data library 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; according to the function of the database The types are divided into at least two database groups, and at least two sets of databases are formed independently of each other, and the data between each group is independent of each other; at least each of the two sets of databases in each of the two sets of databases is The information 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 identification can be switched, and the data is realized through simple configuration. Independent monitoring and switching between library groups helps the system's high availability.

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

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

Optionally, before the slave server obtains status information of each database in each group of the at least two groups of databases, the method further includes: the slave server periodically detecting each group of the at least two groups of data Status information of each database in the library; the slave server updates the history status information of the database according to the status information of each database; the slave server obtains each group of data in at least two groups of databases Status information of each database in the library, including: the slave server obtains updated status information of each database, and the status information of each new database is the slave server according to each The status information of the database is obtained by updating the historical status information of the database.

Optionally, the slave server periodically detects status information of each database in each of the at least two groups of databases, including: the slave server determines that the total duration of the last update operation is not greater than The first preset duration starts from the last update operation, and after the first preset duration, starts to detect status information of each database of the at least two groups of databases; if the slave server determines the last update The total duration of the operation is greater than the first preset duration, and the status information of each database of the at least two groups of databases is detected after the last update operation ends.

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 of the at least two groups of data streams sent by the slave server; each of the data The information of the library includes the identifier of the database, the group identifier of the database, and the status information of the database; the main server determines whether the database with the same group identifier of the database is switched according to the status information of each 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 determines the same group identifier of the database. When there is at least one database in which the database state information is in a normal state, the database whose state information is in an abnormal state is switched to a database whose state is in a normal state.

Optionally, after the primary server receives the information of each database sent by the slave server, the method includes: when the primary server determines that the time for transmitting the information of each database is not greater than the second preset duration And the primary server determines, according to the status information of each database, whether to switch between the same database with the same group identifier of the database; the primary server determines that the time for transmitting the information of each database is greater than the second When the preset duration is long, the primary server sends a request to the slave server to obtain information for each database.

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 at least two groups of data databases; Each group of databases includes a main database and at least one standby database, each of which corresponds to any one or more of four functional types; the four functional types include adding functions, deleting functions, changing functions, and query functions. The status information includes a normal status and an abnormal status; the sending unit is configured to send information of each database to the primary server, and the information of each database is used to make the primary server according to each database The status information determines whether the database with the same group identifier of the database is switched; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database.

In the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database. Each group of data library 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; according to the function of the database The types are divided into at least two database groups, and at least two sets of databases are formed independently of each other, and the data between each group is independent of each other; at least each of the two sets of databases in each of the two sets of databases is The information 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 identification can be switched, and the data is realized through simple configuration. Independent monitoring and switching between library groups helps the system's high availability.

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

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

Optionally, the method further includes: a detecting unit, configured to: periodically detect status information of each database in each of the at least two groups of databases; and further include an updating unit, configured to: each of the data according to the data The status information of the database is updated by 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 unit obtains an update operation of the historical status information of the database according to the status 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 detecting after the first preset duration Status 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, then detecting the at least two groups from the end of the last update operation Status information for each database in the database.

In a fourth aspect, the embodiment of the present invention provides a main server for database switching, comprising: a receiving unit, configured to receive information about each database in each of the at least two groups of data databases sent by the slave server; The information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database; the decision unit is configured to determine the database with the same group identifier of the database according to the status information of each database. Whether to switch between.

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

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 the database according to the state information of each database Whether the group identifiers are switched between the same database; when the decision unit determines that the length of the information for transmitting each database is greater than the second preset duration, the decision unit sends and acquires each data to the slave server. A request for information from the library.

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 the processor, the memory, the transceiver, and the bus interface are connected by a bus bar. 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 includes one a primary database and at least one standby database, each of which corresponds to any one or more of 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 normal State and abnormal state; the memory for storing one or more executable programs, which can store data used by the processor when performing operations; the transceiver is configured to be driven to the main servo under the control of the processor Transmitting the information of each database, and the information of each database is used to make the main server confirm the status information of each database. Whether to switch between the same group identifier database repository; wherein each of the database information includes the group identifier and status information identifying database repository, the repository.

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 the processor, the memory, the transceiver, and the bus interface pass through the bus The transceiver is configured to receive information of each database in each of the at least two groups of data streams sent by the slave server; the information of each database includes the identifier of the database, the group of the database The identifier and the status information of the database; the processor is configured to read the program in the memory, and perform the following method: determining whether the database with the same group identifier of the database is performed according to the status information of each database Switching; the memory for storing one or more executable programs that can store data used by the processor when performing operations.

According to a seventh aspect, an embodiment of the present invention 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 the first aspect or any possible implementation of the first aspect. The method of the method, or the method of causing the computer to perform the second aspect or any possible implementation of the second aspect.

In an eighth aspect, an embodiment of the present invention provides a computer program product including instructions, which when executed on a computer, causes the computer to perform the method in the first aspect or any possible implementation manner of the first aspect, or causes the computer to execute the first The method of any of the two aspects or any of the possible implementations of the second aspect.

In the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database. Each group of data library 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; according to the function of the database The types are divided into at least two database groups, and at least two sets of databases are formed independently of each other, and the data between each group is independent of each other; at least each of the two sets of databases in each of the two sets of databases is The information 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 identification can be switched, and the data is realized through simple configuration. Independent monitoring and switching between library groups helps the system's high availability.

S201~S204‧‧‧Steps

101‧‧‧Database group

102‧‧‧Subordinate Server

103‧‧‧Main server

104, 105‧‧‧ database group

104a, 105a‧‧‧ main database

104b, 105b‧‧‧Alternative database

106a~106d‧‧‧Database detection process

107a, 107b‧‧‧ database group monitoring process

108‧‧‧Information transfer process

109‧‧‧ Receiving process

110‧‧‧Decision process

300‧‧‧Subordinate server

301‧‧‧Acquisition unit

302‧‧‧Send unit

303‧‧‧Detection unit

304‧‧‧Update Unit

400‧‧‧Main server

401‧‧‧ receiving unit

402‧‧‧Decision unit

501, 601‧‧‧ processor

502, 602‧‧‧ memory

503, 603‧‧‧ transceiver

504, 604‧‧ ‧ bus interface

505, 605‧‧ ‧ busbar

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; FIG. 2 is a schematic flowchart of a method for switching a data base 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 invention; 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 invention; and FIG. 6 is a schematic structural diagram of another electronic device according to an embodiment of the present invention.

The present invention will be further described in detail below with reference to the accompanying drawings and embodiments. 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: Global System of Mobile Communication (GSM) system, Code Division Multiple Access (CDMA) system, and broadband. 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 group 101, a slave server 102, and a primary server 103. The primary server and the slave server are connected by wireless connection or wired connection or other means, and the slave server and each database in the database group are connected by wireless connection or wired connection or other means.

The database group 101 includes at least two sets 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, and the database group 104 includes a primary database 104a. And the standby database 104b, the database group 105 includes a primary database 105a and a backup database 105b. PSY is used to synchronize data between the primary database and the alternate database to ensure synchronization of data in the primary and backup databases. Each group of databases 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; for example, the database group includes two sets of databases 104 and 105, The group database is respectively: the query function corresponds to a group of databases 104, and the adding function, the deleting function, and the changing function correspond to another group database 105; wherein each type of function type database corresponds to at least one set of data, and the query function corresponds to at least A set of databases; each of the at least one set of databases corresponds to at least one type of service, wherein the types of services include: cash withdrawal, consumption, and check balance.

The slave module is deployed on the slave 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 slave node. The status information of all the databases connected by the server, 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_DB106a is used to detect the database of the database 104a. Status information; 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 status information of the database 105a, and the HCS_DB 106d is used to detect the database status information of the database 105b; each group of databases starts a data The library group monitoring process HCS_MON_AGENT is used to obtain the information of the database of each group, that is, HCS_MON_AGENT107a is used to obtain the database information of the database group 104, and the HCS_MON_AGENT 107b is used to obtain the database information of the database group 105; the information sending process of the database is UDP_SEND108 Come to the main The server 103 sends the information of each group of databases obtained by the database group monitoring process HCS_MON_AGENT107a~HCS_MON_AGENT107b.

The main server 103 deploys a database monitoring and switching master module, and 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 used to receive the information of the database sent by the slave server; the decision process Infdecision 110 is used to determine whether the database needs to be switched according to the information of the database sent by the received slave server.

Based on the system architecture shown in FIG. 1 , FIG. 2 exemplarily shows a schematic flowchart of a method for switching a database according to an embodiment of the present invention. As shown in FIG. 2 , the data library switching method provided by the embodiment of the present invention includes the following Step: Step S201: The slave server obtains status information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database, each group of data The library 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 in step S202, the slave server sends the slave server to the main server. The information of each database, wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database; in step S203, the primary server receives at least two groups of databases sent by the slave server. Information of each database in each group of databases; step S204, the main server is based on the shape of each database Information to determine whether to switch between the same group identity database repository.

In the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group 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 sets of independent databases, each of which is independent of each other; and information of each of the at least two sets of databases is sent to the main Service, 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 identification can be switched, and the database group can be realized through simple configuration. Independent monitoring and switching between them, which in turn helps the database to be highly available.

In the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases, and each group of databases corresponds to any one or more of the four types of functions, and four functions. This includes adding functions, deleting functions, changing functions, and query functions; among them, the query function of the database is used more 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 group of databases, and the adding function, the deleting function, and the changing function correspond to at least another group of databases; each group of databases corresponds to at least one type of service, and the types of services include cash withdrawal, transfer, consumption, Pre-authorization or account settlement; the database 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 groups according to the type of service; optionally, adding functions, The delete function and the change function correspond to a set of databases, and the set of databases may also correspond to a set of databases or groups of databases according to the type of business.

Optionally, the query function corresponds to at least one set of data bases, and each set of the at least one set of data bases respectively corresponds to at least one service type, including: a set of data bases corresponding to a service type whose transaction frequency is greater than a frequency threshold; and/ Or; a business type with a transaction 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 group of databases, and the group of databases includes a main 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 a frequency threshold corresponds to a group of databases, and a service type whose transaction frequency is not greater than a frequency threshold corresponds to another group of databases; Or in the group of databases corresponding to the query 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 the group corresponding to the query function In the database, the service type whose transaction frequency is greater than the frequency threshold and the transaction quantity is greater than the quantity threshold corresponds to one set of data bases, and the other corresponds to another set of data bases.

Optionally, any one or a plurality of function types corresponding to a 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 of the plurality of types of functions may be further grouped according to the type of the service. For example, 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 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 the same kind of data processing.

Optionally, before the slave server obtains 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 the database Status information of each database; the slave server updates the history status information of the database according to the status information of each database; the slave server obtains each database in each group of at least two groups of databases The status information includes: the slave server obtains the updated status information of each database, and the status information of each database after the new database is the historical status of the database according to the status information of each database. Information obtained by the update operation.

In the embodiment of the present invention, the slave server is associated with multiple databases, and the database detection process HCS_DB on the slave server is used to periodically detect the status information of each data associated with the slave server, assuming database detection. The period of the process HCS_DB detection database is T, and the database detection process HCS_DB performs a detection on the associated database every cycle T, and the slave server updates the history status information of the database according to the status 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 slave server periodically detects status information of each of the at least two groups of the database, including: the slave server determines that the total duration of the last update operation is not greater than the first pre- If the duration is set, the status information of each database of at least two groups of databases is detected after the first preset time period; the slave server determines that the total duration of the last update operation is greater than The first preset duration starts to detect status information of each database of at least two groups of databases from the end of the last update operation. In this way, it can ensure that the database detection process HCS_DB can detect the status 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 slave server performs the detection of the database, the historical state information of the database is updated according to the state information of each database; the database detection process HCS_DB will be the database. After the status information is updated, the slave 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 status 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 the determination is not greater than the third preset duration, the historical status information of the database in the database monitoring process HCS_MON_AGENT is updated according to each database status information acquired; after the update is completed, the next acquisition is performed at least two groups. The status information of each database in each database in the database; determining the database group identifier corresponding to each database according to the mapping relationship between the identifier of the preset database and the identifier of the database group. When the determination is greater than the third preset duration, the database group monitoring process HCS_MON_AGENT re-acquires the database status information after the database detection process HCS_DB is updated, until the database group monitoring process HCS_MON_AGENT determines to obtain the status information of the updated database. When the time is not longer than the third preset duration, the historical status information of the database in the database group monitoring process HCS_MON_AGENT is updated according to each database status information acquired, and after the sleep T duration, the next time at least two are acquired. Status information for each database in each group of databases in the group database.

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

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

Optionally, after the primary server receives the information of each database sent by the slave server, the method further includes: determining, by the primary server, whether the duration of the process sent by the slave server to the primary server is greater than a second preset duration, When the server determines that the time for transmitting the information of each database is not longer than the second preset duration, the main server determines whether to switch between the databases with the same group identifier of the database according to the status information of each database. . When the primary server determines that the information of each database is transmitted for each database for a longer period of time than the second preset duration, the primary server sends a request for obtaining information of each database to the slave server. In this way, it is possible to prevent the main server from obtaining the information of the historical database due to the link interruption between the primary server and the slave server.

In the embodiment of the present invention, the main server receives the information of each database in each of the at least two groups of data streams sent by the slave server, and the transmission time is less than the second preset duration, the main server The decision process in the Infdecision status information of each database determines whether the database with the same group identifier of the database is switched. In an embodiment of the present invention, an optional implementation manner is provided: 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 status information is obtained. A database that changes the state of the database to a normal state for the database of the abnormal state. In the embodiment of the present invention, independent monitoring and switching of multiple groups of databases is realized through 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 other normal state database of the group.

In the embodiment of the present invention, the main server determines whether there is a database in which the database state information is abnormal in the same database with the group identifier of the database, and if so, whether the database exists in the database with the same group identifier. The status information is a normal status database. If it exists, the database whose status information is abnormal is switched to the data whose status information is normal. If there is no abnormal database in the database with the same group identifier in the database, it will not be processed; if the database has the same database in the database with the same identifier, it 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. Thus, 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 main server. Suppose the main server receives the database information of the 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 database The identifiers are 1A and 1B respectively, 1A indicates the primary database, 1B indicates the standby database, the status information of the primary database 1A is normal, and the status information of the standby database 1B is abnormal; then the standby database 1B is switched to The main database 1A; group 2 includes two databases, the database identification is 2A and 2B, 2A indicates the main database, 2B indicates the standby database, the status information of the main database 2A is abnormal, and the standby database 2B The status is abnormal; no switching is performed. Even if the database in the normal state of the group 1 does not perform the switching operation, the database switching will not be carried out, so that the high-availability independent monitoring and switching of the multiple groups of databases can be ensured.

FIG. 3 is a schematic structural diagram of a slave server that is switched by a database 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. The obtaining unit is configured to obtain status information of each database in each group of at least two groups of databases; wherein each group includes a primary database and at least one standby database, each database Corresponding 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 a sending unit is configured to send each to the main server The information of the database, the information of each database is used to enable the main server to determine whether the database with the same group identifier of the database is switched according to the status information of each database; wherein the information of each database includes The identity of the database, the group ID of the database, and the status 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 at least one group of the database corresponds to the at least one service type, respectively, and the service type corresponding to the transaction frequency is greater than the frequency threshold, and/or the service type whose transaction quantity is greater than the quantity threshold. Corresponding to a set of databases.

Optionally, the method further includes: a detecting unit, configured to: periodically detect status information of each of the at least two groups of the data banks; and further include an updating unit, configured to: according to each database The status information updates the history status information of the database; the obtaining unit is configured to: obtain status information of each updated database, and update the status information of each database with the new one according to each data. The status information of the library is obtained by updating the historical status information of the 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 detecting at least two groups after the first preset duration Status information of each database of the database; if the slave server determines that the total duration of the last update operation is greater than the first preset duration, then detecting each of the at least two groups of databases from the end of the last update operation Status information for the database.

It can be seen from the above that, in the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group includes a main database and At least one standby database, each group corresponding to any one or more of the four functional types; the four functional types include adding functions, deleting functions, changing functions, and query functions; status information includes normal status and abnormal status; The function type of the library is divided into at least two database groups, forming at least two groups of databases independent of each other, and the data between each group is independent of each other; each of the at least two groups of databases The information of the 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 identification can be switched, which can be simple The configuration enables independent monitoring and switching between the database groups, which in turn contributes to 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. The receiving unit is configured to receive information of each database in each of the at least two groups of data streams sent by the slave server; the information of each database includes the identifier of the database, the group identifier of the database, and The status information of the database; the decision unit is configured to determine whether to switch between the databases with the same group identifier of the database according to the status information of each database.

Optionally, the determining unit is configured to: when there is at least one database in which the database state information is in a normal state in the same database in which the group identifier of the determined database is located, the database in which the database state information is in an abnormal state is switched. A database with a normal state of the database.

Optionally, the determining unit is configured to: when determining that the duration of transmitting the information of each database is not greater than the second preset duration, the determining unit determines, according to the state information of each database, that the group identifier of the database is the same Whether to switch between the data bases; when the decision unit determines that the time for transmitting the information of each database is greater than the second preset duration, the decision unit sends a request for obtaining the information of each database to the slave server.

It can be seen from the above that, in the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group includes a main database and At least one standby database, each group corresponding to any one or more of the four functional types; the four functional types include adding functions, deleting functions, changing functions, and query functions; status information includes normal status and abnormal status; The function type of the library is divided into at least two database groups, forming at least two groups of databases independent of each other, and the data between each group is independent of each other; each of the at least two groups of databases The information of the 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 identification can be switched, which can be simple The configuration enables independent monitoring and switching between the database groups, which in turn contributes to the high availability of the system.

Based on the same concept, the present invention provides an electronic device that can be used to execute the method flow of the slave server side described above. FIG. 5 is a schematic structural diagram of an electronic device according to the present invention. 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 each other through a bus bar 505.

The memory 502 is used to store a program; specifically, the program may include a code, and the code includes a computer operation instruction. 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, a hard disk drive (HDD) or a 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 their extended set: operational instructions: including various operational instructions for implementing various operations.

Operating System: Includes a variety of system programs for implementing a variety of 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. Busbars can be divided into address busbars, data busbars, and control busbars. For ease of representation, only one thick line is shown in Figure 5, but it does not mean that there is only one bus bar or one type of bus bar.

The bus interface 504 can be a wired communication access port, a wireless bus interface, or a combination thereof. The wired bus interface can be, for example, an Ethernet interface. The Ethernet interface can be an optical interface, a dielectric 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 hard wafer. The above 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 thereof.

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 the database includes a primary database and at least one standby database, each of which 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 state and an 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 an operation; the transceiver 503 is configured at the processor 501 Controlling, sending, to the main server, the information of each database, the information of each database is used to enable the main server to determine the database with the same group identifier of the database according to the status information of each database Whether to switch; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database.

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

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

Optionally, the processor is configured to: periodically detect status information of each database in each of the at least two groups of databases; and record the history of the database according to status information of each database The status information is updated; the status information of each database after the update is obtained, and the status information of each new database is the historical status of the database according to the status information of each database. Information obtained by 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 detecting after the first preset duration Status 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, then detecting each of the at least two groups of databases from the end of the last update operation Status information for each database.

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 invention, 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, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group of data The library includes a main database and at least one standby database, each of which corresponds to any one or more of four functional types; the four functional types include an add function, a delete function, a change function, and a query function; The 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 in each group 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 same group identifier The data can be switched, and the independent monitoring and switching between the database groups can be realized through simple configuration, which helps the system. High availability.

Based on the same concept, the present invention provides another electronic device that can be used to perform the method flow of the above-described main server side. FIG. 6 is a schematic structural diagram of another electronic device according to the present invention. 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 each other through a bus bar 605.

The memory 602 is used to store a program; specifically, the program may include a program code, and the code includes a computer operation instruction. 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, a hard disk drive (HDD) or a solid-state drive (SSD); the memory 602 may also include a combination of the above types of memory.

The memory 602 stores the following elements, executable modules or data structures, or a subset thereof, or their extended set: operational instructions: including various operational instructions for implementing various operations.

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

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

The bus interface 604 can be a wired communication access port, a wireless bus interface, or a combination thereof. The wired bus interface can be, for example, an Ethernet interface. The Ethernet interface can be an optical interface, a dielectric 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 hard wafer. The above 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 thereof.

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 For storing one or more executable programs, may store data used by the processor 601 when performing operations; the transceiver 603 is configured to receive at least two sent by the slave server under the control of the processor 601. The information of each database in each group of the database in the group database; the information of each database includes the identifier of the database, the group identifier 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 the database having the same group identifier of the database, the database state information is in an abnormal state. The database switches the database whose status is normal.

Optionally, the processor 601 is configured to determine, according to the status information of each database, that the group identifier of the database is the same when determining that the duration of the information for transmitting each database is not greater than the second preset duration Whether to switch between the databases; when determining that the time for transmitting the information of each database is greater than the second preset duration, a request for obtaining 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 invention, 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 at the time of shipment of the electronic device 600, and can also store a code or the like for execution of the processor 601.

It can be seen from the foregoing that, in the embodiment of the present invention, in the embodiment of the present invention, the slave server obtains state information of each database in each group of at least two groups of databases; wherein each group of data The library includes a main database and at least one standby database, each of which corresponds to any one or more of four functional types; the four functional types include an add function, a delete function, a change function, and a query function; The 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 in each group 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 same group identifier The data can be switched, and the independent monitoring and switching between the database groups can be realized through simple configuration, which 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 take the form of a complete hardware embodiment, a full software embodiment, or an embodiment combining soft and hardware aspects. Moreover, embodiments of the present invention may employ computer program products implemented on one or more computer usable storage media (including but not limited to disk memory, CD-ROM, optical memory, etc.) including computer usable code. form.

Embodiments of the invention are described with reference to flowchart illustrations and/or block diagrams of a method, a device (system), and a computer program product according to an embodiment 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, a special purpose computer, an embedded processor or other programmable data processing device to produce a machine for executing instructions by a processor of a computer or other programmable data processing device Means are provided for implementing the functions specified in one or more of the flow or in one or more blocks of the flow chart.

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

These computer program instructions can also be loaded onto a computer or other programmable data processing device to perform a series of operational steps on a computer or other programmable device to produce computer-implemented processing on a computer or other programmable device. The instructions executed above provide steps for implementing the functions specified in one or more blocks of the flowchart or in a block or blocks of the flowchart.

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

Claims (12)

A method for switching a database, comprising: obtaining, by a slave server, status information of each database in each group of at least two groups of databases; wherein each group of databases includes a main database and At least one standby database, each of which corresponds to any one or more of 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 state and an abnormal state. The slave server sends the information of each database to the primary server, and the information of each database is used to enable the primary server to determine the same group identifier of the database according to the status information of each database. Whether the switching between the libraries is performed; wherein the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database; wherein the query function corresponds to at least one group of databases; the at least one group Each group of databases in the database corresponds to at least one type of service, including: a transaction whose transaction frequency is greater than a frequency threshold Corresponds to a set type database; and / or; Number greater than a threshold number of transaction service type corresponding to a set of database. The method for switching a database according to claim 1, wherein the slave server obtains status information of each of the at least two groups of the database, and further includes: the slave server periodically Detecting status information of each database in each of the at least two groups of databases; the slave server updates the historical status information of the database according to the status information of each database; the slave servo Obtaining status information of each database in each group of at least two groups of databases, including: the slave server obtains updated status information of each database, and each new database is Status information is the information of the slave server based on the status information of each database The history status information of the library is obtained by the update operation. The method for switching a database according to claim 2, wherein the slave server periodically detects status information of each database in each of the at least two groups of databases, including: the slave server Determining 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 the status of each database of the at least two groups of databases after the first preset duration Information: 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 method for switching a database, comprising: a main server receiving information of each database in each of the at least two groups of data streams sent by the slave server; the information of each database includes a database The identifier of the database, the group identifier of the database, and the status information of the database; the primary server determines, according to the status information of each database, whether to switch between the databases with the same group identifier of the database; wherein, the primary server After receiving the information of each database sent by the slave server, the method includes: when the primary server determines that the time for transmitting the information of each database is not greater than the second preset duration, the primary server is configured according to the The status information of the database determines whether the database of the same group identifier of the database is switched; when the main server determines that the time of transmitting the information of each database is greater than the second preset duration, the main The server sends a request to the slave server to obtain information for each database. The method for switching the database according to claim 4, wherein the primary server determines, according to the status information of each database, whether to switch between the same database of the group identifier of the database, including: the primary server When it is determined that the database with the same group identifier of the database has at least one database whose status information is in a normal state, the database status information is abnormal. The database of the state switches the database whose state is normal. An electronic device, comprising: a processor, a memory, a transceiver, and a bus interface, wherein the processor, the memory and the transceiver are connected by a bus bar; the processor is configured to read the memory The program performs the following methods: for obtaining 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 group of data library 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; the transceiver is used for the transceiver Sending information of each database to the primary server, the information of each database is used to enable the primary server to determine whether the database with the same group identifier of the database is performed according to the status information of each database Switching; wherein, the information of each database includes the identifier of the database, the group identifier of the database, and the status information of the database; the memory And storing one or more executable programs, and storing data used by the processor when performing operations; wherein the query function corresponds to at least one set of databases; each set of the at least one set of databases Corresponding to at least one service type respectively, 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 of databases. The electronic device of claim 6, wherein the processor is configured to periodically detect status information of each database in each of the at least two groups of databases; according to each database The status information updates the historical status information of the database; obtains the updated status information of each database, and the status information of each new database is the status of the database according to the database. The information is obtained by updating the historical status information of the database. The electronic device of claim 7, 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, the last update is The operation starts, after the first preset duration, the state information of each database of the at least two groups of databases is detected; if it is determined that the total duration of the last update operation is greater than the first preset duration, then After the end of an update operation, the status information of each database of the at least two groups of databases is detected. 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 bar; the transceiver is configured to: Receiving information of each of the at least two groups of databases sent by the slave 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 status information of each database, whether to switch between databases with the same group identifier of the database; wherein the processor is further configured to: determine, in the database, When the duration of the information is not greater than the second preset duration, the decision unit determines, according to the status information of each database, whether to switch between the databases with the same group identifier of the database; determining each database in the transmission When the duration of the information is greater than the second preset duration, a request to obtain information of each database is sent to the slave server. The electronic device of claim 9, wherein the processor is further configured to: when it is determined that the database with the at least one database state information is in a normal state in the database having the same group identifier of the database, The database whose database status information is abnormal status switches the database whose status is normal. A non-transitory computer readable storage medium storing computer instructions for causing the computer to execute the database of any one of claims 1 to 3. A switching method, or the computer instruction for causing the computer to execute the switching method of the database according to any one of claims 4 to 5. 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 When the computer is executed by the computer, the computer is caused to perform the switching method of the database according to any one of claims 1 to 3; or the computer is caused to perform the switching method of the database according to any one of claims 4 to 5. .