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

Use PowerShell to call MTools to analyze MongoDB performance and send mail

Problem description:

In the daily operation and maintenance of MongoDB, you often need to check the trend chart of the number of connections, slow queries, Overflow statements, connection sources.

Solution:

1. Mount the Windows backup directory to the MongoDB local directory and copy the latest log after LogRotate switching to the backup directory.

Reference blog post: "Mount the shared directory of Windows system under Linux"

two。 Install Mtools on the Windows server.

Refer to the blog post: "install mtools on 64-bit Windows Server 2008 R2"

3. Write PowerShell scripts, analyze log files through Mtools, and send messages.

Github source code address: https://github.com/UltraSQL/MongoDBDailyReport.git

How to use it:

A) put the DBA module in the appropriate Modules\ DBA directory.

B) load the module in the configuration file: Import-Module DBA-Force.

C) create a task plan and execute the MTools.ps1 script regularly.

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.