User manual MYSQL ENTERPRISE BROCHURE

[. . . ] MySQL Enterprise The Most Comprehensive Enterprise Database, Monitoring and Support "With the MySQL Query Analyzer, we were able to identify and analyze problematic SQL code, and triple our database performance. More importantly, we were able to accomplish this in three days, rather than taking weeks. " Keith Souhrada Software Development Engineer, Big Fish Games The MySQL Enterprise subscription offering includes the most comprehensive set of MySQL database software, monitoring and production support so your business achieves the highest levels of reliability, security and uptime. [. . . ] Its like having a "Virtual DBA Assistant" at your side to recommend best practices and eliminate security vulnerabilities, improve replication, optimize performance and more. As a result, DBAs and System Administrators can manage more servers in less time. The MySQL Enterprise Monitor includes the following Advisors: n Partitioning to improve performance and simplify management of very large database environments Stored Procedures to improve developer productivity Triggers to enforce complex business rules at the database level Views to reduce the complexity of data while increasing security Information Schema to provide easy access to metadata Pluggable Storage Engine Architecture for maximum flexibility Archive Storage Engine for historical and audit data Distributed Transactions (XA) to support complex transactions across multiple databases n n n Emergency Hot Fix Builds In the unlikely event that a critical, business-stopping bug is discovered and has not already been fixed in a service pack, MySQL Enterprise customers can request a special hot fix build that resolves the issue. When mission-critical systems encounter bugs, hot fix builds are invaluable. n n n n n n Upgrade Advisor ­ monitors and advises you on using the most secure and up to date version of MySQL Administration Advisor ­ enforces DBA best practices to prevent costly outages Security Advisor ­ minimizes exposure to security vulnerabilities n n n n n Replication Advisor ­ recommends solutions for replication setup and performance improvements Schema Advisor ­ assists in uncovering database design issues that hurt performance Performance Advisor ­ recommends changes to boost database performance Memory Usage Advisor ­ monitors dynamic memory related server metrics and recommends configuration changes to improve performance Custom Advisor­ create custom best practice rules tailored to your needs MySQL Enterprise Monitor provides at-a-glance view at the health of your MySQL database servers Easily Enforce MySQL Recommended Best Practices The MySQL Enterprise Monitor includes over 140 MySQL Advisor Rules that monitor over 600 MySQL and OS-specific variables to help you automatically enforce MySQL recommended database best practices. They deliver expert advice that come straight from the database professionals who build the MySQL database server. The Advisors provide tailored recommendations that communicate step-by-step how to solve a particular problem. Advice is delivered via SMTP and SNMP notification options or can be viewed using the visual Enterprise Dashboard. MySQL Query Analyzer The MySQL Query Analyzer helps developers and DBAs improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. With the new MySQL Connector Plug-ins, performance of Java and . Net applications can be optimized more efficiently by communicating directly with the Query Analyzer. Queries are presented in an aggregated view across all MySQL servers so DBAs and developers can filter for specific query problems and analyze their most expensive code. With the MySQL Query Analyzer, DBAs can improve the SQL code during active development, and continuously monitor and tune the queries in production. MySQL Replication Monitor The MySQL Replication Monitor provides a real-time replication health and status checks on master/slave performance and latency issues. MySQL Query Analyzer, with the correlation graphs, allows DBAs and developers to filter and analyze problem queries by highlighting the timeframe of interest MySQL ENTERPRISE 24 x 7 Production Support Enterprise Support to Answer Your Toughest Questions MySQL Enterprise includes 24x7 technical support services to help you get your toughest questions answered quickly. MySQL Enterprise Platinum includes: n MySQL support team engineers are database experts and fully understand the real-world issues and challenges you face because they've overcome these same challenges themselves. With direct access to the MySQL support team, your problems will get fixed fast. Partial List of MySQL Enterprise Customers Alcatel-Lucent Amazon. com The Associated Press Bank of America Caterpillar Continental Airlines Craigslist DaimlerChrysler Deutsche Post Dow Jones Disney Ericsson Facebook Google HypoVereinsbank Lockheed Martin Los Alamos Natl. Labs Lufthansa NASA Nortel NYSE Siemens Southwest Airlines Time Inc. [. . . ] To contact MySQL online or via telephone, please go to www. mysql. com/contact Copyright © 2010, Oracle Corporation and/or its affiliates. The Oracle logo, MySQL logo, Java, MySQL and MySQL Enterprise are trademarks or registered trademarks of Oracle Corporation and/or its affiliates. [. . . ]