Slashdot Mirror


Widenius Warns Against MySQL Falling Into Oracle's Hands

jamie sends in a blog post from MySQL co-founder Monty Widenius calling for help to "save MySQL from Oracle's clutches." While the US DoJ approved Oracle's purchase of Sun back in August, the European Commission has been less forthcoming. Widenius points out that Oracle has been using their customers to put pressure on the EC, and he questions Oracle's commitment to MySQL, saying their vague promises aren't good enough. He writes: "Oracle has NOT promised (as far as I know and certainly not in a legally binding manner): To keep (all of) MySQL under an open source license; Not to add closed source parts, modules or required tools; To not raise MySQL license or MySQL support prices; To release new MySQL versions in a regular and timely manner; To continue with dual licensing and always provide affordable commercial licenses to MySQL to those who needs them (to storage vendors and application vendors) or provide MySQL under a more permissive license; To develop MySQL as an Open Source project; To actively work with the community; Apply submitted patches in a timely manner; To not discriminate patches that make MySQL compete more with Oracle's other products; To ensure that MySQL is improved also in manners that make it compete even more with Oracle's main offering."

52 of 278 comments (clear)

  1. So fork the damn thing already! by wiredog · · Score: 4, Insightful

    That's one of the reasons we have open source licenses. So we can fork if we have to.

    1. Re:So fork the damn thing already! by Anonymous Coward · · Score: 3, Insightful

      so a guy who sold out is now worried about what he sold?

    2. Re:So fork the damn thing already! by tomhudson · · Score: 4, Interesting

      so a guy who sold out is now worried about what he sold?

      It's worse than that - Monty is a greedy self-centered pig. He sold it, then waited long enough so that he couldn't be sued (non-compete), then starts whining about how nobody else can be trusted with it.

      If Oracle *doesn't* get it, I'm switching everything to a combination of PostgreSQL and NoSQL. I trust Oracle more than Monty any day. Oracle at least has a business case to not screw around - unlike Monty, who has already demonstrated his crappy ethics.

    3. Re:So fork the damn thing already! by mrmeval · · Score: 2, Interesting

      That is possible if I read this right. http://it.toolbox.com/blogs/php-bsd-me/the-mysql-license-8922
      It would leave any closed source licensed versions dependent on Oracle or force them to carefully separate out their code from mysql so they can use the forked version.

      I would use Postgresql http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL since it's standards compliant, feature full and is fast if properly configured.

      --
      I'd go on a Vegan diet but the delivery time from Vega is too long. --brownkitty
    4. Re:So fork the damn thing already! by Toze · · Score: 2, Informative

      Fork it and then name it MariaDB, specifically. Sun buys MySQL. Monty complains about Sun's treatment of MySQL. Monty leaves MySQL. Monty forks MySQL. Monty complains about Oracle. This isn't exactly a surprising development.

      --
      No OS on the planet can protect itself from a user with the admin password. - Yvan256
    5. Re:So fork the damn thing already! by mangu · · Score: 2, Interesting

      I'm switching everything to a combination of PostgreSQL and NoSQL.

      Not willing to start a religious war here, but I always liked Postgres better than MySQL, for its features alone.

      However, I don't like Oracle getting hold of MySQL. I have enough trouble with managers who blindly follow the Oracle gospel. Better not to have the same managers saying "OK, if you want a lightweight open source database then why don't you use MySQL?"

    6. Re:So fork the damn thing already! by NoYob · · Score: 2, Funny
      Since Oracle is probably getting MySQL, I was thinking of a fork. With Oracle's licensing terms that I've heard about, I think a fork of an Oracle product should be called "SQLLikaPig"?

      SQL is pronounced .in many old timer circles as "squeal".

      --
      It's NOT me! It's the meds! I'm on 1000mg of Fukitol.
    7. Re:So fork the damn thing already! by tomhudson · · Score: 5, Informative

      SQL is pronounced .in many old timer circles as "squeal"

      Old-timers never pronounced it "squeal" or "sequel" - that's a give-away that you're either a newbie or you come from a Microsoft background. Real old-timers pronounce it "ess queue ell".

      Just saying ...

    8. Re:So fork the damn thing already! by whrde · · Score: 2, Interesting

      It's possible that open source licences can be revoked by the copyright/IP holder. Under anglo common law, a bare licence can be revoked, but a contractual licence can't be --- It all depends on whether you consider there to be a contract, supported by consideration (ie someone of value is exchanged for the licence). I personally believe there is consideration and so no one can revoke open source licences. But unlike the US courts, Australian courts don't seem to agree. (I wrote a dissertation on this problem: feel free to read it)

    9. Re:So fork the damn thing already! by Vexorian · · Score: 2, Interesting

      What's worse is that he is attempting to make the EU commision require forcing oracle to change the license from the GPL I guess this will become typical of codeplex foundation members...

      --

      Copyright infringement is "piracy" in the same way DRM is "consumer rape"
    10. Re:So fork the damn thing already! by tomhudson · · Score: 3, Insightful

      Then why does he have to lie?

      Why does he want to have the EU retroactively invalidate the GPL grant-back?

      We would like to draw attention to the fact that some major concerns about the effects of the proposed transaction could be somewhat alleviated by requiring that all versions of MySQL source code previously released under the GPLv2 license (whether in a General Availability, Release Candidate, Beta, Alpha release, or as public bazaar or bitkeeper revision control trees) must be released under a more liberal open source license that is usable also by the OEM users and would also create an opportuity for other service vendors to compete with offerings comparable to MySQL Enterprise. A good candidate is the Apache Software License.

      We believe this could be a FOSS-specific approach to addressing the ownership of some of the key assets involved, as an alternative to conventional conditions imposed on such transactions.

      Section 5.5 of the supplementary document discusses this possible measure.

      In other words, he wants to be able to use and distribute GPL'd code without having to distribute the changes. Greedy pig indeed.

      Or this:

      The "copyleft/infection" principle of the GPL license represents a particular obstacle not only to revenue generation by the fork vendor but also to the overall adoption and market penetration of MySQL, MySQL forks and MySQL storage engines....

      Under such open source licenses as the Berkeley Software Distribution (BSD) license and the Apache license, proprietary derivatives are legal. The only obligation might be attribution.

      Where else have we heard about the GPL being an infection?

    11. Re:So fork the damn thing already! by TemporalBeing · · Score: 3, Informative

      That's one of the reasons we have open source licenses. So we can fork if we have to.

      He did already - it's called MariaDB. He just doesn't like the fact that his fork has to be GPL only - he can't integrate any commercial code like he did when he owned MySQL AB. I don't think I can put it any better here than I did at Groklaw (see this comment. Basically:

      • Monty made MySQL; licensed it under a dual license (GPL + MySQL Commercial License)
      • dual license structure worked well for MySQL AB - prevented commercial competitors, fostered community around GPL version
      • Monty sold MySQL AB to Sun for $1B without changing the license. No compliants; he worked for Sun.
      • Sun seems to be under the gun and going to get sold off - Monty quits, tries to fork MySQL as MariaDB. Wants to build a new "MySQL AB" under another name; but the dual license prevents it.
      • See opportunity to force Sun to change the license so he can keep his money from the sale, while still getting all the code, possibly also the commercial code, and redo MySQL AB
      • Monty's looking to do a "rinse-repeat".

      Monty just doesn't like the hand that he dealt himself - one he had every opportunity to change while he owned MySQL AB, probably even would have been able to influence while he was a Sun Employee too; but never complained (that we know of while he was at Sun) and never did (when he had the chance himself - he could of done it as part of the sale to Sun).

      Yeah - he could just setup a services-oriented company around MySQL; but he doesn't want that - he wants his MySQL back, as well as the money he took from Sun. It's all about his wallet; nothing else.

      --
      Truth is like the sun. You can shut it out for a time, but it ain't goin' away. - Elvis Presley (source: imdb.com)
  2. And what did Monty do? by Anonymous Coward · · Score: 5, Insightful

    Besides being a hippocrite, after he was paid, bolted for the door the first opportunity he got. If it was so important to him, he wouldn't have sold to Sun in the first place. Man up and stay with the company and product if you are so concerned.

    1. Re:And what did Monty do? by SteveFoerster · · Score: 4, Funny

      Besides being a hippocrite

      Whoa, is that like being a big, fat hypocrite?

      --
      Space game using normal deck of cards: http://BattleCards.org
    2. Re:And what did Monty do? by Jesus_666 · · Score: 4, Funny

      No, a hippocrite is someone who uses one set of values to judge himself and another to judge hippopotami.

      --
      USE HOT GRITS WITH STATUE OF NATALIE PORTMAN (NAKED AND PETRIFIED)
    3. Re:And what did Monty do? by diegocg · · Score: 2, Interesting

      Why? After opensourcing solaris and java, Sun had a great record of being opensource friendly, and they had a LOT of incentives to improve MySQL and compete with Oracle. Sun also was a Big Company that could invest in MySQL more money than MySQL alone could even dream.

      Oracle is a different story. They make a lot of their money from a bussines based in software licenses of their closed-source database. Opensource competence kills their bussiness model. They clearly don't have many incentives to make MySQL compete with Oracle - unless bankrupcy is a bussiness model. And MySQL CAN compete with Oracle long-term - look what a JokeOS Linux was some years ago, and how today it has eaten most of the Unix bussiness.

      So why Monty is an hypocrite? It's Sun who has sold out, not Monty. The decisions where Monty was involved were to make mysql BETTER. How could he expect that Sun was going to die? Is he an hypocrite just because he wants to avoid the fall of mysql?

  3. Greed... by Anonymous Coward · · Score: 4, Funny

    So, now, being a very rich guy (1B is a lot of money), he wants to it back for free? That's fair... Right...

    1. Re:Greed... by MightyMartian · · Score: 2, Insightful

      He can always fork it (unless he's signed some sort of non-compete agreement). I don't really get the issue. Everyone knew Oracle was probably going to do evil, Oracle is one of the BIG evils, though it never gets sufficient attention around here, what with the likes of Microsoft and Apple.

      --
      The world's burning. Moped Jesus spotted on I50. Details at 11.
  4. There is no spoon by BadAnalogyGuy · · Score: 5, Funny

    It's strangely appropriate that Neo, when he went to see the Oracle to find out that he is The One, was also shown that the reality he was constantly presented with was simply a computer manipulation. This is why "there is no spoon" was such a critical piece of the Matrix puzzle. There may be no spoon, but there can still be a fork.

    The Oracle told Neo that he wasn't The One, but the Oracle was lying and just telling him what he needed to hear. The One knows that there is a fork, even if the Oracle leads him astray.

    Then there was a whole lot of crap about rogue agents in the system, but the whole movie was clearly an allegory about databases and the GPL.

    1. Re:There is no spoon by Z34107 · · Score: 3, Funny

      It's strangely appropriate that Neo, when he went to see the Oracle to find out that he is The One, was also shown that the reality he was constantly presented with was simply a computer manipulation. This is why "there is no spoon" was such a critical piece of the Matrix puzzle. There may be no spoon, but there can still be a fork.

      ...

      "Whoa."

      --
      DATABASE WOW WOW
  5. Shoulda said it sooner! by Anonymous Coward · · Score: 3, Funny

    Widenius tell us sooner?!?

  6. Monty Needs to STFU by smack.addict · · Score: 2, Insightful

    If he gave a shit about what happened to MySQL, he would not have sold it.

    Instead, he made gobs of money and no longer has a say in what happens to the property except insofar as he is free to fork it.

    1. Re:Monty Needs to STFU by davecb · · Score: 3, Interesting

      Factually, Oracle bought InnoDB and improved it's performance, while Sun bought MySQL proper and improved it's performance. Not a rational use of their money if the aim was to kill the product. In fact, something of the opposite to what one would want to do to kill it.

      According to Groklaw, the objectors to the deal were Microsoft, who competes with MySQL, SAP, who competes with Oracle, and Monty, who has some kind of relationship with Microsoft, albeit not one involving an explicit employer/employee relationship.

      I smell a rat, arguably involving our favorite monopolist.

      --dave

      --
      davecb@spamcop.net
  7. Jeez what a whiner by dnaumov · · Score: 3, Interesting

    Perhaps Monty SHOULDN'T HAVE SOLD the damn thing in the first place if he's so worried about these things happening, no? Besides, there is NOTHING in the world preventing him from forking it, naming it something else and continuing development. NOTHING.

    1. Re:Jeez what a whiner by Hal_Porter · · Score: 2, Funny

      This being MySQL he can probably figure out a way to both cash the cheque and return it due to dodgy transaction somewhere.

      --
      echo -e 'global _start\n _start:\n mov eax, 2\n int 80h\n jmp _start' > a.asm; nasm a.asm -f elf; ld a.o -o a;
  8. *Exactly* why it is better to have a community by poet · · Score: 3, Interesting

    People in the Open Source community have been warning against this for years with MySQL. It is one of the key tenets in the PostgreSQL vs MySQL playbook. Use PostgreSQL because no single company controls the source. It can't be bought. MySQL dug its own destiny by tying its hand into the GPL AND (note the AND) being owned by a single entity.

    --
    Get your PostgreSQL here: http://www.commandprompt.com/
  9. fork names by Anonymous Coward · · Score: 2, Funny

    How about calling the fork 'MySQL2: The Sequel'?

  10. Who cares what the sell-out thinks? by thetoadwarrior · · Score: 4, Interesting

    No one should take his opinion seriously because if he really cared then it wouldn't have sold it. Just fork the thing and forget Oracle.

    Maybe he's hoping it would stay open source so he could pinch Oracle's improved code an basically have his mysql money and access to the myql code as it improves so he can plug it into his branch.

  11. This really frustrates me... by jregel · · Score: 4, Insightful

    As others in this discussion have pointed out, if the concern about Oracle close-sourcing components of MySQL, then why not fork it now?

    Also, beyond the large installed user base, is there anything particularly important about MySQL as a database that other open source databases cannot do?

    But for me, the biggest frustration is that while there is all this concern about MySQL, the lack of direction is really damaging Sun who make excellent servers (SPARC and x64), software (Solaris 10/Open Solaris with ZFS, Dtrace, Containers etc. etc, OpenOffice, Glassfish, Virtualbox, Sun Cluster (free), QFS/SAMFS (cluster FS)) and many more interesting technologies).

    IMHO, the existence of Sun is a positive thing for the open source community and MySQL is a small and largely unimportant part of Sun's inventory.

  12. Re:Oracle by butlerm · · Score: 4, Interesting

    I agree that Oracle's dominance and proprietary nature places it in a unique position to dictate terms to its customers. The problem is that Oracle is at least twenty years ahead of all of their competitors in database technology. Oracle 7, ca 1991, has a better overall implementation than the latest and greatest from IBM, Microsoft, PostgreSQL, MySQL, and so on. I mean MySQL is barely out of the 'toy' stage (special purpose applications excluded). In the intervening two decades Oracle has widened the gap. That means for a certain classes of OLTP applications, people tend to think you are suicidal if you recommend anything else.

    The only way to minimize this problem is to bring (open source) databases closer to parity, even with where Oracle was twenty years ago. PostgreSQL is the only one that comes close in the open source world. MySQL started out with so many bizarre design decisions and gratuitous incompatibilities, that I wonder if it will *ever* come close, at least not without losing backward compatibility in a big way.

  13. MySQL Founders please stop whining by johnnnyboy · · Score: 4, Insightful

    Seriously, these MySQL founders have been whining ever since they sold out to Sun.
    Please stop. If you're worried about MySQL why did you sell the rights in the first place?

    --
    "If a show of teeth is not enough, bite ... but bite hard!"
    1. Re:MySQL Founders please stop whining by soundguy · · Score: 5, Funny

      Bad anology. Your child wasn't kidnapped. You sold her to a pimp named Scott for a billion dollars so he could handcuff and sodomize her, then pass her around to his friends. Scott had a bad run of financial luck and was worried that his Escalade might get repossessed, so he sold her to a pimp named Larry, who will most likely sodomize and asphyxiate her because she's underdeveloped and inexperienced, which means he can't get any real money turning her out.

      In summation, pimpin' ain't easy and you're a shitty parent with a dead kid.

      --
      Nothing worthwhile ever happens before noon
  14. Re:Oracle by Penguinisto · · Score: 3, Interesting

    Agreed. As a big ferinstance, MySQL just barely got two-way replication w/ 5.1, and even then you had to do some seriously weird hoodoo on it to make that happen (hint: it's not a listed feature)... this is a basic function of any full-on enterprise-level DB.

    Now Postgres comes fairly close, but everyone else can't even touch it.

    If Postgres ever got something resembling the ease and power of RAC, then Oracle would have something to worry about. Until then, they're in a position to dictate whatever terms they want to. (I would've put MS SQL Server as a contender, but clustering that into something resembling RAC is a friggin' nightmare to build and maintain, and I doubt that too many MCDBAs have quite wrapped their heads around using SQL Server on a Core (read: non-UI) install of Windows Server just yet.)

    --
    Quo usque tandem abutere, Nimbus, patientia nostra?
  15. Re:The case should be made to government by butlerm · · Score: 2, Informative

    On the contrary, it is not a problem at all. MySQL can be forked and the people dependent on it can use the forked version indefinitely. The commercial users who want to stick with the evolution of "MyOracle" can pay for the privilege. Everyone is happy. The EC has no need to worry. A fork of MySQL could provide all the necessary competition, to say nothing of PostgreSQL.

  16. Background Info by Anonymous Coward · · Score: 2, Informative
  17. Would not be a loss by Improv · · Score: 2, Interesting

    MySQL is the Visual Basic of databases - clumsy and of poor quality, used most strongly by people who don't know any better. I would be delighted to see MySQL fail as a project and have its mindshare go to projects that are superior, like PostgreSQL. There are only two things I can think of that the world would miss - MySQLe (the embedded version, which competes with BDB-esque type uses - it's a really cool idea) and the solid Windows support (PostgreSQL added this about a year ago - I'm not sure how solid it is yet).

    MySQL's wins tend to be based on good marketing for a bad product.

    --
    For every problem, there is at least one solution that is simple, neat, and wrong.
  18. Business as usual... by Plekto · · Score: 2, Insightful

    #40. I will be neither chivalrous nor sporting. If I have an unstoppable superweapon, I will use it as early and as often as possible instead of keeping it in reserve.

  19. MySQL was never truly open source by jocknerd · · Score: 2, Informative

    As long as there was a company behind it, there was always potential that it could be bought. Switch to PostgreSQL. Nobody owns it.

  20. Re:The case should be made to government by jimicus · · Score: 2, Interesting

    A fork of MySQL could provide all the necessary competition, to say nothing of PostgreSQL.

    It's not quite as bad as it was 5 years ago, but there are still a hell of a lot of F/OSS applications which only support MySQL and users who have neither the need nor the desire to tweak them to support PostgreSQL.

    (Though FWIW, I stopped taking MySQL seriously when I figured out the product was designed with a downright cavalier attitude to data integrity)

  21. This isn't really about MySQL by wsanders · · Score: 3, Insightful

    This is all about the EU blocking Oracle's acquisition of Sun. They are trolling for testimonials about how the Sun acquisition would force people to buy Oracle DB, which is almost certainly would not:

    http://www.moneycontrol.com/news/ibu_index.php?storyid=832

    Look at Berkeley DB (on which OpenLDAP uttely depends.) It's now "Oracle Berkeley DB". I don't see any monkey business with that arrangement (although the OpenLDAP people are probably working on ditching BDB just as due diligence.)

    --
    Give a man a fish and you have fed him for today. Teach a man to fish, and he'll say "WHERE'S MY FISH, YOU IDIOT?"
  22. Why Should Oracle Promise ANY of Those Things? by SwashbucklingCowboy · · Score: 4, Interesting

    Just to make his life easier?

    Welcome to the world of commercial open source...

  23. Re:Oracle by butlerm · · Score: 3, Interesting

    I didn't say "features" (although there are those) but rather "better overall implementation".

    For example, with Oracle you can add columns, drop columns, and modify columns while there are ongoing transactions against the table. Try that with DB2 sometime.

    MySQL is worse:

    In most cases, ALTER TABLE works by making a temporary copy of the original table. The alteration is performed on the copy, and then the original table is deleted and the new one is renamed

    That is a trivial example. Generally speaking, however, Oracle gets significant new features with a high quality implementation about a decade before anyone else does. For example, during the 1990s the lack of MVCC and row level locking were serious problems with virtually every database except Oracle. Without them, you can't reliably run large or long running transactions without risking locking every other user out of the database, even if the transactions don't have any row level overlap.

  24. You guys are missing the point! by vladkrupin · · Score: 5, Insightful

    No single entity controls the source of mysql either. It's GPL. If you want to fork it, fork it. You guys are missing the point.

    The point is Widenius wants to start a new company, and wants to work off of what mysql, the company (and thousands of volunteers who have contributed to the project) have created over the past N years. He does not care if it goes to Oracle, Microsoft, some made-up nonprofit-ish foundation, or dies. He could really care less about that. He wants to build a company that will make a proprietary product and will make him money.

    The thorn in his side, however, is the fact that he can't take the code that was once released as GPL and use it in his proprietary software. He either has to open up his software (which he does not want to do), or else not be able to benefit from all those years worth of effort by mysql AB and others who have contributed to the project.

    If the license was just about anything but GPL (apache, BSD, whatever), he could do just that. But he can't.

    What, you really think it's all about evil Oracle taking over mysql, and it's not really the license that's a thorn in Wideniuses side? Read a more in-depth analysis by someone who understands the issue a _whole lot better_ than I or just about any of you folks do. Here: http://www.groklaw.net/article.php?story=20091208104422384

    --

    Jobs? Which jobs?
    1. Re:You guys are missing the point! by dclozier · · Score: 2, Informative

      I wish the parent could be modded higher - Widenius is a hypocrite and does not give a rat's ass about MySQL. He simply wants it under a closed source friendly license so he can build another business around everyone else's hard work that is in MySQL. Widenius has complained that the GPL prevents other companies from competing. This simply isn't true. PJ at Groklaw sheds the light on this rather well.

  25. Re:No they have not. by nxtw · · Score: 3, Insightful

    but everything else you troll about is the result of using the tool wrong

    This is correct; using MySQL despite the availability of a clearly superior open source competitor is definitely using the tool wrong.

  26. Re:Oracle by butlerm · · Score: 5, Informative

    I don't work for Oracle, and I would like to see other databases to get into the same league inf every material respect. Take Oracle RAC (formerly Oracle Parallel Server) for example, Oracle's shared everything database clustering technology. There are no open source equivalents. MS SQL, PostgreSQL, and MySQL don't have anything like it. Apparently IBM DB2 does, but only in the mainframe editions.

    There are often things that can be done to work around these limitations (replication works in some cases, for example), it is just a question of cost effectiveness. There is no reason to buy Oracle just because it is "Oracle". Only if it does what you need better than the alternatives. For many businesses that is the case. Oracle doesn't dominate the business because of FUD. It dominates due to true technical superiority. A business would be positively stupid to pay a large premium for a database that doesn't have any real superiority to much less expensive (if not free) alternatives. That is one of the reasons why it would be great if the alternatives caught up. Transparent clustering for PostgreSQL would be outstanding.

    I *can* use PostgreSQL to do everything I could with Oracle 7 back in the early 90s. That is saying something (MySQL doesn't come close). A lot of people don't need much of what Oracle has added since then. If that is the case, there is a great case to be made for using something else. It is certainly a lot less expensive.

  27. Re:MariaDB is one ugly name for a DB by larry+bagina · · Score: 2, Funny

    Maria: She goes down frequently and has no standards. Unfortunately, she's full of bugs and may silently truncate your input :(

    --
    Do you even lift?

    These aren't the 'roids you're looking for.

  28. Re:Online table modifications by butlerm · · Score: 3, Informative

    Online upgrades. Suppose you have a service that needs to be available on a 24 x 7 basis. Is there any reason to shut everything down just because the upgrade script needs to add a new column, drop an old one, or increase the precision or maximum length of an existing one?

    We do software as a service, for example, and generally speaking, we don't take our site down *ever*, certainly not for application software updates. Logged in users stay logged in and continue their work without noticing.

  29. Mod -1 wrong by metamatic · · Score: 2, Informative

    First came QUEL. The followup developed at IBM was jokingly called SEQUEL. It was changed to SEQL and then SQL for trademark reasons. See Wikipedia.

    So it was originally called "sequel". Pronouncing it as S-Q-L came later.

    --
    GCHQ Quantum Insert installed. If only our tongues were made of glass, how much more careful we would be when we speak
  30. Re:Oracle by rgigger · · Score: 2, Insightful

    That is a great comparison, and contrary to some of the responses, being able to do alter table statements on an in use production system is vital to any serious database solution. It doesn't say anything about Oracle vs. Postgres though as Postgres has been able to do this for a very long time.

    I'm not just trying to be contrary here, I would really like to know. What does Oracle have that puts it (20 years?) ahead of Postgres (other than RAC, there were very informative posts above about that).

  31. Re:Online table modifications by Simetrical · · Score: 2, Interesting

    Online upgrades. Suppose you have a service that needs to be available on a 24 x 7 basis. Is there any reason to shut everything down just because the upgrade script needs to add a new column, drop an old one, or increase the precision or maximum length of an existing one?

    We do software as a service, for example, and generally speaking, we don't take our site down *ever*, certainly not for application software updates. Logged in users stay logged in and continue their work without noticing.

    The same is true for any serious MySQL site. Just with MySQL, you have to go to the hassle of take out slave, apply change, let slave catch up, repeat for all other slaves, promote some slave to master, apply change to old master to get everything working. This works for changing columns' type/adding columns/removing columns/etc. because MySQL normally uses statement-based replication, not row-based. It can be fiddly, but it works fine. Wikipedia has no downtime for database changes, or any planned downtime at all, and it's a pure MySQL shop. Of course, being able to change tables without this whole procedure is probably quite convenient.

    --
    MediaWiki developer, Total War Center sysadmin
  32. Oracle may be making concessions by Get+Behind+the+Mule · · Score: 2, Informative

    Oracle has announced a statement today making commitments concerning MySQL that may (or may not) address some of these concerns -- of both Widenius and the EU.

    http://www.marketwire.com/press-release/Oracle-Corporation-NASDAQ-ORCL-1090000.html

    These include:

    * Continued Availability of Storage Engine APIs
    * Commitment to enhance MySQL in the future under the GPL
    * Support not mandatory
    * Increase spending on MySQL research and development
    * Continuing to maintain the MySQL Reference Manual
    * Preserve Customer Choice for Support

    And some other things about preserving the conditions of licenses currently held by storage vendors.

    Healthy skepticism is of course always a good idea. On first reading, I can't tell how binding these commitments are (the statement says "Oracle hereby publicly commits to the following", and that's about it), and it doesn't exactly make Widenius' commitment to the timeliness of new releases and patches, except for the commitment to increase spending, which Oracle presumably would like to have result in new revenue.

    But Oracle is evidently trying to address the EU's concerns in an effort to get the deal approved, and the EU might get them to make these commitments binding. The EU's initial reaction appears to be positive:

    http://www.bloomberg.com/apps/news?pid=20601087&sid=a4SRxTHKHzTA&pos=7

    The European Commission said Oracle’s proposal addresses concerns about the acquisition of Sun’s MySQL database product, signaling the EU will approve the acquisition next month. European Competition Commissioner Neelie Kroes said in a statement that she’s “optimistic that the case will have a satisfactory outcome.”

    “Neelie Kroes has switched on the green traffic light,” Charles van Sasse van Ysselt, a competition lawyer at NautaDutilh in Brussels, said in a telephone interview today. “She is optimistic and this is a step in the right direction.”