CN109254876A - The management method and device of database in cloud computing system - Google Patents

The management method and device of database in cloud computing system Download PDF

Info

Publication number
CN109254876A
CN109254876A CN201811055607.4A CN201811055607A CN109254876A CN 109254876 A CN109254876 A CN 109254876A CN 201811055607 A CN201811055607 A CN 201811055607A CN 109254876 A CN109254876 A CN 109254876A
Authority
CN
China
Prior art keywords
node
database
address
service
primary
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201811055607.4A
Other languages
Chinese (zh)
Inventor
孙辽东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhengzhou Yunhai Information Technology Co Ltd
Original Assignee
Zhengzhou Yunhai Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Zhengzhou Yunhai Information Technology Co Ltd filed Critical Zhengzhou Yunhai Information Technology Co Ltd
Priority to CN201811055607.4A priority Critical patent/CN109254876A/en
Publication of CN109254876A publication Critical patent/CN109254876A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1464Management of the backup or restore process for networked environments

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses the management methods and device of database in a kind of cloud computing system.The described method includes: obtaining the primary node of mysql database and the address information of standby node;When the primary node is in running order, according to the primary address of node information, the standby node for controlling the mysql database backs up the data of the primary node;When the physical resource and/or application resource for detecting the primary node occur abnormal, the database address for modifying the service node connecting with mysql database is the address of the standby node;Control the request that the standby node proceeds to respond to the service node using the data of backup.

Description

The management method and device of database in cloud computing system
Technical field
The present invention relates to field of information processing, the management method and device of database in espespecially a kind of cloud computing system.
Background technique
Cloud computing (Cloud Computing) is the increase, use and delivery mode of related service Internet-based, is led to Often it is related to providing the resource of dynamic easily extension and often virtualization by internet.Cloud is a kind of ratio of network, internet Explain saying.Past often indicates telecommunications network in figure with cloud, also is used to indicate the pumping of internet and underlying infrastructure later As.Therefore, cloud computing even can allow you to experience the operational capability of 10 trillion times per second, and possessing so powerful computing capability can With simulated-nuclear explosion, Prediction of Climate Change and market trend.User accesses number by modes such as computer, notebook, mobile phones According to center, operation is carried out by the demand of oneself.
Definition to cloud computing, well accepted at this stage is National Institute of Standards and Technology's definition: cloud computing It is a kind of mode paid by usage amount, this mode provides available, convenient and fast, on-demand network access, into configurable Computing resources shared pool, wherein resource includes network, server, storage, application software and service etc., these resources can be by It quickly provides, only need to put into seldom management work, or carry out seldom interaction with service supplier.In Constructing data center Initial stage be mainly complete network, calculating, storage are built, construct unified resource management platform, complete the unitized pipe of resource Reason and autonomous service;User gradually pays close attention to the real service condition of resource in subsequent development process, preferably to plan The use of resource and control resource.
In the use process of cloud management platform, with the continuous enhancing of uninterrupted critical business needs, data base administration The high availability of this core component of system is increasingly by the attention of industry, and user's safety for data and system High availability put forward higher requirements.Current data redundancy and cluster are designed to the first choice of database high availability scheme, that The efficiency that High Availabitity database how to be improved in active-standby switch is a problem to be solved.
Summary of the invention
In order to solve the above-mentioned technical problems, the present invention provides the management methods and dress of database in a kind of cloud computing system It sets, can be improved the switching efficiency of the High Availabitity of database.
In order to reach the object of the invention, the present invention provides a kind of management methods of database in cloud computing system, comprising:
Obtain the primary node of mysql database and the address information of standby node;
When the primary node is in running order, according to the primary address of node information, the mysql is controlled The standby node of database backs up the data of the primary node;
When the physical resource and/or application resource for detecting the primary node occur abnormal, modification and mysql data The database address of the service node of library connection is the address of the standby node;
Control the request that the standby node proceeds to respond to the service node using the data of backup.
Wherein, the method also has a characteristic that described according to the primary address of node information, described in control Before the standby node of mysql database backs up the data of the primary node, the method also includes:
Obtain the primary node and the respective management account of the standby node;
The binding relationship of the management account of the primary node and the management account of the standby node is established, and configures benefit With the permission of the data of respective management account access other side.
Wherein, the method also has a characteristic that
The physical resource of the primary node is detected by following at least one mode, comprising:
Whether the remaining space for detecting the disk of the primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
Wherein, the method also has a characteristic that the data of the service node modified and connect with mysql database Before library address is the address of the standby node, the method also includes:
When the service node application is to the mysql database application service request, local whether for the first time Shen is judged It please service request;
If it is service request is applied for for the first time, then the address information of the service node is increased into pre-stored node In list;
The database address for modifying the service node connecting with mysql database is the address of the standby node, Include:
Using the node listing being locally stored, the node recorded into the node listing is with sending modification database service The message of location.
Wherein, the method also has a characteristic that the node listing that the utilization is locally stored, to the node listing After the node of middle record sends the message of modification database service address, the method also includes:
Receive the modification result that the service node is sent;
If it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, then retransmit modification The message of database service address, modification result and modification result until receiving the service node transmission are successfully to be Only.
The managing device of database in a kind of cloud computing system, comprising:
First obtains module, for obtaining the primary node of mysql database and the address information of standby node;
First control module, for when the primary node is in running order, according to the primary address of node Information, the standby node for controlling the mysql database back up the data of the primary node;
Modified module, for repairing when the physical resource and/or application resource for detecting the primary node occur abnormal The database address for changing the service node connecting with mysql database is the address of the standby node;
Second control module proceeds to respond to the service node using the data of backup for controlling the standby node Request.
Wherein, described device also has a characteristic that described device further include:
Second obtains module, for backing up the number of the primary node in the standby node for controlling the mysql database According to before, the primary node and the respective management account of the standby node are obtained;
Management module, for establishing the binding of the management account of the primary node and the management account of the standby node Relationship, and configure the permission of the data using respective management account access other side.
Wherein, described device also has a characteristic that described device further include:
Detection module, for detecting the physical resource of the primary node by following at least one mode, comprising: inspection Whether the remaining space for surveying the disk of the primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
Wherein, described device also has a characteristic that described device further include:
Judgment module, the database address of the service node for connecting in modification with mysql database are described spare Before address of node, when the service node application is to the mysql database application service request, judge it is local whether Apply for service request for the first time;
Logging modle, for if it is service request is applied for for the first time, then increasing to the address information of the service node In pre-stored node listing;
The node that the modified module is used to record using the node listing being locally stored into the node listing is sent Modify the message of database service address.
Wherein, described device also has a characteristic that described device further include:
Receiving module, for sending the message of modification database service address in the node recorded into the node listing Later, the modification result that the service node is sent is received;
Retransmit module, for if it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, The message for then retransmitting modification database service address, until receiving the modification result and modification knot that the service node is sent Until fruit is successful.
Embodiment provided by the invention, the primary node of acquisition mysql database and the address information of standby node, and When the primary node is in running order, according to the primary address of node information, the standby of the mysql database is controlled The data of primary node described in node standby, realize the backup of the data of database, are detecting the primary node When physical resource and/or application resource occur abnormal, the database address for modifying the service node connecting with mysql database is The address of the standby node becomes new primary node, and controls the standby node and proceeded to respond to using the data of backup The request of the service node, entire active and standby process is managed by address, is reduced the interaction time of switching, is not only protected Hinder the safety row of user data, and reduced operation cost, improves competitiveness of the cloud platform in similar product.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by specification, right Specifically noted structure is achieved and obtained in claim and attached drawing.
Detailed description of the invention
Attached drawing is used to provide to further understand technical solution of the present invention, and constitutes part of specification, with this The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is the flow chart of the management method of database in cloud computing system provided by the invention;
Fig. 2 is the structure chart of the managing device of database in cloud computing system provided by the invention.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application Feature can mutual any combination.
Step shown in the flowchart of the accompanying drawings can be in a computer system such as a set of computer executable instructions It executes.Also, although logical order is shown in flow charts, and it in some cases, can be to be different from herein suitable Sequence executes shown or described step.
Fig. 1 is the flow chart of the management method of database in cloud computing system provided by the invention.Method packet shown in Fig. 1 It includes:
The address information of step 101, the primary node for obtaining mysql database and standby node;
Step 102, when the primary node is in running order, according to the primary address of node information, control The standby node of the mysql database backs up the data of the primary node;
Step 103, when the physical resource and/or application resource for detecting the primary node occur abnormal, modification with The database address of the service node of mysql database connection is the address of the standby node;
Step 104, the control standby node proceed to respond to the request of the service node using the data of backup.
Embodiment of the method provided by the invention obtains the primary node of mysql database and the address information of standby node, And when the primary node is in running order, according to the primary address of node information, the mysql database is controlled Standby node back up the data of the primary node, realize the backup of the data of database, detecting the primary section When the physical resource and/or application resource of point occur abnormal, with modifying the database for the service node connecting with mysql database Location is the address of the standby node, becomes new primary node, and controls the standby node and continued using the data of backup The request of the service node is responded, entire active and standby process is managed by address, reduces the interaction time of switching, no It has only ensured the safety row of user data, and has reduced operation cost, improved competition of the cloud platform in similar product Power.
Method provided by the invention is described further below:
Current data redundancy and cluster are designed to the first choice of database high availability scheme, in order to solve this problem, this case The carrying out safety backup of database data itself is realized using a kind of principal and subordinate based on mysql itself, and complete by automatized script At the dynamic heavy duty of switching and the service of database address.The safety row of user data has not only been ensured by this case, and Operation cost is reduced, competitiveness of the cloud platform in similar product is improved.
The basic thought of scheme of the invention provided by the invention, specific as follows:
1) main and subordinate node completes database principal and subordinate configuration, is automatically performed by script;
2) main and subordinate node database positioning monitors;
3) host node database service automatically switch, when monitor host node database it is unavailable when, use script batch The database service address for modifying various components is from node database address;
4) host node database recovery, using from node data library backup file access pattern host node database, and again Configuration database master-slave relationship.
It is described according to the primary address of node information in an embodiment of the method provided by the invention, control institute Before the data that the standby node for stating mysql database backs up the primary node, the method also includes:
Obtain the primary node and the respective management account of the standby node;
The binding relationship of the management account of the primary node and the management account of the standby node is established, and configures benefit With the permission of the data of respective management account access other side.
Specifically, for the backed up in synchronization for guaranteeing data, and guarantee that the safety accessed is after configuring main-standby nodes Main-standby nodes open up corresponding management account, and the binding relationship by establishing corresponding management account, and configured with access pair The permission of the management account of side, to guarantee the normal access of data.
Unlike the prior art, the present invention is by hard when whether the primary node of detection needs to switch over What part and software aspects detected the working condition of node, compared with judging whether not available mode in the past, the present invention Judge whether the working condition to hardware and software overloads.Due to overload can cause that primary node is abnormal can Can, therefore, the overload of the primary node is judged, when for overloading, active-standby switch process is triggered, to mention Before overcome the generation of risk, specific overload detection mode is specific as follows:
The physical resource of the primary node is detected by following at least one mode, comprising:
Whether the remaining space for detecting the disk of the primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
Judge through the above way whether the hardware and software of primary node overloads, using as triggering active-standby switch Process.
The service node communicated for convenience with primary node changes the address of service of database in time, passes through active management Address modification order, can be effectively reduced the time of modification, concrete implementation mode is as follows:
It is described modify the database address of service node that is connect with mysql database for the standby node address it Before, the method also includes:
When the service node application is to the mysql database application service request, local whether for the first time Shen is judged It please service request;
If it is service request is applied for for the first time, then the address information of the service node is increased into pre-stored node In list;
The database address for modifying the service node connecting with mysql database is the address of the standby node, Include:
Using the node listing being locally stored, the node recorded into the node listing is with sending modification database service The message of location.
Specifically, collecting the address information of service node when service node is to primary node initiating business request;It is sending out After raw active-standby switch operation, using the address information of collection, the message of modification address of service is sent to the node of these addresses, is led to Know that new primary node is revised as in address of service by service node, to continue to service, improves switching efficiency.
In order to further ensure the success of the address of service of service node, the node listing that the utilization is locally stored, to After the node recorded in the node listing sends the message of modification database service address, the method also includes:
Receive the modification result that the service node is sent;
If it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, then retransmit modification The message of database service address, modification result and modification result until receiving the service node transmission are successfully to be Only.
Specifically, judging business section by receiving the modification result of service node after the message for sending modified address Whether point is successfully modified, and to guarantee to continue to be communicated with database, will continue to the service node modified to no success Message is sent, to guarantee the normal operation of database service after switching.
Method provided by the invention is described further with application example provided by the invention below:
A kind of scheme that cloud platform High Availabitity is realized based on MySql principal and subordinate that application example of the present invention provides includes principal and subordinate's section Point completes principal and subordinate's setting of database, the monitoring of main and subordinate node database positioning, host node database service automatic switchover, host node Database recovery.Specific implementation process is as follows:
1) main and subordinate node completes database principal and subordinate configuration, specifically includes:
It modifies to mysql configuration file, the data of host node is backed up, configuration uses backup file from node Restore;It is wherein realized when data backup by setting master-slave synchronisation account, by appointing from node turn-on data library backup is synchronous Business;
2) main and subordinate node database positioning monitors, and specifically includes:
Physical resource monitoring: whether disk service condition, memory service condition, network strategy can be used;
Application resources monitor: database service state, from node database Status of Backups;
3) host node database service automatically switch, when monitor host node database it is unavailable when, use script batch The database service address for modifying various components is from node database address;
4) host node database recovery, using from node data library backup file access pattern host node database, and again Configuration database master-slave relationship.
The method that application example of the present invention provides, has not only ensured the safety row of user data, and reduce operation Cost improves competitiveness of the cloud platform in similar product.
Fig. 2 is the structure chart of the managing device of database in cloud computing system provided by the invention.Fig. 2 shown device packet It includes:
First obtains module 201, for obtaining the primary node of mysql database and the address information of standby node;
First control module 202, for when the primary node is in running order, according to the ground of the primary node Location information, the standby node for controlling the mysql database back up the data of the primary node;
Modified module 203, it is abnormal for occurring in the physical resource and/or application resource for detecting the primary node When, the database address for modifying the service node connecting with mysql database is the address of the standby node;
Second control module 204 proceeds to respond to the business section using the data of backup for controlling the standby node The request of point.
In an Installation practice provided by the invention, described device further include:
Second obtains module, for backing up the number of the primary node in the standby node for controlling the mysql database According to before, the primary node and the respective management account of the standby node are obtained;
Management module, for establishing the binding of the management account of the primary node and the management account of the standby node Relationship, and configure the permission of the data using respective management account access other side.
In an Installation practice provided by the invention, described device further include:
Detection module, for detecting the physical resource of the primary node by following at least one mode, comprising: inspection Whether the remaining space for surveying the disk of the primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
In an Installation practice provided by the invention, described device further include:
Judgment module, the database address of the service node for connecting in modification with mysql database are described spare Before address of node, when the service node application is to the mysql database application service request, judge it is local whether Apply for service request for the first time;
Logging modle, for if it is service request is applied for for the first time, then increasing to the address information of the service node In pre-stored node listing;
The node that the modified module is used to record using the node listing being locally stored into the node listing is sent Modify the message of database service address.
In an Installation practice provided by the invention, described device further include:
Receiving module, for sending the message of modification database service address in the node recorded into the node listing Later, the modification result that the service node is sent is received;
Retransmit module, for if it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, The message for then retransmitting modification database service address, until receiving the modification result and modification knot that the service node is sent Until fruit is successful.
Installation practice provided by the invention obtains the primary node of mysql database and the address information of standby node, And when the primary node is in running order, according to the primary address of node information, the mysql database is controlled Standby node back up the data of the primary node, realize the backup of the data of database, detecting the primary section When the physical resource and/or application resource of point occur abnormal, with modifying the database for the service node connecting with mysql database Location is the address of the standby node, becomes new primary node, and controls the standby node and continued using the data of backup The request of the service node is responded, entire active and standby process is managed by address, reduces the interaction time of switching, no It has only ensured the safety row of user data, and has reduced operation cost, improved competition of the cloud platform in similar product Power.
Those of ordinary skill in the art will appreciate that computer journey can be used in all or part of the steps of above-described embodiment Sequence process realizes that the computer program can be stored in a computer readable storage medium, the computer program exists (such as system, unit, device) executes on corresponding hardware platform, when being executed, include the steps that embodiment of the method it One or combinations thereof.
Optionally, integrated circuit can be used also to realize in all or part of the steps of above-described embodiment, these steps can To be fabricated to integrated circuit modules one by one respectively, or make multiple modules or steps in them to single integrated electricity Road module is realized.In this way, the present invention is not limited to any specific hardware and softwares to combine.
Each device/functional module/functional unit in above-described embodiment, which can be adopted, is realized with general computing device realization, it Can be concentrated on a single computing device, can also be distributed over a network of multiple computing devices.
Each device/functional module/functional unit in above-described embodiment realized in the form of software function module and as Independent product when selling or using, can store in a computer readable storage medium.Computer mentioned above Read/write memory medium can be read-only memory, disk or CD etc..
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any Those familiar with the art in the technical scope disclosed by the present invention, can easily think of the change or the replacement, and should all contain Lid is within protection scope of the present invention.Therefore, protection scope of the present invention should be subject to protection scope described in claim.

Claims (10)

1. the management method of database in a kind of cloud computing system characterized by comprising
Obtain the primary node of mysql database and the address information of standby node;
When the primary node is in running order, according to the primary address of node information, the mysql data are controlled The standby node in library backs up the data of the primary node;
When the physical resource and/or application resource for detecting the primary node occur abnormal, modification connects with mysql database The database address of the service node connect is the address of the standby node;
Control the request that the standby node proceeds to respond to the service node using the data of backup.
2. the method according to claim 1, wherein described according to the primary address of node information, control Before the standby node of the mysql database backs up the data of the primary node, the method also includes:
Obtain the primary node and the respective management account of the standby node;
The binding relationship of the management account of the primary node and the management account of the standby node is established, and is configured using each From management account access other side data permission.
3. according to the method described in claim 1, it is characterized by:
The physical resource of the primary node is detected by following at least one mode, comprising:
Whether the remaining space for detecting the disk of the primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
4. the method according to claim 1, wherein described modify the service node connecting with mysql database Database address be the standby node address before, the method also includes:
When the service node application is to the mysql database application service request, local whether for the first time application clothes are judged Business request;
If it is service request is applied for for the first time, then the address information of the service node is increased into pre-stored node listing In;
The database address for modifying the service node connecting with mysql database is the address of the standby node, comprising:
Using the node listing being locally stored, the node recorded into the node listing sends modification database service address Message.
5. according to the method described in claim 4, it is characterized in that, the node listing that the utilization is locally stored, to the section After the node recorded in point list sends the message of modification database service address, the method also includes:
Receive the modification result that the service node is sent;
If it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, then retransmit modification data The message of library address of service, until the modification result and modification result that receive the service node transmission are successfully.
6. the managing device of database in a kind of cloud computing system characterized by comprising
First obtains module, for obtaining the primary node of mysql database and the address information of standby node;
First control module, for when the primary node is in running order, according to the primary address of node information, The standby node for controlling the mysql database backs up the data of the primary node;
Modified module, for when the physical resource and/or application resource for detecting the primary node occur abnormal, modification with The database address of the service node of mysql database connection is the address of the standby node;
Second control module proceeds to respond to asking for the service node using the data of backup for controlling the standby node It asks.
7. device according to claim 6, which is characterized in that described device further include:
Second obtains module, for backed up in the standby node for controlling the mysql database the primary node data it Before, obtain the primary node and the respective management account of the standby node;
Management module, the binding for establishing the management account of the primary node and the management account of the standby node are closed System, and configure the permission of the data using respective management account access other side.
8. device according to claim 6, which is characterized in that described device further include:
Detection module, for detecting the physical resource of the primary node by following at least one mode, comprising: detection institute Whether the remaining space for stating the disk of primary node is greater than pre-set capacity-threshold;
Whether the memory usage for detecting the primary node is greater than pre-set utilization rate threshold value;
Whether the network state for detecting the primary node is more than pre-set load threshold;
And/or
The application resource of the primary node is detected by following at least one mode, comprising:
Whether the application program detected in the primary node for response external operation is working properly;
Whether the data backup operation for detecting the standby node is working properly.
9. device according to claim 6, which is characterized in that described device further include:
Judgment module, the database address of the service node for connecting in modification with mysql database are the standby node Address before, when the service node application is to the mysql database application service request, judge it is local whether for the first time Apply for service request;
Logging modle, for if it is service request is applied for for the first time, then increasing to the address information of the service node in advance In the node listing of storage;
The node that the modified module is used to record using the node listing being locally stored into the node listing sends modification The message of database service address.
10. device according to claim 9, which is characterized in that described device further include:
Receiving module, for sent in the node that is recorded into the node listing modification database service address message it Afterwards, the modification result that the service node is sent is received;
Retransmit module, for if it exceeds the modification achievement that does not receive or receive of pre-set period be it is failed, then weigh The new message for sending modification database service address, modification result and modification result until receiving the service node transmission are Until successfully.
CN201811055607.4A 2018-09-11 2018-09-11 The management method and device of database in cloud computing system Pending CN109254876A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811055607.4A CN109254876A (en) 2018-09-11 2018-09-11 The management method and device of database in cloud computing system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811055607.4A CN109254876A (en) 2018-09-11 2018-09-11 The management method and device of database in cloud computing system

Publications (1)

Publication Number Publication Date
CN109254876A true CN109254876A (en) 2019-01-22

Family

ID=65047252

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811055607.4A Pending CN109254876A (en) 2018-09-11 2018-09-11 The management method and device of database in cloud computing system

Country Status (1)

Country Link
CN (1) CN109254876A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111200532A (en) * 2020-01-02 2020-05-26 广州虎牙科技有限公司 Method, device, equipment and medium for master-slave switching of database cluster node
CN111444062A (en) * 2020-04-01 2020-07-24 山东汇贸电子口岸有限公司 Method and device for managing master node and slave node of cloud database
CN111770154A (en) * 2020-06-24 2020-10-13 百度在线网络技术(北京)有限公司 Service detection method, device, equipment and storage medium
CN111857548A (en) * 2019-04-29 2020-10-30 杭州海康威视系统技术有限公司 Data reading method, device and system
CN116192441A (en) * 2022-12-12 2023-05-30 深圳崎点数据有限公司 Digital park emergency treatment system and method

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101309167A (en) * 2008-06-27 2008-11-19 华中科技大学 Disaster allowable system and method based on cluster backup
CN102739453A (en) * 2012-07-03 2012-10-17 华为软件技术有限公司 Master-standby switching method, device and system
CN103473328A (en) * 2013-09-17 2013-12-25 中电长城网际系统应用有限公司 MYSQL (my structured query language)-based database cloud and construction method for same
CN105095317A (en) * 2014-05-23 2015-11-25 中国银联股份有限公司 Distributive database service management system
CN106850269A (en) * 2016-12-29 2017-06-13 曙光信息产业(北京)有限公司 A kind of management system of cloud platform
CN108093094A (en) * 2017-12-08 2018-05-29 腾讯科技(深圳)有限公司 Database instance access method, device, system, storage medium and equipment

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101309167A (en) * 2008-06-27 2008-11-19 华中科技大学 Disaster allowable system and method based on cluster backup
CN102739453A (en) * 2012-07-03 2012-10-17 华为软件技术有限公司 Master-standby switching method, device and system
CN103473328A (en) * 2013-09-17 2013-12-25 中电长城网际系统应用有限公司 MYSQL (my structured query language)-based database cloud and construction method for same
CN105095317A (en) * 2014-05-23 2015-11-25 中国银联股份有限公司 Distributive database service management system
CN106850269A (en) * 2016-12-29 2017-06-13 曙光信息产业(北京)有限公司 A kind of management system of cloud platform
CN108093094A (en) * 2017-12-08 2018-05-29 腾讯科技(深圳)有限公司 Database instance access method, device, system, storage medium and equipment

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111857548A (en) * 2019-04-29 2020-10-30 杭州海康威视系统技术有限公司 Data reading method, device and system
CN111857548B (en) * 2019-04-29 2023-05-30 杭州海康威视系统技术有限公司 Data reading method, device and system
CN111200532A (en) * 2020-01-02 2020-05-26 广州虎牙科技有限公司 Method, device, equipment and medium for master-slave switching of database cluster node
CN111444062A (en) * 2020-04-01 2020-07-24 山东汇贸电子口岸有限公司 Method and device for managing master node and slave node of cloud database
CN111444062B (en) * 2020-04-01 2023-09-19 山东汇贸电子口岸有限公司 Method and device for managing master node and slave node of cloud database
CN111770154A (en) * 2020-06-24 2020-10-13 百度在线网络技术(北京)有限公司 Service detection method, device, equipment and storage medium
CN111770154B (en) * 2020-06-24 2023-12-05 百度在线网络技术(北京)有限公司 Service detection method, device, equipment and storage medium
CN116192441A (en) * 2022-12-12 2023-05-30 深圳崎点数据有限公司 Digital park emergency treatment system and method
CN116192441B (en) * 2022-12-12 2023-08-08 深圳崎点数据有限公司 Digital park emergency treatment system and method

Similar Documents

Publication Publication Date Title
CN109254876A (en) The management method and device of database in cloud computing system
CN111290834B (en) Method, device and equipment for realizing high service availability based on cloud management platform
CN105229613A (en) Coordinate the fault recovery in distributed system
RU2604519C2 (en) Cross-cloud management and troubleshooting
CN109151045B (en) Distributed cloud system and monitoring method
CN104158693B (en) The disaster-tolerant backup method and system of data service
US20190235979A1 (en) Systems and methods for performing computing cluster node switchover
WO2019152122A1 (en) Systems and methods for performing computing cluster node switchover
CN104408071A (en) Distributive database high-availability method and system based on cluster manager
CN105337780B (en) A kind of server node configuration method and physical node
CN103199972A (en) Double machine warm backup switching method and warm backup system achieved based on SOA and RS485 bus
CN105159798A (en) Dual-machine hot-standby method for virtual machines, dual-machine hot-standby management server and system
CN103188098B (en) A kind of disaster tolerance switching method, system and device
CN111935244B (en) Service request processing system and super-integration all-in-one machine
CN105577408A (en) Method of VNFM disaster recovery protection, apparatus and NFVO thereof
CN113467873A (en) Virtual machine scheduling method and device, electronic equipment and storage medium
CN105404530B (en) It is a kind of to realize easy deployment and the system and method using private clound
CN113419889A (en) Automatic fault switching method and device for payment system
CN104753992A (en) Method, device and system for data storage and method and device for virtual platform failure recovery
CN109842526B (en) Disaster recovery method and device
CN101262479A (en) A network file share method, server and network file share system
CN103902401A (en) Virtual machine fault tolerance method and device based on monitoring
CN112073499A (en) Dynamic service method of multi-machine type cloud physical server
CN116192885A (en) High-availability cluster architecture artificial intelligent experiment cloud platform data processing method and system
CN115291891A (en) Cluster management method and device and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20190122