CN105354046B - Database update processing method and system based on shared disk - Google Patents
Database update processing method and system based on shared disk Download PDFInfo
- Publication number
- CN105354046B CN105354046B CN201510589398.1A CN201510589398A CN105354046B CN 105354046 B CN105354046 B CN 105354046B CN 201510589398 A CN201510589398 A CN 201510589398A CN 105354046 B CN105354046 B CN 105354046B
- Authority
- CN
- China
- Prior art keywords
- host
- data page
- standby host
- shared disk
- standby
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
The database update processing method based on shared disk that the invention discloses a kind of, the database update processing method based on shared disk is the following steps are included: host receives when writing transactions requests, corresponding data page in shared disk is read, and is stored into host caches；Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；The standby host reads corresponding data page in shared disk according to the synchronization request, and is stored into standby host caching；The standby host is updated the data page in standby host caching according to the synchronization request, and sends response message to the host；The host is according to the response message and described write transactions requests and is updated to the data page in host caches；Data page updated in host caches is written into the shared disk host.The database update processing system based on shared disk that the invention also discloses a kind of.Present invention reduces equipment costs.
Description
Technical field
The present invention relates to field of computer technology, more particularly to the database update processing method based on shared disk and are
System.
Background technique
In recent years, With the fast development of internet, the scale of many big companies is all sharply increasing, and user is increasingly
More, data volume and amount of access are also increasing, and the requirement to database is also higher and higher.Handling such growth, there are two types of schemes:
Longitudinal Extension (scale up) and (scale out) extending transversely.If wanting Longitudinal Extension, just need performance stronger big
Computer will buy more processors, disk storage space and memory.But the performance of machine is stronger, cost is also higher,
And extension scale is also limited.Another scheme is: using the cluster being made of multiple minicomputers.PC in cluster due to
Its cost performance is high, and extension is at low cost, so being easier to receive.
Currently, fragment too complex, maintenance cost is too high, and application scenarios are limited in data-base cluster scheme.Mysql number
It is exactly read and write abruption according to the most widely used trunking mode in library.However, read and write abruption, needs to be respectively provided on host and standby host and be used for
Therefore the disk of storage mysql database causes equipment cost higher.
Summary of the invention
The main purpose of the present invention is to provide a kind of database update processing method and system based on shared disk, purport
Reducing equipment cost.
To achieve the above object, a kind of database update processing method based on shared disk provided by the invention include with
Lower step:
Host receives when writing transactions requests, reads corresponding data page in shared disk, and be stored into host caches；
Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；
The standby host reads corresponding data page in shared disk according to the synchronization request, and is stored into standby host caching
In；
The standby host is updated the data page in standby host caching according to the synchronization request, and sends response and disappear
It ceases to the host；
The host is according to the response message and described write transactions requests and is updated to the data page in host caches；
Data page updated in host caches is written into the shared disk host.
Preferably, the host writes synchronous synchronization request to the standby host that sends of transactions requests according to and includes:
It is corresponding with modification data content to the data content modified in data page that statistics host writes transactions requests according to
Capable major key, to form write-in set；
Synchronization request, which is generated, according to said write set is sent to standby host.
Preferably, the standby host is updated the data page in standby host caching according to the synchronization request, concurrently
Response message to the host is sent to include:
The standby host carries out authentication test to the major key in said write set according to the synchronization request, described in judgement
Whether write-in set can be written in the standby host caching；
If so, said write set is written in standby host caching by the standby host, to update the number in the standby host caching
According to page；And generate certification success response message and be sent to host, to trigger the host according to the response message and described write
Transactions requests are updated the data page in host caches；
If it is not, then the standby host generation authentification failure message is sent to host.
Preferably, the database update processing method based on shared disk further include:
When the standby host carries out data page discarding in standby host caching, the data page currently abandoned and the shared disk are judged
Whether corresponding data page is consistent；If consistent, the data page currently abandoned is subjected to discard processing；If inconsistent, will work as
The data page of preceding discarding saves.
Preferably, the database update processing method based on shared disk further include:
The standby host receives the read transaction request that preset proxy server is sent；
The standby host requests data page corresponding in caching being sent to proxy server according to the read transaction, for generation
Reason server, which exports the data page to client, to be shown.
In addition, to achieve the above object, the database update processing system based on shared disk that the present invention also provides a kind of
Including host and standby host, in which:
When the host writes transactions requests for receiving, corresponding data page in shared disk is read, and be stored into master
In machine caching；According to the synchronous synchronization request that sends of transactions requests of writing to standby host；
The standby host is used for, and reads corresponding data page in shared disk according to the synchronization request, and be stored into standby host
In caching；The data page in standby host caching is updated according to the synchronization request, and sends response message to described
Host；
The host is also used to, according to the response message and it is described write transactions requests to the data page in host caches into
Row updates；Data page updated in host caches is written into the shared disk.
Preferably, the host is specifically used for: statistics host writes transactions requests to the number modified in data page according to
The major key of row is corresponded to, with modification data content according to content to form write-in set；Synchronization request is generated according to said write set
It is sent to standby host.
Preferably, the standby host is specifically used for, and is recognized according to the synchronization request the major key in said write set
Card test, to judge whether said write set can be written in the standby host caching；If so, the standby host is by said write collection
Conjunction is written in standby host caching, to update the data page in the standby host caching；And it generates certification success response message and is sent to
Host, with trigger the host according to the response message and it is described write transactions requests in host caches data page carry out more
Newly；If it is not, the standby host, which generates authentification failure message, is sent to host.
Preferably, the database update processing system based on shared disk further include:
The standby host is also used to, when carrying out that data page abandons in standby host caching, judge the data page that currently abandons with it is described
Whether the corresponding data page of shared disk is consistent；If consistent, the data page currently abandoned is subjected to discard processing；If different
It causes, then saves the data page currently abandoned.
Preferably, the standby host is also used to, and receives the read transaction request that preset proxy server is sent；According to the reading
Data page corresponding in caching is sent to proxy server by transactions requests, for proxy server by the data page export to
Client is shown.
The embodiment of the present invention reads corresponding data page in shared disk by when host receives and writes transactions requests,
And it is stored into host caches；Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；The standby host according to
The synchronization request reads corresponding data page in shared disk, and is stored into standby host caching；The standby host is according to described same
Step request is updated the data page in standby host caching, and sends response message to the host；The host according to
The response message and the transactions requests of writing are updated the data page in host caches；The host will be in host caches
Updated data page is written into the shared disk.Due to being stored only with a shared disk to database, because
This reduces equipment cost.Additionally due to synchronization request is being sent to standby host by host, and in the respective response for receiving standby host
After operation, just the data page in host caches is updated, to ensure that the data page of host caches and standby host cached
The consistency of data page content shortens the time that the data between host and standby host update delay.
Detailed description of the invention
Fig. 1 is that the present invention is based on the flow diagrams of one embodiment of database update processing method of shared disk；
Fig. 2 is that the present invention is based on the thin of synchronization request is sent in one embodiment of database update processing method of shared disk
Change flow diagram；
Fig. 3 is that the present invention is based on standby host update in one embodiment of database update processing method of shared disk is data cached
The refinement flow diagram of page；
Fig. 4 is that the present invention is based on the flow diagrams of another embodiment of database update processing method of shared disk；
Fig. 5 is that the present invention is based on the system architecture diagrams of the database update processing system of shared disk.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present invention provides a kind of database update processing method based on shared disk, referring to Fig.1, in one embodiment,
The database update processing method based on shared disk includes:
Step S10, host receives when writing transactions requests, reads corresponding data page in shared disk, and be stored into master
In machine caching；
Database update processing method provided in an embodiment of the present invention based on shared disk is mainly used in data base set
In group's scheme, controlled for the update to database.Specifically, above-mentioned shared disk can be in host, can also be with
In standby host.It is stored with Mysql (Relational DBMS) database in shared disk, according to Mysql number
It is divided into several data pages according to the spatial position that data in library store.Client is installed in host, it is shared for accessing modification
Data page in disk.When user is write in transactions requests to host by the client transmission installed in host, thus by leading
Machine writes transactions requests according to this and reads corresponding data page in shared disk, and is stored into host caches.
Step S20, host write the synchronous synchronization request that sends of transactions requests to standby host according to；
Step S30, the standby host reads corresponding data page in shared disk according to the synchronization request, and is stored into standby
In machine caching；
Host will send synchronization request to standby according to transactions requests are write in reading shared disk after relevant data page
In machine.Specifically, which can directly write transactions requests forwarding operation, be also possible to basis and read shared disk
In relevant data page modify data analysis generate synchronization request, this is carried out specifically in the examples below
It is bright.After standby host receives the synchronization request, corresponding data page is read in shared disk, and is stored into standby host caching.
It is understood that the data page that above-mentioned host is read is consistent with the data page that standby host is read in the present embodiment.
Step S40, the standby host are updated the data page in standby host caching according to the synchronization request, concurrently
Send response message to the host；
Step S50, the host is according to the response message and the transactions requests of writing to the data page in host caches
It is updated；
Data page updated in host caches is written into the shared disk for step S60, the host.
In the present embodiment, after being stored with data page in the standby host caching of standby host, standby host will be according to above-mentioned synchronization request
It modifies to the data page in standby host caching；Simultaneously by returning response message to host, to tell host that can carry out data
The modification of page.Host according to the corresponding message and above-mentioned transactions requests of writing will repair the data page in host caches
Change, so that the instruction modified in host and standby host is consistent, while guaranteeing that the data page of modification is also consistent.?
After data page in the complete host caches of host modifications, by again by the data web update in caching into shared disk, to complete
Write all operations of affairs.It should be noted that can be carried out by the way of raid to data page in above-mentioned shared disk
Backup, to guarantee the reliability of data.
The embodiment of the present invention reads corresponding data page in shared disk by when host receives and writes transactions requests,
And it is stored into host caches；Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；The standby host according to
The synchronization request reads corresponding data page in shared disk, and is stored into standby host caching；The standby host is according to described same
Step request is updated the data page in standby host caching, and sends response message to the host；The host according to
The response message and the transactions requests of writing are updated the data page in host caches；The host will be in host caches
Updated data page is written into the shared disk.Since synchronization request is being sent to standby host by host, and receiving
After the respective response operation of standby host, just the data page in host caches is updated, to ensure that the data of host caches
The consistency of page and the data page content of standby host caching shortens the time that the data between host and standby host update delay.
Further, referring to Fig. 2, based on the above embodiment, in the present embodiment, above-mentioned steps S20 includes:
Step S21, statistics host write transactions requests to the data content and modification data modified in data page according to
Content corresponds to the major key of row, to form write-in set；
Step S22 generates synchronization request according to said write set and is sent to standby host.
In the present embodiment, host will count all numbers for needing to modify data page in host caches according to transactions requests are write
According to the major key of content and all data contents of the modification data line where corresponding, to form write-in set.Above-mentioned synchronization request
Including write-in set and synchronic command, which is sent to standby host, to notify standby host according to write-in set to standby host
Data page in caching is updated.
Further, referring to Fig. 3, based on the above embodiment, in the present embodiment, above-mentioned steps S40 includes:
Step S41, the standby host carry out authentication test to the major key in said write set according to the synchronization request, with
Judge whether said write set can be written in the standby host caching；If so, thening follow the steps S42；If it is not, thening follow the steps
S43；
Said write set is written in standby host caching by step S42, the standby host, to update in the standby host caching
Data page；And generate certification success response message and be sent to host, to trigger the host according to the response message and described
Transactions requests are write to be updated the data page in host caches；
Step S43, the standby host generate authentification failure message and are sent to host.
In the present embodiment, above-mentioned authentication test is to judge whether above-mentioned write-in set can be by standby host application.Specifically, may be used
To judge whether the major key in above-mentioned write-in set can find in the data page that standby host caches, that is, determine the number of host caches
It is whether consistent before being updated according to the data page of page and standby host caching.When certification passes through, then standby host authenticates transmission successfully
Corresponding message modify update processing to host, while according to above-mentioned write-in set to the data page in standby host caching.When
When certification does not pass through, then directly feedback authentification failure message is to host, and host will not execute above-mentioned transactions requests of writing and correspond at this time
Update operation, and feed back corresponding prompt information to user interface, to inform the current disposition of user.
Further, referring to Fig. 4, based on the above embodiment, in the present embodiment, the above-mentioned database based on shared disk
Update processing method further include:
When step S70, the standby host carry out that data page abandons in standby host caching, judge the data page currently abandoned with it is described
Whether the corresponding data page of shared disk is consistent；If consistent, S80 is thened follow the steps, if it is not, thening follow the steps S90；
The data page currently abandoned is carried out discard processing by step S80；
Step S90 saves the data page currently abandoned.
Specifically, there is checksum to be identified on data page, judge standby host caching in data page whether together
The data page enjoyed in disk is consistent, can be compared to the checksum on data page.When different, then it is assumed that host
Upper corresponding host caches data page does not flush on disk, and standby host cannot lose corresponding background caching page at this time
It abandons, can choose other data pages and abandoned.Discarding operation can occur when standby host caches and is greater than preset value.This implementation
Example in, due to standby host carry out data page abandon operation when, it is first determined whether with data page corresponding in shared disk whether
Unanimously, thereby may be ensured that host collapse in the case where, can be used standby host as host, by standby host cache in update
Data page re-write in shared disk.
It should be noted that in the embodiment of the present invention, in order to reduce the operating pressure of host, for the reading of client transmission
Transactions requests can carry out read operation by standby host.Specifically, in the present embodiment, the above-mentioned database based on shared disk is more
New processing method further include:
The standby host receives the read transaction request that preset proxy server is sent；
The standby host requests data page corresponding in caching being sent to proxy server according to the read transaction, for generation
Reason server, which exports the data page to client, to be shown.
In the present embodiment, user can input read transaction request by above-mentioned client, in query display shared disk
Data page.Specifically, read transaction request is sent to proxy server by client, and proxy server will be asked according to the affairs
The type asked determines the object sent, such as read transaction request is sent to standby host, will write transactions requests and is sent to host.Standby
After machine receives read transaction request, it will corresponding data page in caching is sent to proxy server, and by agency service
The data page received is forwarded to client by device, to carry out data presentation on the client.It is understood that when standby host exists
When not inquiring corresponding data page in caching, standby host can actively read corresponding data page in shared disk, will finally read
The data page got is sent to proxy server, and the data page received is forwarded to client by proxy server, with
Data presentation is carried out in client.
The database update processing system based on shared disk that the present invention also provides a kind of, referring to Fig. 6, in an embodiment
In, the database update processing system provided by the invention based on shared disk includes host and standby host, in which:
When the host writes transactions requests for receiving, corresponding data page in shared disk is read, and be stored into master
In machine caching；According to the synchronous synchronization request that sends of transactions requests of writing to standby host；
The standby host is used for, and reads corresponding data page in shared disk according to the synchronization request, and be stored into standby host
In caching；The data page in standby host caching is updated according to the synchronization request, and sends response message to described
Host；
The host is also used to, according to the response message and it is described write transactions requests to the data page in host caches into
Row updates；Data page updated in host caches is written into the shared disk.
Database update processing system provided in an embodiment of the present invention based on shared disk is mainly used in data base set
In group's scheme, controlled for the update to database.Specifically, above-mentioned shared disk can be in host, can also be with
In standby host.It is stored with Mysql (Relational DBMS) database in shared disk, according to Mysql number
It is divided into several data pages according to the spatial position that data in library store.Client is installed in host, it is shared for accessing modification
Data page in disk.When user is write in transactions requests to host by the client transmission installed in host, thus by leading
Machine writes transactions requests according to this and reads corresponding data page in shared disk, and is stored into host caches.
Host will send synchronization request to standby according to transactions requests are write in reading shared disk after relevant data page
In machine.Specifically, which can directly write transactions requests forwarding operation, be also possible to basis and read shared disk
In relevant data page modify data analysis generate synchronization request, this is carried out specifically in the examples below
It is bright.After standby host receives the synchronization request, corresponding data page is read in shared disk, and is stored into standby host caching.
It is understood that the data page that above-mentioned host is read is consistent with the data page that standby host is read in the present embodiment.
In the present embodiment, after being stored with data page in the standby host caching of standby host, standby host will be according to above-mentioned synchronization request
It modifies to the data page in standby host caching；Simultaneously by returning response message to host, to tell host that can carry out data
The modification of page.Host according to the corresponding message and above-mentioned transactions requests of writing will repair the data page in host caches
Change, so that the instruction modified in host and standby host is consistent, while guaranteeing that the data page of modification is also consistent.?
After data page in the complete host caches of host modifications, by again by the data web update in caching into shared disk, to complete
Write all operations of affairs.It should be noted that can be carried out by the way of raid to data page in above-mentioned shared disk
Backup, to guarantee the reliability of data.
The embodiment of the present invention reads corresponding data page in shared disk by when host receives and writes transactions requests,
And it is stored into host caches；Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；The standby host according to
The synchronization request reads corresponding data page in shared disk, and is stored into standby host caching；The standby host is according to described same
Step request is updated the data page in standby host caching, and sends response message to the host；The host according to
The response message and the transactions requests of writing are updated the data page in host caches；The host will be in host caches
Updated data page is written into the shared disk.Since synchronization request is being sent to standby host by host, and receiving
After the respective response operation of standby host, just the data page in host caches is updated, to ensure that the data of host caches
The consistency of page and the data page content of standby host caching shortens the time that the data between host and standby host update delay.
Further, based on the above embodiment, in the present embodiment, above-mentioned host is specifically used for: statistics host is according to institute
It states and writes the major key that transactions requests correspond to row to the data content modified in data page with modification data content, to form write-in collection
It closes；Synchronization request, which is generated, according to said write set is sent to standby host.
In the present embodiment, host will count all numbers for needing to modify data page in host caches according to transactions requests are write
According to the major key of content and all data contents of the modification data line where corresponding, to form write-in set.Above-mentioned synchronization request
Including write-in set and synchronic command, which is sent to standby host, to notify standby host according to write-in set to standby host
Data page in caching is updated.
Further, based on the above embodiment, in the present embodiment, above-mentioned standby host is specifically used for, and is asked according to the synchronization
It asks and authentication test is carried out to the major key in said write set, to judge it is slow whether said write set can be written to the standby host
In depositing；If so, said write set is written in standby host caching by the standby host, to update the data in the standby host caching
Page；And generate certification success response message and be sent to host, to trigger the host according to the response message and described write thing
Business request is updated the data page in host caches；If it is not, the standby host, which generates authentification failure message, is sent to host.
In the present embodiment, above-mentioned authentication test is to judge whether above-mentioned write-in set can be by standby host application.Specifically, may be used
To judge whether the major key in above-mentioned write-in set can find in the data page that standby host caches, that is, determine the number of host caches
It is whether consistent before being updated according to the data page of page and standby host caching.When certification passes through, then standby host authenticates transmission successfully
Corresponding message modify update processing to host, while according to above-mentioned write-in set to the data page in standby host caching.When
When certification does not pass through, then directly feedback authentification failure message is to host, and host will not execute above-mentioned transactions requests of writing and correspond at this time
Update operation, and feed back corresponding prompt information to user interface, to inform the current disposition of user.
Further, based on the above embodiment, in the present embodiment, the above-mentioned database update processing based on shared disk
System further include:
The standby host is also used to, when carrying out that data page abandons in standby host caching, judge the data page that currently abandons with it is described
Whether the corresponding data page of shared disk is consistent；If consistent, the data page currently abandoned is subjected to discard processing；If different
It causes, then saves the data page currently abandoned.
Specifically, there is checksum to be identified on data page, judge standby host caching in data page whether together
The data page enjoyed in disk is consistent, can be compared to the checksum on data page.When different, then it is assumed that host
Upper corresponding host caches data page does not flush on disk, and standby host cannot lose corresponding background caching page at this time
It abandons, can choose other data pages and abandoned.Discarding operation can occur when standby host caches and is greater than preset value.This implementation
Example in, due to standby host carry out data page abandon operation when, it is first determined whether with data page corresponding in shared disk whether
Unanimously, thereby may be ensured that host collapse in the case where, can be used standby host as host, by standby host cache in update
Data page re-write in shared disk.
It should be noted that in the embodiment of the present invention, in order to reduce the operating pressure of host, for the reading of client transmission
Transactions requests can carry out read operation by standby host.Specifically, above-mentioned standby host is also used to, and is received preset proxy server and is sent
Read transaction request；It is requested data page corresponding in caching being sent to proxy server according to the read transaction, for agency
The data page is exported to client and is shown by server.
In the present embodiment, user can input read transaction request by above-mentioned client, in query display shared disk
Data page.Specifically, read transaction request is sent to proxy server by client, and proxy server will be asked according to the affairs
The type asked determines the object sent, such as read transaction request is sent to standby host, will write transactions requests and is sent to host.Standby
After machine receives read transaction request, it will corresponding data page in caching is sent to proxy server, and by agency service
The data page received is forwarded to client by device, to carry out data presentation on the client.It is understood that when standby host exists
When not inquiring corresponding data page in caching, standby host can actively read corresponding data page in shared disk, will finally read
The data page got is sent to proxy server, and the data page received is forwarded to client by proxy server, with
Data presentation is carried out in client.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content, is directly or indirectly transported
Used in other related technical areas, it is included within the scope of the present invention.
Claims (10)
1. a kind of database update processing method based on shared disk, which is characterized in that the data based on shared disk
Library update processing method the following steps are included:
Host receives when writing transactions requests, reads corresponding data page in shared disk, and be stored into host caches；
Host writes the synchronous synchronization request that sends of transactions requests to standby host according to；
The standby host reads corresponding data page in shared disk according to the synchronization request, and is stored into standby host caching；
The standby host is updated the data page in standby host caching according to the synchronization request, and sends response message extremely
The host；
The host is according to the response message and described write transactions requests and is updated to the data page in host caches；
Data page updated in host caches is written into the shared disk host.
2. the database update processing method based on shared disk as described in claim 1, which is characterized in that the host root
Include: according to synchronous synchronization request to the standby host that sends of transactions requests of writing
Statistics host writes transactions requests according to and corresponds to row with modification data content to the data content modified in data page
Major key, to form write-in set；
Synchronization request, which is generated, according to said write set is sent to standby host.
3. the database update processing method based on shared disk as claimed in claim 2, which is characterized in that the standby host root
The data page in standby host caching is updated according to the synchronization request, and sends response message to the host and includes:
The standby host carries out authentication test to the major key in said write set according to the synchronization request, to judge said write
Whether set can be written in the standby host caching；
If so, said write set is written in standby host caching by the standby host, to update the data page in the standby host caching；
And generate certification success response message and be sent to host, it is asked with triggering the host according to the response message and the affairs of writing
It asks and the data page in host caches is updated；
If it is not, then the standby host generation authentification failure message is sent to host.
4. the database update processing method as described in any one of claims 1 to 3 based on shared disk, which is characterized in that
The database update processing method based on shared disk further include:
When the standby host carries out data page discarding in standby host caching, judge that the data page currently abandoned is corresponding with the shared disk
Data page it is whether consistent；If consistent, the data page currently abandoned is subjected to discard processing；If inconsistent, will currently lose
The data page of abandoning saves.
5. the database update processing method based on shared disk as described in claim 1, which is characterized in that described based on altogether
Enjoy the database update processing method of disk further include:
The standby host receives the read transaction request that preset proxy server is sent；
The standby host requests data page corresponding in caching being sent to proxy server according to the read transaction, for agency's clothes
Business device, which exports the data page to client, to be shown.
6. a kind of database update processing system based on shared disk, which is characterized in that the data based on shared disk
It includes host and standby host that library, which updates processing system, in which:
When the host writes transactions requests for receiving, corresponding data page in shared disk is read, and it is slow to be stored into host
In depositing；According to the synchronous synchronization request that sends of transactions requests of writing to standby host；
The standby host is used for, and reads corresponding data page in shared disk according to the synchronization request, and is stored into standby host caching
In；The data page in standby host caching is updated according to the synchronization request, and sends response message to the host；
The host is also used to, according to the response message and it is described write transactions requests in host caches data page carry out more
Newly；Data page updated in host caches is written into the shared disk.
7. the database update processing system based on shared disk as claimed in claim 6, which is characterized in that the host tool
Body is used for: statistics host writes transactions requests according to and corresponds to row with modification data content to the data content modified in data page
Major key, with formed write-in set；Synchronization request, which is generated, according to said write set is sent to standby host.
8. the database update processing system based on shared disk as claimed in claim 7, which is characterized in that the standby host tool
Body is used for, and authentication test is carried out to the major key in said write set according to the synchronization request, to judge said write set
Whether can be written in the standby host caching；If so, said write set is written in standby host caching by the standby host, to update
Data page in the standby host caching；And generate certification success response message and be sent to host, to trigger the host according to institute
It states response message and the transactions requests of writing is updated the data page in host caches；If it is not, the standby host generates certification
Failed message is sent to host.
9. such as the described in any item database update processing systems based on shared disk of claim 6 to 8, which is characterized in that
The database update processing system based on shared disk further include:
The standby host is also used to, and when carrying out data page discarding in standby host caching, judges that the data page currently abandoned is shared with described
Whether the corresponding data page of disk is consistent；If consistent, the data page currently abandoned is subjected to discard processing；If inconsistent,
The data page currently abandoned is saved.
10. the database update processing system based on shared disk as claimed in claim 6, which is characterized in that the standby host
It is also used to, receives the read transaction request that preset proxy server is sent；It will be corresponding in caching according to read transaction request
Data page is sent to proxy server, shows so that proxy server exports the data page to client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510589398.1A CN105354046B (en) | 2015-09-15 | 2015-09-15 | Database update processing method and system based on shared disk |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510589398.1A CN105354046B (en) | 2015-09-15 | 2015-09-15 | Database update processing method and system based on shared disk |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105354046A CN105354046A (en) | 2016-02-24 |
| CN105354046B true CN105354046B (en) | 2019-03-26 |
Family
ID=55330021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510589398.1A Active CN105354046B (en) | 2015-09-15 | 2015-09-15 | Database update processing method and system based on shared disk |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354046B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108363641B (en) * | 2017-01-26 | 2022-01-14 | 华为技术有限公司 | Main and standby machine data transmission method, control node and database system |
| CN110018782B (en) * | 2018-01-09 | 2022-06-17 | 阿里巴巴集团控股有限公司 | Data reading/writing method and related device |
| CN110196788B (en) * | 2018-03-30 | 2022-05-20 | 腾讯科技（深圳）有限公司 | Data reading method, device and system and storage medium |
| CN110597904B (en) * | 2018-05-25 | 2023-11-24 | 海能达通信股份有限公司 | Data synchronization method, standby machine and host machine |
| CN109062931B (en) * | 2018-06-12 | 2021-08-03 | 创新先进技术有限公司 | Cache synchronization control method, device, system, server and readable storage medium |
| CN110688357B (en) * | 2018-06-20 | 2021-08-20 | 华为技术有限公司 | Method and device for reading log type data |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103365987A (en) * | 2013-07-05 | 2013-10-23 | 北京人大金仓信息技术股份有限公司 | Clustered database system and data processing method based on shared-disk framework |
| CN104219085A (en) * | 2014-08-07 | 2014-12-17 | 深圳市同洲电子股份有限公司 | Proxy server and data processing method and system of database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| ES2723781T3 (en) * | 2011-08-03 | 2019-09-02 | Amadeus Sas | Method and system to maintain strong consistency of replicated content distributed on a client / server system |
-
2015
- 2015-09-15 CN CN201510589398.1A patent/CN105354046B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103365987A (en) * | 2013-07-05 | 2013-10-23 | 北京人大金仓信息技术股份有限公司 | Clustered database system and data processing method based on shared-disk framework |
| CN104219085A (en) * | 2014-08-07 | 2014-12-17 | 深圳市同洲电子股份有限公司 | Proxy server and data processing method and system of database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105354046A (en) | 2016-02-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105354046B (en) | Database update processing method and system based on shared disk | |
| US11360863B2 (en) | Key-value store on persistent memory | |
| US8548945B2 (en) | Database caching utilizing asynchronous log-based replication | |
| US10936578B2 (en) | Client-driven commit of distributed write transactions in a database environment | |
| US8799213B2 (en) | Combining capture and apply in a distributed information sharing system | |
| US8429134B2 (en) | Distributed database recovery | |
| US9442858B2 (en) | Solid state drives as a persistent cache for database systems | |
| US20060167895A1 (en) | Database system and method for adapting a main database components in a main memory thereof | |
| CN105183839A (en) | Hadoop-based storage optimizing method for small file hierachical indexing | |
| CN112035528B (en) | Data query method and device | |
| CN104765661B (en) | The multinode hot spare method of Metadata Service node in a kind of cloud storage service | |
| US20100169289A1 (en) | Two Phase Commit With Grid Elements | |
| US20130103708A1 (en) | Apparatus and method for enabling clients to participate in data storage in distributed file system | |
| CN105701219A (en) | Distributed cache implementation method | |
| US20170124191A1 (en) | Techniques for visualizing storage cluster system configurations and api therefore | |
| CN110147345A (en) | A kind of key assignments storage system and its working method based on RDMA | |
| WO2022048358A1 (en) | Data processing method and device, and storage medium | |
| CN113377868A (en) | Offline storage system based on distributed KV database | |
| CN111414392A (en) | Cache asynchronous refresh method, system and computer readable storage medium | |
| CN107888687B (en) | Proxy client storage acceleration method and system based on distributed storage system | |
| US20160034191A1 (en) | Grid oriented distributed parallel computing platform | |
| CN104484136B (en) | A kind of method of sustainable high concurrent internal storage data | |
| CN103077099A (en) | Block-level snapshot system and user reading and writing method based on same | |
| CN112764662B (en) | Method, apparatus and computer program product for storage management | |
| US20200387412A1 (en) | Method To Manage Database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 518000 the first floor of A1 building, Nanshan Zhiyuan 1001, Nanshan District Xue Yuan Avenue, Shenzhen, Guangdong. Applicant after: SINFOR Polytron Technologies Inc Address before: 518052 the first floor of A1 building, Nanshan Zhiyuan 1001, Nanshan District Xue Yuan Avenue, Shenzhen, Guangdong. Applicant before: Shenxinfu Electronics Science and Technology Co., Ltd., Shenzhen |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |