MySQL is still alive on IBM i

Over the past week I’ve received several emails, ranging in tone from panicked to angry, seeking clues to the fate of MySQL on IBM i. The database vendor Oracle—recent buyer of Sun Microsystems, and therefore of MySQL—has issued an end-of-life notice for MySQL distributions on IBM i.

IBM i’s primary database is still db2, but many in the community have grown to trust MySQL when deploying MySQL-based applications such as WordPress, Drupal, Joomla, and SugarCRM. Some have trusted MySQL enough to let it into their inner application sanctum, using the IBM DB2 for i Storage Engine (IBMDB2i) to share data between MySQL-based applications and traditional db2-based apps and languages (think RPG).

Now that trust seems to be shattered.

Fortunately, MySQL is an open source product. Zend is still distributing existing versions of MySQL for i, and even if Oracle ceases to create new distributions, someone else can pick up the slack.  An article in IT Jungle quotes IBM’s Allison Butterill and Ian Jarman as offering hope that IBM can find a way to maintain MySQL as an officially supported database, possibly with Zend’s help. It’s all speculation at this stage, but IBM seems to be considering the alternatives and wants to choose the right path.

Forgive me if I seem unduly sanguine about the situation, but many of us ran MySQL on the i before any of these official distributions existed. Back in 2005, the now-defunct site i5php.net hosted distributions of both PHP and MySQL that were compiled for for the IBM i (called the i5 at that time).

The dust hasn’t settled yet. Anything can happen. Yet I believe that MySQL’s open source licensing will, in the end, rescue it from Oracle’s decisions, allowing MySQL to remain viable on the IBM i—with the help of those who care.

This entry was posted in db2, IBM i, iSeries, MySQL, Open Source, System i. Bookmark the permalink.

13 Responses to MySQL is still alive on IBM i

  1. Pingback: Alan Seiden's Information Technology » MySQL is still alive on IBM i | mysql

  2. Ira Chandler says:

    Unduly sanguine? Duly, methinks. These things seem to have a way of sorting out. Who REALLY expected Oracle to support IBM, anyway?

  3. Ryan says:

    Jeez! I just had a meeting yesterday were we discussed the viability for a linux-based Drupal installation to write data to our iSeries DB2 database. IBMDB2i was the answer.

    Now I am unsure if we should proceed given the recent announcement from Oracle.

    Quite disappointing news indeed.

  4. Alan Seiden says:

    Hi, Ryan: Yes, Oracle has created uncertainty for organizations such as yours that are considering the use of the IBM DB2 for i storage engine. Your Drupal idea makes so much sense that if I were you, I’d allow a little time for further news to emerge.

  5. Matt says:

    @Ryan The good news is Ryan that you could proceed and install of Drupal on Windows or Linux and then migrate it to IBM i when and if MySQL comes back to life on IBM i. We were discussing a similar option (but with Joomla) and we will proceed but run everything on Windows Server.

  6. Alan Seiden says:

    @Matt yes, you’re right, it’s easy to move the MySQL database back and forth from IBM i to Linux, Windows, or whatever, but without the IBMDB2i engine, he couldn’t write the data to his DB2 database.

    To clarify, as of today MySQL and the db2 engine are still available from Zend. The issue is whether future MySQL releases will be supported, and by whom.

  7. Sarel says:

    Why is MySQL leading the pack of open source db solutions? The GIS world has embraced PostGeSQL for such a long time I cant understand the hype of MySQL. Is there more marketing power behind MySQL?

  8. Alan Seiden says:

    @Sarel Your point about PostgreSQL is well taken. Oracle’s recent actions regarding MySQL have been creating positive buzz about PostgreSQL. MySQL has been paired with PHP in people’s minds for a long time, and is still important because of the applications that run on it, but PostgreSQL may have a strong future. I saw a presentation at NY-PHP recently about PostgreSQL (http://www.nyphp.org/PHP-Presentations/123_EnterpriseDB-Postgres-PHP) and was impressed with how robust it appeared to be, relative to the other open source databases.

  9. Alan Seiden says:

    Follow-up article by Alex Woodie in IT Jungle: http://www.itjungle.com/fhs/fhs012511-story02.html. The article quotes me about the willingness of the IBM i community to accept an open source model for MySQL, and IBM’s options for providing commercial support.

  10. Alan Seiden says:

    Update: Zend will provide IBM i customers with MySQL under the name “Zend DBi.” For more information, see:
    http://www.itjungle.com/tfh/tfh092611-story02.html
    and http://mikepavlak.blogspot.com/2011/09/zend-dbi-to-rescue.html

  11. Pingback: links for 2011-01-25 | Freelabs

  12. Do not simply let them have one topic repeatedly gain. Strategic positioning of content is
    also important. Did they payy a bundle for being at the top 10 page.

  13. Chris says:

    What’s up, I desire to subscribe for this weblog to take latest updates, so where
    can i do it please help.

  14. The Stylish Cheap Jersey Hot Sale Online Right Now,The Excellent Quality
    With Surprsing Discount In Progress,Ship From China.Please Don’t
    Miss It. Access:wholesale jerseys

  15. Flossie says:

    Will customers eventually be yours, oor would you like to visit them.
    Perhaps like the life oof a designer or writer. We unfortunately
    see a lot of this within our industry.

  16. defeat says:

    SPELLBIND (v.) – to bind by or as if by spell,” 1808, in all probability
    a again-formation from spellbound.

  17. wheat says:

    Name them tax-avoiders or terrorists!

  18. The key is getting your pulse rate up, and never having much calories within you, so that your body decides of burning off the extra
    fat. Eat reasonable portions (cease eating if you are full).
    Eating a structured meals are the main factor for weight loss in a faster and easier way.

  19. MySQL is still alive on IBM i | Alan Seiden Consulting: PHP and IBM i Expertise
    Cheap Oakley Confront For Sale http://www.whatisaxapta.com/en/oakley-sunglasses-replica-confront-cheap-sale.php

  20. Etsuko says:

    Your blog can go viral, you need some initial traffic only.
    How to do that??? Search in google for: Willard’s
    Tips SM Traffic

  21. Also, with what condition will be the fireplace’s masonry.
    tink should you be furnace is leaking Carbon Monoxide.
    Pressure Wash woold siding in order to prevent mold.

  22. Lebron James says:

    Hurrah! At last I got a blog from where I know how to genuinely obtain helpful information regarding my study and knowledge.

  23. I always want the purchaser to become at the house with me.
    Does it slant away from the main wall from the house.

    Don’t be worried to question questions about the process.

  24. Aja says:

    Hello there! I could have seorn I’ve been to thijs blkog before but affter going through some of the articles I realized
    it’s new to me. Anyways, I’m certainly delighted I discovered it and I’ll bee
    bookmarking it and checking baxk frequently!

  25. Centranz says:

    Thanks ffor a marvelous posting! I certainly enjoyed reqding it, you
    are a great author.I will remember to bookmark your blog
    and definitely will ccome baxk at some point. I want to encourage you to ontinue
    your great writing, have a nice morning!

  26. Diego says:

    I like itt when people come togethr and share views.

    Great site,stick wwith it!

  27. Aw,this was a really nice post. Finding the time and actual effort to produce a great article… buut what can I say…
    I put thongs off a whoole lot and don’t manage to get anything done.

  28. IrishMannino says:

    I see, that your website needs fresh and unique articles.
    I know it’s hard to write articles manually everyday, but there is solution for this.
    Simply search in google for: Erlory’s Essential Tool

  29. Keywolrd search software is often confusing. Now you ought to be prepared
    to start a new business. One can just enter in the blog contennt and, “Voila”.

  30. Lebron James says:

    Everything is very open with a really clear clarification of the challenges.
    It was truly informative.Your website is extremely helpful.
    Thanks for sharing!

  31. The wholesale jerseys outlet sale right now, wholesale fashionable
    sports nike NFL jerseys from China are selling. we
    offer fast shipment & good quality to you, check us out!

    More From: nike nfl jerseys wholesale

  32. The fantastic cheap jerseys free shipping from China hot sale online, choose your like sports
    NFL jerseys from us. Place order with us get big deal & fast shipment.
    More at: cheapjerseys-freeshipping.com

  33. Like other things, blogging has evolved over time. Video mareting might be a bit
    intimidating at first. If you hve a bad review, don’t attak the reviewer.

  34. Latest selection of Youth NFL Jerseys for Pro Bowls. Get game
    kids uniforms here,wholesale draft jerseys online free shipping,worth it.
    More at: Youth NFL Jerseys & Buy Cheap Kids Color Rush Uniforms

  35. Latest selection of Youth NFL Jerseys for Pro Bowls.
    Get game kids uniforms here,wholesale draft jerseys online free shipping,worth it.

    More at: Youth NFL Jerseys & Buy Cheap Kids Color Rush Uniforms

  36. I think that what you typed was actually very logical.
    However, think about this, suppose you added a little information? I ain’t suggesting your information is not solid., however suppose you added a
    post title that grabbed people’s attention? I mean MySQL is still
    alive on IBM i | Alan Seiden Consulting: PHP and IBM
    i Expertise is kinda boring. You might peek at Yahoo’s front
    page and see how they write article titles to get people to open the links.
    You might try adding a video or a picture or two to grab readers excited about what you’ve got to say.
    In my opinion, it might bring your website a little bit more interesting.

  37. Julia says:

    Nice post. I used to be checking continuously this blog and I am
    inspired! Very useful information specially the remaining section :) I take
    care of such information much. I used to be seeking this particular information for a long time.
    Thanks and good luck.

  38. I don’t know if this is cool from a young person’s perspective, but from a parents view
    point it was a comforting thought knowwing the car would lock itself and
    protect the occupabts inside. Even if you are interested in visiting the surrounding areas, traveling by car
    remains the moswt convenient method. Good driving schools are known to intersperse theory lessons
    with practical driving classes. s estimated blood alcohol concentration was
    between 2. , driver and front paassenger airbags, pelvisbags and sidebags,
    driver kneebag and NECK-PRO head restraints for front
    seats.

  39. Their main aim is to provide a 100% satisfaction to their customers.
    They should face any worst conditions in their life and
    can achive whstever they have drreamt of for their career.
    The Chrysler Aspen Hybrid, owing to its inherent ruggedness,
    is best suited for those who often need to transport cargo or tow stuff.

    Theor Rolls Royce Spares DECOKE KIT (RH2130P) is thhe
    cylinder head kit that includes gaskets, washers, seals &
    hoses and many more products. Audi: Apple Car – Pllay and Android
    Auto will be available on the Q7 SUV, which goes oon sale early next year.

  40. Cheap Jerseys sale with great quality. And we also wholesale jerseys of NFL,NHL,NBA,NCAA,
    MLB online. Find those cheap wholesale jerseys both classic &
    popular for men women kids, free shipping from China.

    Come to buy:Cheap Wholesale Jerseys

  41. Denver Broncos,Denver Broncos #18 Peyton Manning Blue Stitched NFL Jerseys,
    T-Shirts, Apparel, Gear for Men,Women and Kids. Buy your boy/girl the wholesale
    price jerseys, other great hot jerseys for pick.

Leave a Reply

Your email address will not be published. Required fields are marked *