Archive for the ‘MySQL’ Category.

Tenth anniversary: OSCON CFP is open

This year’s OSCON will be held from July 21-25 2008 in sunny Portland, OR.    This will be a very special OSCON as it’s the tenth anniversary - we’d like to make it double plus good, so please, please submit your best efforts, and we’ll all party on down while opening our minds in July.

OSCON 2008 Call for Papers

Sun buys MySQL - now what?

Interesting news greets us this morning with Sun’s acquisition of MySQL.  (Congratulations are in order for both parties.)

I think a lot of us are still at the "oh wow" stage.  There are lots of implications.  It seems like a good fit because of Sun’s deep involvement in the Open Source community. 

The partnership will certainly juxtapose some interesting personalities: now we have Josh Berkus (PostgreSQL) and Monty (MySQL) working for the same company.

What will happen with licensing?  Will MySQL still be available under a
dual GPL/commercial license, or is it likely to end up under CDDL/SCSL or
similar?  Changing from one open source license to another can be an
extraordinarily difficult challenge both logistically and ecologically.

I note that I read in Don MacAskill’s blog that

"Maybe MySQL will finally start fixing all the performance/concurrency
issues with InnoDB (basically, InnoDB’s threading and concurrency
aren’t working well with modern multi-core CPUs). Google’s had some fabulous patches for awhile, and the brilliant Yasufumi Kinoshita does as well, but they don’t seem to be making their way into MySQL anytime soon." 

This is not going to happen as far as I know, because the patches were contributed under the GPL, and can’t be incorporated into the commercially licensed version.  In addition, Innobase Oy is owned by Oracle.  I think we’re more likely to see those performance and concurrency issues solved by using Falcon.

It’s also interesting from a Java perspective: traditionally Oracle has been the Database-of-Choice for Java devs, and MySQL for PHP devs.  With Sun producing MySQL we can expect to see better support within the Java community, although the press releases all note that support for the PHP/Rails/etc communities will continue.

It’s going to be another interesting year in Open Source.  I’m looking forward to it.

OSCON Days 1 and 2

Tutorial days.  I had planned on blogging yesterday but Typepad, my blog overlords, had kind of a bad day along with a bunch of other companies hosted by 365Main.  The root cause of this failure was of course issuing a press release earlier in the day talking about how they had 100% uptime for the previous two years.  Murphy was listening.  I believe Terry Pratchett has something to say about standing in a shallow copper basin of water on a hilltop during a thunderstorm, cursing the gods.  Anyway.  It’s up now.

I attended a couple of tutorials: on Monday Wez and Marcus on Extending and Embedding PHP, and on Tuesday Michael Schwern on Simple Ways to be a Better Programmer.  They were at absolute opposite ends of the spectrum in a lot of ways: Extending was digging into C, and Better Programmer was largely about people hacks, but both were excellent tutorials.

In the morning Luke and I gave our tutorial on PHP and MySQL Best Practices (and I uploaded the slides).  I think it went ok but a little long - we had too much material as usual.  Email me if you have any questions, particularly about the bits we didn’t get to in the time.

I love OSCON; I always feel like my brain is expanding the whole time I’m here.  This time I keep hearing about parallelism, something I haven’t spent a lot of time on since doing pthreads stuff in  my final year at college.  I have been thinking the last couple of weeks that it’s time to refresh some of the things that I have long forgotten, and acquire some new skills.  OSCON is a great place for all of that.

Talk slides added

By popular request, I have added my most recent talk slides to this blog.  You can get them from the side bar (over on the right side there) or on the about page.

linux.conf.au

Just as a follow up on the topic of MySQL: next week I’ll be at linux.conf.au in Sydney. I’m going to give a talk on MySQL Troubleshooting in the MySQL miniconf on Monday, and will also attend the PostgreSQL miniconf (Tuesday) and one day of the main conference (Wednesday).   It looks like a great conference - I haven’t been to an LCA before and people keep telling me how much I am missing out on.

MySQL, Windows, and building community

I saw this today in Ilia’s blog.  In a nutshell, Kaj’s announcement explains that this is the first source-only release of MySQL Community Edition, version 5.0.33.  He points out "I expect the next Community release, 5.0.35, to be available as source
and binaries for the same platforms as MySQL Enterprise Server and as
the previous MySQL Community Server binary release 5.0.27. Until that
point in time, the 5.0.27 binaries will be the ones listed on the
normal MySQL 5.0 download pages at dev.mysql.com/downloads/mysql/5.0.html."
  That is, this won’t be the last of Windows binaries (for now at least).

Knowing the MySQL community and new MySQL users pretty well, this is a step in an interesting direction.  Last time I heard some numbers from a MySQL staffer, roughly half of the MySQL downloads were for Windows.  On the other hand, there are not many enterprise customers running MySQL on Windows.  So who are these people who are downloading MySQL for Windows?

I know who a lot of them are: they are the same people that buy our book.  People who are learning about MySQL.  These guys are never going to a) buy the Enterprise edition, or b) compile it themselves.  What they do do is swell the userbase.  If many developers know how to use your product, more companies will adopt it.

Some may say that it doesn’t matter that these people are a few versions behind and that’s fairly much true.  I am mostly commenting here because these seems like a step in a particular direction, just as splitting the licenses into Community and Enterprise was another step in this direction.  If things continue in this direction, we may one day look back and say "That was where they started to go wrong."  I hope I’m wrong.

ApacheCon early bird deadline extended

ApacheCon EU has extended the early bird deadline to June 6.

The scheduling works really well for attendees interested in PHP:  on the Tuesday you can attend Chris Shiflett’s Essential PHP Security tutorial in the morning, and my PHP and MySQL Best Practices tutorial in the afternoon.

I’m really looking forward to giving this tutorial: it has all new material and focuses on building scalable, maintainable PHP and MySQL apps.  It should be a great counterpoint to a morning spent with Chris learning how to make those same apps secure.

OmniTI acquires Brain Bulb

…which means I now look across my desk at the smiling face of one Chris Shiflett.

This means we’re ramping up our consulting offerings in the security sector here at OmniTI,  which is really exciting for us.   Chris’s expertise is certainly a great fit here.  (For more information you can read the press release, Chris’s blog, or George’s blog.)

Welcome to the "OmniTI brain trust", Chris.  I’m sure you’ll have a ball.