Slashdot Mirror


Why You Shouldn't Panic About Closed Source MySQL Extensions

jfruhlinger writes "Oracle has released proprietary extensions to the open source MySQL database, seeming to reinforce the worst fears of those in the open source community who opposed Oracle's acquisition of MySQL in the first place. But open source observer Brian Proffitt urges you not to panic: This dual source strategy really isn't unusual in the commercial open source world, Oracle has already released a bevy of open source improvements to the database, and anyway the EU extracted a commitment to keep MySQL open for another four years when it approved the Sun-Oracle merger."

26 of 171 comments (clear)

  1. lol by Alex+Belits · · Score: 4, Funny

    open source observer Brian Proffitt

    lol

    --
    Contrary to the popular belief, there indeed is no God.
  2. Just another 4 years... by unixisc · · Score: 3, Insightful

    ... after which Oracle will be @ liberty to digest MySQL as closed, and the EU will have nothing to say about it.

    1. Re:Just another 4 years... by d4fseeker · · Score: 4, Insightful

      And, as with OpenOffice, the community will fork the Database and add a bunch of useful features to it.
      Finally Oracle will either "donate" MySQL back to the community or keep it closed source and everyone will move over to PostgreSQL.
      4 years is 2 Server and, depending on your scneario, 1-3 Software Generations away so let's not panic before Oracle has committed to anything.

    2. Re:Just another 4 years... by Anonymous Coward · · Score: 5, Informative

      Its already forked :)
      http://mariadb.org/

    3. Re:Just another 4 years... by Dark$ide · · Score: 3, Informative

      Its already forked :) http://mariadb.org/

      And to http://www.drizzle.org/

      --

      Sigs. We don't need no steenking sigs.

  3. I just migrated... by Kagetsuki · · Score: 4, Interesting

    from MySQL to PG. It was easy. You should do it too.

    1. Re:I just migrated... by Errol+backfiring · · Score: 2

      Because there are a lot of types of data:

      Live data Should off course not be in an upgrade SQL script Settings Insert-only, should not be updated when present. This is where you would use INSERT IGNORE (or INSERT .. ON DUPLICATE KEY UPDATE somedummyfield=somedummyfield if you dislike INSERT IGNORE) System data For instance, Object-Relational-Mapping data. Should be set to the new value. INSERT .. ON DUPLICATE KEY is perfect for this. What's more, with MySQL's multirow inserts, you can make statements that are legible even if you set more than one field. Standard SQL's MERGE command is the least legible command I ever saw, and as far as I know Postgress does not even support MERGE.

      In agile programming, both structural and content changes are often necessary. These must be done on both local development databases, test databases and live databases. So you would want the SQL script in your source code control system and be able to run non-interactively. For an example, see Evolving A Database With MySQL.

      --
      Nae king! Nae laird! Nae yurrupiean pressedent! We willna be fooled again!
    2. Re:I just migrated... by buchner.johannes · · Score: 4, Informative

      Migrating from MySQL to PG may be easy, but migrating from MySQL to MariaDB is trivial.

      --
      NB: The message above might reflect my opinion right now, but not necessarily tomorrow or next year.
  4. because by roman_mir · · Score: 3, Informative

    because of postgresql?

  5. "open for four years" by KiloByte · · Score: 5, Insightful

    By "keep MySQL open for another four years", they mean "pay lip service to its life support, then on day 1462 stop even that". Sorry, but unless one of independent forks really takes off, I'm not going to even look at something else than Postgres. For that "bevy of open source improvements", what exactly has been added? Heck, MySQL development has been dormant even during Sun days.

    --
    The creatures outside looked from Alt-Right to Antifa; but already it was impossible to say which was which.
    1. Re:"open for four years" by hholzgra · · Score: 5, Informative

      As if PostgreSQL didn't have it's own ecosystem of commercial-only extensions, too (EnterpriseDB, GreenPlum, just to name a few) ... the big difference here is that in the MySQL ecosystem Oracle is the only one that can do such dual-license stunts while in the PostgreSQL ecosystem anybody can ... (whether that's good or bad is a different story)

      For "improvements"/"what's been added":

      * lots of multi CPU scalability work (although part of it came from Google/Facebook and other sources where Sun/Oracle 'just' did the integration work)
      * MySQL Cluster got a *lot* better in Sun/Oracle days
      * the InnoDB plugin improved InnoDB affairs a lot (and this has been Oracles baby even in the Sun days)
      * connectors, e.g. PHP/mysqlnd
      * more interesting InnoDB improvements (e.g. fulltext indexes, finally) are in the queue, how these are going to be licensed remains to be seen though

      It's not that everything is going into the optimal direction with MySQL under Oracle (i'm not working for them anymore for a reason), but saying there has been no development ever since the Sun acquisition is not fair, and i don't see any reason to believe that things will radically change on day 1462 either ...

    2. Re:"open for four years" by JustOK · · Score: 3, Funny

      The original version had a default Sabbath value of SAT, while the two common forks use either FRI or SUN.

      --
      rewriting history since 2109
    3. Re:"open for four years" by Zontar+The+Mindless · · Score: 2

      InnoDB has been added in 2001. Replication has been there since forever. You're listing old features of MySQL, not additions done by Oracle.

      InnoDB becomes the default storage engine in MySQL 5.5, a non-trivial change from earlier versions (where MyISAM was the default).

      Semi-synchronous replication is a new feature of replication in MySQL 5.5.

      All of the other features mentioned by the AC are also either new or singificantly changed in 5.5.

      --
      Il n'y a pas de Planet B.
  6. Why you shouldn't panic? by eexaa · · Score: 3, Insightful

    ...because if you aren't already running some better DBMS, chances are that you are probably generally unable to panic about any DBMS quality.

  7. Re:Migration Window by GPLHost-Thomas · · Score: 3, Informative

    Wake up. MariaDB has been around for some time already!

  8. Enjoy your crumbs. ...oh stop looking at the cake by ciaran_o_riordan · · Score: 2

    Free software is about setting minimum levels of respect: the four freedoms.

    Many projects go beyond this, by using copyleft, by assisting community participation, by being transparent, etc.

    By abandoning this standard, Oracle shows itself as just another free software freerider, not to be trusted and not worthy of community support or good will.

  9. VirtualBox by AdamInParadise · · Score: 3, Interesting

    In VirtualBox v4.0, Oracle released the core as an open-source projet and the proprietary extensions as a plug-in. This proprietary extension is free for home use but commercial users must by a licence. The extension is not 100% necessary but does provides some very useful features, such as being able to connect to the "console" of a headless VM. Cool right?

    Well, not really. There is at the moment no way to actually buy such a licence from Oracle, so all the people using VirtualBox v4.0 with this extension in a business are technically out of compliance.

    VirtualBox is cool, but they really need some leadership from Oracle.

    --
    Nobox: Only simple products.
  10. Open, but poisoned. by AliasMarlowe · · Score: 2

    How long did it take for LibreOffice to take over from OpenOffice?
    You'll probably see a perfect replacement fork for MySQL the day it's open source life ends.

    Perhaps the binary-only extensions from Oracle are part of an attempt to prevent that sort of thing. After all, if a large part of the user base is hooked on non-forkable proprietary extensions during the next few years, then forking MySQL when Oracle's commitment to keep it FOSS expires would be largely fruitless. Moreover, relying on these extensions may also make it harder to port one's DB and related applications to Postgres or other alternatives.

    For this reason, I'd say Mr. Proffitt is utterly wrong: there is much to worry about. Each proprietary binary extension is potentially a poisoned chalice, and should be viewed as such.

    --
    Those who can make you believe absurdities can make you commit atrocities. - Voltaire
  11. Guess it will no longer be in the linux repos by nzac · · Score: 2

    I would think most distros will have policies that will make this a second class DB or drop it entirely. It rules it out of Debian for the next release, openSUSE will drop it to non-oss, gentoo wont like binaries and so on.

    Having to go the Oracle website to get it would put off the majority of new non-commercial users or anyone wanting automatic update notification.

    1. Re:Guess it will no longer be in the linux repos by hholzgra · · Score: 2

      Does it rule out PostgreSQL from being released with Debian as there are commercial/non-oss extensions to it like EnterpriseDB?

      Sure, the non-GPL "Enterprise Edition" will not make it into any distribution, but for the GPL edition licensing would not be the reason for not distributing it any longer (although other reasons may lead to one of the forks becoming the default and Oracles GPL version only an alternative, but this will for sure be not for license reasons alone if/when it happens ...)

  12. Poisoned chalice devalues forking... by AliasMarlowe · · Score: 5, Interesting

    And, as with OpenOffice, the community will fork the Database and add a bunch of useful features to it.
    Finally Oracle will either "donate" MySQL back to the community or keep it closed source and everyone will move over to PostgreSQL.

    I suspect the binary-only extensions from Oracle are part of an attempt to prevent that sort of thing. After all, if a large part of the user base becomes reliant on non-forkable proprietary extensions during the next few years, then forking MySQL when Oracle's commitment to keep it FOSS expires would be largely fruitless. Moreover, relying on these extensions may also make it harder to port one's DB and related applications to Postgres or other alternatives. Furthermore, a MySQL donated to the community would be worthless to those who need the extensions (and nothing prevents Oracle from making those extensions quite expensive later). Conceivably, the extensions could even make it easier to port to a commercial DB offering from Oracle, if they are cunning enough.

    For this reason, I'd say Mr. Proffitt is utterly wrong: there is much to worry about in these extensions. Each proprietary binary extension is potentially a poisoned chalice, and should be viewed as such.

    --
    Those who can make you believe absurdities can make you commit atrocities. - Voltaire
    1. Re:Poisoned chalice devalues forking... by znrt · · Score: 2

      I suspect the binary-only extensions from Oracle are part of an attempt to prevent that sort of thing. After all, if a large part of the user base becomes reliant on non-forkable proprietary extensions during the next few years, then forking MySQL when Oracle's commitment to keep it FOSS expires would be largely fruitless.

      That's an obvious possibility but for now its just "extensions": monitoring and and mostly fancy stuff for enterprise dba. Nothing the big majority of mysql base can't live without (if of any real interest at all). Anyway if your software depends critically on this kind of stuff (or any other propietary candy) then you have bigger problems to worry about than Oracle.

    2. Re:Poisoned chalice devalues forking... by Just+Brew+It! · · Score: 2

      OK, but under this scenario you're already locked into a closed-source solution anyway (this hypothetical other commercial product). I don't see how something that solution depends on also being closed-source makes things any worse.

      I still fail to see how this move by Oracle represents a serious (or even moderate) threat to FOSS. MySQL has been dual-licensed since day 1. Are people just now waking up to the fact -- 16 years late! -- that whoever owns the MySQL code base is allowed to have their own proprietary fork?

  13. Re:Migration Window by cpghost · · Score: 2

    Last time we checked we would need at least 3-4 times the hardware if we wanted to move to PostgreSQL.

    I've migrated dozens of BIG sites from MySQL to PostgreSQL over the last couple of years, and I can confirm that more RAM was needed in some cases. But since this was on enterprise-class servers running 64-bit OSes (on SPARC and amd64), adding some GB RAM wasn't a big deal. The result was even better performance, both on Solaris and FreeBSD. The applications were never short of CPU cycles though.

    So if you need 3-4 times the hardware, you're doing something wrong. Definitely wrong.

    --
    cpghost at Cordula's Web.
  14. Re:Migration Window by GPLHost-Thomas · · Score: 3, Informative

    What features will be added to MySQL that MariaDB doesn't have?

    Oh, maybe you meant "what killer features that have been already in MariaDB are still not in MySQL"? Yeaaarh, I'm sure you made a mistake. In this case...

    Ever wonder why MySQL is still stuck with a single core taking 100% of your CPU, while other cores are idling doing nothing? MariaDB, and it's been more than a year it does, had multi-threading. If you didn't know, it's been written by one of the main authors of MySQL in the first place, that felt he shouldn't stay in this Oracle world. And he's doing very well, by himself... The good thing: MariaDB is ABI compatible. Yes, it's a pure replacement. Remove MySQL, install MariaDB instead, and there you go, you got a multi-threaded MySQL. That alone is enough to convince any decent admin.

  15. FOR THE LOVE OF GOD MAN, POSTGRESQL by nemmi · · Score: 2

    After the release of Postgresql 9.x. MySQL has no place, period. MySQL can't even get UTF-8 right. Bug laden transaction support. TS engine? CRAP. Trash OO wannabe. If you do not need the features, then use mongo or couch. I don't know why anyone would use it knowing Postgresql exists.

    mysql = java = sun = oracle = trash