Itchy Ninja Software is pleased to announce the release of Analyst for MySQL v1.1. Revolutionize the way you work and administrate MySQL, MariaDB, Galera, and Percona XtraDB installations.
Make More Efficient Use of Your Time
Gathering all of the metrics to diagnose a database installation is a very time consuming process, and many simply do not have the experience to know where to begin. With Analyst for MySQL, you will be able to get your hands on hundreds of metrics within moments. It really takes all of the guesswork, as well as tedious long sessions of writing queries out of managing a MySQL database server.
Cross-Platform
Not only can you run the program on Windows, Mac, or Linux, you can also generate server reports from each of those platforms as well! No need to install anything on the server at any time. All diagnostics are run from your laptop or desktop machine. The source computer (your laptop or desktop machine) can be any operating system and so can the server you are auditing.
Performance Tuning
With Analyst, you will get dozens of charts, tables, graphs, and rules concentrated on helping you resolve performance issues. You can even see CPU utilization, disk I/O, swapping / paging, network throughput, and more. For Linux systems with systat (SAR) installed, historical system metrics are also available.
Minimize Downtime
Analyst includes over 200 industry-proven rules which help identify the source of the issues as well as advice on how to resolve them. You’ll also get multiple charts, tables, and graphs that give you immediate access to the specifics of how your server is running.
Team Collaboration
Ever wish you could share all of the key server metrics with the rest of your team when there is an outage? With Analyst for MySQL we make this easy. You will be able to export all of the key data and send it to anyone you want. Have a manager who wants a report of what you have done? Analyst makes it easy to show reports from before and after your work to show improvement in scoring. Have team members who are not in the office and/or don’t have access to the server? No problem. Just send an Analyst report file to them and they will have instant access to the same data you have.
Security Hardening
With Analyst for MySQL, you will find anonymous users, users without passwords, accounts with excessive privileges, connections that are not encrypted, and much more.
Best Practices
One of the first tasks a MySQL administrator should perform when receiving a new server or setting one up is to ensure standards. We have spent countless hours drafting documentation on proper server configuration to ensure environments meet industry best practices. With Analyst for MySQL, you can benefit from all of our work.
Server Metrics
See metrics in the form of tabular data, pie graphs, line charts, and more. You will have metrics such as memory usage, InnoDB Buffer Pool usage, query cache utilization, and more at the tip of your fingers. Confused by the new Performance Schema? No worries. Analyst provides easy to understand metrics and does all of the heavy lifting for you.
For those with systat package installed on Linux, you will be able to turn back the clock and see how the server was performing throughout the day! See metrics such as CPU utilization, disk I/O, RAM consumption, network throughput, and more in gorgeous charts and graphs.
High Availability
For those with an Analyst Enterprise license, an audit of a MySQL Cluster, Percona XTRADB Cluster, MariaDB CLuster, or Galera Cluster you will give you rules, tables, graphs, and alerts giving detailed information on cluster performance. You will know immediately how the cluster is performing. Moreover, you will know whether the node you audited is the source of the problem or whether it is another node in the cluster.
Ease of Use
We created Analyst for MySQL to be easy to use. We know you don’t have time, or even want to read a complicated manual, to figure out how to use software. Want to archive your findings? Or send a report to someone? Analyst offers the ability to save your data to disk, export it into PDF, CSV, PNG, RTF, or HTML format, and of course printing.
Server Scoring
Analyst will examine key metrics in several areas including standardization, best practices, administration, high availability, performance, security, and more and assign a score to that category. You will get an overall score to see the current condition of your server. Once you start making the suggested improvements, run another analysis of the server. What could be easier?
Free To Use!
Click here to download your copy today!
via Planet MySQL
Analyst for MySQL v1.1: Database Performance, Security, & Best Practices Auditing Tool Released – Download for FREE!