• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM Details MySQL on System i Offering

    August 7, 2007 Alex Woodie

    Among the various System i announcements that IBM made last week was IBM Software Announcement 207-172, which details the various support programs that customers can purchase to run the MySQL database on the System i platform. IBM also announced which database engines would be supported with MySQL Enterprise for i5/OS (hint: DB2/400 isn’t one of them).

    Ever since IBM and PHP development tool maker Zend Technologies partnered to bring PHP to the i5/OS server more than two years ago, there has been a need to run MySQL on the System i platform. While Zend’s tools are useful for allowing developers to create new PHP applications that run on i5/OS and utilize the server’s integrated DB2/400 database, the vast majority of commercial PHP applications already in existence were developed to use the MySQL database.

    While there were no technical limitations to prevent users from installing and running MySQL on their System i machines, it still took time to configure MySQL to work correctly on the System i. A series of technical instructions posted on Zend’s Web forums provided the more technically inclined with a guide for installing, configuring, and running the MySQL database on the System i, and other enthusiasts were available online to answer questions. But it was just too geeky for the business-oriented System i customer, who typically want simple, integrated solutions, and professional support. (Besides, it’s LAMP–Linux, Apache, MySQL and PHP–not LADP–Linux, Apache, DB2/400, and PHP–that all the kids are learning today. Duh.)

    These users’ earnest prayers were answered in May when, at MySQL’s annual user conference, IBM and MySQL announced plans for MySQL to offer professional support for the open source database running on i5/OS. The companies also announced their intention to support DB2/400 as one of the “engines” that power the MySQL relational database–an announcement about which there are still few details.

    This week, IBM announced MySQL Enterprise for i5/OS, a new package of software and support services that System i customers will be able to buy from the IBM channel when it becomes available August 17, and redeem with MySQL, which will provide the software and support.

    The offering includes the MySQL Enterprise Server database, MySQL Production Support services, and the Network Monitoring and Advisory Service tool, which MySQL bills as a “virtual DBA assistant” that recommends best practices to help eliminate security vulnerabilities, improve replication, and to optimize performance. Depending on the level of service needed, the sophistication of the MySQL environment, and the quickness of support services, customers can choose among Silver, Gold, and Platinum support packages.

    No matter which package is selected, all customers get all code updates, including the monthly “rapid updates,” quarterly service packs, and all other notifications and alerts. Silver customers also get access to various components of the Network Monitoring and Advisory Services tool, including the administration, security, and “custom” advisors.

    The MySQL Enterprise Gold package is aimed primarily at customers doing database replication. This package gives customers access to the replication advisor component of the Network Monitoring and Advisory Services tool and additional support services from MySQL’s tech experts, including reviews of database installations set up for data replication, and support for any replication problems that may come up, including troubleshooting remote systems.

    Only customers with the most sophisticated MySQL environments need the Platinum support package. Platinum support customers get the schema and performance components of the Network Monitoring and Advisory Services tool, as well as reviews by MySQL’s pros of the implementation and performance of the customer’s database schemas, queries, stored procedures, triggers, user-defined functions, client APIs, and server extensions.

    The level of customer care is also dependent on the support package purchased. The Silver package only provides for support during “business hours,” while the Gold and Platinum packages provide 24×7 phone support. All customers get an unlimited number of support incidents, no matter which support package purchased. But Silver customers must expect to wait up to four hours per call, Gold customers can expect waits up to two hours, and Platinum customers can expect to wait no longer than 60 minutes before getting their problems addressed. Gold and Platinum also provide for emergency bug fixes and hot fixes–services that Silver customers aren’t eligible for.

    IBM also announced which database storage engines would be supported with MySQL Enterprise for i5/OS. The engines supported will include: MyISAM a high-speed engine for storing non-transactional tables, and also the default engine in MySQL; MEMORY, a storage engine that can be used to handle a string of MyISAM tables as a single table; EXAMPLE, a “stub” engine that does nothing and is used by developers; ARCHIVE, which is used to store large amounts of data without indexes with a very small footprint; and CSV, which stores data as text files using the comma-separated values format.

    RELATED STORY

    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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Precisely

    Participate in Precisely’s 2021 IBM i Security Survey

    Every year, Precisely asks IT pros responsible for IBM i security about their top challenges, strategies, technologies and best practices. These annual survey results provide a revealing look at the current state of IBM i security through the eyes of your peers.

    Click here to contribute your perspectives to this year’s survey.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    DRV Technologies:  Automatically convert and distribute AS/400 reports with SpoolFlex
    Maximum Availability:  The ultimate System i replication for business of all sizes
    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee

    IT Jungle Store Top Book Picks

    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

    BOS Boosts Sales in Q2, Bottom Line Hit by Note Conversion Let WDSc Help You Format Your Source Code

    Leave a Reply Cancel reply

Volume 7, Number 30 -- August 7, 2007
THIS ISSUE SPONSORED BY:

PowerTech
Vision Solutions
ARCAD Software
Computer Keyes
Affirmative Computer

Table of Contents

  • IBM Prepares to Launch DB2 Web Query for System i
  • IBM Details MySQL on System i Offering
  • CCSS Adds Predictive Capability to System Monitoring Tool
  • VAI Automates Service Calls, Tightens Inventory Control
  • IBM Releases Portal Accelerator for SAP Customers
  • VAI Adds Tax Management Features to ERP Suite
  • Outsourced ERP Lightens Load for Tech Company
  • Infinite Software Introduces New Features for App Migration Tool
  • IBM Unveils Virtual E-Mail Security Appliance
  • Cape Clear Tests New ESB Release

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • 2021 Predictions for IBM i, Part 1
  • West Four Stands Out With On Demand Color Label Printing
  • HelpSystems Acquires Data Security, File Transfer Companies
  • Four Hundred Monitor, January 13
  • IBM i PTF Guide, Volume 23, Number 2
  • Seiden Group Unveils A PHP Distro For IBM i
  • Thoroughly Modern: DevOps Refactoring Of RPG Applications with RDi
  • Guru: Fall Brings New RPG Features, Part 2
  • More Vintage Power Systems Feature Withdrawals
  • IBM i PTF Guide, Volume 23, Number 1

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2021 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.