The world's most popular open source database
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-221-0634
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +31 6 25003558
Italy: +39 06-99268193
Israel: +31 6 25003558
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140
| General | |
| 1. | Check the health, security, performance and available of all your MySQL servers from a consolidated view. |
| 2. | Monitor 600+ MySQL and OS specific variables. |
| 3. | Use 130+ MySQL provided Advisor Rules to enforce security, performance, replication best practices. |
| 4. | Define and customize thresholds and alert severity levels to meet your specific requirements. |
| 5. | Receive new and updated Advisor Rules periodically as soon as they available. |
| 6. | Quickly test applications to ensure they are secure, tuned and working efficiently before deploying them into production. |
| 7. | Make it easier to get approvals for hardware upgrades by sending a graph to your boss that shows CPU/memory utilization creeping towards the danger zone over a period of time. |
| Monitoring | |
| 8. | Download, install, configure and begin proactively monitoring all MySQL servers within 20 minutes. |
| 9. | Auto detect, group and monitor all of your Replication topologies. |
| 10. | Use color-coded server heat chart for at-a-glance view into the health, security and performance of all your MySQL servers. |
| 11. | Monitor groups of MySQL servers by different Service Level Agreement (SLA) requirements. |
| 12. | Monitor all your MySQL servers or only specific groups of MySQL servers. |
| 13. | Monitor and get alerted to only events you deem critical. |
| 14. | Monitor your MySQL servers across multiple geographic locations. |
| 15. | Monitor your MySQL servers remotely from home or away from the office. |
| 16. | Quickly identify the up/down status of your MySQL servers. |
| 17. | Quickly correlate OS system performance spikes with MySQL related performance issues. |
| 18. | Visually correlate MySQL and OS performance issues with query activity quickly. |
| 19. | Help predict when you will need more hardware to scale-out further using graphs of historical data. |
| Query Analyzer | |
| 20. | Quickly find and tune the queries behind system performance spikes. |
| 21. | Identify and fix poorly-written queries across all your MySQL servers from a single console. |
| 22. | Collect, aggregate and analyze queries across all your MySQL servers, with no dependence on Query Log or SHOW PROCESSLIST. |
| 23. | Analyze queries aggregated by execution times, number of executions, total rows, or total bytes. |
| 24. | View an EXPLAIN to determine the current access path and index usage. |
| 25. | View historical queries by a specific time interval or by a date/time range. |
| 26. | View and sort queries by MySQL server, application grouping, database, query type or content. |
| 27. | Analyze query load across all your MySQL replicated read slaves. |
| 28. | Easily find newly deployed queries by when they were first seen. |
| 29. | Tag queries you want to watch as they are tuned. |
| 30. | Test and tune your code during development before it is promoted to production. |
| 31. | Sample queries during non-peak hours for later analysis. |
| 32. | Quickly detect when new or changed queries are first seen. |
| Performance | |
| 33. | Receive tailored advice on how to tune MySQL's built in caching capabilities to improve throughput. |
| 34. | Get immediately notified if indexes have been altered or dropped which will impact and performance of your database. |
| 35. | Get alerted to poorly running queries so you can improve application performance. |
| 36. | Monitor dynamic metrics over time and leverage advice on tuning for optimal performance. |
| Administration | |
| 37. | Resolve issues quickly using MySQL recommended commands to fix security, replication, schema, and performance issues. |
| 38. | Notify multiple DBAs as a single group when thresholds are violated so that critical alerts are addressed immediately. |
| 39. | Quickly identify the version numbers of all of my MySQL Servers so you can make sure they are all current. |
| 40. | Get immediately notified if databases or tables have been altered or dropped. |
| 41. | Learn from others' experience using historical annotations on issues that have been previously corrected and closed. |
| 42. | Get notified before maximum connection limits are reached to ensure the server does not run out of resources. |
| 43. | Gain deeper insight into reported issues with the integrated MySQL Enterprise Knowledge Base and MySQL Reference Manual. |
| 44. | Ensure your MySQL servers are configured for highest level of performance and recoverability |
| 45. | Ensure your MySQL Servers are configured to detect/identify poorly performing queries |
| Replication | |
| 46. | Quickly identify and resolve MySQL replication latency issues such as Slave Lag. |
| 47. | Get notified if a slave has been stopped or has stopped replicating to ensure read capacity is maintained. |
| 48. | Verify that slaves are configured to start as masters if necessary. |
| 49. | Determine exactly which thread or permission setting has stopped the replication process. |
| 50. | Secure slaves by ensuring that ALTER TABLE and DROP TABLE statements are not replicated. |
| 51. | Monitor the status of all your Master/Slaves from a consolidate view. |
| 52. | Drill into each Master/Slave for status details. |
| 53. | Ensure Binary Log purge frequency and size limits are configured correctly. |
| 54. | Identify network issues that impact Master/Slave synchronization. |
| 55. | Identify and correct Relay log issues that can lead to Master/Slave synchronization issues. |
| Security | |
| 56. | Resolve security vulnerabilities across all MySQL servers in under 20 minutes. |
| 57. | Get immediately notified of security vulnerabilities as they occur, such as Accounts without Passwords, Accounts with Global Privileges, and Servers with Anonymous Accounts. |
| 58. | Get notified if privileges are being granted or revoked without your knowledge. |
| 59. | Determine if you have appropriately limited external domain access to your server. |
| 60. | Verify that user accounts don't have powerful file write privileges. |
| 61. | Monitor dynamic security settings over time and close loopholes as they occur. |
| Customization | |
| 62. | Use the MySQL provided Advisor Rules as a template to build your own custom Advisors. |
| 63. | Create and manage server groupings (by location, application, etc.). |
| 64. | Create targeted notification groups (by server, location, application, etc.). |
| 65. | Create custom SMTP and SNMP notifications. |
| 66. | Apply custom thresholds and alerts for specific servers, applications, notification groups. |
| 67. | Get live feeds for your open support issues. |
| 68. | Get live feeds for MySQL product updates, announcements and alerts. |
Recommended Servers for MySQL