Easy to master the way of database management--operation and maintenance patrol series

Patrol is the database administrator to ensure the health of the necessary maintenance items, comprehensive inspection can be early detection of problems, solve problems, prevent problems.

Many database maintainers do not understand the database in depth (often concentrated in the traditional industry), not a professional DBA, but also a multi-job (business, software, network, hardware), in the daily complex work has been physically and mentally exhausted. Such a state is bound to let the system administrator even if the intention of careful care system, but due to limited energy, can not study deeply, and can not find a suitable and efficient way to fully patrol their own system.

What will result in the end? There are a lot of hidden dangers in the system, often acting as firefighters, the role of the bomb squad.

Then this series with simple tools, easy to understand language, help the system operators understand the database should often patrol which indicators, so that operators no longer play a high-risk occupation!

　　

Patrol mainly consists of several parts:

　　

Easy to master the way of database management--one of operation and maintenance patrol (server status and hardware indicators)

Easy to master the way of database management--operation and maintenance Patrol II (database)

Easy to master the way of database management--the third of operation and maintenance inspection (structural design)

Easy to master the way of database management--operation and maintenance patrol four (database backup)

Easy to master the way of database management--operation and maintenance patrol five (instance-level parameters)

Easy to master the way of database management--operation and maintenance patrol six (operating condition)

Easy to master the way of database management--operation and maintenance patrol seven (log)

Easy to master the way of database management--operation and maintenance patrol eight (performance)

--------------Blog Address-----------------------------------------------------------------------------

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

If there is reprint please keep the original address!

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

This series is designed to address some common problems:

• I don't know what to patrol.
• Don't know how to get a quick checkup
• Machine Too much physical examination trouble
• Difficult to generate reports, no visual rendering of results

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

Note: This article is original, welcome reprint, please in the article page obvious location give this article link!
If you think this article is not bad please click on the lower right corner of the recommendation , thank you very much!

Easy to master the way of database management--operation and maintenance patrol series