Call Center Services Featured Article

Oracle's Spring 2010 MySQL Enterprise Offers Improved Performance, Security

By Brendan B. Read
Senior Contributing Editor

With databases companies want to do more, with greater security and less administration, especially as business begins to turn around amidst ever-increasing data theft threats.

Oracle has met these needs with the Spring 2010 release of MySQL Enterprise. This product is a comprehensive offering of production support, monitoring tools and MySQL database software.

A key component of this new release is MySQL Enterprise Monitor 2.2. It improves the collecting, searching and viewing query performance data, allowing developers to filter and analyze patterns that may hinder key system resources. New features include:

*                  Query Analyzer Execution Notices. These pinpoint problem queries, that allows DBAs (database administrators) and developers to quickly find and fix performance problems

*                  MySQL Enterprise Connector Plug-ins, which are plug-ins to an application's existing Connector that can allow users to gather and send SQL and related performance data to the query analyzer. In addition, users can track SQL errors and warnings; end user response times; query execution times and counts; and with a single click go directly to the offending query in the source code

MySQL Enterprise Monitor 2.2 also has features that helps bolster security, lower costs and improve efficiencies through GUI-based tools that continuously monitor the MySQL database and help developers implement MySQL best practices.

These enhancements include:

*                  A User and Security Model that integrates with existing LDAP authentication and commonly accepted security models

*                  Integration with MySQL Support. This feature eliminates the time DBAs spend scrutinizing the most common diagnostics needed to resolve issues

*                  Advisor Rules and Graphs. This give developers increased visibility and management for all of their MySQL servers and enables them to implement best-practices related to administration, upgrades, schema performance and security

*                  Usability Enhancements. These allow DBAs to spend more time monitoring and tuning applications and databases and less time managing and administering the tools themselves

"DBAs and developers need solutions that help them manage their MySQL servers efficiently and allow them to identify performance issues before they become expensive, time-consuming problems," explained Tomas Ulin, director, MySQL Development, Oracle (News - Alert). 'MySQL Enterprise Spring 2010 Release offers powerful tools for query performance monitoring, improved security and an enhanced administration experience -- all of which help alleviate many common pain points DBAs and developers face when building, maintaining and scaling Web applications."

Oracle's customers applaud the new release.

"MySQL Enterprise Monitor allows us to quickly identify our most expensive queries and optimize our platform's database usage," said Jeff Freund, CEO and Co-founder, Clickability. "We are excited about this release of MySQL Enterprise because we believe it can to help us further improve the performance of our Content Management platform and enable it to scale even more efficiently."