分布式mysql数据库集群在线监测系统设计和实现-design and implementation of distributed mysql database cluster online monitoring system.docxVIP

AbstractAs the development in recent years, internet has become the synonymous of this age. Information technology has become an indispensable part of peoples lives. In this process, people who depends on it has a higher requirement with the stability and robustness of internet service, under such an extremely urgent condition, the stability and robustnes of internet service is directly related to the development of the internet companies. In another respect, the internet service data layer which is the core layer determines the quality of service, users require the service data is high-speed accessed, available online and can not be lost, so how to ensure data efficient and available has become a very important issue to large internet companies. As the large internet companies used to adopt the distributed MySQL database cluster as the data services layer, so if t he core database node is fail without in time processing and response, it will have a bad effect to companys revenue. So research on online database s monitoring and detecting the abnormal state of the databases and bottlenecks, troubleshooting and optimizing of database has become the core issue of the internet enterprise, which has a high significance and value.In this paper, the author will implement a set of large internet companies distributed MySQL database monitoring system according to the working experience in distributed MySQL database maintenance in Tencent company. This system‘s background program is developed with C and C++ language, the foreground program is developed with PHP language.The system is operating in a distributed environment, it will monitor the MySQL database cluster of Tencent WenWen community and the advertising business online. Via online getting the indicators data of distributed MySQL databases, it can detect the abnormal state and warn it, this will help users understand the size and characteristics of business development, make the adjustment of the business environmen