I’m pleased to announce that after almost one year since the last release, the new version is available. There are many new features this time around. Originally it was titled Monolith MySQL Backup Manager, but because of the new features it has been changed to the new name. You can download here: http://sourceforge.net/projects/monolith-mysql
Screenshots:
Features:
- Graphing / Trending with variable date reporting
- Query rate + Data growth
- Connections + Uptime
- Query cache in + Query cache hit
- Queries not cached + Queries in cache
- Memory allocation: max_allocated + max_configured
- Data transfer: bytes_sent + bytes_received
- Created temp files + Created temp tables
- Open tables + Created temp disk tables
- Threads cached + Threads created + Thread utilization ratio
- Threads connected + Threads running
- Alerting for the following tuning settings
- Slow Query
- Long Query
- Used Connections
- Thread Status
- Key Buffer
- Query Cache
- Sort Merge Operations
- Join Merge settings
- Temporary Tables
- Open Files
- Table Cache
- Table Locks
- Table Scans
- InnoDB settings
- Memory Usage
- Talkback backup scripts for local disk backup – scripts report back from remote servers to Monolith server with status of backup. Talkback report per server tab, and itemized for all servers in summarization page.
- Data+Index size reporting with data summarization page for all servers
- Misc server meta data tracking
- Change request feature that show recommended cnf file changes for performance tuning + full audit report in html
Note:
The installation process is a bit involved, and I know of one hangup about the stored procedures – you must connect the monolith user to the IP address of the server and not localhost. Feel free to email me or get me on #mysql as Lumberg if you have any questions or need help installing.
