Newsletters   Subscriptions  Forums  Store   Career  Media Kit  About Us  Contact  Search   Home 
tlb
Volume 2, Number 42 -- November 8, 2005

MySQL Brings Database Up to Par for Enterprise Deployments


by Alex Woodie


Large companies that previously would not consider the open-source MySQL database due to its lack of high-end features needed to run enterprise applications may want to take a fresh look at the data platform. Last week the Swedish company announced MySQL version 5.0, which adds critical new features such as triggers, stored procedures, and views, which for years have been available in competing databases.

Since the open-source software movements started to gain steam in the late 1990s, MySQL has come to the forefront as arguably the most visible provider of open-source database software. With six million active installations, and 40,000 downloads per day, MySQL has become a popular back-end for Web sites, especially when paired with other commonly used components in the open-source stack: the Linux operating system and the JBoss Web application middleware.

But when it comes to powering the critical business applications that process hundreds of thousands or millions of transactions per day at banks, insurance companies, retailers, and manufacturers, enterprises have steered clear of MySQL in favor of more established products, like IBM's DB2, Microsoft's SQL Server, and Oracle's eponymous database. This avoidance of MySQL in the enterprise realm was due, in large part, to a lack of enterprise-grade features in the MySQL database.

That could change. Now many of those enterprise-grade features have made their way into MySQL version 5.0. Support for stored procedures is one of the major new features. Stored procedures will enable developers to build business logic directly into the MySQL database, which is expected to have several impacts, including increased performance, greater security, and more code portability. Stored procedures in MySQL version 5.0 comply with the ANSI SQL 2003 stored procedures specifications, the company says. In addition to stored procedures, MySQL 5.0 also supports SQL functions for the first time.

Another important new feature is support for triggers. Like stored procedures and functions, triggers force more business logic that would otherwise be coded into an application, down into the database, bringing advantages such as cleaner and more portable code, and more uniform execution of business rules. MySQL says triggers will be most useful for data auditing and ensuring data security, such as triggering calls for encrypting sensitive data.

Support for views is another new feature in MySQL 5.0 expected to attract support from enterprise-level organizations. Views helps to protect sensitive data by hiding one or more sensitive columns in a table. It can also help database administrators (DBAs) tune the performance of a database application by limiting the amount of data returned in large tables. While limited in this release, MySQL 5.0 also brings support for cursors.

This release brings DBAs additional ways to prevent data from becoming corrupted through a new feature called "server enforced data integrity." According to MySQL, prior to MySQL 5.0, invalid data being sent to a MySQL database was denied at the server only through the use of column default values. In version 5.0 of MySQL, a new strict mode option is available that rejects invalid data outright and prevents any data misrepresentations from finding their way into the server.

"We are quite proud to deliver this new version of MySQL, as it includes the most-requested features from our users, customers, and partners," says Marten Mickos, chief executive of MySQL. "With their feedback, we have been able to provide important enterprise-class features."


This is a good time to be in the database software market. According to market researcher IDC, the worldwide market for database software grew by almost 12 percent to $14.9 billion in 2004. Oracle captured about 41 percent of the market, followed by IBM with 31 percent, Microsoft with 13 percent, and Sybase and Teradata, with about 3 percent each.

While open-source database software doesn't yet account for much of the overall database market, the major players are girding for battle, IDC says. Oracle launched its offensive against MySQL when it bought Innobase OY, a Finnish open-source software company whose InnoDB storage engine is often deployed alongside the MySQL database. And as we report elsewhere in this issue, Oracle has launched

The release of MySQL 5.0 is not the only move MySQL is making to gain traction in the enterprise space. The company has formed many partnerships with leading enterprise software firms over the past year, including deals with business intelligence software maker Business Objects and others.

As part of last week's MySQL 5.0 announcement, SSA Global, the world's fifth largest ERP software company by 2004 revenues, announced it will work with MySQL to certify the database with its ERP LN suite (formerly Baan). MySQL also has partnerships with about 30 other major IT vendors, including Informatica, Novell, Red Hat, Sun Microsystems, and Zend.

The production version of MySQL 5.0 is available now for Linux, Windows, Solaris, Mac OS X, FreeBSD, HP-UX, AIX 5L, and other operating systems. All MySQL database software is available under a dual licensing model. Developers and organizations can choose between an open-source (GPL) or a commercial MySQL license, depending on their deployment requirements. Support contracts range from $295 to $4,784 per server per year. For more information, go to www.mysql.com.

Sponsored By
LINUX NETWORX

Clusterworx® Whitepaper

High performance Linux clusters can consist of hundreds or thousands of individual components. Knowing the status of each CPU, memory, disk, fan, and other components is critical to ensure the system is running safely and effectively.

Likewise, managing the software components of a cluster can be difficult and time consuming for even the most seasoned administrator. Making sure each host's software stack is up to date and operating efficiently can consume much of an administrator's time. Reducing this time frees up system administrators to perform other tasks.

Though Linux clusters are robust and designed to provide good uptime, occasionally conditions lead to critical, unplanned downtime. Unnecessary downtime of a production cluster can delay a product's time to market or hinder critical research.

    Since most organizations can't afford these delays, it's important that a Linux cluster comes with a robust cluster monitoring tool that:
  • Provides essential monitoring data to make sure the system is operational.
  • Eliminates repetitive installation and configuration tasks to reduce
          periods of downtime.
  • Provides powerful features, but doesn't compromise on usability.
  • Automates problem discovery and recovery on would-be critical events.

This paper discusses the features and functions of Clusterworx® 3.2. It details how Clusterworx® provides the necessary power and flexibility to monitor over 120 system components from a single point of control. The paper also discusses how Clusterworx® reduces the time and resources spent administering the system by improving software maintenance procedures and automating repetitive tasks.

High Performance Monitoring

Each cluster node has its own processor, memory, disk, and network that need to be independently monitored. This means individual cluster systems can consist of hundreds or thousands of different components. The ability to monitor the status and performance of all system components in real time is critical to understanding the health of a system and to ensure it's running as efficiently as possible.

Because so many system components need to be monitored, one of the challenges of cluster management is to efficiently collect data and display system health status in an understandable format. For example, let's say a cluster system has 100 nodes and is running at 97 percent usage. It's very important to know whether 100 nodes are running at 97 percent usage or whether 97 nodes are running at 100 percent usage while three nodes are down.

Clusterworx® provides real-time analysis of over 120 essential system metrics from each node. Data is displayed in easy-to-read graphs, thumbnails, and value tables. Clusterworx® collects data from groups of nodes to spot anomalies, then drills down to single node view to investigate problems. This allows users to determine exactly what the problem is before taking corrective action.

Clusterworx® also tracks the power and health state of each node and displays its status using visual markers in a node tree view throughout the user interface. Power status shows whether the node is on, off, provisioning, or in an unknown state. The health state tracks informational or warning messages and critical errors. Health state messages are displayed in a message queue on the interface.

Clusterworx®'s comprehensive monitoring and easy-to-read charts and graphs allow users to quickly asses the state of each node and the overall system at a glance - while providing the necessary information to make informed decisions about the cluster system.

To read the rest of this whitepaper, please visit www.linuxnetworx.com


Editor: Timothy Prickett Morgan
Contributing Editors: Dan Burger, Joe Hertvik, Kevin Vandever,
Shannon O'Donnell, Victor Rozek, Hesh Wiener, Alex Woodie
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.


THIS ISSUE
SPONSORED BY:

Arkeia
Egenera
Guild Companies
Linux Networx
OpenLogic


The Linux Beacon

BACK ISSUES

TABLE OF
CONTENTS
Novell Names President, Cuts 10 Percent of Workforce

Fabric7 Creates Flexible Opteron Server for Linux, Windows

PA Semi Divulges Its Power Processor Aspirations

MySQL Brings Database Up to Par for Enterprise Deployments

But Wait, There's More


The Four Hundred
Domino on the iSeries Versus the Competition

Two New iSeries ISVs Target Large Accounts

PA Semi Divulges Its Power Processor Aspirations

As I See It: Management by Intercourse

The Windows Observer
Microsoft Aims to Streamline Web Experience with "Live" Offerings

Microsoft Revenues Grow 6 Percent, Profit Soars to $3.1 Billion

SQL Server 2005 Released to Manufacturing

Informatica Aims to Virtualize Data with PowerCenter 8

The Unix Guardian
Entry Unix Servers: It's a Tighter Three-Horse Race Now

HP Delivers Unix-Itanium Blade Server

Sun Continues to Transition Products and Lose Money

PA Semi Divulges Its Power Processor Aspirations


Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc. (formerly Midrange Server), 50 Park Terrace East, Suite 8F, New York, NY 10034
Privacy Statement