MySQL 5.4 Brings Scalability, Performance Improvements

April 28, 2009 Alex Woodie

Sun Microsystems took a moment last week, as it was getting prepared to be eaten by Oracle, to announce a new release of MySQL, the open source relational database management system it bought for $1 billion just over a year ago. MySQL 5.4 brings scalability enhancements for X64 and Chip Multi-threaded (CMT) servers, while general performance enhancements will help users running the software on all types of servers, including IBM Power Systems boxes.

When paired with the InnoDB storage engine, which coincidentally is owned by Oracle, MySQL 5.4 can really scale. With InnoDB powering MySQL, Sun says, the duo can scale up to run on 16-way x86 servers and 64-way CMT servers. (Sun has been moving its SPARC chip architecture toward CMT for the last few years.)

The new database also brings new subquery optimizations and JOIN improvements that can result in up to 90 percent better response times for certain types of analytical queries. “Without any modifications to your applications, MySQL 5.4 will transparently increase the performance and scalability of your applications, to enable them to scale under more demanding user and data processing loads,” said Karen Tegan Padir, vice president of Sun’s MySQL and Software Infrastructure Group, during the keynote address at last week’s MySQL Conference & Expo in Santa Clara, California.

Other improvements were made in the areas of stored procedures, prepared statements access to information schemas, and DTrace support on Sun Solaris.

A preview of MySQL 5.4 is currently available for 64-bit versions of Linux and Solaris 10. Sun also intends to support the new database on IBM i OS, Windows, AIX, HP-UX, Mac OS X, and Free BSD. The general availability date for MySQL 5.4 will be announced later this year.

DB2/400 Storage Engine for MySQL Now Available as Public Beta

Enterprise Features Gain Focus as MySQL 5.1 Nears Release

Sun Casts a $1 Billion Net to Catch MySQL

IBM Details MySQL on System i Offering

MySQL Database Getting Closer Ties to the System i

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

Strategic Partnerships Add Value

A Case for On-Prem IBM i Deployment

As organizations decide where to run their IBM i workloads with a growing range of strategies, it becomes more important to have strong differentiators in the various options to help make prudent IT decisions. Cloud options are now becoming more widely considered, but as UCG Technologies explains in a recent IT Jungle article, these options should be weighed in comparison to purchasing or leasing your own IBM Power Server and installing it on premises or at a Co-location facility.

On premise (on-prem) deployments largely remain most cost-effective and appropriate for midrange systems, especially when factoring in backup and disaster recovery. One way to maximize this approach is to capitalize on long-standing partnerships with complimentary expertise as in the case with IBM and UCG Technologies. The IBM i Solution Edition for UCG’s VAULT400 cloud backup & DRaaS is an offering that allows organizations the ability to combine the power of IBM Power Systems and IBM i with the strengths of business applications, along with superior services and support. The leads to improved productivity and responsiveness, adaptability and competitive Total Cost of Ownership (TCO).

Benefits to the end user include:

Discounted single or unlimited user entitlements – Save $6,000 to $60,000
No-charge IBM i processor core entitlements
No-charge IBM i access unlimited user entitlements
Discounted Rational Developer for i
No-charge service vouchers – 4 hours or 8 hours – Value of up to $ 1,800
IBM Spec Sheet for IBM i Solution Edition

To receive the above benefits, end user client must meet IBM requirements including contracting for a minimum of $6,000 of VAULT400 cloud backup services for P05 or $25,000 for P10 with UCG Technologies. The IBM i Solution Edition may be purchased directly from UCG Technologies or from another qualified – authorized IBM partner.

The IBM i Solution Edition for VAULT400 cloud backup & DRaaS is available for both the IBM Power System S914 and S924. Leverage a platform that utilizes the full power of IBM i while deploying a complete backup and disaster recovery solution that delivers rapid ROI. That is an on-prem win-win for mid-market organizations.

Request Complimentary POWER9 System Upgrade Analysis

Please visit ucgtechnologies.com/IBM-POWER9-systems for more information.

800.211.8798 | info@ucgtechnologies.com

NSPI Taps Halcyon to Manage i Hosting Customers New Power6+ Iron: The Feeds and Speeds

Table of Contents

Content archive

Recent Posts

Subscribe

Pages

Search