Xaprb

One of MySQL’s notable projects was splitting the product into two editions: Enterprise Edition and Community Edition. This move alienated many in the community, and failed to create meaningful differentiation on either side, even with a team of people beating the community bushes for “contributions.” The net differentiation was ultimately Jeremy Cole’s SHOW PROFILES functionality, which made Community better than Enterprise. Sun put less effort into making this split work, and eventually they abandoned it.

But that could change under Oracle’s stewardship. Oracle’s promises to maintain a GPL version don’t preclude it, and the fact that they thought it worth mentioning explicitly seems significant. Here’s a quote from the press release:

Oracle will not release any new, enhanced version of MySQL Enterprise Edition without contemporaneously releasing a new, also enhanced version of MySQL Community Edition licensed under the GPL. Oracle shall continue to make the source code of all versions of MySQL Community Edition publicly available at no charge.

This manages to sound generous, but a) the second sentence is simply what’s required by law as a consequence of the first sentence, and b) there has been no MySQL Enterprise/Community split for quite a while. So although this press release seems to say that Oracle would be maintaining the status quo, I am not sure that impression is supported by the facts.

I’ve always said that the split didn’t have to be a business failure. I think Oracle could be quite capable of making this work where MySQL couldn’t and Sun decided to stop trying.

A renewed commitment to the split could re-alienate many in the community. It might also result in a closed-source Enterprise Edition of MySQL, a tactic that MySQL themselves tried but abandoned.

I just returned from a MySQL Federal Migration Boot Camp, jointly presented by Carahsoft and Sun/MySQL. It was a half-day seminar on the topic of migrating applications to MySQL, targeted to the US Government sector. Specifically, most of the audience seemed to be running Oracle, though there were some users of other systems (Microsoft SQL Server, Sybase, Informix, etc).

Ronald Bradford presented the whole thing. I thought he did a great job giving a fair and balanced look at topics such as what types of applications are good candidates for migration, what gotchas you might encounter, etc. I’m sure someone looking at migrating in earnest would benefit from a whole day’s discussion (or a more focused engagement with a consultant), but I thought it was a great way to help people figure out whether they should dig deeper or just stay where they are.

Here are samples of the questions I heard:

• Does MySQL provide encryption comparable to Oracle?
• Can MySQL reach into Oracle to get legacy data?
• Is there something comparable to Oracle Forms?
• Can I embed MySQL into remote devices in the field? What license do I need to do that?
• Can I store JPEG and TIFF images in MySQL?
• Can I extend the stored procedure language to be PL/SQL compatible?
• Does MySQL have multi-byte character set support?
• What level of governance does MySQL have over third-party development?
• How does MySQL incorporate features back from the community?
• What is the best reliable source of information about differences between the community and enterprise versions of the server?
• In terms of high availability, how does MySQL compare to Oracle RAC?
• Can I do ETL of 400GB of data per hour into MySQL?
• Does MySQL Enterprise have additional scalability over MySQL Community?
• Are MySQL Migration tools free? What about for migration from Sybase?
• Does MySQL not checksum its own data?
• Is there any comparison to be drawn to migration from other opensource databases to MySQL?
• Is there any way to store strings with trailing spaces in MySQL?
• Is DDL replicated?
• Are there any workarounds for the blocking nature of ALTER TABLE? What about in MySQL Cluster?
• Is MySQL Cluster shared-everything or shared-nothing?
• Oracle makes it tedious to keep up with patches. Is MySQL Enterprise easier? Can I get alerts about them? Are they all aggregated together?
• I’m on the Community version and I have an Enterprise subscription. Do I have to upgrade to the Enterprise version of MySQL Server?
• If I have a third-party SNMP monitoring tool, can MySQL Enterprise send SNMP traps to it?
• Does MySQL Enterprise Gold include replication functionality?

I spoke to some people for a while afterwards. Some of them are MySQL Enterprise customers already and indicated that they’re actually not using their subscriptions. I asked them whether that’s important to them, and what is really a value for them; do they mind paying for it if they don’t use it? Maybe they just see a MySQL support contract as an insurance policy? (a few heads nodded yes). I asked people what they value in a support or consulting contract. Generally, I think what I heard can be boiled down to the following:

• They want someone who stands behind the software they’ve installed, regardless of where that comes from.
• They don’t like paying for things they don’t use.
• One person said she finds it easier to search the manual for answers than to open a support ticket.

This is not scientific. This is a sample size of just a handful of people.

Afterwards there was a buffet lunch, which was tasty and had a lot of vegetarian options. I traded a few business cards and talked with a couple of people about topics like how you can design MySQL to replace Oracle RAC, which I believe is not a good way to approach MySQL. Maybe I’ll write more about that separately.

The sales presence during Ronald’s talk was very supportive — “we’re here if you have questions” — and not intrusive. At the very end, one of the sales people showed two slides about MySQL Enterprise, for a total of about 3 minutes, and explained their pricing model. However, from what I heard people say, there is some disconnect — the sales people think it’s very simple pricing, but everyone is confused about it. At least 5 people asked me to explain it, but I’m not sure why. I explained to a few curious people how Percona’s pricing models work.

Kudos to Ronald for a balanced and fair look at migration, and thanks to MySQL and Carahsoft for sponsoring the event!

As you may know, MySQL has a dual-licensing model. You can get the source under the GPL version 2, or you can buy a commercial license.

I’ve recently been hearing a lot of confusion about when you have to buy a commercial license. People I’ve spoken to wrongly believe that they’re required to purchase a license if they’re going to use MySQL in anything but a not-for-profit business, for example. I don’t know how these notions get started, but they do.

So when are you required to buy a commercial license? It’s very simple: when you want to do something with MySQL that the GPL doesn’t permit.