Database switching method and device

Abstract

The invention discloses a database switching method and a database switching device, wherein the method comprises the following concrete steps that a database instance of associated container storage service is adopted, and the database instance in an associated container is marked to be available during storage; when a call request from a business layer is received, connection between a master database and the business layer is established; the database instance with an available mark is selected from the associated container; connection between a corresponding database of the selected database instance and the business layer is established; and when abnormal connecting times of the database and the business layer is captured to be greater than a first threshold, the available mark of the corresponding database instance in the associated container is changed to be unavailable. According to the database switching method and the database switching device, the processing and concurrent efficiency of a database system can be increased, and system overhead and waste of resources can be reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database switching method and device. Background technique [0002] Some data backup technologies provided by the database itself usually mean that the database itself provides a management, monitoring and automatic operation architecture, which is suitable for creating and maintaining one or more backup databases. Generally, at the physical level and logical level, the data consistency of the production and backup databases is maintained by transferring and running database log files. Once the primary database is unavailable due to certain circumstances, the backup database will be switched to the new primary database to achieve the purpose of no database loss or minimize data loss. [0003] The process of an existing database system switching method may specifically include: [0004] Step 1. The agents of the master machine and the standby machine perform the same databas...

AI Technical Summary

Problems solved by technology

[0009] 1. The database operation package is sent to the primary and standby machine agents to complete data replication by broadcasting, which increases the system distribution load and prolongs the system processing process, which is likely to cause waste of system overhead and affect the concurrent efficiency of the system;

[0010] 2. Using the message confirmation mechanism to switch between the active and standby database systems will easily cause message congestion and queuing within a certain time period. During the peak request period, a large number of requests will be waiting, which reduces the processing efficiency of the system;

[0011] 3. The main and standby machines each have their own agents, which have similar functions, which may easily cause system redundancy and waste of resources

Images