Unlock instant, AI-driven research and patent intelligence for your innovation.

Shared disk based database update processing method and system

A technology of shared disk and processing method, applied in the computer field, can solve the problem of high equipment cost, and achieve the effect of reducing equipment cost, ensuring consistency, and shortening the time of data update delay

Active Publication Date: 2016-02-24
SANGFOR TECH INC
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the read-write separation requires disks for storing the mysql database to be installed on both the host and standby machines, thus resulting in higher equipment costs

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Shared disk based database update processing method and system
  • Shared disk based database update processing method and system
  • Shared disk based database update processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0041] The present invention provides a database update processing method based on a shared disk, referring to figure 1 , in one embodiment, the shared disk-based database update processing method includes:

[0042] Step S10, when the host receives the write transaction request, it reads the corresponding data page in the shared disk and stores it in the host cache;

[0043] The database update processing method based on the shared disk provided by the embodiment of the present invention is mainly applied in the database cluster solution, and is used to control the update of the database. Specifically, the above-mentioned shared disk may be in the main machine or in the standby machine. A Mysql (a relational database management system) database is stored on the shared disk, which is divided into several data pages a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a shared disk based database update processing method. The shared disk based database update processing method comprises the following steps of: when a host receives a writing transaction request, reading a corresponding data page in a shared disk, and storing the data page into a host cache; the host synchronously sending a synchronization request to a standby unit according to the writing transaction request; the standby unit reading the corresponding data page in the shared disk according to the synchronization request, and storing the data page into a standby unit cache; the standby unit performing updating on the data page in the standby unit cache according to the synchronization request, and sending a response message to the host; the host performing updating on the data page in the host cache according to the response message and the writing transaction request; and the host writing the updated data in the host cache into the shared disk. The invention furthermore discloses a shared disk based database update processing system. According to the method, the device cost is reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database update processing method and system based on a shared disk. Background technique [0002] In recent years, with the rapid development of the Internet, the scale of many large companies has increased dramatically, with more and more users, and the amount of data and visits has also increased, and the requirements for databases have also become higher and higher. There are two options for handling this type of growth: scaleup and scaleout. If you want to scale up, you need a more powerful computer, and you need to buy more processors, disk storage space, and memory. But the stronger the performance of the machine, the higher its cost, and the scale of expansion is also limited. Another option is to use a cluster of multiple minicomputers. The PCs in the cluster are relatively easy to accept because of their high cost performance and low expansion costs. [0003] At...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F9/445
Inventor 吴利斌刘少东黄茂彪
Owner SANGFOR TECH INC