Shulou(Shulou.com)05/31 Report--

Today, I would like to talk to you about how to effectively do database inspection, many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Database inspection is the most important work in the field of database operation and maintenance, and it will exist for a long time. Similar to the development of database operation and maintenance, database inspection has also experienced the development of human flesh, script and platform.

01

Human flesh patrol inspection

The operation and maintenance engineer inspects the indicators of the database manually. The inspection items and conclusions depend entirely on the level of operation and maintenance engineers. If different engineers inspect the same set of database, the inspection results may be quite different. And the more databases, the worse the quality of inspection reports, and the less likely it is for operation and maintenance engineers to find problems.

02

Scripted inspection

In the upgraded version of human flesh inspection, operation and maintenance engineers use ready-made scripts to inspect the various components of the database manually or automatically. Because the inspection script is fixed, the script inspection can inspect the database relatively comprehensively, but whether the problems can be found from the execution results of the script is still limited by the experience of operation and maintenance engineers. Similar to human flesh inspection, the more the number of databases, the worse the quality of inspection reports.

03

Platform patrol and inspection

An upgraded version of scripted inspection. The database inspection platform has built-in inspection script and intelligent expert system. After the completion of the automatic inspection of the database, the intelligent expert system evaluates the inspection results in real time and generates the inspection report automatically, which completely ensures the quality of the inspection report. In addition, different operation and maintenance scenarios have different inspection requirements, and the database inspection platform should be able to automatically generate inspection reports adapted to different scenarios.

The differences among human flesh inspection, scripted inspection and platform inspection are shown in the following table:

During the development stage, the number of databases for patrol inspection issued a timely inspection report, the quality of human flesh inspection is completely limited, less than 20 a day, part of uncontrollable script inspection is limited, less than 50 a day is limited, and more than one day part of controllable platform patrol inspection

Unrestricted, more than 500 a day is unrestricted, automatic report is completely controllable

Platform inspection has become the mainstream way of database inspection nowadays, and more and more database inspection platforms are listed.

With the development of business system, higher requirements are put forward for the operation efficiency and performance of the database. The selection of database inspection platform needs to be considered from the perspectives of comprehensiveness, diversity and timeliness.

one

All-round

First of all, the database inspection must be comprehensive, and the inspection report should be able to reflect the health status of the database comprehensively and accurately. Database inspection is not simply to collect and analyze the current operating indicators of the database, it also needs to reflect the law of historical changes (database running rhythm), and even be able to predict the future development trend.

The database can be checked from the following key aspects:

Database environment, such as operating system resources, operating system configuration, database software version, etc.

Database configuration, such as database parameter configuration, redo log configuration, etc.

Database resources are mainly divided into space resources (such as table space, archive space, flashback space, backup space), memory resources, process resources and so on.

Database objects, such as large tables, large indexes, whether invalid objects are reasonable, etc.

Database security, such as whether there are super privileges, weak password users, etc.

Database performance, mainly analyzes the changing trend and development law of database performance.

Database disaster recovery, mainly analyzes whether the database disaster recovery is running normally.

Take the Midea database operation and maintenance toolbox as an example, the operation and maintenance personnel operate the comprehensive inspection function with one click, and after the automatic inspection of the above indicators, the built-in expert system gives targeted suggestions. As shown in the following figure:

Each set of database has its own specific operation law, in order to avoid limitations, database inspection can not only check the instantaneous index, but also need to consider its historical operation law, and then judge whether each index and system operation rhythm is reasonable. For example, from the time division trend chart of the database redo log, we can see that there is an obvious running peak in the database from 9 am to 10:00:

You can also clearly know the changing trend of objects from the database object change trend diagram, for example, on January 28, 2019, a customer's database created a large number of objects:

two

Diversity

Secondly, database inspection needs to reflect diversity. Database inspection in different periods and different scenarios should focus on the collection and analysis of different indicators, and then automatically generate inspection reports suitable for different scenarios, and give targeted suggestions.

1. Comprehensive inspection, system inspection of database components. Through the comprehensive inspection, we can clearly know the database health status, running rhythm, configuration and other information, and automatically generate a comprehensive inspection report. As shown in the following figure:

2. go to work for inspection, focusing on whether the components of the database are in a healthy state and whether the resources are sufficient to meet the business needs of the day. The general situation of the inspection is displayed directly through the radar map (health indicators and risk indicators) combined with red, yellow and green sections, as shown in the following figure:

3, after work inspection, focus on checking whether the use of various resources is reasonable during the day. The off-duty inspection summarizes the use of various resources on the basis of the work inspection, and ensures that the host and database resources can support the normal operation of the business in the "unmanned mode" after work. As shown in the following figure:

Database inspection is not a single operation, it needs to be carried out automatically in a planned way to find problems in time and reduce the workload of operation and maintenance personnel. The automatic planning function needs to be realized in the inspection platform, and the database is inspected regularly. The automatic inspection record of a database on the Meituang database inspection platform is as follows:

three

Timeliness

Finally, the database inspection needs to be timely. As the database is changing all the time, in order to find problems in time, it is generally required to issue an inspection report on the same day, or a shorter time. According to the report, the engineer evaluates whether to adopt the recommendations to ensure the efficient and stable operation of the database.

There are many ways for database inspection, and an excellent database inspection platform must rely on professional and technical reserves and rich experience accumulation. When choosing an excellent database inspection platform, we should also consider the reserve of experts behind it.

After reading the above, do you have any further understanding of how to do database inspection effectively? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.