intuit

intuit

The problem

Mysql was mysteriously stopping. When I logged in to check on it, mysqld was down:

mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

What it do

Logs a history of information about the server's state leading up to the fault.

• Every n minutes a swath of system information is logged, including
  • Tail of log files nabbed from SHOW GLOBAL VARIABLES the last time mysql was working
  • Indications of hung queries via SHOW FULL PROCESSLIST
  • Memory and CPU usage via SHOW ENGINE INNODB
  • Timeline of mysqld's aliveness via ps aux | grep mysql
  • ...and more
• Logs are rotated and dropped according to configurable settings
• Option to band-aid the problem upon detection by running any custom script, defaults to service mysql restart

What it will do

Shed light on more problems across any *nix-based stack.

Install

npm install intuit && cd ./node_modules/intuit

Configure

Copy config.local.example.sh as config.local.sh

cp ./config/config.local.example.sh ./config/config.local.sh && vim ./config/config.local.sh

Start

npm start

Quickstart using defaults

npm install intuit && cd ./node_modules/intuit && cp ./config/config.local.example.sh ./config/config.local.sh && cat ./config/config.local.sh && npm start

To Do

• Better check for super user privileges
• CPU info
• Prettier logs
• Solve more problems!