Shulou(Shulou.com)06/01 Report--

The following content mainly brings you the alarm fault handling methods of the cloud server monitoring system DBA Monitor V1.0. The knowledge mentioned here is slightly different from the books. It is summed up by professional and technical personnel in the process of contact with users, and has a certain experience sharing value. I hope to bring help to the broad masses of readers.

CVM monitoring system DBA Monitor V1.0

Alarm server: *

Alarm hostname: *: 3306

Alarm time: 2017-10-20 11:10:03

The content of the alarm:

Materid-185:mysql-bin.002114 | 391767716

Slaveid-189:mysql-bin.002114 | 391767716 | mysql-bin.002114 | 384247058 |

Analysis:

Through the alarm content, we can find that there is a delay between the master and slave servers of this group of servers. From the alarm content, we can know that the master binlog log is the same as the relay_log log point that has been synchronized to the slave. The log files are all but the mysql-bin.002114 log point is 391767716, but all the rely-log logs on the slave have not been restored, so it is likely that the master and slave delay is caused by the execution of large transactions on the master, which can be found by analyzing the binlog log on the master. It is true that a large number of transaction operations have been performed on the master since the 384247058 log point.

Treatment plan: wait for natural recovery.

MySQL course recommendation

MySQL performance Management and Architecture Design

High performance Extensible MySQL Database Design and Architecture Optimization of E-commerce Project

MySQL performance Management and Rack

With regard to the above alarm fault handling methods for DBA Monitor V1.0 of the CVM monitoring system, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional solutions, you can contact the pre-sale and after-sale ones on the official website. I hope this article can bring you some knowledge updates.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.