• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • MySQL Support Options for IBM i Customers

    January 25, 2011 Alex Woodie

    Oracle may have cut the cord between MySQL and the IBM i operating system. But that doesn’t mean customers should be ditching the database immediately. While IBM has not announced whether there will be another formal technical support organization put in place to support customers who want to run MySQL on IBM i, the fact that the database is an open source product leaves many options on the table.

    Oracle surprised and even angered the IBM i community in December when it stopped supporting the IBM i operating system with its MySQL database. Despite evidence that the open source database was becoming more popular among IBM i professionals, the software giant cited “low demand” as a business reason to kill the IBM i relationship, which it inherited a year before with its acquisition of Sun, which itself had bought MySQL about a year before that.

    Oracle’s move is a blow to open source adoption on the IBM i platform. While there are exceptions, the AS/400 community has historically been reluctant to put into production any code that is backed by a community of enthusiasts and other users, and not an actual profit-seeking enterprise. The advent of the commercial open source model–whereby customers can purchase professional support agreements that guarantee a certain level of responsiveness in the event of technical difficulties–has helped to ease some of the qualms that midrange shops had over open source. But there remains an uneasiness and a distrust, frankly, of open source that doesn’t exist on other platforms. Oracle’s move encourages that distrust.

    While Oracle has stopped all IBM i-related development with MySQL and is no longer taking formal technical support calls, it doesn’t mean the end of the road for professionals interested in continuing to develop MySQL applications for IBM i or using the DB2/400 storage engine (officially IBMDB2i). It just means that IBM i shops will have to buck up a little bit, and start learning to love the open source.

    Allison Butterill, IBM’s application development offerings manager for Power, notes that the MySQL resources are there for IBM i developers to start taking matters into their own hands.

    “You can download the source from the website and compile it yourself. So you can create the binaries–just the finished binaries are no longer available,” Butterill told IT Jungle recently. “And it is still supported the way that most open source is supported, which is through the user community, through forums.”

    There may still be professional support offered for MySQL. IBM says it’s talking with Zend Technology about the possibility of creating a formal technical support organization to create IBM i binaries for MySQL and provide tech support for the database. Zend, which develops and supports the PHP scripting language, already distributes MySQL binaries for IBM i with its Zend Server package. Because Zend is already working with these products (including IBMDB2i), it wouldn’t be much of a stretch for Zend to be the official go-to organization for professional support.

    Nothing has been formally announced, yet. But even if Zend doesn’t take the ball and run with it, there are other possibilities.

    Alan Seiden, is one IBM i professional who thinks the midrange community may be willing to try something different. While a formal tech support agreement would be best, Seiden–who develops software for Strategic Business Systems of New Jersey and writes a blog on PHP and IBM i issues–thinks the IBM i community may turn to the open source community to support their MySQL-on-IBM-i implementations.

    “For the more adventuresome among us, the open source route might be fine,” Seiden says in an e-mail. “Most of us in the i community who are using MySQL seem to use it for packaged standalone applications such as WordPress, Drupal, or SugarCRM, not for business-critical transaction processing, for which DB2 is still king. At least that’s what I see today.”

    However, the situation surrounding the IBMDB2i storage engine, which is owned by IBM, is different. The product, which allows MySQL applications to access data stored in DB2/400 tables, was first listed as a development goal in the original IBM i agreement between MySQL and IBM in 2007, and was delivered in May 2009. IBM i shops who have adopted MySQL have started to use it as a bridge between existing DB2/400 data and their PHP applications.

    Seiden, for one, hopes the storage engine stays part of IBM. “I assume and hope that IBM will continue to maintain IBMDB2i or otherwise allow its further development within any new arrangement,” he says.

    In the meantime, the IBM i community will wait until IBM and its partners determine the best way to move forward with MySQL.

    RELATED STORY

    Oracle Drops MySQL Support for IBM 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
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    SEQUEL Software:  FREE Webinar. SEQUEL: The Only Data Access Tool. Jan. 26
    ProData Computer Services:  We've added MORE! DBU 9.0 Now Available!
    Four Hundred Monitor Calendar:  Latest info on national conferences, local events, & Webinars

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    IBM Is One Step Closer to High Speed, Low Power Racetrack Memory A Reusable Routine for Doubly-Linked Lists, Part 2

    Leave a Reply Cancel reply

Volume 11, Number 3 -- January 25, 2011
THIS ISSUE SPONSORED BY:

Vision Solutions
PowerTech
ManageEngine
Computer Keyes
Twin Data Corporation

Table of Contents

  • Security Scoreboard Adds Analytics to Crowd-Sourced Product Reviews
  • Data Domain Delivers Native IBM i Support
  • MySQL Support Options for IBM i Customers
  • ASCI Delivers Java Support with Job Scheduler
  • Capitalware Unveils New WebSphere MQ Auditing Tool
  • UDO Owner Quiet Over Plans for New ‘Storage Product’
  • Lawson Puts M3 Portal on iPad
  • Gumbo Delivers New Goodies in Dumpster
  • SolarWinds Debuts Application Performance Monitor
  • Drummond Unveils AS2 Certificates

Content archive

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

Recent Posts

  • ARCAD’s Deal with IBM for DevOps In Merlin Is Exclusive
  • In The IBM i Trenches With: Maxava
  • Is The Cloud On Your IBM i Horizon?
  • Four Hundred Monitor, September 20
  • IBM i PTF Guide, Volume 25, Number 38
  • The Subscription Pricing For The IBM i Stack So Far
  • Facing The Challenges Of Upgrading Old Systems With The Cloud
  • Guru: Generating XML Using SQL – The Easy Way
  • Rocket Buys Data Integration Provider B.O.S.
  • IBM i PTF Guide, Volume 25, Number 37

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 © 2023 IT Jungle