Method for improving data read-write performance based on mysql database cluster

Abstract

The invention discloses a method for improving data read-write performance based on a mysql database cluster. The method comprises the following steps: establishing a mysql database cluster system; realizing read-write separation and library division functions of the mysql database cluster system by utilizing mycat intermediate; using MYISAM as a storage engine of a table; when a new table is created, implementing a mysql partitioning strategy; and performing data caching by using a redis database. A set of large mysql database cluster system is designed by utilizing mycat + mysql, landslide and debris flow real-time monitoring data can be quickly written into a database, and Beidou high-precision positioning data is stored by using an MYISAM data table; the data storage reliability can beimproved by utilizing a multi-master and multi-slave structure, and the query efficiency is further improved by using mysql partitions; a keyword index can be used for increasing the retrieval speed,and redis cache is used for improving the reading performance; the functions of read-write separation and library division can be achieved, and the data read-write speed is effectively increased. Onthe whole, the read-write performance of the system is not reduced along with the increasing of the data volume.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for improving data reading and writing performance based on a mysql database cluster. Background technique [0002] my country's landforms are complex and changeable, and geological disasters occur frequently. Geological disasters such as landslides and mudslides seriously threaten the safety of people's lives and property. In order to effectively prevent geological disasters and ensure the safety of people's lives and property, a Beidou intelligent real-time monitoring and early warning system has been developed. While monitoring landslides, debris flows and other geological disasters at fixed points, the read and write performance of real-time dynamic monitoring data is related to the operation and maintenance efficiency of the entire monitoring and early warning system. The system reads and writes data quickly, which can effectively improve data storage and query ef...

AI Technical Summary

Problems solved by technology

Therefore, improving the reading and writing ability of the system is the key to monitoring and early warning of geological disasters. However, in the current solutions, most of them only use a single master-slave mysql database to store Beidou high-precision positioning data. With the increase of monitoring sites, the single The master-slave database is easy to reach the bottleneck, resulting in slow reading and writing data, and the release of early warning information is not timely, posing a certain threat to the lives and property of the people

Images