Description

It gathers performance metrics about MySQL database engine and checks its status

Features:

• Detailed operations per second monitoring
• Slow queries per minute
• Total queries per second
• Connection usage
• Bytes received/sent per second
• MySQL Master­Slave:
  • Slave running status
  • Replication lag

Requirements

• Read-only MySQL user
• Python >= 2.6
• PyMySQL Python module
• PyYAML Python module
• simplejson Python module

Setup

1. Create the read-only MySQL user:
   mysql> GRANT USAGE, REPLICATION CLIENT ON *.* TO ‘nubity‘@‘127.0.0.1‘ IDENTIFIED BY ‘strongPassword‘;
2. Run nubity-cli to set MySQL credentials created above:
   $ sudo /usr/sbin/nubity-cli

   Choose option 1: MySQL Database Login

   Insert your MySQL connection details