CN106919654A - A kind of implementation method of the High Availabitity MySQL database based on Nginx - Google Patents
A kind of implementation method of the High Availabitity MySQL database based on Nginx Download PDFInfo
- Publication number
- CN106919654A CN106919654A CN201710059502.5A CN201710059502A CN106919654A CN 106919654 A CN106919654 A CN 106919654A CN 201710059502 A CN201710059502 A CN 201710059502A CN 106919654 A CN106919654 A CN 106919654A
- Authority
- CN
- China
- Prior art keywords
- server
- database
- data
- nginx
- database server
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of implementation method of the High Availabitity MySQL database based on Nginx, it includes Web server cluster, master-slave database server cluster, Nginx Reverse Proxies, page cache server and data cache server;User sends connection request to Nginx Reverse Proxies, Nginx Reverse Proxies forward the request to Web server cluster, Web server receives the request, first page cache server with corresponding data have been searched whether in data cache server, if in the presence of directly using data cached;If not existing, by database fastening means DBConnection analyses, SQL statement judges read-write operation and is connected to corresponding master-slave database server, and master-slave database server is operated and returns the result to Web server accordingly.This method realizes digital independent and is separated with data write-in.
Description
Technical field
The present invention relates to server cluster, database High Availabitity technical field, specifically a kind of High Availabitity based on Nginx
The implementation method of MySQL database.
Background technology
With the fast development of technology, it is more and more with the approach of storage information that people obtain information, wherein surf the Net into
It is people's information and the main path for exchanging.But increasing with Internet numbers of users, website visiting amount increases increasingly
Greatly, how the request that quick response client sends turns into a problem to server.Therefore, how to provide it is a kind of quick, reliable,
Easy to implement and maintenance, the database server High Availabitity solution of the fast quick-recovery of failure become particularly important.
The content of the invention
In order to solve large-scale MySQL database software platform, service disruption causes the problem that business is paused for a long time, this hair
It is bright that a kind of implementation method of the High Availabitity MySQL database based on Nginx is provided, digital independent is realized with dividing that data write
From while the access mode of design architecture based on traditional relational data and SQL is not changed, can possessing reply big
The scalability of concurrency and big data quantity allow the application to be obtained on the premise of making no modifications it is high can
Autgmentability and high availability.
The present invention is realized with following technical scheme:A kind of realization side of the High Availabitity MySQL database based on Nginx
Method, it includes Web server cluster, master-slave database server cluster, Nginx Reverse Proxies, page cache service
Device and data cache server;User sends connection request, Nginx Reverse Proxies to Nginx Reverse Proxies
Web server cluster is forwarded the request to, Web server receives the request, delayed in page cache server and data first
Deposit and searched whether corresponding data in server, if in the presence of directly using data cached;If not existing, by data
Storehouse fastening means DBConnection analyzes SQL statement and judges read-write operation and be connected to corresponding master-slave database server,
Master-slave database server is operated and is returned the result to Web server accordingly.
Further, when Web server receives the request from Reverse Proxy Nginx, Web server passes through
DBConnection analyzes SQL statement, judges the action type that will be carried out to data place, is specifically divided into read operation and writes behaviour
Make two kinds of situations:
(1) when DBConnection analysis SQL statement draw be write operation when, can in main database server cluster with
Machine selects a main database server in idle upstate, performs the write operation of data;
(2) when DBConnection analysis SQL statement draw be read operation when, can from database server cluster according to
Secondary selection one sets a SECO to prevent dirty reading, i.e., herein in idle upstate from database server
A timing information, the real-time for ensuring data query are added when data are distributed.
Further, database manipulation workflow is write as follows:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, and analyzing SQL statement by database fastening means DBConnection draws
It is write operation;
(3) main database server cluster is connected by database connection string, randomly chooses idle MDL
Server;
(4) main database server carries out corresponding write operation, while main database server generates corresponding binary system
Daily record, to other main database servers in main database server cluster and from the high-performance in database server cluster from
Database server distributes the binary log;
(5) when it is high performance receive the binary log from database server when, then produce the daily record of corresponding relaying
And corresponding write operation is carried out to itself according to the daily record, while distribute binary log from database server to other, together
The data in its database are walked, when other main database servers receive the binary log, corresponding relaying day is produced
Will simultaneously carries out corresponding write operation according to the daily record to itself;
(6) operating result is returned to from database server to Web server, Web server is serviced to Nginx reverse proxys
Device returns to operating result, and last Nginx reverse proxys device forwards the accordingly result to user.
Further, read from database operation element flow is as follows:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, and analyzing SQL statement by database fastening means DBConnection draws
It is read operation;
(3) Web server whether there is the data to page cache server and data cache server inquiry;If not depositing
Step (4) is then being performed, if in the presence of directly the data to caching server carry out read operation, are returned to user and read result;
(4) connected from database server cluster by database connection string, select idle from database successively
Server, carries out read operation, compares with sequence number, judges that data whether there is and correct;
(5) most rear line is returned and reads result, as a result has and only two kinds situations, i.e. data do not exist or correct.
Further, using the host-guest architecture of database server, in same cluster, it is firstly received the database of data
Server turns into master server, and it is responsible for being distributed to binary log from server, and data syn-chronization is carried out from server;Principal and subordinate
Database server data have real time synchronization, and the two is connected by high-speed transfer network.
Further, main database server can be while produce a binary log when write-in data are carried out, and should
Binary log send to other main database servers with from data-base cluster performance it is high from database server, this from
Database server constitutes host-guest architecture with other from database server, after the database server receives binary log
The daily record of corresponding relaying can be produced, and the data of itself are operated accordingly, while binary log is distributed into other
It is that can accordingly produce the daily record of a relaying when other database servers receive the binary log from database server,
And the data of oneself are operated accordingly according to the relaying daily record, so as to reach the synchronization of data;Stored using black hole and drawn
Hold up to solve also produce the binary log of response to forward after operating data.
The beneficial effects of the invention are as follows:
(1) digital independent is separated with data write-in, and both can be carried out simultaneously, improve the High Availabitity of data
Property;
(2) database is by the way of cluster, i.e., master server to be delayed and have other server after machine and replace his position,
So as to ensure the continuous availability that service is provided;
(3) using page cache server recycling data, the pressure of Web server is significantly reduced;Using data
Caching server, multiplex data reduces the pressure of database server.
Brief description of the drawings
The invention will be further described below in conjunction with the accompanying drawings.
Fig. 1 is the overall architecture schematic diagram in invention;
Fig. 2 writes database manipulation workflow diagram for this method;
Fig. 3 is the read from database operation element flow chart of this method;
Fig. 4 is the strobe utility schematic diagram of black hole storage engines;
Fig. 5 is main database server cluster host-guest architecture schematic diagram;
Fig. 6 is from database server cluster host-guest architecture schematic diagram.
Specific embodiment
As shown in figure 1, a kind of implementation method of the High Availabitity MySQL database based on Nginx, it includes Web server
Cluster, master-slave database server cluster, Nginx Reverse Proxies, page cache server and data cache server;
User sends connection request to Nginx Reverse Proxies, and Nginx Reverse Proxies forward the request to Web service
Device cluster, Web server receives the request, has been searched whether in page cache server with data cache server first
Corresponding data, if in the presence of directly using data cached;If not existing, by database fastening means
DBConnection analysis SQL statements judge read-write operation and are connected to corresponding master-slave database server, master-slave database
Server is operated and is returned the result to Web server accordingly.
Multiple Web servers form a Web server cluster, when Nginx Reverse Proxies receive request,
The Web server of free time can be randomly choosed in Web server cluster and sends request, so as to avoid many people while accessing clothes
The situation that business device cannot be responded.Page cache server and data cache server has been set up to make the direct access cache of user
Middle data, without accessing database, the mechanism need periodically by page cache server and data cache server not
Conventional data are substituted for the data commonly used in database server;When user accesses a certain web page resources, Web server meeting
Corresponding data are first searched whether in page cache server and data cache server, if in the presence of directly using should
Data, conversely, Web needs, by database connection string and database server connected reference data, so to greatly improve
Access speed.
Binary log is that database server is generated when a read-write operation is carried out, and relaying daily record is binary system day
The copy of will, its effect is performing again for operation, so as to reach the synchronization of master-slave database.Page cache server and data are slow
Deposit server be the Web content for frequently accessing will be needed to be stored in close to user, in the faster system of access speed, to carry
Access to content speed high.
As shown in Fig. 2 it is as follows to write database manipulation workflow:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, and analyzing SQL statement by database fastening means DBConnection draws
It is write operation;
(3) main database server cluster is connected by database connection string, randomly chooses idle MDL
Server;
(4) main database server carries out corresponding write operation, while main database server generates corresponding binary system
Daily record;
(5) to other main database servers in main database server cluster and from the height in database server cluster
Performance distributes the binary log from database server;
(6) when it is high performance receive the binary log from database server when, then produce the daily record of corresponding relaying
And corresponding write operation is carried out to itself according to the daily record, while distribute binary log from database server to other, together
The data in its database are walked, when other main database servers receive the binary log, corresponding relaying day is produced
Will simultaneously carries out corresponding write operation according to the daily record to itself;
(7) database server returns to operating result to Web server, and Web server is to Nginx Reverse Proxies
Operating result is returned to, last reverse proxy device forwards the accordingly result to user.
As shown in figure 3, read from database operation element flow is as follows:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, and analyzing SQL statement by database fastening means DBConnection draws
It is read operation;
(3) Web server whether there is the data to page cache server and data cache server inquiry;If not depositing
Step (4) is then being performed, if in the presence of directly the data to caching server carry out read operation, are returned to user and read result;
(4) connected from database server cluster by database connection string, select idle from database successively
Server, carries out read operation, compares with sequence number, judges that data whether there is and correct;
(5) most rear line is returned and reads result, as a result has and only two kinds situations, i.e. data do not exist or correct.
As shown in figure 4, realizing strobe utility using black hole storage engines (BLACKHOLE storage engines).In database
In server host-guest architecture, master server distributes its binary log through the Distributor using black hole storage engines to it
He from server, the daily record of corresponding relaying is produced after receiving the binary log from server, and read and write accordingly
Operation, can also produce binary log, but this binary log can be sent into black hole storage from server and draw during this
Hold up, and black hole storage engines do not store any data, received data have been similarly entered into without the black hole for going out, so as to keep away
The situation of recursive copying daily record is exempted from.
As shown in figure 5, main database server cluster is using double main or multi-main constructions.
As shown in fig. 6, main-slave structure is used from database server cluster, the server that a performance can be selected higher
To serve as master server (relative to the cluster), for receiving the binary log that main database server cluster is sent.
The course of work:User sends connection request to Nginx directions proxy server, and Nginx Reverse Proxies will
Request is forwarded to Web server cluster, and Web server receives the request, first in page cache server and data buffer storage
Corresponding data are searched whether in server, if in the presence of directly using data cached;If not existing, by database
Fastening means DBConnection analysis SQL statements draw its operating database type, are specifically divided into reading database and write-in
The class situation of database two:
(1) when client user needs to read data from database, sent to Nginx Reverse Proxies first
Request of data message, Nginx is received and idle Web service in Web server cluster is sent this request to after the message
Device, Web server by database fastening means DBConnection analyze SQL statement draw it is read operation, then be connected to from
In data-base cluster it is idle it is available take device from database, a SECO is set herein to prevent dirty reading, i.e., in distribution number
According to when add a timing information, then the real-time for ensuring data query carry out the read operation of data.
(2) when client user needs to write data from database, sent to Nginx Reverse Proxies first
Data write request message, Nginx is received and idle Web in Web server cluster is sent this request to after the message
Server, Web server analyzes SQL statement draws it is write operation by database fastening means DBConnection, is connected to
Idle database server in MDL cluster, so as to carry out data write operation, produces corresponding binary log, point
It is dealt on other all database servers, other all database servers produce corresponding relaying daily record, and according in this
Carry out corresponding operation to its data to keep the synchronous uniformity of database after daily record.
The present invention carries out the write operation of data by setting up main MySQL database server cluster, sets up from database
Server cluster carries out the read operation of data, wherein carrying out write operation to database every time can all produce corresponding binary system day
Will, the synchronism of data in data-base cluster is ensured by the daily record.Connected by high-speed transfer network between principal and subordinate's server
Connect, the synchronous time difference is eliminated with this.The present invention also by page cache server and data cache server come reading cache data,
So as to improve access rate.The present invention realizes read operation and is separated with write operation, and read-write operation is independent of each other so that substantial amounts of
During user accesses data storehouse, server can also do as usual offer service.The present invention is not changing the design of traditional relational data
While the access mode of framework and SQL, can possess the scalability of reply high concurrent amount and big data quantity so that apply journey
Sequence can obtain high scalability on the premise of making no modifications, the Web server cluster reality based on Nginx frameworks
The high availability of server is showed.
Claims (6)
1. a kind of implementation method of the High Availabitity MySQL database based on Nginx, it is characterised in that:It includes Web server collection
Group, master-slave database server cluster, Nginx Reverse Proxies, page cache server and data cache server;With
Family sends connection request to Nginx Reverse Proxies, and Nginx Reverse Proxies forward the request to Web server
Cluster, Web server receives the request, has searched whether phase in page cache server with data cache server first
The data answered, if in the presence of directly using data cached;If not existing, by database fastening means DBConnection
SQL statement judges read-write operation and is connected to corresponding master-slave database server for analysis, and master-slave database server carries out phase
The operation answered simultaneously returns the result to Web server.
2. a kind of implementation method of High Availabitity MySQL database based on Nginx according to claim 1, its feature exists
In:When Web server receives the request from Reverse Proxy Nginx, Web server passes through DBConnection
Analysis SQL statement, judges the action type that will be carried out to data place, is specifically divided into read operation and two kinds of situations of write operation:
(1) when it is write operation that DBConnection analysis SQL statements draw, can at random be selected in main database server cluster
A main database server in idle upstate is selected, the write operation of data is performed;
(2) when it is read operation that DBConnection analysis SQL statements draw, can successively selected from database server cluster
Select one to set a SECO herein to prevent dirty reading in idle upstate from database server, that is, dividing
A timing information, the real-time for ensuring data query are added during hair data.
3. a kind of implementation method of High Availabitity MySQL database based on Nginx according to claim 2, its feature exists
In:Write database manipulation workflow as follows:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, analyzes SQL statement draws it is to write by database fastening means DBConnection
Operation;
(3) main database server cluster is connected by database connection string, randomly chooses idle MDL service
Device;
(4) main database server carries out corresponding write operation, while main database server generates corresponding binary log,
To other main database servers in main database server cluster and from the high-performance in database server cluster from data
Storehouse server distributes the binary log;
(5) when it is high performance receive the binary log from database server when, then produce the daily record of corresponding relaying and root
Corresponding write operation is carried out to itself according to the daily record, while distribute binary log from database server to other, it is synchronous its
Data in database, when other main database servers receive the binary log, produce the daily record of corresponding relaying simultaneously
Corresponding write operation is carried out to itself according to the daily record;
(6) operating result is returned to from database server to Web server, Web server is returned to Nginx Reverse Proxies
Operating result is returned, last Nginx reverse proxys device forwards the accordingly result to user.
4. a kind of implementation method of High Availabitity MySQL database based on Nginx according to claim 2, its feature exists
In:Read from database operation element flow is as follows:
(1) Reverse Proxy receives the connection request that user sends, and is forwarded to Web server;
(2) Web server receives the request, and analyzing SQL statement by database fastening means DBConnection draws it is to read
Operation;
(3) Web server whether there is the data to page cache server and data cache server inquiry;If not existing,
Step (4) is then performed, if in the presence of directly the data to caching server carry out read operation, are returned to user and read result;
(4) connected from database server cluster by database connection string, select idle from database service successively
Device, carries out read operation, compares with sequence number, judges that data whether there is and correct;
(5) most rear line is returned and reads result, as a result has and only two kinds situations, i.e. data do not exist or correct.
5. a kind of implementation method of High Availabitity MySQL database based on Nginx according to claim 1, its feature exists
In:Using the host-guest architecture of database server, in same cluster, the database server for being firstly received data turns into master
Server, it is responsible for being distributed to binary log from server, and data syn-chronization is carried out from server;Master-slave database server
Data have real time synchronization, and the two is connected by high-speed transfer network.
6. a kind of implementation method of High Availabitity MySQL database based on Nginx according to claim 5, its feature exists
In:Main database server can be while produce a binary log, and by binary log hair when write-in data are carried out
Deliver to other main database servers with from data-base cluster performance it is high from database server, this is from database server
Host-guest architecture is constituted from database server with other, the database server can be produced accordingly after receiving binary log
Relaying daily record, and the data of itself are operated accordingly, while binary log is distributed into other from database service
Device, is that can accordingly produce the daily record of a relaying when other database servers receive the binary log, and according to the relaying
Daily record is operated accordingly to the data of oneself, so as to reach the synchronization of data;Logarithm is solved using black hole storage engines
Forwarded according to can also produce the binary log of response after being operated.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710059502.5A CN106919654A (en) | 2017-01-24 | 2017-01-24 | A kind of implementation method of the High Availabitity MySQL database based on Nginx |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710059502.5A CN106919654A (en) | 2017-01-24 | 2017-01-24 | A kind of implementation method of the High Availabitity MySQL database based on Nginx |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106919654A true CN106919654A (en) | 2017-07-04 |
Family
ID=59453437
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710059502.5A Pending CN106919654A (en) | 2017-01-24 | 2017-01-24 | A kind of implementation method of the High Availabitity MySQL database based on Nginx |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106919654A (en) |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107741963A (en) * | 2017-09-30 | 2018-02-27 | 北京奇虎科技有限公司 | Across company-data merging method and device, electronic equipment, computer-readable storage medium |
CN107844403A (en) * | 2017-12-14 | 2018-03-27 | 上海振大电器成套有限公司 | A kind of hardware device monitoring system |
CN108509507A (en) * | 2018-02-11 | 2018-09-07 | 北京原点时空信息技术有限公司 | The account management system and its implementation of unified entrance |
CN108549725A (en) * | 2018-04-28 | 2018-09-18 | 北京百度网讯科技有限公司 | Access and control strategy of database method, apparatus, system, equipment and computer-readable medium |
CN108989390A (en) * | 2018-06-19 | 2018-12-11 | 北京智明星通科技股份有限公司 | User requests retransmission method and device, Reverse Proxy and computer readable storage medium |
CN109151079A (en) * | 2018-10-31 | 2019-01-04 | 珠海迈科智能科技股份有限公司 | Trans-regional server resource method for implanting, access method and Transmission system |
CN109672711A (en) * | 2017-10-17 | 2019-04-23 | 航天信息股份有限公司 | A kind of http request processing method and system based on Reverse Proxy Nginx |
CN110032699A (en) * | 2019-03-11 | 2019-07-19 | 北京智游网安科技有限公司 | A kind of web data acquisition methods, intelligent terminal and storage medium |
CN110196859A (en) * | 2019-06-10 | 2019-09-03 | 天津神舟通用数据技术有限公司 | Data base read-write based on JDBC distributor separates cluster real-time consistency method |
CN111221818A (en) * | 2019-12-27 | 2020-06-02 | 特瓦特能源科技有限公司 | Alarm information analysis method and device |
CN112307069A (en) * | 2020-11-12 | 2021-02-02 | 京东数字科技控股股份有限公司 | Data query method, system, device and storage medium |
CN113064912A (en) * | 2021-03-24 | 2021-07-02 | 西安热工研究院有限公司 | Method for rapidly inquiring historical alarm information by DCS background |
CN114138809A (en) * | 2021-12-08 | 2022-03-04 | 纳里健康科技有限公司 | Database read-write separation method and platform |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104753966A (en) * | 2013-12-25 | 2015-07-01 | 明博教育科技有限公司 | Resource file inquiry method and system based on server and client caches |
US20170017692A1 (en) * | 2015-07-13 | 2017-01-19 | Paypal, Inc. | Read/write split database query routing |
-
2017
- 2017-01-24 CN CN201710059502.5A patent/CN106919654A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104753966A (en) * | 2013-12-25 | 2015-07-01 | 明博教育科技有限公司 | Resource file inquiry method and system based on server and client caches |
US20170017692A1 (en) * | 2015-07-13 | 2017-01-19 | Paypal, Inc. | Read/write split database query routing |
Non-Patent Citations (1)
Title |
---|
蒋文旭: ""基于Nginx部署环境的Web加速方案设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107741963A (en) * | 2017-09-30 | 2018-02-27 | 北京奇虎科技有限公司 | Across company-data merging method and device, electronic equipment, computer-readable storage medium |
CN109672711A (en) * | 2017-10-17 | 2019-04-23 | 航天信息股份有限公司 | A kind of http request processing method and system based on Reverse Proxy Nginx |
CN109672711B (en) * | 2017-10-17 | 2021-08-06 | 航天信息股份有限公司 | Reverse proxy server Nginx-based http request processing method and system |
CN107844403A (en) * | 2017-12-14 | 2018-03-27 | 上海振大电器成套有限公司 | A kind of hardware device monitoring system |
CN108509507A (en) * | 2018-02-11 | 2018-09-07 | 北京原点时空信息技术有限公司 | The account management system and its implementation of unified entrance |
CN108549725A (en) * | 2018-04-28 | 2018-09-18 | 北京百度网讯科技有限公司 | Access and control strategy of database method, apparatus, system, equipment and computer-readable medium |
CN108989390B (en) * | 2018-06-19 | 2020-11-10 | 北京智明星通科技股份有限公司 | User request forwarding method and device, reverse proxy server and computer readable storage medium |
CN108989390A (en) * | 2018-06-19 | 2018-12-11 | 北京智明星通科技股份有限公司 | User requests retransmission method and device, Reverse Proxy and computer readable storage medium |
CN109151079A (en) * | 2018-10-31 | 2019-01-04 | 珠海迈科智能科技股份有限公司 | Trans-regional server resource method for implanting, access method and Transmission system |
CN110032699A (en) * | 2019-03-11 | 2019-07-19 | 北京智游网安科技有限公司 | A kind of web data acquisition methods, intelligent terminal and storage medium |
CN110196859A (en) * | 2019-06-10 | 2019-09-03 | 天津神舟通用数据技术有限公司 | Data base read-write based on JDBC distributor separates cluster real-time consistency method |
CN111221818A (en) * | 2019-12-27 | 2020-06-02 | 特瓦特能源科技有限公司 | Alarm information analysis method and device |
CN112307069A (en) * | 2020-11-12 | 2021-02-02 | 京东数字科技控股股份有限公司 | Data query method, system, device and storage medium |
CN113064912A (en) * | 2021-03-24 | 2021-07-02 | 西安热工研究院有限公司 | Method for rapidly inquiring historical alarm information by DCS background |
CN114138809A (en) * | 2021-12-08 | 2022-03-04 | 纳里健康科技有限公司 | Database read-write separation method and platform |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106919654A (en) | A kind of implementation method of the High Availabitity MySQL database based on Nginx | |
CN107018042B (en) | Tracking method and tracking system for online service system | |
CN103812849B (en) | A kind of local cache update method, system, client and server | |
CN103312791B (en) | Internet of Things isomeric data storage means and system | |
CN111400326B (en) | Smart city data management system and method thereof | |
CN105335513B (en) | A kind of distributed file system and file memory method | |
CN104133882A (en) | HDFS (Hadoop Distributed File System)-based old file processing method | |
WO2021129477A1 (en) | Data synchronization method and related device | |
CN103260050A (en) | Video-on-demand system based on Google App Engine Cloud platform | |
CN105354328B (en) | A kind of system and method solving the access conflict of NoSQL database concurrency | |
CN107800808A (en) | A kind of data-storage system based on Hadoop framework | |
CN109344122B (en) | Distributed metadata management method and system based on file pre-creation strategy | |
US10747739B1 (en) | Implicit checkpoint for generating a secondary index of a table | |
CN103399894A (en) | Distributed transaction processing method on basis of shared storage pool | |
CN105354250A (en) | Data storage method and device for cloud storage | |
CN102521389A (en) | Postgresql database cluster system mixedly using solid state drives and hard disk drive and optimizing method thereof | |
CN103312725A (en) | Content-centric networking cache judgment method based on node importance degrees | |
CN105989065B (en) | Flash data processing method and system | |
CN104572505A (en) | System and method for ensuring eventual consistency of mass data caches | |
CN105407044B (en) | A kind of implementation method of the cloud storage gateway system based on NFS | |
Mealha et al. | Data replication on the cloud/edge | |
CN110069565B (en) | Distributed database data batch processing method and device | |
CN107659626B (en) | Temporary metadata oriented separation storage method | |
Chandramouli et al. | End-to-end support for joins in large-scale publish/subscribe systems | |
CN109635161B (en) | Cross-domain allopatric collaborative design method in mass data environment |
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 |
Application publication date: 20170704 |
|
RJ01 | Rejection of invention patent application after publication |