HoneyMonitor is a nice, easy to use and powerful tool for MySQL® management.
All MySQL® administration tasks are provided by several Wizards and Editors, thus cutting administration time using a familiar GUI to rapidly create/edit databases, tables, fields, indexes, foreign keys, triggers, partitions, views, procedures, functions, UDFs, plugins, events and users.
An advanced query builder, a fine report designer, code assistance features, cluster management features, and master/slaves replication management features are also included making HoneyMonitor a professional choice for MySQL® administration in Windows® systems.
If your aim is Performance Tuning & Monitoring, HoneyMonitor can help you too. It includes a Performance Tuning Monitor and, just installing an audit database, it allows you to see 90+ performance charts.
HoneyMonitor is a complex application which doesn't require Agents running on your Servers.
Here are some key features of "HoneyMonitor":
· new Virtual Data Grid for a better data management in HoneyMonitor (insert / edit / delete of records) [it is linked to the Table Editor, Queries Editor, View Editor, Server Objects List].
· new menu entry Database Objects / Tables / Open Table's Data (Quick Way).
· new menu entry Auditing / Reports / Custom Report. Possibility to create a customized Report using the Audit Table (useful to see how a numeric variable (raw or calculated) is changing over time).
· new menu entry Auditing / Reports / Edit Report's Template to edit the Templates of the Performance Reports.
· new menu entry Utility / Edit Report (Designer).
· compatibility with all MySQL® versions, from 3.23 to 6.0;
· multi-server registration; connections management;
· SSH Tunneling Connections to Internet Provider;
· SSL Connections;
· server management: properties, variables, process list, log, ping, shutdown;
· users management: creation, modification, elimination, rename, grants;
· Master / Slaves Replication management: Replication Monitor, binary logs management, change Master Wizard;
· Cluster management: Cluster Monitor, LogFile Group Editor, TableSpace Editor;
· server tuning: Performance Tuning Monitor;
· server auditing: Performance Audit Reports;
· pre-loaded SQL syntax ready to execute;
· server extension (UDF and Plugin): creation, modification, elimination; installation, uninstallation;
· federated server management: creation, modification, elimination;
· database administration: creation, modification, rename, elimination, backup, restore;
· table administration: creation, modification, rename, clone, copy, move;
· table maintenance: check, optimize, repair,... wizard;
· fields, indexes, foreign keys, triggers, partitions, records, table properties management;
· partition maintenance: rebuild, optimize, repair;
· geometric fields and blob management;
· tables, views and queries report: several extension export (i.e. .pdf);
· HTML report of database objects;
· views management: creation, modification, rename, elimination;
· stored procedures management: creation, modification, execution, elimination;
· stored functions management: creation, modification, call, elimination;
· scheduled events management: creation, modification, enable/disable, elimination;
· database objects transfer from a server to another;
· data import and export wizard;
· advanced SQL Editor with Syntax Highlighting, Formatting and Code Completion Features;
· Interactive MySQL® Reference System, Visual MySQL® Command Builder;
· SQL Syntax Checker and Spell Checker for Comments and hard-coded String;
· SQL queries management: creation, editing, execution, modification and print of returned recordsets;
· SQL Queries Builder;
· SQL Script management: creation, modification, execution, result view;
· asynchronous Script Execution;
· multi-languages: english and italian;
· several program options to configure;
· web browser inside to view on-line documentations;
· on-line update wizard;
· FAQ, Forum and Customer Area in Honeysoftware Web Site with additional resources;
· on-line Support Centre and technical support via e-mail.
Requirements:
· 500 MHz Intel Pentium processor or equivalent;
· 256 Mb RAM;
· hard disk space 200 Mb;
· monitor with a minimum resolution of 1024x768 pixel;
· A MySQL v. 3.23, or higher, account;
· MyODBC 3.51.24 or higher (the HoneyMonitor's Setup will give you the possibility to install it);
· Adobe Acrobat Reader 4, or higher (for viewing .pdf files);
· Internet Explorer 7 or other web browser (for viewing HTML reports).
· Internet Connection
Limitations:
· 30 days trial
What's New in This Release: [ read full changelog ]
New Features:
· new Tab "Defaults Folders" in the "HoneyMonitor Options" Window to set the default folders to be used when storing Audit Reports, Standard Reports, HTML Reports, Queries, Backups, Scripts, Exported Data.
Improvements:
· during the installation of the Audit System, it is now possible to choose the engine of the Audit Table. InnoDB is used by default.
· when connecting to a server through Network or Audit Pro Editions, now a message alerts users if Event Scheduler is stopped.
· minor improvements to the Filter Editor: an info-icon has been included to help users when setting a filter condition.
· a different structure of directories is now used to store users' files created through HoneyMonitor (queries, reports, backups). All the files are now stored as default in the folder DocumentsHoneySoftwareHoneyMonitor.
· minor improvements in the Binary and Relay Log Editor.
· improved stability of Connections to MySQL®: both for direct and SSH Tunneling connections.
· sever...