CN101464888A - Smooth upgrading apparatus and method for information system - Google Patents
Smooth upgrading apparatus and method for information system Download PDFInfo
- Publication number
- CN101464888A CN101464888A CNA2008102417150A CN200810241715A CN101464888A CN 101464888 A CN101464888 A CN 101464888A CN A2008102417150 A CNA2008102417150 A CN A2008102417150A CN 200810241715 A CN200810241715 A CN 200810241715A CN 101464888 A CN101464888 A CN 101464888A
- Authority
- CN
- China
- Prior art keywords
- database
- storer
- update content
- source
- record
- 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)
- Stored Programmes (AREA)
Abstract
The invention discloses a device and a method for smoothly upgrading an information system. The device comprises a database synchronization management module, a database system and a memorizer F, wherein, the database system consists of a new version database and at least one old version database; a synchronizer trigger used for recording modifications is respectively arranged in the databases; the memorizer F is connected with the database system and is used for recording updating information; when a database is changed, the synchronizer trigger arranged inside the database records asynchronous updating contents automatically according to marks for operation source and records the asynchronous updating contents into the memorizer F; the updating content in the memorizer F is monitored on a real-time basis by the database synchronization management module; and synchronous operations among databases can be performed. The invention ensures that the uninterrupted running can be realized during the information system upgrading process.
Description
Technical field
The present invention relates to infotech, relate in particular to a kind of apparatus and method of infosystem smooth upgrade.
Background technology
In the continuous perfecting process of infosystem, the infosystem version needs from low to high constantly upgrading and upgrades.When infosystem was upgraded, existing method was issue one announcement, stops the operation of original information system in a period of time, resumes operation behind the system upgrade again.When the infosystem scale is big, node is many, and during broad covered area, the meeting out of service of system brings very big negative effect, sometimes even can bring loss to the user; In addition, also some system does not allow interrupt run.Therefore, to finish the upgrading of system be the technical barrier that industry needs to be resolved hurrily to the state how to run without interruption in system.
Summary of the invention
The objective of the invention is to overcome above-mentioned problems of the prior art, a kind of apparatus and method that allow the infosystem smooth upgrade under the state that system runs without interruption are provided, can there be the program of a plurality of versions and the old and new's database to move simultaneously in this method guarantee information system escalation process, finish system upgrade work smoothly.
The infosystem upgrading that the present invention relates to comprises database and program.
The device of the infosystem smooth upgrade that the present invention proposes comprises: by the Database Systems that a new edition database and at least one old version database constitute, be respectively arranged with the synchronizer trigger of a record change in new edition database and the old version database; One database synchronization administration module; And one connect Database Systems and write down the storer F of lastest imformation; When change takes place in a database, the synchronizer trigger that is provided with in it identifies the asynchronous update content of record automatically according to the operation source, and should asynchronous update content record among the storer F, update content among the real-time monitoring memory F of database synchronization administration module, the synchronous operation between the line data storehouse of going forward side by side.
The present invention can also comprise a storer F1 who is connected with storer F, is used to write down the lastest imformation of synchronous mistake.
The method of the infosystem smooth upgrade that the present invention proposes comprises the following steps:
(1) when infosystem is upgraded, the database synchronization administration module is created a new edition database, and this new edition database carries out topology update by old version database, and the data in the old synchronously simultaneously version database are in the new edition database;
(2) in new edition and boss's database, create the synchronizer trigger that is used for the recorded information change respectively;
(3) program that connects old version database is upgraded, the new edition program after the renewal connects the new edition database;
When (4) database information changed, synchronizer trigger operation in it was at first judged to upgrade and is operated source OS, if this renewal operation source OS is an asynchronous operation, then adds update content and is recorded among the storer F;
(5) database synchronization administration module real-time retrieval storer F if there is new update content record, then takes out this more new record, judges the storehouse, renewal source in the update content record, and other database is upgraded synchronously.
Compared with prior art, the advantage that has of the present invention is: the escalation process infosystem can run without interruption; Allow many version programs in the escalation process and deposit; Can realize between a plurality of databases synchronously.
Description of drawings
The present invention is described in detail below in conjunction with embodiment and accompanying drawing, wherein:
Fig. 1 is the structured flowchart of one embodiment of the invention;
Fig. 2 is a process flow diagram embodiment illustrated in fig. 1.
Embodiment
The infosystem upgrading of indication of the present invention comprises the upgrading of database and program.
Fig. 1 is the theory diagram of one embodiment of the invention.Among this embodiment, the device of the infosystem smooth upgrade that the present invention proposes comprises: by the Database Systems that a new edition database and at least one old version database constitute, be respectively arranged with the synchronizer trigger of a record change in new edition database and the old version database; One database synchronization administration module; And one connect Database Systems and write down the storer F of lastest imformation.When change takes place in a database, the synchronizer trigger that is provided with in it identifies the asynchronous update content of record automatically according to the operation source, and should asynchronous update content record among the storer F, update content among the real-time monitoring memory F of database synchronization administration module, the synchronous operation between the line data storehouse of going forward side by side.
As shown in Figure 2, the method for the infosystem smooth upgrade of the present invention's proposition comprises the following steps:
(1) when infosystem is upgraded, the database synchronization administration module is created a new edition database D 2, this database D 2 be by old version database D 1 through structure updating, purpose is to carry out synchronous between database D 1 and the D2;
(2) in database D 1, D2, create synchronizer trigger A1 and the A2 that is used for the recorded information change respectively;
(3) program that connects old version database D 1 is upgraded, the new edition program after the renewal connects new edition database D 2;
(4) when database D 1 or D2 information-change, synchronizer trigger A1 in it or A2 operation are at first judged and are upgraded operation source OS, are asynchronous operation if should renewals operate the OS that originates, and then add update content and are recorded among the storer F;
(5) database synchronization administration module real-time retrieval storer F if there is new update content record, takes out this more new record, and the storehouse, renewal source in the judgement update content record, if the storehouse, source is D1, the content of upgrading is taken out from database D 1, be synchronized in the database D 2; If the storehouse, source is D2, then the content of upgrading is taken out from database D 2, be synchronized in the database D 1, simultaneously the update content record is transferred among the F1 from F.
The asynchronous update content of described synchronizer trigger record comprises storehouse, source, the unique identification information R of lastest imformation content in the storehouse, source and the mode of upgrading operation upgraded.
After all application program updates are finished, the trigger A2 in delete database D1 and the database D 2.
In one embodiment of the invention, update content being added the step that records among the storer F is finished by synchronizer trigger.The position that the database synchronization administration module is installed can be the position that database server, intermediate server or other can be operated database.
In above-mentioned embodiment, storer F, the F1 of described preservation update content can be one or many tables of data, also can be that file or other modes exist; And the mode that is used for change source, judgment data storehouse is database connection user, also can be the Hostname that database connects client C, can certainly be that database connects user and the combination that is connected client C Hostname.In addition, database connects the user can be fixed in program, also can be configured by configuration file.
In embodiments of the present invention, following variation can also be arranged:
(1) to database D1 and database D 2 synchronously, in synchronizer trigger, call storing process, go to add changed content information in storer F by storing process.
(2) to database D1 and database D 2 synchronously, in synchronizer trigger, call storing process, go to add changed content information in storer F by storing process, changed content information exists with sql statement and storehouse, renewal source form, during management by synchronization module sync database, directly carry out the sql statement.
(3) comprise the infosystem of a plurality of versions as infosystem, when database synchronization, equally also want synchronous a plurality of databases.
(4), be altered to and synchronizer trigger is arranged to invalid mode realizes to the synchronizer trigger among database D2 deletion.
The present invention can be applied to the infosystem of a plurality of versions, and the infosystem quantity of different editions can be two, three, also can be more.
The present invention's infosystem in escalation process can run without interruption, and allows the infosystem of many versions in the escalation process and deposit.
Though in conjunction with the embodiments the present invention is had been described in detail above, under edifying, the above-mentioned explanation of those skilled in the art can make multiple variation, and these variations should be included within claims of the present invention scope required for protection.
Claims (9)
1, a kind of device of infosystem smooth upgrade, its feature comprises: by the Database Systems that a new edition database and at least one old version database constitute, be respectively arranged with the synchronizer trigger of a record change in new edition database and the old version database; One database synchronization administration module; And one connect Database Systems and write down the storer F of lastest imformation; When change takes place in a database, the synchronizer trigger that is provided with in it identifies the asynchronous update content of record automatically according to the operation source, and should asynchronous update content record among the storer F, update content among the real-time monitoring memory F of database synchronization administration module, the synchronous operation between the line data storehouse of going forward side by side.
2, device as claimed in claim 1 is characterized in that: the asynchronous update content of described synchronizer trigger record comprises upgrades storehouse, source, the unique identification information R of lastest imformation content in the storehouse, source and the mode of operation of upgrading.
3, device as claimed in claim 1 is characterized in that: also comprise a storer F1 who is connected with storer F, be used to write down the lastest imformation of synchronous mistake.
4, device as claimed in claim 1 is characterized in that: the position that the database synchronization administration module is installed is the position that database server, intermediate server or other can be operated database.
5, device as claimed in claim 1 is characterized in that: update content is added the step that records among the storer F finished by synchronizer trigger.
6, a kind of method of infosystem smooth upgrade is characterized in that comprising the following steps:
(1) when infosystem is upgraded, the database synchronization administration module is created a new edition database, and this new edition database carries out topology update by old version database;
(2) in new edition and boss's database, create the synchronizer trigger that is used for the recorded information change respectively;
(3) program that connects old version database is upgraded, the new edition program after the renewal connects the new edition database;
When (4) database information changed, synchronizer trigger operation in it was at first judged to upgrade and is operated source OS, if this renewal operation source OS is an asynchronous operation, then adds update content and is recorded among the storer F;
(5) database synchronization administration module real-time retrieval storer F if there is new update content record, then takes out this more new record, judges the storehouse, renewal source in the update content record, and other database is upgraded synchronously.
7, method as claimed in claim 6 is characterized in that: the asynchronous update content of described synchronizer trigger record comprises upgrades storehouse, source, the unique identification information R of lastest imformation content in the storehouse, source and the mode of operation of upgrading.
8, method as claimed in claim 6 is characterized in that: after comprising that also database synchronization is finished, update content is write down the step of transferring among the storer F1 from storer F.
9, method as claimed in claim 6 is characterized in that: after whole infosystem upgrading is finished, and the trigger in deletion old version database and the new edition database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008102417150A CN101464888B (en) | 2008-12-29 | 2008-12-29 | Smooth upgrading apparatus and method for information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008102417150A CN101464888B (en) | 2008-12-29 | 2008-12-29 | Smooth upgrading apparatus and method for information system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101464888A true CN101464888A (en) | 2009-06-24 |
| CN101464888B CN101464888B (en) | 2010-08-18 |
Family
ID=40805463
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2008102417150A Active CN101464888B (en) | 2008-12-29 | 2008-12-29 | Smooth upgrading apparatus and method for information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101464888B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN102945236A (en) * | 2011-11-29 | 2013-02-27 | Ut斯达康通讯有限公司 | Method for synchronizing different databases by triggering events |
| CN102103613B (en) * | 2009-12-22 | 2013-06-12 | 中兴通讯股份有限公司 | Distributed database upgrade method, upgrade processing device and upgrade control device |
| CN104426975A (en) * | 2013-09-03 | 2015-03-18 | 北京网秦天下科技有限公司 | Method, equipment and system for data synchronization |
| CN106453549A (en) * | 2016-10-08 | 2017-02-22 | 中国工商银行股份有限公司 | Distributed software version release method and system thereof |
| CN108984743A (en) * | 2018-07-16 | 2018-12-11 | 广州友米科技有限公司 | The synchronous method of cross-border data is realized based on local and overseas data centers |
-
2008
- 2008-12-29 CN CN2008102417150A patent/CN101464888B/en active Active
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103613B (en) * | 2009-12-22 | 2013-06-12 | 中兴通讯股份有限公司 | Distributed database upgrade method, upgrade processing device and upgrade control device |
| CN102945236A (en) * | 2011-11-29 | 2013-02-27 | Ut斯达康通讯有限公司 | Method for synchronizing different databases by triggering events |
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN102779191B (en) * | 2012-07-03 | 2015-09-02 | 互动在线（北京）科技有限公司 | A kind of system that realizes of MySQL database smooth upgrade and implementation method |
| CN104426975A (en) * | 2013-09-03 | 2015-03-18 | 北京网秦天下科技有限公司 | Method, equipment and system for data synchronization |
| CN106453549A (en) * | 2016-10-08 | 2017-02-22 | 中国工商银行股份有限公司 | Distributed software version release method and system thereof |
| CN106453549B (en) * | 2016-10-08 | 2019-09-13 | 中国工商银行股份有限公司 | A kind of distributed software version dissemination method and system |
| CN108984743A (en) * | 2018-07-16 | 2018-12-11 | 广州友米科技有限公司 | The synchronous method of cross-border data is realized based on local and overseas data centers |
| CN108984743B (en) * | 2018-07-16 | 2021-04-13 | 广州天高软件科技有限公司 | Method for realizing cross-border data synchronization based on internal and external data centers |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101464888B (en) | 2010-08-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101464888B (en) | Smooth upgrading apparatus and method for information system | |
| CN101650741B (en) | Method and system for updating index of distributed full-text search in real time | |
| CN102521269B (en) | Index-based computer continuous data protection method | |
| CN101706795B (en) | Method for synchronizing data of database in active/standby server | |
| CN102981931B (en) | Backup method and device for virtual machine | |
| CN104506625A (en) | Method for improving reliability of metadata nodes of cloud databases | |
| CN100471134C (en) | Method, device for upgrading telecommunication equipment and upgrading engine unit | |
| CN102497280B (en) | Distributed system and method thereof for realizing management | |
| CN102982087B (en) | A kind of method, device and Database Systems of Test database data consistency | |
| CN104679841A (en) | Consumption terminal data flow copying method and system | |
| CN101621405A (en) | Distributed type management monitoring system, monitoring method and establishing method thereof | |
| CN109189860A (en) | A kind of active and standby increment synchronization method of MySQL based on Kubernetes system | |
| CN102291416A (en) | Two-way synchronizing method and system of client-side and server-side | |
| JP2004334574A (en) | Operation managing program and method of storage, and managing computer | |
| CN107797767A (en) | One kind is based on container technique deployment distributed memory system and its storage method | |
| CN102132259A (en) | Firmware updating system, firmware delivering server, firmware incorporating device, and program | |
| CN106777126B (en) | Data online migration method supporting heterogeneous time sequence database | |
| CN106775702B (en) | Container-based service internal interface discovery method | |
| CN103166984B (en) | System that Network Video Surveillance equipment control is controlled and automatically updates, method | |
| CN103024065A (en) | System configuration management method for cloud storage system | |
| JP6633642B2 (en) | Method and device for processing data blocks in a distributed database | |
| WO2019057193A1 (en) | Data deletion method and distributed storage system | |
| CN106209827A (en) | Virtual card port system based on container cloud and service creating method thereof | |
| CN105045533A (en) | Disk heartbeat transmitting and receiving method suitable for dual-control high-availability memory system | |
| CN103973791A (en) | Rapid uniform storage system of internet of things |
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 |