7 ms·
MySQL Editions
- alanh 16y agoWell, fuck. InnoDB is now a premium feature. So long, ACID compliance? Edit “Classic Edition” — what a cop-out name. It should be “Crippled edition.”
- RyanGWU82 16y agoJust to be clear, "Classic Edition" is not the free open-source MySQL that we all know and love. It's a separate product for inclusion in other proprietary products. MySQL has always been a dual-license product, and this is similar to previous offerings by MySQL AB and Sun. The "N/A" price probably just means "contact us so our sales team can squeeze you for all you're worth" -- which is how enterprise software deals typically work.
- AlexC04 16y agoI'm glad I read the comments. I had the same knee-jerk reaction as above. Glad to know I'm still safe :)
- limmeau 16y agoStill, MySQL is under GPL, InnoDB is under GPL.
- jarin 16y agoWow, yeah hello PostgreSQL
- plaes 16y agoYeah, and also Drizzle, MariaDB and Percona Server.
- mcs 16y agoDrizzle probably is the future of "mysql in the cloud", but it's not quite there yet.
- rbanffy 16y agoIt's certainly not worse than Oracle MySQL...
- mcs 16y agoI guess it's mainly this mindset of something must have years of testing or it's not really ACID compliant. Drizzle works fantastic, however there needs to be more drivers written to take advantage of it (and it's asynchronous facilities, especially for the Node.JS people). If you're not familiar with Drizzle, it's MySQL that has a bunch of crap you'll never use stripped out.
- rbanffy 16y ago> something must have years of testing or it's not really ACID compliant Can't really grasp that. Drizzle is MySQL minus cruft... Its parts have been extensively tested for many years.
- nodata 16y agoI think the reason you are being downvoted is that you are comparing PostgreSQL with the commercial version of MySQL. A better comparison would be between EnterpriseDB and the commercial version of MySQL.
- jarin 16y agoAh yes, my mistake.
- Andys 16y agoAfaik, the free version of MySQL doesn't let you do a live transaction-safe database dump of InnoDB tables. A pretty basic feature I thought, which is included in the free version of PostgreSQL.
- nodata 16y agoWell you can almost get there (completely if you're not changing schemas): mysqldump --single-transaction This option sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.
- mrj 16y agoUnfortunately, mysql still doesn't have transactional DDL, I believe...
- koenigdavidmj 16y agoNor does Oracle, for what it's worth.
- spudlyo 16y agoThis is incorrect. You can use XtraBackup for this which is an open source alternative to innodb hot backup. Alternately you can quickly lock tables and take a filesystem snapshot or even run mysqldump with --single-transaction all which will let you get a consistent dump of a set of InnoDB tables.
- deleted 16y ago[deleted]
- RyanGWU82 16y agoHow is this different than before? MySQL was always a dual-license product. You can use the product if you comply with the terms of the GPL, or purchase a commercial license to get priority features, priority support, and get around the GPL terms. This is the same business model that MySQL AB and Sun have used for the last decade.
- deleted 16y ago[deleted]
- dangrossman 16y agoJudging by the comments people are confused. The free, GPL edition of MySQL ("MySQL Community Server") is still what you've always had. These are the commercially licensed products. Oracle's shifted around some features and pricing on support plans and such, but if you're not a commercial customer, nothing's changed for you.
- dtran 16y agoCan anyone offer numbers on how many commercial clients MySQL has currently/had before Oracle bought SUN? I've never seen any numbers. I also wonder how these pricing changes impact the already hurting community of open source developers supporting the community version.
- jarin 16y agoWhat's the difference between community and commercial customers, aside from support? Is InnoDB a feature? Why would MyISAM support be free but InnoDB support have a yearly fee?
- dangrossman 16y agoMySQL is dual-licensed. If you download the community server, it's GPL licensed. If you want to distribute MySQL as part of your application, then your application may have to be GPL licensed as well, which is often undesirable. ISVs and others that need to distribute MySQL can buy one of the commercial editions to get it under a non-GPL license. If you're worried about the future, Oracle agreed to maintain the dual-licensing strategy until at least 2015 as part of the EU negotiations before acquiring Sun.
- deleted 16y ago[deleted]
- candeira 16y agoHow exactly does distributing MySQL as part of your application make your application GPL as well? It's not a retorical question, can you please suggest a case? Unless you outright fork MySQL to make your own database, you can run and distribute it with your proprietary stack without being forced to license your code as GPL. The FSF call it "mere aggregation": http://www.gnu.org/licenses/gpl-faq.html#MereAggregation http://www.gnu.org/licenses/gpl-faq.html#MereAggregation
- clam 16y agoThe Community Server editions are still available.
- ars 16y agoEven the $10,000 cluster edition (which is based on NDB) is GPL. So clearly they can not be selling software, I can only assume these are prices for support, not for software. Have they taken down download links? Removed source code?
- dangrossman 16y agoYou are making the assumption that the GPL is appropriate for everyone that will use MySQL, which is incorrect. ISVs and other businesses that want to distribute MySQL as part of an application can buy it from Oracle with a non-GPL license so they don't have to GPL license what they're selling too.
- robin_reala 16y agoGPL doesn’t mean you can’t sell it; it means you have to provide source and allow derivative products within the constraints of the license.
- ars 16y agoIsn't that what I said? It's GPL, so why are people so worried that they are also selling it? Edit: I guess I can see how you can read it in reverse from what I meant.
- randallsquared 16y agoIsn't that what I said? "Selling software" is distinct from "preventing others from selling copies of [said] software", and confusing the two is the source of much fear, uncertainty, and doubt about the GPL, so some people get a little defensive when they're conflated. When I ran a small software shop, most of the work I sold to small business was built on libraries and other works that were GPL, but this didn't prevent me from charging money for it, it just meant that I couldn't prevent them from selling or giving away copies themselves. Of course, few small businesses are interested in paying for software and then providing it to their competitors, so in practice that never mattered.
- Uchikoma 16y agoDoes the introduction of MySQL without InnoDB mean they can also remove this from the community edition (and bug fixes) without getting into trouble with the EU? They still provide a dual licensing strategy with the same code base then.
- iwr 16y agoSo now Workbench costs $2000?
- cstuder 16y agoNo, the MySQL Workbench Community Edition is still GPL and free.
- timhastings 16y agoYou have got to admire the evil villany we're up against. Buying the 'M' in LAMP and then exploiting that position. Business first, not the heart and minds of developers. Luckily the 'L' + 'A' + 'P' cannot be bought. LAPP stack anyone?
- wlievens 16y agoIf you're going the "non-default" route of using postgresql you might as well ditch PHP. Unless P=Python? :-) LAMP is a loaded acronym which these days basically means "a web app built using FOS but not in Java or Ruby".
- timhastings 16y agoI am using the LNNMMMMP stack at the moment... Linux, nginx, node.js, memcached, MySQL, Mono, MongoDB and PHP. Am I normal?
- ax0n 16y agoNo. You, sir, are not normal. I'd love to know what sort of evil hackery you're cooking with that setup, though.
- timhastings 16y agoI'm cooking up a Twitter Recommendation Engine for users, hashtags, and links etc. For example: http://tagwalk.com/tag/MySQL http://tagwalk.com/tag/MySQL
- ax0n 16y agoPlayed with it a bit. I like it :D
- timhastings 16y agoThanks!
- cageface 16y agoIt's about time! All three specs of MySQL have been OP for too long.
- bigiain 16y agoDoes anyone have ballpark numbers for what a non gpl encumbered mysql licence used to cost before this announcement? I assume Sun and/or Mysql ab used to offer a similar range of mysql based licences?
- brandon 16y agoI'd negotiated licenses between $200 and $500 for their old basic offering (depending on volume). I've been punting on a switch to Postgres for the last few months, but they've forced my hand now.
- Travis 16y agoAny particular reason you're not just using the community edition? Do you need the innodb features? (I'm asking because I've been wondering lately if I should make the switch...)
- famousactress 16y agoThe fee is for the JDBC connector, not the db.. regardless of edition.. Bummer, that.
- nkassis 16y agoGot confused until I read the legend at the bottom. Everything with a 1 next to it is commercial edition only. This does not include InnoDB thus, it's available in the community edition. Which is good, who uses MyISAM anyway?
- riffraff 16y agomaybe some people who want basic full text search capabilities but do not want to roll their own solution or use solr/sphinx whatever, I recall innodb did not support that?
- LiveTheDream 16y agoSome people are capitalizing on this: http://news.ycombinator.com/item?id=1866064 http://news.ycombinator.com/item?id=1866064
- Kilimanjaro 16y agoSomebody please fork mysql and get rid of oracle once and for all. I bet the whole community will support the new sql.
- hapless 16y agoThere are several MySQL forks, have been for years. Most notably: Drizzle, MariaDB, Percona MySQL. There are many others. I don't see anyone rushing to abandon mainline MySQL for the forks.
- sabat 16y agoPercona's is probably the closest to the MySQL people are looking for; Percona is the premier MySQL consultancy, and they've patched the codebase for performance, etc.
- runningdogx 16y agoFrom Monty's presentation about MariaDB, http://www.youtube.com/watch?v=AL1l9Puh0sk http://www.youtube.com/watch?v=AL1l9Puh0sk I got the impression that MariaDB is the primary open MySQL fork, with Percona merging their patches and becoming a downstream of MariaDB. Did MariaDB and Percona have a falling out in recent months?
- Nrsolis 16y agoWe could call it MinesSQL.
- Kilimanjaro 16y agonice, perhaps youSQL, uSQL, SqlME, a name is really important for a project to take off.
- Calamitous 16y agoWell, don't imagine anyone's too terribly surprised by this. Time to start boning back up of Postgres, I guess.
- charlief 16y agoOracle has updated the page and clarified their lowest offering: Embedded Database6 6 MySQL Classic Edition is not available as an Annual Subscription. ISVs, OEMs and VARs can purchase a license to use as an embedded database.