CN103473328A - MYSQL (my structured query language)-based database cloud and construction method for same - Google Patents
MYSQL (my structured query language)-based database cloud and construction method for same Download PDFInfo
- Publication number
- CN103473328A CN103473328A CN2013104245709A CN201310424570A CN103473328A CN 103473328 A CN103473328 A CN 103473328A CN 2013104245709 A CN2013104245709 A CN 2013104245709A CN 201310424570 A CN201310424570 A CN 201310424570A CN 103473328 A CN103473328 A CN 103473328A
- Authority
- CN
- China
- Prior art keywords
- database
- mysql
- main
- standby
- databases
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
Abstract
The invention relates to a MYSQL (my structured query language)-based database cloud and a construction method for the same. The database cloud comprises MYSQL databases and high-performance storage equipment, wherein the MYSQL databases are deployed on virtual machines of two host computers in a cloud computing environment respectively; the high-performance storage equipment is arranged outside the host computers; the two MYSQL databases are both connected with the high-performance storage equipment through network communication interfaces established by a BONDING technology, are used for storing user data in the high-performance storage equipment outside the host computers after receiving database requests of a user, and performing heartbeat detection, and are synchronized in real time. According to the database cloud, the live migration rapid-deployment of the databases can be realized, high IO (input/output) performance is ensured, and the diversified requirements of a part of services of an enterprise on the databases can also be met.
Description
Technical field
The present invention relates to database technical field, particularly a kind of database cloud and method for building up thereof based on MYSQL.
Background technology
Enterprise is various to the database demand, and especially the demand for the full resource isolated data storehouse product of difference configuration, different capabilities, difference in functionality is day by day strong, disposes at present the diversified demand that the sole disposition database product is difficult to deal with enterprise.The database product existed on market is deployed in physical server substantially, and this just causes migration, it is more difficult to back up and tackle multiple different business demand; If directly dispose database on the empty machine under cloud computing environment, the IO performance of the simple Database Systems of formation can not meet demand, and the security performance of data resource is also poor.
Summary of the invention
The present invention is directed to prior art disposes database and causes migration and tackle multiple different business demand difficulty and problem that simple empty machine deploy Database Systems IO performance can't satisfy the demands in physical server, a kind of database cloud based on MYSQL is provided, thermophoresis rapid deployment that can fulfillment database, and high IO performance is provided, can also tackle the enterprise department separate service demand various to database.The invention still further relates to a kind of method based on MYSQL building database cloud.
Technical scheme of the present invention is as follows:
A kind of database cloud based on MYSQL, it is characterized in that, be included in the MYSQL database of disposing respectively on the empty machine of two hosts in cloud computing environment and the high-performance memory device arranged outside host, the network communication interface that described two MYSQL databases are all set up by the BONDING technology is connected with the high-performance memory device, described MYSQL database receives the high-performance memory device after user's database request, storage of subscriber data arranged outside host, and described MYSQL database carries out heartbeat detection and two MYSQL database real-time synchronizations.
Described two MYSQL databases are with hot standby work pattern, described two MYSQL databases are respectively main MYSQL database and standby MYSQL database, described main MYSQL database receives user's database request, and the user data real-time synchronization is backed up to standby MYSQL database, described main MYSQL database and standby MYSQL database all by storage of subscriber data to described high-performance memory device; Described standby MYSQL database carries out heartbeat detection to main MYSQL database under the state of waiting for, carries out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected.
Described two MYSQL databases are with two holotype work, and described two MYSQL databases are main MYSQL database, and described two main MYSQL databases all receive user's database request, and by storage of subscriber data to described high-performance memory device; The described two mutual heartbeat detection of main MYSQL database are also carried out the mutual backed up in synchronization of user data.
High-performance memory device in described database cloud is SAN memory device or NAS distributed storage device.
A kind of method based on MYSQL building database cloud, it is characterized in that, the method is first disposed respectively the MYSQL database on the empty machine of two hosts in cloud computing environment, the high-performance memory device that the network communication interface that receives user's database request by the MYSOL database again and set up by the BONDING technology arranges storage of subscriber data outside host, described MYSQL database carries out heartbeat detection and utilizes BINLOG to realize two MYSQL database real-time synchronizations.
Described method is set to respectively main MYSQL database and standby MYSQL database by two MYSQL databases, the database request that described main MYSQL database receives the user also backs up to the user data real-time synchronization standby MYSQL database, described main MYSQL database and standby MYSQL database all by storage of subscriber data to described high-performance memory device; Described standby MYSQL database carries out heartbeat detection to main MYSQL database under the state of waiting for, carries out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected.
Described method all is set to main MYSQL database by two MYSQL databases, and described two main MYSQL databases all receive user's database request, and by storage of subscriber data to described high-performance memory device; Described two main MYSQL databases carry out the mutual backed up in synchronization of heartbeat detection and user data mutually.
High-performance memory device in described method is SAN memory device or NAS distributed storage device.
Carry out the data O&M with processing user's data delay or the situation of loss by the PLUGIN technology.
Described two MYSQL databases are encrypted the user data of transmission when real-time synchronization.
Technique effect of the present invention is as follows:
The present invention relates to a kind of database cloud based on MYSQL, be included in the MYSQL database of disposing respectively on the empty machine of two hosts in cloud computing environment and the high-performance memory device arranged outside host, this database cloud is to be based upon the MYSQL dual computer group formed on two empty machines, and store data on the high-performance memory device after the database request that receives the user, make the number of times of the acceptable random access of database storage per second greatly to improve, therefore solved high IOPS problem, avoided prior art directly at empty machine deploy database, to form the problem that simple empty machine data storehouse system IO performance can't meet the demands.This database cloud is by the normal operation of another MYSQL database of function heartbeat detection of a MYSQL data base manipulation self, guarantee the respond services of user's database request, two MYSQL database real-time synchronizations are set, make a MYSQL database the response user database request in can be by backed up in synchronization be checked to the user data of another MYSQL database, the operations such as processing, and do not affect on line the MYSQL database of service, guarantee the security performance of user data resource, two MYSQL databases run on respectively on the empty machine of two different hosts, avoided Single Point of Faliure, use up and load balancing or the read-write separation of fulfillment database, maximization has guaranteed the performance of business continuance and business.Database cloud of the present invention builds on cloud computing environment, based on two MYSQL databases and the extra common cooperating of high-performance memory device, when increasing database volume, can improve the available database performance of height of user data resource isolation, further strengthened the security of data resource, solved again the problem of simple empty machine data storehouse performance deficiency, can also avoid the physical server database to exist migration backup difficulty can't face the problem of different business demand again, the MYSQL database that can move rapidly and back up under cloud computing environment on empty machine forms new database cloud, directly the MYSQL database migration on empty machine is got final product in the network that will dispose, dirigibility is good, reach the effect of thermophoresis rapid deployment database product, and do not need to buy again or move other hardware, reduced manpower, set-up time, installation cost and installation resource.Database cloud of the present invention can provide various database server for enterprise, and then reply enterprise department separate service is to the diversified demand of database.
According to the diversified demand of enterprise, two MYSQL databases in database cloud of the present invention are set to hot standby pattern or two holotype work.Form main MYSQL database and standby MYSQL database under hot standby pattern, main MYSQL database receives user's database request, standby MYSQL database carries out heartbeat detection in waiting status and to main MYSQL database, carry out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected, the database cloud of this hot standby work pattern is applicable to database and writes the little situation of storage pressure, can economize on the user data resource.Write the large situation of storage pressure for database, the database cloud is with two holotype work, two MYSQL form two main MYSQL databases, these two main MYSQL databases all receive user's database request, mutual heartbeat detection carry out the mutual backed up in synchronization of user data, complete two database nodes and tackle Operational Visit simultaneously, can improve database work efficiency.Two MYSQL databases in database cloud of the present invention, with hot standby mode or two holotype work, in conjunction with the high availability with O&M script fulfillment database, have further guaranteed the performance of business continuance and business.
The invention still further relates to a kind of method based on MYSQL building database cloud, first in cloud computing environment, on the empty machine of two hosts, dispose respectively the MYSQL database, by the high-performance memory device that the MYSOL database receives user's database request and the network communication interface set up by the BONDING technology arranges storage of subscriber data outside host, the method is by cloud computing environment, the empty machine of take on two hosts is unit, dispose the MYSQL dual computer group, by storage of subscriber data on extra high-performance memory device, can solve the IOPS problem, improve the IO performance, utilize the BINLOG that the MYSQL database carries to realize quickly and efficiently two MYSQL database real-time synchronizations, guaranteed the integrality of user data resource, two MYSQL databases run on respectively on the empty machine of two different hosts, avoided Single Point of Faliure, two MYSQL databases are set with hot standby mode or two holotype work, in conjunction with the high availability with O&M script fulfillment database, use up and load balancing or the read-write separation of fulfillment database, maximization has guaranteed the performance of business continuance and business, and can avoid that database part is deployed in to physical server or be deployed in database product migration difficulty that simple empty machine data storehouse system that empty machine forms causes and problem that sole disposition or IO performance can't satisfy the demands, the solution of this database cloud is avoided the drawback of the each side of prior art simultaneously, thermophoresis rapid deployment database product, high IO performance and security performance are provided, and can tackle the diversified demand of enterprise to database.
The accompanying drawing explanation
Fig. 1 is the structural representation that the present invention is based on the database cloud of MYSQL.
Fig. 2 is a kind of preferred structure schematic diagram that the present invention is based on the database cloud of MYSQL.
Fig. 3 is the another kind of preferred structure schematic diagram that the present invention is based on the database cloud of MYSQL.
Fig. 4 is a kind of preferred flow charts that the present invention is based on the method for MYSQL building database cloud.
Fig. 5 is the another kind of preferred flow charts that the present invention is based on the method for MYSQL building database cloud.
Embodiment
Below in conjunction with accompanying drawing, the present invention will be described.
The present invention relates to a kind of database cloud based on MYSQL, its structure as shown in Figure 1, be included in the MYSQL database of disposing respectively on the empty machine of two hosts in cloud computing environment and the high-performance memory device arranged outside host, the network communication interface 1 that two MYSQL databases are all set up by the BONDING technology is connected with the high-performance memory device, the MYSQL database receives the high-performance memory device after user's database request, storage of subscriber data arranged outside host, and the MYSQL database carries out heartbeat detection and two MYSQL database real-time synchronizations.
Diversified demand according to different enterprises, database cloud based on MYSQL can have preferred structure as shown in Figures 2 and 3, MYSQL database in these two embodiment is respectively with hot standby pattern and two holotype work, the high-performance memory device of selecting is the SAN memory device, this SAN memory device is for providing the high-performance memory device of naked dish, certainly, also can be chosen as other high-performance memory devices such as NAS distributed storage devices.
In the embodiment shown in Figure 2, two MYSQL databases are with hot standby work pattern, two MYSQL databases are respectively main MYSQL database and standby MYSQL database, for user's database request, be by the service of main MYSQL database response, and standby MYSQL database are in waiting status.Main MYSQL database receives user's database request and the user data real-time synchronization is backed up to standby MYSQL database, and main MYSQL database and standby MYSQL database are all set up user data network communication interface 1 by the BONDING technology is stored to described SAN memory device.Standby MYSQL database carries out heartbeat detection to main MYSQL database under the state of waiting for, to detect its health status, carries out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected.Certainly, main MYSQL database also can carry out heartbeat detection to standby MYSQL database, to detect the health status of standby MYSQL database.The database cloud of the described hot standby work pattern of this embodiment is a MYSQL database work, and a MYSQL database backup is applicable to write the little situation of storage pressure as website visiting etc. database, and this active-standby mode can be economized on the user data resource.
In the embodiment shown in fig. 3, two MYSQL databases are with two holotype work, and two MYSQL databases are main MYSQL database, for these two main MYSQL databases of database request of user, all carry out respond services.These two main MYSQL databases all receive user's database request, mutually carry out heartbeat detection and carry out the mutual backed up in synchronization of user data, main MYSQL database carries out heartbeat detection and the user data synchronization of oneself storage is backed up to another main MYSQL database another main MYSQL database, and vice versa.These two main MYSQL databases are all set up the user data of oneself network communication interface 1 by the BONDING technology is stored to described SAN memory device.The database cloud of described pair of holotype work of this embodiment is that two main MYSQL databases have been worked two database nodes simultaneously and tackled Operational Visit simultaneously, be applicable to write the large situation of storage pressure as bank handles business of withdrawing cash etc. database of saving, this pair of holotype can improve database work efficiency.
The invention still further relates to a kind of method based on MYSQL building database cloud, it is the method for building up of the described database cloud based on MYSQL in Fig. 1-3 that the method also can be understood as.The method of the invention is first disposed respectively the MYSQL database on the empty machine of two hosts in cloud computing environment, carry out respond services by MYSOL database reception user's database request again, the MYSQL database carries out heartbeat detection and utilizes BINLOG to realize two MYSQL database real-time synchronizations, the high-performance memory device that the network communication interface of being set up by the BONDING technology arranges storage of subscriber data outside host.The central principle of the method based on MYSQL building database cloud is by cloud computing environment, the empty machine of take on two hosts is unit, dispose the database cloud of the dual computer group of the hot standby pattern of MYSQL or two holotypes, improve the IO performance based on high-performance memory device (the naked dish provided as the SAN memory device), the network communication interface that uses the BONDING technology to set up, utilize the BINLOG that the MYSQL database carries to realize quickly and efficiently two MYSQL database real-time synchronizations.
The present invention is based on the method for MYSQL building database cloud, the MYSQL database of disposing respectively hot standby pattern of take in two empty machines is example, and a kind of preferred flow as shown in Figure 4, comprises the steps:
A, in cloud computing environment, on the empty machine of two hosts, dispose respectively the MYSQL database;
B, two MYSQL databases are set to respectively to main MYSQL database and standby MYSQL database; Concrete script operation comprises the configuration file of revising main MYSQL database (also can be called is the host node database) and standby MYSQL database (also can be called the slave node database), in host node database initialize slave node database user the data that copy the host node database to slave node database, i.e. host node database mandate slave node database access data;
C, main MYSQL database receive user's database request, and the user data real-time synchronization is backed up to standby MYSQL database; Concrete script operation is that the slave node database is being closed under the state in storehouse, modifies after action, realizes the initial manual synchronization of two MYSQL databases, the start detection state; Start storehouse and carry out state-detection, when two Yes appear in script, prove that real-time synchronization backs up to start working;
Slave_IO_Running:Yes
Slave_SQL_Running:Yes
Add user data at main MYSQL database and checking from the MYSQL database, the backed up in synchronization success;
D, two MYSQL databases are carried out to health examination, carry out by heartbeat detection, mainly comprise that standby MYSQL database carries out heartbeat detection to main MYSQL database; When main MYSQL database failure being detected, execution step E, otherwise still by main MYSQL database, received user's database request, return to step C and perform step F, omit the step of its initial manual synchronization when execution step C, directly the user data real-time synchronization is backed up to standby MYSQL database;
E, when main MYSQL database failure being detected by the active and standby switching of internal database detection script fulfillment database, received user's database request by standby MYSQL database;
F, no matter be that main MYSQL database or standby MYSQL database are all set up user data network communication interface by the BONDING technology is stored to the high-performance memory device as SAN memory device or NAS distributed storage device.
Fig. 5 is the another kind of preferred flow charts that the present invention is based on the method for MYSQL building database cloud, and the MYSQL database of disposing respectively hot standby pattern of still take in two empty machines is example, comprises the steps:
A, in cloud computing environment, on the empty machine of two hosts, dispose respectively the MYSQL database;
B, two MYSQL databases are set to respectively to main MYSQL database and standby MYSQL database;
C, two MYSQL databases carry out heartbeat detection mutually, mainly comprise that standby MYSQL database carries out heartbeat detection to main MYSQL database, and standby MYSQL database does not carry out respond services for the customer data base request, but in waiting status;
D, main MYSQL database detected when normal, by main MYSQL database, receiving user's database request and the user data real-time synchronization is backed up to standby MYSQL database;
E, when main MYSQL database failure being detected by the active and standby switching of internal database detection script fulfillment database, received user's database request by standby MYSQL database;
F, no matter be that main MYSQL database or standby MYSQL database are all set up user data network communication interface by the BONDING technology is stored to the high-performance memory device as the SAN memory device.
These two processes of heartbeat detection in method based on MYSQL building database cloud of the present invention and two database real-time synchronizations can be carried out simultaneously or successively be carried out.Certainly, also can follow-up increase step process fortuitous event, as causing greatly mass data, stops up network pressure, or unstable networks or accidental interruption, the heartbeat detection situation such as make mistakes, cause data delay or loss or data inconsistent, can utilize ripe O&M technology to realize data delay or the inconsistent situation of individual cases data.Operation from script is that MYSQL has the phenomenon copied not in time in reproduction process, enables alternate solution, to main MYSQL database and standby MYSQL database, divides the configuration script, by the PLUGIN technology, carries out the data O&M, as part is ordered:
INSTALLPLUGINrpl_semi_sync_masterSONAME‘semisync_master.so’；
SHOWVARIABLESLIKE ' rpl_semi_sync_master_enabled ' value is ON, means to open, otherwise checks failure cause;
INSTALLPLUGINrpl_semi_sync_slaveSONAME‘semisync_slave.so’;
SHOWVARIABLESLIKE ' rpl_semi_sync_slave_enabled ' value is ON, means to open; Otherwise unsuccessfully check reason;
Prevent the data degradation that the unexpected collapse of main MYSQL database produces, main MYSQL database is enabled the sync_binlog option.
In addition, preferably, two MYSQL databases can be encrypted the user data of transmission when real-time synchronization, the danger of revealing with the prevention user data.
Except embodiment illustrated in fig. 4, the method that the present invention is based on MYSQL building database cloud can also be disposed respectively the MYSQL database of two holotypes in two empty machines, specifically two MYSQL databases all are set to main MYSQL database, this two main MYSQL database all receives user's database request, and by storage of subscriber data to described SAN memory device; Two main MYSQL databases carry out the mutual backed up in synchronization of heartbeat detection and user data mutually.From script operation, be first on two main MYSQL database place servers (also can be described as empty machine server), to set up separately a user with the authority of copying, if now two servers are new the establishment, tool is without other write operation, each server only need record current own binary log file and event location, and what using surpasses the beginning position as other server replicates.Next each server specifies another station server is oneself master server, as example:
Mysql1>changemasterto172.20.80.72,master_log_file=’a’,master_log_pos=111;
Mysql2>changemasterto172.20.80.71,master_log_file=’b’,master_log_pos=222;
Two holotypes have greater risk in business, in order better to allow two holotypes serve service application, can adopt more professional two principal solutions scheme mysql-mmm that determines to realize in addition the script of re-synchronization function between data backup, node.Can first configure the authority of mysql-mmm agency and account monitoring, the all config options of mysql-mmm all have been integrated in the individual files of a cry/etc/mysql-mmm/mmm_common.conf, start mmm, utilize mmm_control monitoring MYSQL database place server state, test sees that can two servers realize that fault automatically switches.Solve the data inconsistency problem, can utilize the orders such as pt-table-checksum, and can realize the automatic fault forwarding function; By mysqljk program judgement database availability.
It should be pointed out that the above embodiment can make the invention of those skilled in the art's comprehend, but do not limit the present invention in any way creation.Therefore; although this instructions has been described in detail the invention with reference to drawings and Examples; but; those skilled in the art are to be understood that; still can modify or be equal to replacement the invention; in a word, all do not break away from technical scheme and the improvement thereof of the spirit and scope of the invention, and it all should be encompassed in the middle of the protection domain of the invention patent.
Claims (10)
1. the database cloud based on MYSQL, it is characterized in that, be included in the MYSQL database of disposing respectively on the empty machine of two hosts in cloud computing environment and the high-performance memory device arranged outside host, the network communication interface that described two MYSQL databases are all set up by the BONDING technology is connected with the high-performance memory device, described MYSQL database receives the high-performance memory device after user's database request, storage of subscriber data arranged outside host, and described MYSQL database carries out heartbeat detection and two MYSQL database real-time synchronizations.
2. the database cloud based on MYSQL according to claim 1, it is characterized in that, described two MYSQL databases are with hot standby work pattern, described two MYSQL databases are respectively main MYSQL database and standby MYSQL database, described main MYSQL database receives user's database request, and the user data real-time synchronization is backed up to standby MYSQL database, described main MYSQL database and standby MYSQL database all by storage of subscriber data to described high-performance memory device; Described standby MYSQL database carries out heartbeat detection to main MYSQL database under the state of waiting for, carries out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected.
3. the database cloud based on MYSQL according to claim 1, it is characterized in that, described two MYSQL databases are with two holotype work, described two MYSQL databases are main MYSQL database, described two main MYSQL databases all receive user's database request, and by storage of subscriber data to described high-performance memory device; The described two mutual heartbeat detection of main MYSQL database are also carried out the mutual backed up in synchronization of user data.
4. according to the described database cloud based on MYSQL of one of claims 1 to 3, it is characterized in that, described high-performance memory device is SAN memory device or NAS distributed storage device.
5. the method based on MYSQL building database cloud, it is characterized in that, the method is first disposed respectively the MYSQL database on the empty machine of two hosts in cloud computing environment, the high-performance memory device that the network communication interface that receives user's database request by the MYSOL database again and set up by the BONDING technology arranges storage of subscriber data outside host, described MYSQL database carries out heartbeat detection and utilizes BINLOG to realize two MYSQL database real-time synchronizations.
6. the method based on MYSQL building database cloud according to claim 5, it is characterized in that, two MYSQL databases are set to respectively to main MYSQL database and standby MYSQL database, the database request that described main MYSQL database receives the user also backs up to the user data real-time synchronization standby MYSQL database, described main MYSQL database and standby MYSQL database all by storage of subscriber data to described high-performance memory device; Described standby MYSQL database carries out heartbeat detection to main MYSQL database under the state of waiting for, carries out the active and standby switching of database and then received user's database request by standby MYSQL database when main MYSQL database failure being detected.
7. the method based on MYSQL building database cloud according to claim 5, it is characterized in that, two MYSQL databases all are set to main MYSQL database, and described two main MYSQL databases all receive user's database request, and by storage of subscriber data to described high-performance memory device; Described two main MYSQL databases carry out the mutual backed up in synchronization of heartbeat detection and user data mutually.
8. according to the described method based on MYSQL building database cloud of one of claim 5 to 7, it is characterized in that, described high-performance memory device is SAN memory device or NAS distributed storage device.
9. the method based on MYSQL building database cloud according to claim 8, is characterized in that, by the PLUGIN technology, carries out the data O&M with processing user's data delay or the situation of loss.
10. the method based on MYSQL building database cloud according to claim 5, is characterized in that, described two MYSQL databases are encrypted the user data of transmission when real-time synchronization.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104245709A CN103473328A (en) | 2013-09-17 | 2013-09-17 | MYSQL (my structured query language)-based database cloud and construction method for same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104245709A CN103473328A (en) | 2013-09-17 | 2013-09-17 | MYSQL (my structured query language)-based database cloud and construction method for same |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103473328A true CN103473328A (en) | 2013-12-25 |
Family
ID=49798176
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013104245709A Pending CN103473328A (en) | 2013-09-17 | 2013-09-17 | MYSQL (my structured query language)-based database cloud and construction method for same |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103473328A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281506A (en) * | 2014-07-10 | 2015-01-14 | 中国科学院计算技术研究所 | Data maintenance method and system for file system |
| CN104331508A (en) * | 2014-11-21 | 2015-02-04 | 浪潮(北京)电子信息产业有限公司 | Management system and method for realizing load balance of relational database |
| CN105516365A (en) * | 2016-01-22 | 2016-04-20 | 浪潮电子信息产业股份有限公司 | Management method of distributed mirror image storage block equipment based on network |
| CN105739960A (en) * | 2014-12-11 | 2016-07-06 | 上海尚景信息技术有限公司 | Software development environment framework capable of being continuously integrated |
| CN106452864A (en) * | 2016-09-30 | 2017-02-22 | 北京悦畅科技有限公司 | Parking lot fault protection method, apparatus and system thereof |
| CN106570021A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Database connection establishment method and device |
| CN109254876A (en) * | 2018-09-11 | 2019-01-22 | 郑州云海信息技术有限公司 | The management method and device of database in cloud computing system |
| CN110019346A (en) * | 2017-12-29 | 2019-07-16 | 北京京东尚科信息技术有限公司 | A kind of data processing method and device based on double primary databases |
| CN110569303A (en) * | 2019-08-19 | 2019-12-13 | 杭州衣科信息技术有限公司 | MySQL application layer high-availability system and method suitable for various cloud environments |
| CN112527596A (en) * | 2020-12-03 | 2021-03-19 | 福建省索菲特智能工程有限公司 | Method for judicial supervision safety monitoring |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101997884A (en) * | 2009-08-18 | 2011-03-30 | 升东网络科技发展(上海)有限公司 | Distributed storage system and method |
| US20120084252A1 (en) * | 2009-10-21 | 2012-04-05 | Delphix Corp. | Datacenter Workflow Automation Scenarios Using Virtual Databases |
| CN102495853A (en) * | 2011-11-17 | 2012-06-13 | 成都康赛电子科大信息技术有限责任公司 | Aspect-oriented cloud storage engine construction method |
| CN103199972A (en) * | 2013-03-25 | 2013-07-10 | 成都瑞科电气有限公司 | Double machine warm backup switching method and warm backup system achieved based on SOA and RS485 bus |
-
2013
- 2013-09-17 CN CN2013104245709A patent/CN103473328A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101997884A (en) * | 2009-08-18 | 2011-03-30 | 升东网络科技发展(上海)有限公司 | Distributed storage system and method |
| US20120084252A1 (en) * | 2009-10-21 | 2012-04-05 | Delphix Corp. | Datacenter Workflow Automation Scenarios Using Virtual Databases |
| CN102495853A (en) * | 2011-11-17 | 2012-06-13 | 成都康赛电子科大信息技术有限责任公司 | Aspect-oriented cloud storage engine construction method |
| CN103199972A (en) * | 2013-03-25 | 2013-07-10 | 成都瑞科电气有限公司 | Double machine warm backup switching method and warm backup system achieved based on SOA and RS485 bus |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281506A (en) * | 2014-07-10 | 2015-01-14 | 中国科学院计算技术研究所 | Data maintenance method and system for file system |
| CN104331508A (en) * | 2014-11-21 | 2015-02-04 | 浪潮(北京)电子信息产业有限公司 | Management system and method for realizing load balance of relational database |
| CN104331508B (en) * | 2014-11-21 | 2017-12-29 | 浪潮(北京)电子信息产业有限公司 | A kind of implementation relation type database loads balanced management system and method |
| CN105739960A (en) * | 2014-12-11 | 2016-07-06 | 上海尚景信息技术有限公司 | Software development environment framework capable of being continuously integrated |
| CN106570021A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Database connection establishment method and device |
| CN105516365A (en) * | 2016-01-22 | 2016-04-20 | 浪潮电子信息产业股份有限公司 | Management method of distributed mirror image storage block equipment based on network |
| CN106452864A (en) * | 2016-09-30 | 2017-02-22 | 北京悦畅科技有限公司 | Parking lot fault protection method, apparatus and system thereof |
| CN110019346A (en) * | 2017-12-29 | 2019-07-16 | 北京京东尚科信息技术有限公司 | A kind of data processing method and device based on double primary databases |
| CN109254876A (en) * | 2018-09-11 | 2019-01-22 | 郑州云海信息技术有限公司 | The management method and device of database in cloud computing system |
| CN110569303A (en) * | 2019-08-19 | 2019-12-13 | 杭州衣科信息技术有限公司 | MySQL application layer high-availability system and method suitable for various cloud environments |
| CN112527596A (en) * | 2020-12-03 | 2021-03-19 | 福建省索菲特智能工程有限公司 | Method for judicial supervision safety monitoring |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103473328A (en) | MYSQL (my structured query language)-based database cloud and construction method for same | |
| US9747179B2 (en) | Data management agent for selective storage re-caching | |
| US11194677B2 (en) | Configuration inconsistency identification between storage virtual machines | |
| US11468014B2 (en) | Resynchronization to a filesystem synchronous replication relationship endpoint | |
| US9037822B1 (en) | Hierarchical volume tree | |
| US9842033B2 (en) | Storage cluster failure detection | |
| US9817721B1 (en) | High availability management techniques for cluster resources | |
| US20220058159A1 (en) | Cloned virtual machine disk replication | |
| US8726072B1 (en) | System and method for improving cluster performance using an operation thread for passive nodes | |
| US10191958B1 (en) | Storage provisioning in a data storage environment | |
| JP2004532442A (en) | Failover processing in a storage system | |
| CN107430603A (en) | The system and method for MPP database | |
| KR20110044858A (en) | Maintain data indetermination in data servers across data centers | |
| CN102622427A (en) | Method and system for read-write splitting database | |
| US10452502B2 (en) | Handling node failure in multi-node data storage systems | |
| US9830237B2 (en) | Resynchronization with compliance data preservation | |
| CN105262633A (en) | Application-level disaster tolerant method and application-level disaster system | |
| US11762814B2 (en) | Synchronous replication for synchronous mirror copy guarantee | |
| CN110175089A (en) | A kind of dual-active disaster recovery and backup systems with read and write abruption function | |
| US20210406280A1 (en) | Non-disruptive transition to synchronous replication state | |
| US20230081436A1 (en) | Dependency aware parallel splitting of operations | |
| WO2024120227A1 (en) | Container data protection system, method and apparatus, and device and readable storage medium | |
| EP3896571B1 (en) | Data backup method, apparatus and system | |
| CN116389233B (en) | Container cloud management platform active-standby switching system, method and device and computer equipment | |
| CN104765798A (en) | System and method for achieving Mysql remote synchronous fault tolerance enhancement |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20131225 |
|
| RJ01 | Rejection of invention patent application after publication |