CN100431371C - System for automatic switching database in imputation position register and method thereof - Google Patents
System for automatic switching database in imputation position register and method thereof Download PDFInfo
- Publication number
- CN100431371C CN100431371C CNB2005100387388A CN200510038738A CN100431371C CN 100431371 C CN100431371 C CN 100431371C CN B2005100387388 A CNB2005100387388 A CN B2005100387388A CN 200510038738 A CN200510038738 A CN 200510038738A CN 100431371 C CN100431371 C CN 100431371C
- Authority
- CN
- China
- Prior art keywords
- database
- standby
- node
- main
- processing module
- 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.)
- Expired - Fee Related
Links
Images
Abstract
The present invention discloses an automatic switching system of a databank in a home location register(HLR), which comprises a service processing module and a main databank node connected to the service processing module. The present invention is characterized in that the automatic switching system also comprises a standby databank node containing the databank and a databank information monitoring center, wherein the standby databank node is respectively connected with the service processing module and the main databank node, and is used for replicating the data of the main databank node; the database information monitoring center is respectively connected with the service processing module and the main databank node, and is used for monitoring the running condition of the service processing module accessing the databank according to the databank configured information of the main databank node and for sending out a databank switching instruction when the databank is in the abnormal running state. When the abnormal databank system of the HLR causes users' service failure, the present invention can automatically switch to the standby databank so as to ensure that the service is carried out persistently and stably.
Description
Technical field
The present invention relates to PHS, GSM and 3G mobile communication system, relate in particular in the mobile communication system when the customer service failure appears causing unusually in the Database Systems of HLR, database is automatically switched to the method for standby database.
Background technology
In PHS, GSM and 3G mobile communication system, user's base attribute, various subscription data and positional information all are kept at its HLR (Home Location Register, attaching position register) in, the user capacity of HLR is substantially all more than 100,000 grades.Any user stop answering a pager's call etc. service handling, called out or during change in location, all may need to get in touch with HLR, inquiry, modification user data, and notice corresponding network device, therefore, HLR is an exigent system of real-time, and the safe and stable operation of its database is the vital ring of mobile communication system, directly has influence on the degree of recognition of user to operator.
Most HLR database system adopts the mode of active and standby two-machine server visit shared data bank magnetic battle array, just often mainly uses server access, switches to standby server and visit the magnetic battle array when server or network are unusual.The fail safe of magnetic battle array is very high, causes database access failure in the time of can avoiding the unit fault like this, but the service fail that causes unusually of and database itself unusual for duplex software is with regard to intractable.Can't guarantee that professional normally continuing carry out.
Summary of the invention
Technical problem to be solved by this invention is to provide system for automatic switching database and method thereof in a kind of attaching position register, be used for when the customer service failure appears causing unusually in the Database Systems of HLR, database can be automatically switched to standby database, to guarantee the continual and steady of business.
To achieve these goals, the invention provides system for automatic switching database in a kind of attaching position register, comprising:
Service Processing Module;
The master who is connected with described Service Processing Module uses database node, and wherein, described master comprises main with database server and standby database server with database node;
The standby database node that contains database, it connects described Service Processing Module, the main database node of using respectively, to be used to duplicate described main data with database node; And
Database information Surveillance center, it connects described Service Processing Module, the main database node of using respectively, being used for main monitoring the described main ruuning situation of described Service Processing Module visit,, described master then sends the database switching command when unusual when being in the running status of database node with database node with the database configuration information of database node according to described; It is characterized in that,
Described master is contained an agent process module with database server, is used to accept and carries out switching command that described database information Surveillance center issues and then realize switching to described standby database server from described master with database server by active and standby duplex software.
System for automatic switching database in the above-mentioned attaching position register, wherein, described main with the Database Systems of database node for organizing by active and standby duplex software, by the main database magnetic battle array of sharing with database server control, when the master breaks down with database server, switch to the standby database server and control described database magnetic battle array when normally moving by active and standby duplex software.
System for automatic switching database in the above-mentioned attaching position register, it is characterized in that described database switching command comprises if described standby database server exception then further send instructions so that described master is switched to described standby database node with database node.
System for automatic switching database in the above-mentioned attaching position register, wherein, described standby database node is the Database Systems that adopt single database server.
System for automatic switching database in the above-mentioned attaching position register, wherein, described standby database node is a plurality of.
In order to realize above-mentioned purpose better, the present invention also provides the database that is used for said system automatic switching method, comprising:
Step 61, the HLR Database system starting stage, described database information Surveillance center will lead with database node information and standby database nodal information and be sent to described Service Processing Module;
Step 62, described Service Processing Module are called database access interface and are connected main use database server and processing service data;
Step 63, described the Service Processing Module regularly current main database server running status of using in notification database information monitoring center are normal or unusual; And
Step 64, the described main running status with database server of described database information Surveillance center's statistics determines whether that according to statistics the active and standby machine that carries out database server switches.
Above-mentioned database automatic switching method, wherein, described step 64 further comprises: switch to the standby database server from main with database server, if described standby database server operation exception, then described database information Surveillance center notifies described Service Processing Module to switch to the standby database node from main with database node.
Above-mentioned database automatic switching method wherein, surpasses a predetermined threshold if described standby database server is in the duration of abnormality, then switches to the standby database node from main with database node.
Above-mentioned database automatic switching method, wherein, if described master surpasses a predetermined threshold with the duration that database server is in abnormality, then switch to the standby database server with database server from main, and if business is normally carried out after described switching, system normally carries out with regard to continuing, if and described standby database server exception just further switches to the standby database node from main with database node.
Above-mentioned database automatic switching method, wherein, by the running status of the autonomous judgment data of the internal logic of described Service Processing Module storehouse server.
Describe the present invention below in conjunction with the drawings and specific embodiments, but not as a limitation of the invention.
Description of drawings
Fig. 1 realizes the structural representation that database automaticallyes switch in the attaching position register system for the present invention.
Wherein, Reference numeral:
10 database information Surveillance center, 11 Service Processing Modules
12 is main with database server 13 standby database servers
14 database magnetic battle arrays, 15 database servers
16 database magnetic battle arrays
1～7 step (1)～step (7)
Embodiment
The invention provides the method that database automaticallyes switch in a kind of attaching position register system, this method at ordinary times with database from main with database replication to standby database, occur switching to the standby database node fast when unusual with database node main, thereby guaranteed professional continual and steady.
Be to realize the technical problem to be solved in the present invention, the method that database automaticallyes switch in a kind of attaching position register of the present invention system comprises following content:
One, suitably increases the standby database node according to the database configuration information in the HLR system, database information Surveillance center is set simultaneously;
Two, require specified data storehouse fault permissible delay and switching mode etc. according to professional real-time;
Three, according to the data integrity index, as the record number that allows to lose, allow the insecure dominant record number of data etc., come specified data storehouse copy mode;
Four, configuration HLR system service data provides the flexible operating mode.
Above-mentioned method, its characteristics are, content one is supported all commercial data bases, thereby select to provide multiple possibility to system configuration; Content two can carry out Autonomous Control to the original two-shipper switching mode of HLR database, and it is complete inadequately and fault that cause is omitted to have avoided two-shipper to switch software, has increased the monitoring that two-shipper is switched, and the two-stage switching mode that flexible selection can be arranged is provided simultaneously; Content three because can the service feature of HLR system be exerted an influence during database replication, so need select different replication strategies according to the real-time specific requirement of database, reaches the complete best combination of service feature and data; Content four, the mode of automatic switchover can be sent action command immediately when the system failure, but the manual intervention processing also is indispensable, can increase the flexibility of operation like this.
Figure 1 shows that the present invention realizes the structural representation that database automaticallyes switch in the attaching position register system, the invention provides when the customer service failure takes place to cause unusually the HLR system database, database is automatically switched to the method for standby database.Title in the system shown in Figure 1 is described as follows: to the stopping answering a pager's call and accept operation, called out or unit that activity such as change in location is controlled of mobile subscriber, need carry out real-time frequent access in the Service Processing Module 11:HLR system database.
The master uses database node: the Database Systems that adopt traditional active and standby duplex software to organize, control the database magnetic battle array of sharing 14 by main with database server 12 during normal the operation, when the master breaks down with database server 12, switch to the standby database server 13 magnetic battle array 14 of controlling database by duplex software, externally show as single database.
The standby database node: based on cost consideration, adopt the Database Systems of single database server 15, database magnetic battle array 16, its data are duplicated with database node by main.
Database information Surveillance center 10: according to database configuration information the situation of Service Processing Module 11 accessing databases is monitored, when unusual, can be sent the unit of change action instruction.
This system configuration has following characteristics:
1), on traditional two-shipper Database Systems basis, increase the standby database node, object as database replication, be used for quasi real time the user data that duplicates, the strategy that duplicates can be selected according to the scope that system allows, if it is unreliable than multi-user data to allow to have, can adopt the strategy that duplicates every day when database switches; If bigger, can adopt the replication strategy of avoiding the peak traffic time to the systematic function influence; If take into account the influence of each side, also can adopt the strategy of incremental replication.
2), increase independent database information monitoring center 10 in the HLR system, this center 10 has database configuration information maintenance, statistics and analyzes the function of the reported data of Service Processing Module 11, the control of database server two-shipper and sync database configuration information.Database information Surveillance center 10 is at system's starting stage informing business processing module 11 current the main with database and preliminary data library information of connection that need, according to being set, condition triggers when switching at the unusual needs of database, main to the database server initiation with the inner two-shipper switching of database node, the perhaps instruction of between Service Processing Module 11 initiation database nodes, switching.
3), increase agent process on database server 12, accept also to carry out the instruction that database information Surveillance center 10 sends, finish the database two-shipper and switch HLR master.
Concrete switch step is described as follows:
Step (1): the HLR system starting stage, database information Surveillance center 10 is sent to Service Processing Module 11 with database node information;
Step (2): Service Processing Module 11 calls database access interface connection master and uses database, the industry of going forward side by side affair data manipulation;
Step (3): Service Processing Module 11 is notification database information monitoring center 10 current database running statuses (normal or unusual) regularly, and the database running status can independently be judged by the internal logic of Service Processing Module 11;
Step (4): database information Surveillance center 10 staqtistical data base running statuses, when running status is in abnormality for a long time, and the duration, database information Surveillance center 10 notified the master to carry out the two-shipper switching with the agent process on the database server 12 immediately when having surpassed the setting threshold values;
Step (5): the active and standby machine of database server switches, and the current database server transfers to standby, and the standby database server transfers the main database server, HLR business process used to and keeps professional the continuation normally to carry out after switching is finished;
Step (6): if standby database server 13 can normally move, then the HLR system restoration normally moves.If standby database server 13 is still unusual, database information Surveillance center 10 is according to the reporting message of Service Processing Module 11, the statistics back finds that database still is in abnormality for a long time, and the duration has been when having surpassed setting threshold, then database information Surveillance center 10 immediately informing business processing module 11 switch to the standby database node;
Step (7): Service Processing Module 11 reconnects to the standby database node according to the data that database information Surveillance center 10 provides, and carries out business in database server 15, thereby has guaranteed that professional continuing carries out.
Wherein configuration can be selected according to actual conditions in step (4) and (5), switches as the first order; The precondition and the time threshold that switch are determined according to actual conditions by system.For example, have important mobile subscriber business in Service Processing Module 11 is handled, comprise position renewal and calling etc., less important business is also arranged as registering supplementary service etc., can be according to the requirement of operator, important content is occurred unusual as the precondition of switching, unusually the lasting time be 1 minute or 5 minutes also can be according to the requirement setting of operator.It is can fast once more quick-recovery normal that step (6) and (7) have guaranteed to switch under the uncontrollable situation such as unusual business at two-shipper, reduced system failure time.
Certainly; the present invention also can have other various embodiments; under the situation that does not deviate from spirit of the present invention and essence thereof; those of ordinary skill in the art work as can make various corresponding changes and distortion according to the present invention, but these corresponding changes and distortion all should belong to the protection range of the appended claim of the present invention.
Claims (10)
1, system for automatic switching database in a kind of attaching position register comprises:
Service Processing Module;
The master who is connected with described Service Processing Module uses database node, and wherein, described master comprises main with database server and standby database server with database node;
The standby database node that contains database, it connects described Service Processing Module, the main database node of using respectively, to be used to duplicate described main data with database node; And
Database information Surveillance center, it connects described Service Processing Module, the main database node of using respectively, being used for main monitoring the described main ruuning situation of described Service Processing Module visit,, described master then sends the database switching command when unusual when being in the running status of database node with database node with the database configuration information of database node according to described; It is characterized in that,
Described master is contained an agent process module with database server, is used to accept and carries out switching command that described database information Surveillance center issues and then realize switching to described standby database server from described master with database server by active and standby duplex software.
2, system for automatic switching database in the attaching position register according to claim 1, it is characterized in that, described main with the Database Systems of database node for organizing by described active and standby duplex software, by the main database magnetic battle array of sharing with database server control, when described master breaks down with database server, switch to described standby database server and control described database magnetic battle array during its normal operation by described active and standby duplex software.
3, system for automatic switching database in the attaching position register according to claim 1, it is characterized in that, described database switching command comprises if described standby database server exception then further send instructions, so that described master is switched to described standby database node with database node.
4, system for automatic switching database in the attaching position register according to claim 1 is characterized in that, described standby database node is the Database Systems that adopt single database server.
5, system for automatic switching database in the attaching position register according to claim 4 is characterized in that, described standby database node is a plurality of.
6, a kind of database automatic switching method that is used for any one described system of claim 1-5 is characterized in that, comprising:
Step 61, the HLR Database system starting stage, described database information Surveillance center will lead with database node information and standby database nodal information and be sent to described Service Processing Module;
Step 62, described Service Processing Module are called database access interface and are connected main use database server and processing service data;
Step 63, described the Service Processing Module regularly current main database server running status of using in notification database information monitoring center are normal or unusual; And
Step 64, the described main running status with database server of described database information Surveillance center's statistics determines whether that according to statistics the active and standby machine that carries out database server switches.
7, database automatic switching method according to claim 6, it is characterized in that, described step 64 further comprises: switch to the standby database server from main with database server, if described standby database server operation exception, then described database information Surveillance center notifies described Service Processing Module to switch to the standby database node from main with database node.
8, database automatic switching method according to claim 7 is characterized in that, surpasses a predetermined threshold if described standby database server is in the duration of abnormality, then switches to the standby database node from main with database node.
9, database automatic switching method according to claim 6, it is characterized in that, if described master surpasses a predetermined threshold with the duration that database server is in abnormality, then switch to the standby database server with database server from main, and if business is normally carried out after described switching, system normally carries out with regard to continuing, if and described standby database server exception just further switches to the standby database node from main with database node.
10, database automatic switching method according to claim 6 is characterized in that, by the running status of the autonomous judgment data of the internal logic of described Service Processing Module storehouse server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100387388A CN100431371C (en) | 2005-04-04 | 2005-04-04 | System for automatic switching database in imputation position register and method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100387388A CN100431371C (en) | 2005-04-04 | 2005-04-04 | System for automatic switching database in imputation position register and method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1848989A CN1848989A (en) | 2006-10-18 |
| CN100431371C true CN100431371C (en) | 2008-11-05 |
Family
ID=37078309
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005100387388A Expired - Fee Related CN100431371C (en) | 2005-04-04 | 2005-04-04 | System for automatic switching database in imputation position register and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100431371C (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101106548B (en) * | 2007-07-10 | 2010-06-16 | 中兴通讯股份有限公司 | Device and method for realizing storage and disaster tolerance in multimedia message service system |
| CN102841895B (en) * | 2011-06-22 | 2015-06-24 | 阿里巴巴集团控股有限公司 | Method and system for processing database state transition |
| CN102902779B (en) * | 2012-09-28 | 2016-03-02 | 五八有限公司 | A kind of method of attachment of multiple database and device |
| CN103914354A (en) * | 2012-12-31 | 2014-07-09 | 北京新媒传信科技有限公司 | Method and system for database fault recovery |
| CN103077242B (en) * | 2013-01-11 | 2016-03-09 | 北京佳讯飞鸿电气股份有限公司 | The method of a kind of fulfillment database server two-node cluster hot backup |
| CN104156360B (en) * | 2013-05-13 | 2018-01-02 | 阿里巴巴集团控股有限公司 | Business data processing method and system |
| CN105447029B (en) * | 2014-08-27 | 2019-06-21 | 阿里巴巴集团控股有限公司 | Method for processing business and equipment when a kind of database failure |
| US11030045B2 (en) | 2015-07-28 | 2021-06-08 | Futurewei Technologies, Inc. | Apparatus and method for utilizing different data storage types to store primary and replicated database directories |
| CN106570021A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Database connection establishment method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1428969A (en) * | 2001-12-24 | 2003-07-09 | 华为技术有限公司 | Method for setting backup attaching position register |
| US20030140273A1 (en) * | 2001-12-20 | 2003-07-24 | Ajay Kamalvanshi | Method and apparatus for fault tolerant persistency service on network device |
| CN1553716A (en) * | 2003-06-04 | 2004-12-08 | 中兴通讯股份有限公司 | Clustering system for utilizing sharing internal memory in mobile communiation system and realizing method thereof |
| CN1568027A (en) * | 2003-06-24 | 2005-01-19 | 中兴通讯股份有限公司 | A method of disaster recovery for home location register (HLR) with zero-time service take-over |
-
2005
- 2005-04-04 CN CNB2005100387388A patent/CN100431371C/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030140273A1 (en) * | 2001-12-20 | 2003-07-24 | Ajay Kamalvanshi | Method and apparatus for fault tolerant persistency service on network device |
| CN1428969A (en) * | 2001-12-24 | 2003-07-09 | 华为技术有限公司 | Method for setting backup attaching position register |
| CN1553716A (en) * | 2003-06-04 | 2004-12-08 | 中兴通讯股份有限公司 | Clustering system for utilizing sharing internal memory in mobile communiation system and realizing method thereof |
| CN1568027A (en) * | 2003-06-24 | 2005-01-19 | 中兴通讯股份有限公司 | A method of disaster recovery for home location register (HLR) with zero-time service take-over |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1848989A (en) | 2006-10-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100431371C (en) | System for automatic switching database in imputation position register and method thereof | |
| US11223690B2 (en) | Service management modes of operation in distributed node service management | |
| RU2507703C2 (en) | Resource pooling in electronic board cluster switching centre server | |
| EP1906681B1 (en) | Changeover-to-backup technique in a computer system | |
| EP1532799B1 (en) | High availability software based contact centre | |
| CN103581289A (en) | Method and system conducive to service provision and coordination of distributed computing system | |
| CN101645800B (en) | Upgrading method and system of computer telecommunication integrated device | |
| CN101977124A (en) | Service clustering method and system based on ZooKeeper technology | |
| CN101277217B (en) | Redundant configuration method of a storage system maintenance/management apparatus and apparatus using the same method | |
| CN101267345B (en) | Service node backup method and distributed system | |
| CN102467508A (en) | Method for providing database service and database system | |
| CN103795553A (en) | Switching of main and standby servers on the basis of monitoring | |
| CN102761528A (en) | System and method for data management | |
| CN101945180A (en) | Fault processing system of call center seats and method | |
| CN105227385A (en) | A kind of method and system of troubleshooting | |
| CN102752093A (en) | Distributed file system-based data processing method, device and system | |
| CN101110776A (en) | Backup method, backup device and backup system for data business | |
| CN103856357A (en) | Stack system fault processing method and stack system | |
| CN109901951A (en) | A kind of storage system and method for ceph company-data | |
| CN100490343C (en) | A method and device for realizing switching between main and backup units in communication equipment | |
| JPH05244653A (en) | Common data base duplex system for mobile communication system | |
| CN101001396A (en) | Call processing method in intelligent network | |
| CN109753292A (en) | A kind of method and device for disposing multiple applications in more single instance database services | |
| CN112612654B (en) | Multi-host-standby switching method of air traffic control automation system and redundant service system | |
| KR20090127574A (en) | Method and system of dual authentication service for measuring obstacle using dynamic query switch of heterogeneous db |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20081105 Termination date: 20150404 |
|
| EXPY | Termination of patent right or utility model |