CN103793538A - System and method for realizing restoration of web service in case of crash of database - Google Patents
System and method for realizing restoration of web service in case of crash of database Download PDFInfo
- Publication number
- CN103793538A CN103793538A CN201410079937.2A CN201410079937A CN103793538A CN 103793538 A CN103793538 A CN 103793538A CN 201410079937 A CN201410079937 A CN 201410079937A CN 103793538 A CN103793538 A CN 103793538A
- Authority
- CN
- China
- Prior art keywords
- page
- website
- database
- server
- asynchronous
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/56—Provisioning of proxy services
- H04L67/568—Storing data temporarily at an intermediate stage, e.g. caching
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to a system and method for realizing the restoration of a web service in case of a crash of a database. The system comprises a page caching server and a database caching server, wherein the page caching server is used for acquiring a general web page from a web server of the web service for caching, and the database caching server is used for caching general database query content of the web service. The structure is adopted for the system and method for realizing the restoration of the web service in case of the crash of the database, page caching and database caching are reasonably set, asynchronous personalized data are acquired, reasonable strategies and services are set, and web page caching, asynchronous personalized data loading, database caching and other technologies are applied comprehensively, as a result, the web service can be quickly restored in case of the crash of the database, a user website can still provide all or part of service under the circumstance that the database has the crash, normal access by users of the web site can be guaranteed, and the application range is wider.
Description
Technical field
The present invention relates to website service technical field, recovery technology field when relating in particular to site databases and delaying machine, specifically refers to the delay system and method for website service recovery in machine situation of a kind of fulfillment database.
Background technology
In website using, database occupies a very status for core.The nearly all operation of user all needs the participation of database.The simple topology of whole web station system as shown in Figure 1.If in system there is the situation of the machine of delaying in data-base cluster, as: SAN(Storage Area Networking, storage area network) break down, can cause all pages in website that any service cannot be provided, the situation of whole website paralysis.
Summary of the invention
The object of the invention is to overcome the shortcoming of above-mentioned prior art, provide in a kind of situation of the machine of can fulfillment database server all delaying all or part of service still can be provided, guaranteed the system and method for website service recovery in user can use website, the fulfillment database with broader applications scope is delayed machine situation.
To achieve these goals, the fulfillment database of the present invention system and method for website service recovery in machine situation of delaying has following formation:
The delay system of website service recovery in machine situation of this fulfillment database, its principal feature is that described system comprises:
Page cache server, carries out buffer memory in order to obtain general Website page from the web page server of website service;
Database caches server, carries out buffer memory in order to the frequently-used data library inquiry content to website service.
Preferably, described system also comprises:
Asynchronous individuation data acquisition module, in order to obtain the individuation data of uncurrent Website page from the web page server of website service.
The invention still further relates to a kind of the delay method of website service recovery in machine situation of system fulfillment database based on described, its principal feature is that described method comprises the following steps:
(1) whether the database that judges current site service normally works, and if so, continues step (2), otherwise continues step (5);
(2) described page cache server upgrades the general Website page of buffer memory;
(3) described database caches server upgrades the frequently-used data library inquiry content of buffer memory;
(4) database that loads website service carries out normal website service, then finishes to exit;
(5) from described database caches server, obtaining data carries out subscription authentication and makes user possess the authority of the access websites page;
(6) from described page cache server, load general Website page.
Preferably, described system also comprises asynchronous individuation data acquisition module, between described step (3) and (4), further comprising the steps of:
(31) individuation data of the uncurrent Website page of described asynchronous individuation data acquisition module to storage upgrades.
More preferably, described asynchronous individuation data acquisition module upgrades the uncurrent Website page of storage, is specially:
Described asynchronous individuation data acquisition module upgrades the uncurrent Website page of storage by AJAX mode.
More preferably, described step (6) is afterwards, further comprising the steps of:
(7) from described asynchronous individuation data acquisition module, load the individuation data of uncurrent Website page according to user's selection.
Preferably, described page cache server upgrades the general Website page of buffer memory, is specially:
Described page cache server is acted on behalf of the general Website page of buffer memory is upgraded by Nginx.
Adopt the delay system and method for website service recovery in machine situation of fulfillment database in this invention, there is following beneficial effect:
The present invention has mainly increased database caches and page cache function, by the reasonable setting of page cache and database caches and the obtain manner of asynchronous individuation data, by rational strategy and service are set, by the integrated application of the technology such as Website page buffer memory, the loading of asynchronous individuation data, database caches, can make user website in the situation that machine appears delaying in database, all or part of service still can be provided, thereby guarantee website user's normal access, there is range of application widely.
Accompanying drawing explanation
Fig. 1 is the configuration diagram of website service system in prior art.
Fig. 2 is the delay configuration diagram of the system of website service recovery in machine situation of fulfillment database of the present invention.
Fig. 3 is the delay process flow diagram of the method for website service recovery in machine situation of fulfillment database of the present invention.
Embodiment
In order more clearly to describe technology contents of the present invention, conduct further description below in conjunction with specific embodiment.
The present invention is by the integrated application of the technology such as Website page buffer memory, the loading of asynchronous individuation data, database caches, and fulfillment database is delayed in machine situation, and the some or all of function in website can be used.
1, page cache
The page by the access to certain customers' needs carries out buffer memory, general internal memory in User Page access can be preserved, and without accessing database.The content of these buffer memorys is regular update in the normal situation of database, and database is delayed, and the situation of machine is next no longer to be upgraded.
2, asynchronous individuation data loads
Load by asynchronous individuation data, can provide personal page for user, avoided because the identical situation of User Page that uses buffer memory to cause.Individuation data can be placed in database caches.
3, database caches
By part significant data database data is carried out to buffer memory, can, in the situation that database is delayed machine, realize the normal access of significant data, therefore can avoid the database impact of machine on this type of data access of delaying.
As shown in Figure 2, the fulfillment database of the present invention system of website service recovery in machine situation of delaying comprises:
Page cache server, described page cache server in order to carry out buffer memory by general Website page from the web page server of website service;
Database caches server, carries out buffer memory in order to the frequently-used data library inquiry content to website service;
Asynchronous individuation data acquisition module, in order to obtain the individuation data of uncurrent Website page from the web page server of website service.
In order to realize function of the present invention, embodiment is as follows:
1, in website, increase page cache server and database caches server.
2, Web server/Reverse Proxy and Email (IMAP/POP3) proxy server that Nginx(is a lightweight is installed on Web server) etc. buffer memory program, and Universal page is buffered in page cache server.For the uncurrent page of part, as personal page etc., update routine, individualized content is passed through to AJAX(Asynchronous JavaScript and XML, asynchronous JavaScript and XML, refer to a kind of webpage development technology that creates interaction network page application) mode is from other URL(URL(uniform resource locator)) obtain.
3,, for database provides database caches server, common data base querying content caching, to database caches server, is guaranteed to conventional database query result can both obtain in database caches server.
4, reconfigure the authority logic of website, assurance system is in the database machine of delaying cannot calling party authority situation, can from database caches server, obtain data completing user authentication, and completing user mandate or the mandate of use default user, allow user possess the authority of accession page.
As shown in Figure 3, the fulfillment database of the present invention method of website service recovery in machine situation of delaying comprises the following steps:
(1) whether the database that judges current site service normally works, and if so, continues step (2), otherwise continues step (5);
(2) described page cache server upgrades the general Website page of buffer memory;
(3) described database caches server upgrades the frequently-used data library inquiry content of buffer memory;
(31) described asynchronous individuation data acquisition module upgrades the uncurrent Website page of storage;
(4) database that loads website service carries out normal website service, then finishes to exit;
(5) from described database caches server, obtaining data carries out subscription authentication and makes user possess the authority of the access websites page;
(6) from described page cache server, load general Website page;
(7) from described asynchronous individuation data acquisition module, load the individuation data of uncurrent Website page according to user's selection.
Adopt the delay system and method for website service recovery in machine situation of fulfillment database in this invention, there is following beneficial effect:
The present invention has mainly increased database caches and page cache function, by the reasonable setting of page cache and database caches and the obtain manner of asynchronous individuation data, by rational strategy and service are set, by the integrated application of the technology such as Website page buffer memory, the loading of asynchronous individuation data, database caches, can make user website in the situation that machine appears delaying in database, all or part of service still can be provided, thereby guarantee website user's normal access, there is range of application widely.
In this instructions, the present invention is described with reference to its specific embodiment.But, still can make various modifications and conversion obviously and not deviate from the spirit and scope of the present invention.Therefore, instructions and accompanying drawing are regarded in an illustrative, rather than a restrictive.
Claims (7)
1. the fulfillment database system for website service recovery in machine situation of delaying, is characterized in that, described system comprises:
Page cache server, carries out buffer memory in order to obtain general Website page from the web page server of website service;
Database caches server, carries out buffer memory in order to the frequently-used data library inquiry content to website service.
2. the fulfillment database according to claim 1 system of website service recovery in machine situation of delaying, is characterized in that, described system also comprises:
Asynchronous individuation data acquisition module, in order to obtain the individuation data of uncurrent Website page from the web page server of website service.
3. the method for website service recovery in machine situation of delaying of the system fulfillment database based on described in claim 1 or 2, is characterized in that, described method comprises the following steps:
(1) whether the database that judges current site service normally works, and if so, continues step (2), otherwise continues step (5);
(2) described page cache server upgrades the general Website page of buffer memory;
(3) described database caches server upgrades the frequently-used data library inquiry content of buffer memory;
(4) database that loads website service carries out normal website service, then finishes to exit;
(5) from described database caches server, obtaining data carries out subscription authentication and makes user possess the authority of the access websites page;
(6) from described page cache server, load general Website page.
4. the fulfillment database according to claim 3 system of website service recovery in machine situation of delaying, is characterized in that, described system also comprises asynchronous individuation data acquisition module, between described step (3) and (4), further comprising the steps of:
(31) individuation data of the uncurrent Website page of described asynchronous individuation data acquisition module to storage upgrades.
5. the fulfillment database according to claim 4 system of website service recovery in machine situation of delaying, is characterized in that, described asynchronous individuation data acquisition module upgrades the uncurrent Website page of storage, is specially:
Described asynchronous individuation data acquisition module upgrades the uncurrent Website page of storage by AJAX mode.
6. the fulfillment database according to claim 4 system of website service recovery in machine situation of delaying, is characterized in that, described step (6) is afterwards, further comprising the steps of:
(7) from described asynchronous individuation data acquisition module, load the individuation data of uncurrent Website page according to user's selection.
7. the fulfillment database according to claim 3 system of website service recovery in machine situation of delaying, is characterized in that, described page cache server upgrades the general Website page of buffer memory, is specially:
Described page cache server is acted on behalf of the general Website page of buffer memory is upgraded by Nginx.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410079937.2A CN103793538A (en) | 2014-03-06 | 2014-03-06 | System and method for realizing restoration of web service in case of crash of database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410079937.2A CN103793538A (en) | 2014-03-06 | 2014-03-06 | System and method for realizing restoration of web service in case of crash of database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103793538A true CN103793538A (en) | 2014-05-14 |
Family
ID=50669204
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410079937.2A Pending CN103793538A (en) | 2014-03-06 | 2014-03-06 | System and method for realizing restoration of web service in case of crash of database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103793538A (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104123356A (en) * | 2014-07-17 | 2014-10-29 | 成都康赛信息技术有限公司 | Method for increasing webpage response speed under large data volume condition |
CN105491029A (en) * | 2015-11-26 | 2016-04-13 | 盛趣信息技术(上海)有限公司 | Game server cluster |
CN106156231A (en) * | 2015-04-24 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of website disaster recovery method, Apparatus and system |
CN108400884A (en) * | 2018-01-10 | 2018-08-14 | 链家网(北京)科技有限公司 | A kind of method, system and device improving website service stability |
CN108446356A (en) * | 2018-03-12 | 2018-08-24 | 上海哔哩哔哩科技有限公司 | Data cache method, server and data buffering system |
CN110837521A (en) * | 2019-11-15 | 2020-02-25 | 北京金山云网络技术有限公司 | Data query method and device and server |
US10866866B2 (en) | 2016-06-29 | 2020-12-15 | Huawei Technologies Co., Ltd. | Query fault processing method and processing apparatus |
CN112347363A (en) * | 2020-11-18 | 2021-02-09 | 北京百家科技集团有限公司 | Page generation method and device |
CN112596955A (en) * | 2020-12-28 | 2021-04-02 | 山西云时代研发创新中心有限公司 | Emergency processing system and method for processing large-scale system emergency in cloud computing |
CN112732999A (en) * | 2021-01-21 | 2021-04-30 | 建信金融科技有限责任公司 | Static disaster recovery method, system, electronic device and storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080181008A1 (en) * | 2007-01-25 | 2008-07-31 | Byeong-Hoon Lee | Flash memory system capable of improving access performance and access method thereof |
CN101488135A (en) * | 2008-01-14 | 2009-07-22 | 盛大计算机(上海)有限公司 | Designing and acquiring method for delayed personalized web page |
CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
CN103597463A (en) * | 2011-06-06 | 2014-02-19 | 微软公司 | Automatic configuration of a recovery service |
-
2014
- 2014-03-06 CN CN201410079937.2A patent/CN103793538A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080181008A1 (en) * | 2007-01-25 | 2008-07-31 | Byeong-Hoon Lee | Flash memory system capable of improving access performance and access method thereof |
CN101488135A (en) * | 2008-01-14 | 2009-07-22 | 盛大计算机(上海)有限公司 | Designing and acquiring method for delayed personalized web page |
CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
CN103597463A (en) * | 2011-06-06 | 2014-02-19 | 微软公司 | Automatic configuration of a recovery service |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104123356B (en) * | 2014-07-17 | 2017-06-27 | 成都康赛信息技术有限公司 | A kind of method that webpage response is improved under big data quantity |
CN104123356A (en) * | 2014-07-17 | 2014-10-29 | 成都康赛信息技术有限公司 | Method for increasing webpage response speed under large data volume condition |
CN106156231A (en) * | 2015-04-24 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of website disaster recovery method, Apparatus and system |
CN105491029A (en) * | 2015-11-26 | 2016-04-13 | 盛趣信息技术(上海)有限公司 | Game server cluster |
US10866866B2 (en) | 2016-06-29 | 2020-12-15 | Huawei Technologies Co., Ltd. | Query fault processing method and processing apparatus |
US11461195B2 (en) | 2016-06-29 | 2022-10-04 | Huawei Technologies Co., Ltd. | Query fault processing method and processing apparatus |
CN108400884B (en) * | 2018-01-10 | 2021-08-03 | 贝壳找房(北京)科技有限公司 | Method, system and device for improving stability of website service |
CN108400884A (en) * | 2018-01-10 | 2018-08-14 | 链家网(北京)科技有限公司 | A kind of method, system and device improving website service stability |
CN108446356A (en) * | 2018-03-12 | 2018-08-24 | 上海哔哩哔哩科技有限公司 | Data cache method, server and data buffering system |
CN108446356B (en) * | 2018-03-12 | 2023-08-29 | 上海哔哩哔哩科技有限公司 | Data caching method, server and data caching system |
CN110837521A (en) * | 2019-11-15 | 2020-02-25 | 北京金山云网络技术有限公司 | Data query method and device and server |
CN112347363A (en) * | 2020-11-18 | 2021-02-09 | 北京百家科技集团有限公司 | Page generation method and device |
CN112596955A (en) * | 2020-12-28 | 2021-04-02 | 山西云时代研发创新中心有限公司 | Emergency processing system and method for processing large-scale system emergency in cloud computing |
CN112732999A (en) * | 2021-01-21 | 2021-04-30 | 建信金融科技有限责任公司 | Static disaster recovery method, system, electronic device and storage medium |
CN112732999B (en) * | 2021-01-21 | 2023-06-09 | 建信金融科技有限责任公司 | Static disaster recovery method, system, electronic equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103793538A (en) | System and method for realizing restoration of web service in case of crash of database | |
US9794242B2 (en) | Method, apparatus and application platform for realizing logon to an application service website | |
US9077681B2 (en) | Page loading optimization using page-maintained cache | |
US8925056B2 (en) | Universal management of user profiles | |
US20110231778A1 (en) | Customizing content displayed for a user based on user preferences of another user | |
WO2015043428A1 (en) | Method, system, browser and proxy server for loading webpage | |
CN112615907B (en) | Data synchronization system and method | |
US10165039B1 (en) | Pre-connecting to a cacheable resource based on page profiles | |
US20160198014A1 (en) | Techniques for predictive network resource caching | |
CN103246667A (en) | Method and device for cross-domain transfer of data | |
RU2630380C9 (en) | System and advertising push method (push) based on home gateway | |
CN102662993A (en) | A method for providing page data | |
Pande et al. | Enhanced web application and browsing performance through service-worker infusion framework | |
US9058399B2 (en) | System and method for providing network resource identifier shortening service to computing devices | |
US11405363B2 (en) | File upload control for client-side applications in proxy solutions | |
CN106254451A (en) | Embedded device web menu control system and method | |
CN103475714A (en) | System and method for operation log recording and uploading on basis of Active X technique | |
CN109634753B (en) | Data processing method, device, terminal and storage medium for switching browser kernels | |
CN104994139A (en) | System capable of quickly responding to high-concurrency network request | |
CN103297498A (en) | Relevant content pushing method based on mobile phone client side | |
CN101557403A (en) | Website login method, device and system | |
CN105528369A (en) | Webpage transcoding method and device and server | |
CN106557584A (en) | A kind of web site collection method and device | |
US20130290515A1 (en) | Method and Apparatus for Redirecting Webpage Requests to Appropriate Equivalents | |
CN104765844A (en) | Website page generating method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140514 |
|
WD01 | Invention patent application deemed withdrawn after publication |