CN101876924A - Database fault automatic detection and transfer method - Google Patents
Database fault automatic detection and transfer method Download PDFInfo
- Publication number
- CN101876924A CN101876924A CN2009100504356A CN200910050435A CN101876924A CN 101876924 A CN101876924 A CN 101876924A CN 2009100504356 A CN2009100504356 A CN 2009100504356A CN 200910050435 A CN200910050435 A CN 200910050435A CN 101876924 A CN101876924 A CN 101876924A
- Authority
- CN
- China
- Prior art keywords
- server
- database
- client
- master
- mdha
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
- Hardware Redundancy (AREA)
Abstract
The invention discloses a database fault automatic detection and transfer method which is configured with a client (100), a cache memorizer (200), an MDHA module (210), a management terminal (500) and a plurality of database server groups (300 and 400), and comprises the main steps that each database server group is divided into a master server (300) and a slave server (400); the MDHA module (210) is arranged between the client (100) and a database and is used for detecting the database; when the client connection is started, a detection thread is set up; when in running, the client (100) can be used for detecting the master server (300) through the MDHA module (210); when the master server (300) is detected to be abnormal, the MDHA module (210) leads the access of the client to be automatically switched into the slave server; and when the master server is recovered, intermediate leads the access of the client to be switched into the master server. The method can be applied into a small and medium size data base management systems adopting a My SQL system, can guarantee the continuity of the service operation of a network server, and improves the reliability.
Description
Technical field
The present invention relates to a kind of database access technology, relate in particular to a kind of database failure and detect automatically and transfer method, can be applicable to the method for operating that database service is had the system of high-availability requirement.
Background technology
MySQL is a small-sized Relational DBMS, and the developer is a Sweden MySQL AB company.Purchased by Sun Microsystems on January 16th, 2008.At present MySQL is widely used in the middle-size and small-size website on the Internet.Because its volume is little, speed is fast, the total cost of ownership is low, these characteristics of open source code especially, many middle-size and small-size websites have selected MySQL as site databases in order to reduce the website total cost of ownership.
The most widely used free database open source software MySQL of internet industry provides a kind of small-sized correlation data base management system (DBMS).At present MySQL is widely used in the middle-size and small-size website on the Internet.Because its volume is little, speed is fast, the total cost of ownership is low, these characteristics of open source code especially, many middle-size and small-size websites have selected MySQL as site databases in order to reduce the website total cost of ownership.Because these characteristics of MySQL make it can be applicable to various medium and small databases very easily, and the supvr can pass through Web interface management database, is particularly useful for the remittance and the remittance abroad of mass data.And it is applicable to the webpage servomechanism well, can realize the telemanagement database at any old place easily.
Yet foundation along with remote data base, its safe and stable problem is just following, promptly how to guarantee the operation that remote data base is continual and steady as much as possible, and when network connection fault or database failure take place, the function that how to guarantee system can find application, and becomes the problem that people are concerned about.
There is an effective solution to be known as two-shipper cluster (HA) system, two-shipper cluster (HA) system is a kind of server cluster system solution of high reliability, a standby server promptly is provided, when master server breaks down when can't use, process is transferred on the standby server, so that the server downtime is shortened as far as possible.Avoid the user is produced too much loss.
But in the toy data base management system that MySQL provided, a little less than the design relative thin for the HA link, often stop using, cause service disruption owing to Single Point of Faliure causes the entire database server.Report according to the issue of U.S. parallel computing company points out that planned and unexpected database is shut down the revenue losses Yi Banwei $78 that causes, and 000 per hour.
Therefore, in the small and medium databases management system of using MySQL, provide data, services with how guaranteeing steady and continuous, become a problem that presses for solution.
Summary of the invention
The objective of the invention is for better in the toy data base management system, solve stable continue data, services is provided, and ensure connect accurately and validity.
The database failure that provides of the present invention detects and transfer method automatically, and the scheme of being taked is as follows:
The invention provides a kind of database failure and detect automatically and transfer method, dispose client (100), buffer memory (200), MDHA module (210), management end (500) and a plurality of database servers group (300,400), wherein:
Group of server is divided into master server (300) and from server (400);
The MDHA module (210) that is provided with between client (100) and the database is used to detect database, when the connection of client starts, sets up and detects thread;
When operation, client (100) detects master server (300) by MDHA module (210);
When detecting master server (300) when unusual, MDHA module (210) automatically switches to the visit of client from server;
After master server recovered, middle visit with client switched to master server.
Above-mentioned database failure automatically detects and transfer method, wherein, is provided with database server parallel more than three in each group of server, comprising a master server and many from server.
Above-mentioned database failure automatically detects and transfer method, wherein, the master server in the described same group of server with realize data sync from server by MySQL system synchronization module.
Above-mentioned database failure automatically detects and transfer method, wherein, after described master server fault, switch by substituting master server work from server, and former master server switches to from server, carries out data sync with new server master slave relation again.
Above-mentioned database failure detects and transfer method automatically, wherein, when the master server abnormal state, and detects from server also abnormal state, then to the disabled notice of client send server.
Above-mentioned database failure automatically detects and transfer method, and wherein, after client sent the disabled notice of server, the MDHA module continued to detect that to search in this group of server other available from server.
Above-mentioned database failure automatically detects and transfer method, and wherein, the distribution of MDHA module is by the HASH policy calculation, and server address is confirmed and pointed to.
Above-mentioned database failure detects and transfer method automatically, wherein, described HASH strategy is the MD5 algorithm, transmit a user name as request by client, the MDHA module calculates the MD5 value of this user name of client transmission subsequently, according to current database configuration, carries out segmentation or delivery by the MD5 value, thereby find the database server of depositing corresponding data, make client be connected to correct server.
Above-mentioned database failure detects and transfer method automatically, and wherein, the MDHA module detects in real time to database server, and its frequency is that per second detects a server state.
Above-mentioned database failure detects and transfer method automatically, wherein, also comprises the steps:
Step 1: client (100) and caching server (200) UNICOM, invokes thread reads while write caching server (200) according to the HASH strategy immediately;
Step 2: upgraded the thread of caching server, the update content of will being correlated with simultaneously writes journal file;
Step 3: open same 1 pair 1 thread simultaneously according to the asynchronous concurrent more new database of journal file.
Step 4: the log file is updated to the situation of database;
Step 5:MDHA detection module, the running status of detection master server (300);
Step 6: when master server (300) but the time spent, then all read-write threads all point to master server, by caching server and client realization reading and writing data; If detect master server (300) when unavailable, suspend immediately the read-write requests of oriented master server;
Step 7: detect situation from server (400);
Step 8: the change by MDHA is pointed to, and the whole read requests of connection of the client (100) with master server (300) after unusual all are directed to from server;
Step 9: the data base administrator locates by the MDHA module returning to form of database master server (300) to be judged at data base administration end (500);
Step 10; Exchange by address from server (400), become new master server, open write data storehouse thread simultaneously with former master server (300);
Step 11: recover when data base administration end (500) detects master server (300) by MDHA, then open and recover write data storehouse thread master server, and again all read-write requests are pointed to master server again, continue master server (500) to be carried out database and read and write by buffer memory (200).
Database failure of the present invention detects and transfer method automatically, can be applied to adopt the small and medium databases management system of MySQL system, can ensure the continuity of webserver service operation, improves reliability.
In addition, MDHA is with respect to other HA software, can detect the various abnormality of MySQL, comprise global lock, a series of database down states such as read-only, and can switch moment, and back the administrative mechanism of MDHA, for state is cut control, the active and standby switching of server, the Web operation sublimity that manual operation is provided convenience.
Description of drawings
Fig. 1 is the module diagram of automatic detection of database failure of the present invention and transfer system.
Fig. 2 is the process flow diagram of automatic detection of database failure of the present invention and transfer method;
Embodiment
As shown in Figure 1, be the synoptic diagram of respectively forming module of automatic detection of database failure of the present invention and transfer system, it comprises, user side 100, buffer memory (Cache) server 200, database master (Master) server 300, database is from (Slave) server 400, and management end 500.Database server of the present invention adopts two redundancy structures of Master/Slave, and the Slave server is also configurable many simultaneously, and the data between the database are implemented strict synchronism, and are consistent to guarantee Master server and Slave data in server.In addition, caching server 200 of the present invention directly is connected with a plurality of independent user ends 100 by the internet, the line data of going forward side by side transmission; The related data of user side is all by caching server 200 subsequently, and carries out data sync between the database server (300,400), comprises reading and writing, upgrades operation.Simultaneously, has MDHA (based on the HA system that is applied to MySQL multiserver database of MD algorithm) module 210 in the caching server 200, described MDHA module 210 inside comprise the MDHA access interface of customization, client 500 can be carried out transparent access to database server by this access interface, and carry out alternately with database server, the MDHA interface for client is distributed corresponding server, can have access to correct database server to guarantee client according to the strategy of setting.This MDHA inside modules also comprises a fault detection module, in order to detect database server (300,400), per second can carry out one-time detection to database server, if find that current database can't use, can learn and upgrade the current database work state information immediately.MDHA module 210 is connected with management end 500, and can manage by management end 500, as carries out parameter setting, manual operation, modification etc.In addition, this MDHA inside modules also comprises an administration module, externally provides a udp port for monitoring.Any inquiry of 500 couples of MDHA of management end, management such as modification can be undertaken by this udp port.
In addition, described management end 500 can be by record and the journal file that calls the MDHA module, the state of Query Database server.Simultaneously, the various recorded informations of MDHA be connected with management end 500 by a web port, and management end also can manage MDHA by this web port.
The present invention also provides a kind of database failure to detect automatically and transfer method, is used for guaranteeing that client can have access to correct database server.In the client terminal start-up process, the MDHA module all writes down a Status Flag to the master server of database with from server, init state is " ok " or " normally ", when detecting any abnormality subsequently, then corresponding abnormality is illustrated in the server state sign, as " authority is unusual ", " database locking ", " the network response slowly ", " network disconnection " etc.In each request of client, a user name (by the client input) is transmitted in the capital, caching server 200 receives this username information, pass through the calculating of MDHA module again, obtain the MD5 value of this user name, according to the configuration of current database, find corresponding database servers group, database servers group comprises that at least one master (Master) server 300 and at least one are from (Slave) server 400.The calculative strategy of MDHA module is the HASH calculative strategy, especially preferably adopts the MD5 algorithm, according to two kinds of strategies of segmentation of MD5 value and delivery, indicates respectively herein.When primary server database operation just often, the MDHA module is routed to master server with the request of client; When the master server operation exception, revise database respective flag (as the IP address) at once; And to detecting from server, if normal from server, then the request of access with client is routed to the server from (Slave).And simultaneously master (Master) server is continued to detect, in case main (Master) server working properly after, by the interface of MDHA module, the Master server is switched back in the visit of client.
It is transfer method that database failure of the present invention detects automatically, comprises the steps:
A) group of server is divided into main (Master) server and from (Slave) server;
B) be provided with intermediate module between client and the database,, be used to detect database, when the connection of client starts, set up and detect thread as the MDHA module with measuring ability;
C) when operation, client detects master server by intermediate module;
D) when detecting master server when unusual, intermediate module automatically switches to the visit of client from server;
E) after master server recovers, middle visit with client switches to master server.
Database of the present invention need keep strict synchronism, promptly leads (Master) server and the canned data in (Slave) server database should be consistent as far as possible.Generally, when master server with when server all normally moves, realize data sync by the synchronization module of MySQL system.Behind the master server abnormal state, by the MDHA module access of database is routed to from server, after treating that master server recovers, with be switched substitute master server from server as new master server, original master server is then as from server, after both all normal operations, carry out data sync once more.Simultaneously, this kind master server and reversible from the switching of server promptly when new master server breaks down, also can switch back it from server, and will switch to master server from server.The master server of this two-shipper group system and should be approaching as far as possible from the performance configuration of server is to avoid switching owing to master and slave server the instability of the Network Transmission that causes.
As shown in Figure 2, the process flow diagram for automatic detection of the preferred database failure of the present invention and transfer method wherein, specifically comprises following these steps:
Step 1: client 100 and caching server 200 UNICOMs, invokes thread reads while write buffer memory (Cache) server 200 according to HASH strategy (hashing algorithm) immediately.Wherein, the general MD5 algorithm of the preferred employing of HASH strategy of the present invention, concrete, client transmits a user name as request, the MDHA module then calculates the MD5 value of this user name of client transmission, according to current database configuration, carries out segmentation or delivery by the MD5 value, thereby find the database server of depositing corresponding data, make client be connected to correct server.
Step 2: upgraded the thread of caching server, the update content of will being correlated with simultaneously writes journal file (LOG).
Step 3: open same 1 pair 1 thread simultaneously according to the asynchronous concurrent more new database of journal file (LOG) (DB).
Step 4: log file (LOG) is updated to the situation of database (DB), as: be recorded in another journal file or the server.
Step 5:MDHA detection module, to the running status of master (Master) server 300, per second carries out one-time detection, to detect the various abnormality of server.Abnormality generally has two kinds, and a kind of MySQL of being can provide the unusual of response, and can discern this moment according to the return code that MySQL provides, to judge concrete abnormal conditions.Unusual or database table can be identified by the response of abnormal conditions such as locking as the current database authority.Under the another kind of situation, MySQL does not provide response, and whether whether this kind unusual condition by a normal timeout value that sets in advance, surpasses this timeout value according to the response time of detecting a request signal, unusual to learn server.The MySQL process withdraws from as working as, current network is blocked up, and under the situation that low-response or network disconnect, refers to response time and the acceptable timeout value of asking by comparing a New Development, draws the unusual result of network state.
Step 6: as master (Master) but 300 times spent of server, then all read-write threads all point to master server, by caching server and client realization reading and writing data.It is unusual no matter which kind of takes place, once detect main (Master) server 300 unavailable after, suspend immediately the read-write requests of oriented master server, and these requests are retained in the buffer memory.
Step 7: detect situation from (Slave) server 400, if in order from (Slave) server, then by two-shipper (HA) group system, all write the database request failure mark, all write former database server, and (for example: thread master server 300) all stops, and the MDHA module will be pointed to from server 400 from all read requests that client is received simultaneously.If also unusual, then, the disabled information of server is sent to client 100 by buffer memory (Cache) server from server state.
Step 8: the change by MDHA is pointed to, and the whole read requests of connection of the clients with master server 300 after unusual all are directed to from server, thus latter linked new user, the client 100 by separately is all by from server continuation reading of data.And before the master server abnormal state, the old user who is connected with master server 300, by its client 100,, continue the thread of reading of realization and these clients by from master server 300, calling in the user data in buffer memory (Cache) storer 200.
Step 9; The data base administrator judges returning to form of database master (Master) server 300 by the MDHA module at data base administration end 500 places, if the data base administrator of management end 500 judges that master server needs can to recover for a long time or is unavailable, then directly change master server 300 and from the IP address of server 400 by management end 500, be that both point to the address, exchange heavy duty configuration (Reload conf.).
Step 10: exchange by address with former master (Master) server 300 from (Slave) server 400, become new " master " (Master) server, open write data storehouse thread simultaneously, write request is imported (former in server) in the new master server by client 100.
Step 11: recovered when data base administration end 500 detects master server 300 by MDHA, then open and recover write data storehouse thread master server, and again all read-write requests are pointed to master server again, continue to carry out database and read and write by 200 pairs of master servers of buffer memory 500.
Claims (10)
1. a database failure detects and transfer method automatically, disposes client (100), buffer memory (200), and MDHA module (210), management end (500) and a plurality of database servers group (300,400) is characterized in that:
Group of server is divided into master server (300) and from server (400);
The MDHA module (210) that is provided with between client (100) and the database is used to detect database, when the connection of client starts, sets up and detects thread;
When operation, client (100) detects master server (300) by MDHA module (210);
When detecting master server (300) when unusual, MDHA module (210) automatically switches to the visit of client from server;
After master server recovered, middle visit with client switched to master server.
2. database failure as claimed in claim 1 automatically detects and transfer method, it is characterized in that, is provided with database server parallel more than three in each group of server, comprising a master server and many from server.
3. database failure as claimed in claim 2 automatically detects and transfer method, it is characterized in that, the master server in the described same group of server with realize data sync from server by MySQL system synchronization module.
4. database failure as claimed in claim 3 detects and transfer method automatically, it is characterized in that, after described master server fault, switch by substituting master server work from server, and former master server switches to from server, carries out data sync with new server master slave relation again.
5. detect automatically and transfer method as any described database failure in the claim 1 to 4, it is characterized in that, when the master server abnormal state, and detect, then to the disabled notice of client send server from server also abnormal state.
6. database failure as claimed in claim 5 automatically detects and transfer method, it is characterized in that, after client sent the disabled notice of server, the MDHA module continued to detect that to search in this group of server other available from server.
7. database failure as claimed in claim 3 automatically detects and transfer method, it is characterized in that, the distribution of MDHA module is by the HASH policy calculation, and server address is confirmed and pointed to.
8. database failure as claimed in claim 7 detects and transfer method automatically, it is characterized in that, described HASH strategy is the MD5 algorithm, transmit a user name as request by client, the MDHA module calculates the MD5 value of this user name of client transmission subsequently, according to current database configuration, carries out segmentation or delivery by the MD5 value, thereby find the database server of depositing corresponding data, make client be connected to correct server.
9. database failure as claimed in claim 1 detects and transfer method automatically, it is characterized in that the MDHA module detects in real time to database server, and its frequency is that per second detects a server state.
10. database failure as claimed in claim 1 detects and transfer method automatically, it is characterized in that, also comprises the steps:
Step 1: client (100) and caching server (200) UNICOM, invokes thread reads while write caching server (200) according to the HASH strategy immediately;
Step 2: upgraded the thread of caching server, the update content of will being correlated with simultaneously writes journal file;
Step 3: open same 1 pair 1 thread simultaneously according to the asynchronous concurrent more new database of journal file.
Step 4: the log file is updated to the situation of database;
Step 5:MDHA detection module, the running status of detection master server (300);
Step 6: when master server (300) but the time spent, then all read-write threads all point to master server, by caching server and client realization reading and writing data; If detect master server (300) when unavailable, suspend immediately the read-write requests of oriented master server;
Step 7: detect situation from server (400);
Step 8: the change by MDHA is pointed to, and the whole read requests of connection of the client (100) with master server (300) after unusual all are directed to from server;
Step 9: the data base administrator locates by the MDHA module returning to form of database master server (300) to be judged at data base administration end (500);
Step 10: exchange by address from server (400), become new master server, open write data storehouse thread simultaneously with former master server (300);
Step 11: recover when data base administration end (500) detects master server (300) by MDHA, then open and recover write data storehouse thread master server, and again all read-write requests are pointed to master server again, continue master server (500) to be carried out database and read and write by buffer memory (200).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910050435 CN101876924B (en) | 2009-04-30 | 2009-04-30 | Database fault automatic detection and transfer method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910050435 CN101876924B (en) | 2009-04-30 | 2009-04-30 | Database fault automatic detection and transfer method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101876924A true CN101876924A (en) | 2010-11-03 |
| CN101876924B CN101876924B (en) | 2013-10-30 |
Family
ID=43019485
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910050435 Active CN101876924B (en) | 2009-04-30 | 2009-04-30 | Database fault automatic detection and transfer method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101876924B (en) |
Cited By (53)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102194009A (en) * | 2011-06-09 | 2011-09-21 | 北京新媒传信科技有限公司 | Database hosting method and database hosting platform system |
| CN102307115A (en) * | 2011-09-21 | 2012-01-04 | 大唐移动通信设备有限公司 | Method and device for recovering fault entity |
| CN102420708A (en) * | 2011-12-16 | 2012-04-18 | 广东高新兴通信股份有限公司 | Load balancing processing system of service data and method thereof |
| CN102541885A (en) * | 2010-12-10 | 2012-07-04 | 中国移动通信集团浙江有限公司 | Method and device for detecting database blockage |
| CN102541693A (en) * | 2011-12-31 | 2012-07-04 | 曙光信息产业股份有限公司 | Multi-copy storage management method and system of data |
| CN102571834A (en) * | 2010-12-15 | 2012-07-11 | 金华六度信息科技有限公司 | WEB instant messaging system based on server push technology, and method |
| CN102629260A (en) * | 2012-02-29 | 2012-08-08 | 浪潮(北京)电子信息产业有限公司 | Processing method, device and system for database collapse |
| CN102742223A (en) * | 2011-09-19 | 2012-10-17 | 华为技术有限公司 | User service migration method, device and system |
| CN102752164A (en) * | 2011-10-19 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Dual-computer hot-standby switching method and system of grading system |
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN102841895A (en) * | 2011-06-22 | 2012-12-26 | 阿里巴巴集团控股有限公司 | Method and system for processing database state transition |
| CN103049348A (en) * | 2012-12-21 | 2013-04-17 | 四川川大智胜软件股份有限公司 | Data fault tolerant storage method under multiserver environment |
| CN103346903A (en) * | 2013-06-20 | 2013-10-09 | 北京捷成世纪科技股份有限公司 | Dual-machine backup method and device |
| CN103425645A (en) * | 2012-05-14 | 2013-12-04 | 阿里巴巴集团控股有限公司 | Monitoring system and monitoring method for single point of failure of database cluster |
| CN103516668A (en) * | 2012-06-20 | 2014-01-15 | 中国银联股份有限公司 | Broadcast-type database reconnection-based data processing server and broadcast-type database reconnection method |
| CN103780417A (en) * | 2012-10-23 | 2014-05-07 | 上海盛大网络发展有限公司 | Database failure transfer method based on cloud hard disk and device thereof |
| CN103793538A (en) * | 2014-03-06 | 2014-05-14 | 赛特斯信息科技股份有限公司 | System and method for realizing restoration of web service in case of crash of database |
| CN104216943A (en) * | 2014-06-24 | 2014-12-17 | 用友优普信息技术有限公司 | Method and device for automatically collecting blockage information to facilitate post analysis on database blockage |
| CN104252485A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Database management platform |
| CN104252500A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Method and device for carrying out fault repairing on database management platform |
| CN104348842A (en) * | 2013-07-23 | 2015-02-11 | 腾讯科技（深圳）有限公司 | Route method and route management server of distributed storage system, and distributed storage system |
| CN104506353A (en) * | 2014-12-23 | 2015-04-08 | 北京奇虎科技有限公司 | Authentication management method, equipment and system |
| CN104601354A (en) * | 2013-10-31 | 2015-05-06 | 深圳市腾讯计算机系统有限公司 | Business log storage method, device and system |
| CN104679604A (en) * | 2015-02-12 | 2015-06-03 | 大唐移动通信设备有限公司 | Method and device for switching between master node and standby node |
| CN105159944A (en) * | 2015-08-10 | 2015-12-16 | 北京思特奇信息技术股份有限公司 | Database emergency handling method and system |
| CN105404633A (en) * | 2014-09-16 | 2016-03-16 | 无锡科技职业学院 | Client based database multi-point backup system and backup method |
| CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
| CN105554143A (en) * | 2015-12-25 | 2016-05-04 | 浪潮(北京)电子信息产业有限公司 | High-availability cache server and data processing method and system thereof |
| CN106161644A (en) * | 2016-08-12 | 2016-11-23 | 珠海格力电器股份有限公司 | The distributed system of data process and data processing method thereof |
| CN106254103A (en) * | 2016-07-28 | 2016-12-21 | 北京中电普华信息技术有限公司 | A kind of RTMP group system can Dynamic Configuration and device |
| CN106407069A (en) * | 2015-07-30 | 2017-02-15 | Ls 产电株式会社 | Apparatus and method for managing of database in energy management system |
| CN106776157A (en) * | 2017-01-19 | 2017-05-31 | 国网山东省电力公司滨州供电公司 | It is used for the device of big customer's power supply service in a kind of electric power system |
| CN106814645A (en) * | 2015-11-30 | 2017-06-09 | 株式会社东芝 | Data logger and it is applied to the control method of the data logger |
| CN106897288A (en) * | 2015-12-18 | 2017-06-27 | 阿里巴巴集团控股有限公司 | The service providing method and system of database |
| CN106919478A (en) * | 2017-03-07 | 2017-07-04 | 中国建设银行股份有限公司 | A kind of Website page element backup method and system |
| CN107066354A (en) * | 2017-04-18 | 2017-08-18 | 中国银联股份有限公司 | A kind of switching method of database, master server and from server |
| CN107480014A (en) * | 2017-07-24 | 2017-12-15 | 北京奇安信科技有限公司 | A kind of High Availabitity equipment switching method and device |
| CN107870830A (en) * | 2016-09-23 | 2018-04-03 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for lifting database availability |
| CN108134854A (en) * | 2017-12-15 | 2018-06-08 | 江苏神州信源系统工程有限公司 | A kind of hot spare method and system based on NAT technologies |
| CN108154045A (en) * | 2016-12-02 | 2018-06-12 | 航天星图科技（北京）有限公司 | A kind of method for creating authentic data library |
| CN108259242A (en) * | 2018-01-12 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | Data exchange management method, terminal, system and computer readable storage medium based on duoble computer disaster-tolerance back-up security mechanism |
| CN108259259A (en) * | 2016-12-29 | 2018-07-06 | 北京国双科技有限公司 | Cluster stability diagnostic method and device |
| CN108647113A (en) * | 2018-03-30 | 2018-10-12 | 阿里巴巴集团控股有限公司 | A kind of Disaster Recovery Method and server |
| CN108959604A (en) * | 2018-07-13 | 2018-12-07 | 浙江彩虹鱼科技有限公司 | Safeguard the method, apparatus and computer readable storage medium of data-base cluster |
| CN109474674A (en) * | 2018-10-26 | 2019-03-15 | 腾讯科技(成都)有限公司 | Transmission method and device, storage medium, the electronic device of content |
| CN109491830A (en) * | 2017-09-12 | 2019-03-19 | 北京京东尚科信息技术有限公司 | The method and system in switch data source |
| CN110019484A (en) * | 2018-01-04 | 2019-07-16 | 腾讯科技（深圳）有限公司 | Database Systems and implementation method, management equipment, data interface unit and medium |
| CN110347343A (en) * | 2019-07-16 | 2019-10-18 | 珠海格力电器股份有限公司 | Data managing method and device |
| CN110865907A (en) * | 2018-08-27 | 2020-03-06 | Ovh公司 | Method and system for providing service redundancy between master server and slave server |
| CN111414247A (en) * | 2020-04-24 | 2020-07-14 | 北京金山云网络技术有限公司 | Server switching method, device, management node and storage medium |
| CN111641716A (en) * | 2020-06-01 | 2020-09-08 | 第四范式（北京）技术有限公司 | Self-healing method of parameter server, parameter server and parameter service system |
| CN111966488A (en) * | 2020-07-17 | 2020-11-20 | 北京思特奇信息技术股份有限公司 | Interface gateway multi-center application system and method |
| CN114661827A (en) * | 2022-05-23 | 2022-06-24 | 武汉四通信息服务有限公司 | Database taking-over method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1371058A (en) * | 2001-02-22 | 2002-09-25 | 北京北信源自动化技术有限公司 | Hot mirror image base driven hot back-up method of server data |
| JP2002312312A (en) * | 2001-04-13 | 2002-10-25 | Kit Asp:Kk | Application service method using network constitution of logical hierarchical structure and application server system |
| US20050055351A1 (en) * | 2003-09-05 | 2005-03-10 | Oracle International Corporation | Apparatus and methods for transferring database objects into and out of database systems |
| CN201497981U (en) * | 2009-04-30 | 2010-06-02 | 升东网络科技发展(上海)有限公司 | Database failure automatic detecting and shifting system |
-
2009
- 2009-04-30 CN CN 200910050435 patent/CN101876924B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1371058A (en) * | 2001-02-22 | 2002-09-25 | 北京北信源自动化技术有限公司 | Hot mirror image base driven hot back-up method of server data |
| JP2002312312A (en) * | 2001-04-13 | 2002-10-25 | Kit Asp:Kk | Application service method using network constitution of logical hierarchical structure and application server system |
| US20050055351A1 (en) * | 2003-09-05 | 2005-03-10 | Oracle International Corporation | Apparatus and methods for transferring database objects into and out of database systems |
| CN201497981U (en) * | 2009-04-30 | 2010-06-02 | 升东网络科技发展(上海)有限公司 | Database failure automatic detecting and shifting system |
Cited By (82)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102541885A (en) * | 2010-12-10 | 2012-07-04 | 中国移动通信集团浙江有限公司 | Method and device for detecting database blockage |
| CN102571834A (en) * | 2010-12-15 | 2012-07-11 | 金华六度信息科技有限公司 | WEB instant messaging system based on server push technology, and method |
| CN102194009A (en) * | 2011-06-09 | 2011-09-21 | 北京新媒传信科技有限公司 | Database hosting method and database hosting platform system |
| CN102841895B (en) * | 2011-06-22 | 2015-06-24 | 阿里巴巴集团控股有限公司 | Method and system for processing database state transition |
| CN102841895A (en) * | 2011-06-22 | 2012-12-26 | 阿里巴巴集团控股有限公司 | Method and system for processing database state transition |
| CN102742223B (en) * | 2011-09-19 | 2015-01-21 | 华为技术有限公司 | User service migration method, device and system |
| CN102742223A (en) * | 2011-09-19 | 2012-10-17 | 华为技术有限公司 | User service migration method, device and system |
| WO2012149750A1 (en) * | 2011-09-19 | 2012-11-08 | 华为技术有限公司 | User service migration method, device and system |
| US9401958B2 (en) | 2011-09-19 | 2016-07-26 | Huawei Technologies Co., Ltd. | Method, apparatus, and system for migrating user service |
| CN102307115A (en) * | 2011-09-21 | 2012-01-04 | 大唐移动通信设备有限公司 | Method and device for recovering fault entity |
| CN102752164B (en) * | 2011-10-19 | 2017-12-29 | 新奥特（北京）视频技术有限公司 | A kind of switching method and system of the two-node cluster hot backup of scoring system |
| CN102752164A (en) * | 2011-10-19 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Dual-computer hot-standby switching method and system of grading system |
| CN102420708A (en) * | 2011-12-16 | 2012-04-18 | 广东高新兴通信股份有限公司 | Load balancing processing system of service data and method thereof |
| CN102541693A (en) * | 2011-12-31 | 2012-07-04 | 曙光信息产业股份有限公司 | Multi-copy storage management method and system of data |
| CN102629260A (en) * | 2012-02-29 | 2012-08-08 | 浪潮(北京)电子信息产业有限公司 | Processing method, device and system for database collapse |
| CN103425645A (en) * | 2012-05-14 | 2013-12-04 | 阿里巴巴集团控股有限公司 | Monitoring system and monitoring method for single point of failure of database cluster |
| CN103425645B (en) * | 2012-05-14 | 2017-03-01 | 阿里巴巴集团控股有限公司 | The monitoring system and method for single point of failure of database cluster |
| CN103516668A (en) * | 2012-06-20 | 2014-01-15 | 中国银联股份有限公司 | Broadcast-type database reconnection-based data processing server and broadcast-type database reconnection method |
| CN103516668B (en) * | 2012-06-20 | 2017-03-01 | 中国银联股份有限公司 | The data processing server being reconnected based on broadcast data storehouse and broadcast data storehouse reconnection method |
| CN102779191B (en) * | 2012-07-03 | 2015-09-02 | 互动在线（北京）科技有限公司 | A kind of system that realizes of MySQL database smooth upgrade and implementation method |
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN103780417B (en) * | 2012-10-23 | 2018-10-26 | 上海盛大网络发展有限公司 | A kind of database failure transfer method and device based on cloud hard disk |
| CN103780417A (en) * | 2012-10-23 | 2014-05-07 | 上海盛大网络发展有限公司 | Database failure transfer method based on cloud hard disk and device thereof |
| CN103049348A (en) * | 2012-12-21 | 2013-04-17 | 四川川大智胜软件股份有限公司 | Data fault tolerant storage method under multiserver environment |
| CN103346903B (en) * | 2013-06-20 | 2017-02-15 | 北京捷成世纪科技股份有限公司 | Dual-machine backup method and device |
| CN103346903A (en) * | 2013-06-20 | 2013-10-09 | 北京捷成世纪科技股份有限公司 | Dual-machine backup method and device |
| CN104252485A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Database management platform |
| CN104252500A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Method and device for carrying out fault repairing on database management platform |
| CN104252485B (en) * | 2013-06-29 | 2017-08-04 | 北京新媒传信科技有限公司 | A kind of database management platform |
| CN104252500B (en) * | 2013-06-29 | 2017-11-28 | 北京新媒传信科技有限公司 | The fault repairing method and device of a kind of database management platform |
| CN104348842A (en) * | 2013-07-23 | 2015-02-11 | 腾讯科技（深圳）有限公司 | Route method and route management server of distributed storage system, and distributed storage system |
| CN104601354A (en) * | 2013-10-31 | 2015-05-06 | 深圳市腾讯计算机系统有限公司 | Business log storage method, device and system |
| CN104601354B (en) * | 2013-10-31 | 2019-05-17 | 深圳市腾讯计算机系统有限公司 | A kind of business diary storage method, apparatus and system |
| CN103793538A (en) * | 2014-03-06 | 2014-05-14 | 赛特斯信息科技股份有限公司 | System and method for realizing restoration of web service in case of crash of database |
| CN104216943A (en) * | 2014-06-24 | 2014-12-17 | 用友优普信息技术有限公司 | Method and device for automatically collecting blockage information to facilitate post analysis on database blockage |
| CN105404633B (en) * | 2014-09-16 | 2018-06-19 | 无锡科技职业学院 | A kind of client-based database multi-point backup system and its backup method |
| CN105404633A (en) * | 2014-09-16 | 2016-03-16 | 无锡科技职业学院 | Client based database multi-point backup system and backup method |
| CN104506353A (en) * | 2014-12-23 | 2015-04-08 | 北京奇虎科技有限公司 | Authentication management method, equipment and system |
| CN104679604A (en) * | 2015-02-12 | 2015-06-03 | 大唐移动通信设备有限公司 | Method and device for switching between master node and standby node |
| CN106407069B (en) * | 2015-07-30 | 2019-04-12 | Ls 产电株式会社 | Device and method for the database in management energy management system |
| CN106407069A (en) * | 2015-07-30 | 2017-02-15 | Ls 产电株式会社 | Apparatus and method for managing of database in energy management system |
| US10437792B2 (en) | 2015-07-30 | 2019-10-08 | Lsis Co., Ltd. | Apparatus and method for managing of database in energy management system |
| CN105159944A (en) * | 2015-08-10 | 2015-12-16 | 北京思特奇信息技术股份有限公司 | Database emergency handling method and system |
| CN106814645A (en) * | 2015-11-30 | 2017-06-09 | 株式会社东芝 | Data logger and it is applied to the control method of the data logger |
| CN106897288A (en) * | 2015-12-18 | 2017-06-27 | 阿里巴巴集团控股有限公司 | The service providing method and system of database |
| CN106897288B (en) * | 2015-12-18 | 2021-01-08 | 阿里巴巴集团控股有限公司 | Service providing method and system for database |
| CN105554143A (en) * | 2015-12-25 | 2016-05-04 | 浪潮(北京)电子信息产业有限公司 | High-availability cache server and data processing method and system thereof |
| CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
| CN106254103B (en) * | 2016-07-28 | 2019-08-16 | 北京国电通网络技术有限公司 | A kind of dynamically configurable method and device of RTMP group system |
| CN106254103A (en) * | 2016-07-28 | 2016-12-21 | 北京中电普华信息技术有限公司 | A kind of RTMP group system can Dynamic Configuration and device |
| CN106161644A (en) * | 2016-08-12 | 2016-11-23 | 珠海格力电器股份有限公司 | The distributed system of data process and data processing method thereof |
| CN106161644B (en) * | 2016-08-12 | 2021-11-02 | 珠海格力电器股份有限公司 | Distributed system for data processing and data processing method thereof |
| CN107870830A (en) * | 2016-09-23 | 2018-04-03 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for lifting database availability |
| CN107870830B (en) * | 2016-09-23 | 2021-07-20 | 北京京东尚科信息技术有限公司 | Method and device for improving availability of database |
| CN108154045A (en) * | 2016-12-02 | 2018-06-12 | 航天星图科技（北京）有限公司 | A kind of method for creating authentic data library |
| CN108154045B (en) * | 2016-12-02 | 2019-11-26 | 中科星图股份有限公司 | A method of creation authentic data library |
| CN108259259A (en) * | 2016-12-29 | 2018-07-06 | 北京国双科技有限公司 | Cluster stability diagnostic method and device |
| CN106776157A (en) * | 2017-01-19 | 2017-05-31 | 国网山东省电力公司滨州供电公司 | It is used for the device of big customer's power supply service in a kind of electric power system |
| CN106919478A (en) * | 2017-03-07 | 2017-07-04 | 中国建设银行股份有限公司 | A kind of Website page element backup method and system |
| CN106919478B (en) * | 2017-03-07 | 2020-12-01 | 中国建设银行股份有限公司 | Website page element backup method and system |
| CN107066354A (en) * | 2017-04-18 | 2017-08-18 | 中国银联股份有限公司 | A kind of switching method of database, master server and from server |
| CN107480014A (en) * | 2017-07-24 | 2017-12-15 | 北京奇安信科技有限公司 | A kind of High Availabitity equipment switching method and device |
| CN109491830A (en) * | 2017-09-12 | 2019-03-19 | 北京京东尚科信息技术有限公司 | The method and system in switch data source |
| CN108134854A (en) * | 2017-12-15 | 2018-06-08 | 江苏神州信源系统工程有限公司 | A kind of hot spare method and system based on NAT technologies |
| CN110019484A (en) * | 2018-01-04 | 2019-07-16 | 腾讯科技（深圳）有限公司 | Database Systems and implementation method, management equipment, data interface unit and medium |
| CN108259242B (en) * | 2018-01-12 | 2022-08-12 | 深圳市卓讯信息技术有限公司 | Data exchange management method, terminal, system and computer readable storage medium based on dual-computer disaster recovery backup guarantee mechanism |
| CN108259242A (en) * | 2018-01-12 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | Data exchange management method, terminal, system and computer readable storage medium based on duoble computer disaster-tolerance back-up security mechanism |
| CN108647113A (en) * | 2018-03-30 | 2018-10-12 | 阿里巴巴集团控股有限公司 | A kind of Disaster Recovery Method and server |
| CN108959604B (en) * | 2018-07-13 | 2020-11-10 | 浙江彩虹鱼科技有限公司 | Method, apparatus and computer readable storage medium for maintaining database cluster |
| CN108959604A (en) * | 2018-07-13 | 2018-12-07 | 浙江彩虹鱼科技有限公司 | Safeguard the method, apparatus and computer readable storage medium of data-base cluster |
| CN110865907B (en) * | 2018-08-27 | 2022-04-15 | Ovh公司 | Method and system for providing service redundancy between master server and slave server |
| CN110865907A (en) * | 2018-08-27 | 2020-03-06 | Ovh公司 | Method and system for providing service redundancy between master server and slave server |
| CN109474674B (en) * | 2018-10-26 | 2021-06-25 | 腾讯科技(成都)有限公司 | Content transmission method and device, storage medium and electronic device |
| CN109474674A (en) * | 2018-10-26 | 2019-03-15 | 腾讯科技(成都)有限公司 | Transmission method and device, storage medium, the electronic device of content |
| CN110347343B (en) * | 2019-07-16 | 2020-09-18 | 珠海格力电器股份有限公司 | Data management method and device |
| CN110347343A (en) * | 2019-07-16 | 2019-10-18 | 珠海格力电器股份有限公司 | Data managing method and device |
| CN111414247A (en) * | 2020-04-24 | 2020-07-14 | 北京金山云网络技术有限公司 | Server switching method, device, management node and storage medium |
| CN111641716A (en) * | 2020-06-01 | 2020-09-08 | 第四范式（北京）技术有限公司 | Self-healing method of parameter server, parameter server and parameter service system |
| CN111641716B (en) * | 2020-06-01 | 2023-05-02 | 第四范式（北京）技术有限公司 | Self-healing method of parameter server, parameter server and parameter service system |
| CN111966488A (en) * | 2020-07-17 | 2020-11-20 | 北京思特奇信息技术股份有限公司 | Interface gateway multi-center application system and method |
| CN111966488B (en) * | 2020-07-17 | 2024-04-23 | 北京思特奇信息技术股份有限公司 | Interface gateway multi-center application system and method |
| CN114661827A (en) * | 2022-05-23 | 2022-06-24 | 武汉四通信息服务有限公司 | Database taking-over method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101876924B (en) | 2013-10-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101876924B (en) | Database fault automatic detection and transfer method | |
| CN201497981U (en) | Database failure automatic detecting and shifting system | |
| EP3352433B1 (en) | Node connection method and distributed computing system | |
| US9753954B2 (en) | Data node fencing in a distributed file system | |
| US7882286B1 (en) | Synchronizing volumes for replication | |
| US9286298B1 (en) | Methods for enhancing management of backup data sets and devices thereof | |
| EP2435916B1 (en) | Cache data processing using cache cluster with configurable modes | |
| CN100547558C (en) | The method and system of the redundancy protecting in the concurrent computational system | |
| CN102137017B (en) | Working method and device used for virtual network unit | |
| US9734025B2 (en) | Automatic client side seamless failover | |
| US11892922B2 (en) | State management methods, methods for switching between master application server and backup application server, and electronic devices | |
| CN101388759A (en) | Method and system for implementing from asynchronous copy to synchronous copy by data | |
| CN101989922A (en) | Method and system for recovering session initial protocol affairs | |
| CN111787055B (en) | Redis-based transaction mechanism and multi-data center oriented data distribution method and system | |
| CN111740877B (en) | Link detection method and system | |
| CN108512753B (en) | Method and device for transmitting messages in cluster file system | |
| CN113065963B (en) | Futures chairman trading system | |
| CN113961397A (en) | High-availability cluster disaster tolerance method based on backup disaster tolerance system | |
| CN105323271A (en) | Cloud computing system, and processing method and apparatus thereof | |
| CN101102176A (en) | A data backup method | |
| CN107404511B (en) | Method and device for replacing servers in cluster | |
| CN111309515A (en) | Disaster recovery control method, device and system | |
| CN113630317B (en) | Data transmission method and device, nonvolatile storage medium and electronic device | |
| CN107590032A (en) | The method and storage cluster system of storage cluster failure transfer | |
| CN114422335A (en) | Communication method, communication device, server and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20160526 Address after: 201800, room 8, building 25, 2260 North Street, Wai Gang Town, Shanghai, Jiading District Patentee after: Shanghai spades Interactive Network Technology Co., Ltd. Address before: 2415 room 2, Gangcheng Road, Pudong New Area, Shanghai, 201204 Patentee before: Shengdong Network Technology Development (Shanghai) Co., Ltd. |