Service providing method for database and database system

Abstract

The embodiment of the invention relates to a service providing method of a data base, and a database system. The service providing method includes: when a master database server receives a service providing request of a client, the master database server changes data in a database according to the service providing request, writes change information of the database into a first transaction log, and sends the first transaction log to a slave database server; and when a network connection between the master database server and the slave database server is disconnected or time-out, or when the number of accumulated transaction logs which are not sent successively exceeds a preset number value in the master database server, or when the sending time of the first transaction log exceeds the preset time, the master database server transmits the first transaction log or information of an update object corresponding to the first transaction log to a buffer zone. In the embodiment of the invention, when a backup database cannot receive logs temporarily, the master database sends the logs to the buffer zone, and then the logs will not be lost.

Description

technical field [0001] This application relates to the field of computers, in particular to a database service providing method and system. Background technique [0002] Currently, database systems generally adopt a master-slave architecture of one master and one slave to provide high-availability services. Under normal circumstances, external services are provided by the main database server. If the process of the external service performs a change to the data, it will be written to the transaction log before writing the change to the database storage. Each log records the modification of a data record, which contains the primary key of the data record and the specific information of the update operation. The log generated by the master database server is continuously sent to the slave database server through the network connection. After the log is received from the database server, it is played back to synchronize its data with the main database server. For ease of de...

AI Technical Summary

Problems solved by technology

[0004] As can be seen from the above, in the prior art database service provision method, in the one-master-slave architecture, there will often occur between the master and the backup due to network instability (such as loss of data packets), network bottlenecks, or the performance of the backup library reaching performance. Bottlenecks (such as peak CPU utilization) that prevent logs from being sent to the standby database in time may lead to log loss

Images