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

Patrol is a necessary maintenance item for database administrators to ensure the health of the database. Comprehensive patrol can find problems early, solve problems and prevent problems.

Many database maintainers do not know much about databases (often concentrated in traditional industries), are not professional DBAs, and have multiple roles (business, software, network, hardware), and are physically and mentally exhausted in their daily work. Such a state will inevitably make system administrators even if they care about the system carefully, but due to limited energy, they cannot learn deeply, and they cannot find a suitable and efficient way to comprehensively inspect their own systems.

What kind of outcome will it lead to? There are many hidden dangers in the system, often acting as firefighters, bomb disposal soldiers role.

Then this series uses simple tools and easy-to-understand language to help system operation and maintenance personnel understand which indicators should be checked frequently in the database, so that operation and maintenance personnel no longer play a high-risk occupation!

Inspection mainly includes several parts:

Easy to master the way of database management--one of operation and maintenance inspection (Server status and hardware metrics) Easy to master database management-Operation and Maintenance Inspection II (database) Easy to master database management-Operation and Maintenance Inspection III (structure design) Easy to master database management-Operation and Maintenance Inspection IV (database backup) Easy to master database management-Operation and Maintenance Inspection V (instance-level parameters) Easy to master database management-Operation and Maintenance Inspection VI (job operation) Easy to master the way of database management--Operation and maintenance inspection VII (log) Easy to master the way of database management--Operation and maintenance inspection VIII (performance)

---------------------

Original address: http://www.cnblogs.com/double-K/

If there is a reprint, please keep the original address!

----------------------------------------------------------------------------------------------------

This series aims to address some common concerns:

I don't know what to inspect.

I don't know how to check it out.

Too many machines, too much trouble with the physical examination.

Difficulty in generating reports and visualizing results

----------------------------------------------------------------------------------------------------

Note: This article is original, welcome to reprint, please give this article link in the obvious position of the article page!

If you think this article is good, please click on the recommendation in the lower right corner, thank you very much!

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.