Volume 9, Number 10 -- March 10, 2009

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

Published: March 10, 2009

by Alex Woodie

MySQL and IBM last week started a public beta for the new DB2 for i (IBMDB2i) Storage Engine for the MySQL database, a long-awaited product that will allow System i shops to care and feed for their MySQL-based PHP applications running on their i OS server just as they do for ordinary DB2 for i (DB2/400) applications. The Storage Engine will be available for customers at V5R4 and i 6.1 versions of the operating system, but they must install several PTFs first.

System i shops have been eagerly waiting for IBM and MySQL (now owned by Sun Microsystems) to deliver IBMDB2i Storage Engine for MySQL since IBM first announced plans to build the product nearly two years ago. A private beta of the product was released in October, and now the product is ready for testing among a wider group of users.

Before installing the public beta, which is available for download here, System i shops must first download and install several PTFs. To see which PTFs you must install, check out this IBM APAR.

The origins of the IBMDB2i Storage Engine can be traced to the introduction of PHP to the AS/400 platform, and the resulting popularity of the development language. While developers can use tools from Zend Technology to write PHP applications that utilize DB2/400, the vast majority of PHP applications already on the market were designed to access data from the free and open source MySQL database platform, which necessitated running MySQL on the System i.

While System i shops have been able to get support for running MySQL on their servers for the last two years, IBM and MySQL decided to take the partnership a step further, and develop a storage engine that would mask some of the complexity (or differences in technology, at the very least) that MySQL presented for System i shops.

With the IBMDBi for MySQL Storage Engine, customers can run MySQL-based PHP applications (or other applications written to MySQL), and the data is stored in DB2/400. This brings several advantages, including broadening the number of open source applications that will run (and be supported) on the System i; eliminating the need to learn how to manage the MySQL database; and simplifying data integration between MySQL applications and DB2/400 applications.

MySQL is unique among relational databases in that it has a pluggable architecture that supports multiple database engines and allows users to customize the database for specific tasks, such as running transactional applications, data warehouse programs, or in-memory business intelligence systems. Popular MySQL database engines include Oracle's InnoDB, Solid Information Technology's SolidDB, NitroSecurity's NitroEDB, and Infobright's BrightHouse, among others.

The IBMDB2I Storage Engine for MySQL works with MySQL version 5.1. For more information, see solutions.mysql.com/engines/ibm_db2_storage_engine.html.


IBM Close to Delivering DB2/400 Storage Engine for MySQL

AURA Equipments Beats IBM to the Punch with DB2/400 Engine for 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

Sponsored By

Now available in the USA and UK, *noMAX Subscription Edition
gives you the same great capabilities as regular *noMAX but on
a flexible and affordable quarterly or annual fee basis.


                                                      + No capital investment
                                                      + No long term commitments
                                                      + Same great software

*noMAX Subscription Edition includes:
+ *noMAX + Support and Maintenance + Upgrades and updates
+ HA Health-Checks™ + User training
+ The flexibility to address your particular needs

*noMAX has high profile accounts world wide.
Whether you are operating a P05 or a P50, we have the proven
experience, performance and people that you can rely on.

* Best Software * Best Deal * End of Story *

Contact us on 1- 888 400 1541
or email sales@maxava.com

smart thinking saves you money

Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
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.

Sponsored Links

BCD:  Reaching your IBM i Web modernization goals is a lot closer with BCD
WMCPA:  24rd Annual Spring Technical Conference, April 1 & 2, 2009, Delavan, WI
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada


IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95

The Four Hundred
Getting Dizzy from Dynamic Infrastructure

The Economy Gives the Server Biz a Flat Tire in Q4

Infor Battles Customers in Court Over License Fees

As I See It: Isolation

Global IT Spending Barely Ahead of 2008; Some Regions Showing Strength

Four Hundred Guru
A Bevy of BIFs: %XLATE and %REPLACE

Send Messages Unto Others

Admin Alert: Things I learned About IBM Maintenance Contracts

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
March 7, 2009: Volume 11, Number 10

February 28, 2009: Volume 11, Number 9

February 21, 2009: Volume 11, Number 8

February 14, 2009: Volume 11, Number 7

February 7, 2009: Volume 11, Number 6

January 31, 2009: Volume 11, Number 5

TPM at The Register
AT&T wants to run your data center

Gartner: PC sales, except netbooks, to slump in 2009

Citrix taps VMLogix for fake server jukeboxing

Taiwan bails out memory makers

Lenovo erects Atom tower

Forrester: Fake servers like recessions

HP babysits small biz servers

Dell plays with virtual data centers

Server market gets second opinion on Q4

SGI lays off another 9 per cent

Virtualization soars on Big Blue Power boxes

AMD: 'At heart, we're a design company'

EMC facing DoJ probe

Gartner: PC sales, except netbooks, to slump in 2009


Maximum Availability
ARCAD Software
Guild Companies

Printer Friendly Version

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

PHP Saves Company Millions by Refurbishing Old ERP System

ManageEngine Goes On Demand with Data Center Tools

RSA Cracks Down on Security Threats with enVision 4.0

Kisco Adds Fax Support to WebReport/400

News Briefs and Product Shorts:

Blog Food for the RPG Programmer: Tastes a Bit Like .NET . . . HiT Touts Real World Work of IBM i Data Provider . . . New Tip Sheet for RDE and WDSc Programmers Arrives . . . PlanetJ Gives WOW an AJAX Refresh . . . Tolly Report Shows Reflection 2008 Outperforms Competitors, Attachmate Says . . .

Four Hundred Stuff


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement