At the end of the year, do a routine inspection for MySQL.

At the end of the year, do a routine inspection for MySQL.
Preface:

Routine inspection is a required item before the holidays. It performs a round of comprehensive health check on servers. On the one hand, it can ensure the stability of servers during holidays, in addition, you can also check the areas that are not normally covered by monitoring.
Even the powerful O & M team like hearth stone can lose data. What is the reason for you not to perform a inspection?

Inspection is divided into the following four layers:

1. Hardware

2. Operating System

3. Database

4. Architecture

5. ETL

Inspection items:
If you need a large image and remarks, contact me directly. Files in mindmanger format cannot be uploaded on the website. Inspection script:

1. #! /Bin/bash
   
2. # This script is used to inspect MySQL.
   
3. # Written by LiHui
   
4. # Version 1.1
   
5. # Data: 2017-01-19
   
6. 
   
7. Echo-e "\ 033 [33 m ======================= hardware check ==== ======================================\033 [0 m"
   
8. 
   
9. Echo-e "\ 033 [31 m ==== display boot information =====\ 033 [0 m"
   
10. Dmesg | tail-20
    
11. 
    
12. Echo-e "\ 033 [31 m ==== view RAID array information =====\ 033 [0 m"
    
13. /Opt/MegaRAID/MegaCli/MegaCli64-LDInfo-Lall-aALL
    
14. 
    
15. Echo-e "\ 033 [31 m ==== check physical disk SMART Information =====\ 033 [0 m"
    
16. /Opt/MegaRAID/MegaCli/MegaCli64-PDList-aALL | egrep 'slot | S. M.A. R. t'
    
17. 
    
18. Echo-e "\ 033 [31 m ==== check RAID Battery status =====\ 033 [0 m"
    
19. /Opt/MegaRAID/MegaCli/MegaCli64-AdpBbuCmd-a0 | grep-E 'charger | isSOHGood | Cycle Count | Max error'
    
20. 
    
21. 
    
22. 
    
23. Echo-e "\ 033 [33 m ====================== operating system check ==== ========================================\033 [0 m"
    
24. 
    
25. Echo-e "\ 033 [31 m ==== startup Item check =====\ 033 [0 m"
    
26. Chkconfig -- list | grep-E "lvs | iptables | zabbix_agentd"
    
27. 
    
28. Echo-e "\ 033 [31 m ==== MySQL startup Item check =====\ 033 [0 m"
    
29. Cat/etc/rc. d/rc. local | grep mysql
    
30. 
    
31. Echo-e "\ 033 [31 m ==== IO Performance Check =====\ 033 [0 m"
    
32. Vmstat 1 5
    
33. 
    
34. Echo-e "\ 033 [31 m ==== memory check =====\ 033 [0 m"
    
35. Free-m
    
36. 
    
37. Echo-e "\ 033 [31 m ==== Operating System Log check =====\ 033 [0 m"
    
38. Tail-50/var/log/messages
    
39. 
    
40. Echo-e "\ 033 [31 m ==== disk space check =====\ 033 [0 m"
    
41. Df-h
    
42. 
    
43. Echo-e "\ 033 [31 m ==== network condition check =====\ 033 [0 m"
    
44. Ifconfig | grep errors
    
45. 
    
46. 
    
47. 
    
48. Echo-e "\ 033 [33 m ===================== database check ==== ======================================\033 [0 m"
    
49. 
    
50. For I in 'netstat-nult | grep 33 | awk-F': ''{print $2} '| awk' {print $1 }''; do echo-e "\ 033 [31 m ==== this section is buffer pool for port" $ I "=====\ 033 [0 m "; mysql-uxxx-pxxx-S/data0/mysqldata/$ I/mysql. sock-e 'show engine innodb status \ G' | grep 'free Buffers'; done
    
51. 
    
52. For I in 'netstat-nult | grep 33 | awk-F': ''{print $2} '| awk' {print $1 }''; do echo-e "\ 033 [31 m ==== this section is error log for port" $ I "=====\ 033 [0 m "; tail-50/data0/mysqldata/$ I/mysql-error.log; done

1. 
   
2. 
   
3. 
   
4. Echo-e "\ 033 [33 m ====================== architecture check ==== ======================================\033 [0 m"
   
5. 
   
6. For I in 'netstat-nult | grep 33 | awk-F': ''{print $2} '| awk' {print $1 }''; do echo-e "\ 033 [31 m ==== this section is slave status for port" $ I "=====\ 033 [0 m "; mysql-uxxx-pxxx-S/data0/mysqldata/$ I/mysql. sock-e 'show slave status \ G' | grep-E 'slave _ IO_Running | Slave_ SQL _Running | Master_Log_File | Read_Master_Log_Pos | executor | Exec_Master_Log_Pos | Seconds_Behind_Master '; done
   
7. 
   
8. Echo-e "\ 033 [31 m ==== virtual IP check =====\ 033 [0 m"
   
9. Ip addr | grep lo | grep-v eth1