O’Reilly MySQL Conference Awards 2010

The O’Reilly MySQL Conference & Expo 2010 is over. I hope all of you had a good time. I have plenty of blog posts and thoughts lined up about this, but first, I’d like to point out something that has become a tradition, that was continued in 2010: the O’Reilly MySQL Conference Community Award Winners.

Conference award winners

Tim O’Reilly was kind enough to hand out the awards this year. In case people were wondering, the awards were pewter wine goblets from Royal Selangor.

Selection of the award winners happened via voting from the alumni of winners, and was all done in a rather short period of time. Kudos to the entire team that voted. Now for the winners…

O’Reilly MySQL Community Member of the Year 2010

  1. Mark Callaghan is known for his work in leading a MySQL engineering team first at Google, and now at Facebook. In addition, the panel appreciated his insightful and always tasteful blogging, ranging from insightful benchmark reports to open source community advocacy.
  2. Kai ‘Oswald’ Seidler is a developer of XAMPP, a multi-platform LAMP stack, especially popular amongst Microsoft Windows users. Many users get their first contact with the AMP (Apache-MySQL-PHP) platform using XAMPP!
  3. Daniel Nichter created the Hack MySQL Kit, hacks on Maatkit and heaps of other software. He’s also a fabulous MySQL DBA.

O’Reilly MySQL Application of the Year 2010
Twitter was unanimously voted to be the application of the year in 2010.

Panellist Marc Delisle described his use of Twitter recently:

“Seven weeks ago I was in Niamey, Niger during the coup d’état. While borders and the airport were closed and a tank was patrolling on my street, I took refuge at the Canadian embassy where Twitter users updated me on the situation, almost minute by minute.”

O’Reilly MySQL Corporate Sponsor of the year 2010

  1. Rackspace received the award for hiring many of the core Drizzle developers, enabling them to work full-time on the MySQL fork. Rackspace also contributes to open source projects like MariaDB, Drizzle and more, providing hosting.
  2. Percona has over the last years hired many valuable MySQL contributors, and have a lot of consultants and developers extending MySQL and tools around it. Percona’s team blog on MySQL performance is also highly regarded within the community.

Another picture from the excellent James Duncan Davidson:


annual MySQL awards

The iPad: Early-experience notes

I was initially unsure if I would like to buy an iPad when asked many a time, and my usual response was “let’s see it first”. Then I saw it. It didn’t take a couple of minutes of playing with it, and looking at it, that I decided that I must get it. A week later, the Apple Store still gets queues in the morning (when I went there was no queue – a pre-requisite for me even entering the store), and they’re all out of 16GB models. In fact, the 32GB models are hard to come by. So I got a 64GB model – oops! Here are my early-experience notes:

  1. I like the form factor. Its a bit heavy (try holding it on left hand, typing with right hand for long periods of time). Brushed aluminium on the back, and it seems like my MacBook Pro – I doubt its going to get scratched easily. The screen is like an iPhone/iPod Touch’s, and it smudges similarly – not too badly. I doubt its going to scratch easily, which is probably why Apple can’t be bothered with screen protectors.
  2. Speed. The A4 processor is totally amazing! Scrolling is easy, changing from an app to another is snappy, I’m totally amazed.
  3. The battery life is totally amazing. A4 processors in an iPhone in the future might help. But I also think there’s a huge battery here. One thing to remember – there’s a special 10W USB Power Adapter to charge the iPad. So even when you grab the Apple World Travel Kit, you don’t get a compatible adapter. The standard iPod/iPhone one only outputs 0.15A of power, while the iPad one gives it 0.45A. They may even be the same size, but they’re not the same. In fact, when you pick up 3rd party power adapters that have USB chargers… you’ll find its not rated high enough for the iPad.
  4. Activation process is interesting. The device will not work until you connect it to your computer. It has to be running iTunes 9.1 (so I had to reboot my laptop to get this going). It was simple. Of course I have a Malaysian iTunes account, and for this to work, I needed a US iTunes account. No iPad Apps unless you have a US account. No credit card that has a US-based start, so I can’t buy apps yet. I consider this to be a major fail and think Apple should stop limiting folk to regions – its retarded. I’ll have to go buy lots of gift cards soon…
  5. Typing on the touch screen is surprisingly easy. Portrait mode – check. Landscape mode – check.
  6. I don’t know what the WiFi troubles are all about (just yet). I am currently travelling and using an Airport Express. I hope when I get back home, it “just works” with my current access points.
  7. iBook only gets installed the first time you connect to the AppStore. Winnie the Pooh is the story of choice – why? The interface reminds me very much of Delicious Library. The management of this is via iTunes.
  8. Standard iPhone apps work. They don’t necessarily look pretty – sitting in the middle and all that. People are going to want to get their apps working on this platform, fast.
  9. It has a pretty good speaker. It comes with no headphones, so if you don’t want to be annoying, spend USD$29 and get yourself a pair from Apple.
  10. The screen has an interesting wallpaper. It looks like the iPad had been scratched. Tsk tsk.
  11. I bought a dock. The keyboard dock isn’t available for sale yet. But it can already work with a Bluetooth keyboard. I’m excited to try this working, so I can type fast on my iPad.
  12. The guy at the Apple Store told me he returned his Apple-made iPad case. To make matters worse, the store was out of stock. So I bought an Incase one. With a zip (the other one had a retarded design). I have no complaints here.
  13. Watching YouTube videos are nice. I highly recommend giving it a try. In fact, watching videos are quite pleasant on this large screen. Its about the size you get in an airplane…
  14. The accelerometer is very active. There exists a screen rotation lock – totally useful when you’re lying in bed and reading.
  15. I tried out the Maps application. Interesting. There should be a digital compass. No assisted-GPS or using the nearest cell to find you, but I tried to find my location and it was pretty accurate just based on what must have been the IP address. I’m not complaining. Maps would be good for this kind of device, and my model does not have an A-GPS, but I don’t really think I’ll be needing it.
  16. This is not a netbook replacement. You just can’t access your media that easily. In fact, iTunes is such a horrendous way to manage all this. I’d have preferred if I could drag & drop things onto my iPad. Not all media will get on your iPad easily, quite naturally. Mac users are probably used to Perian, but such an application does not exist for the iPhone/iPad. I presume converting lots of media to a format that is capable for the iPad/iPhone.

Applications

  1. I’ve had an iPod Touch for years (I bought the first generation when it was announced, from the same Apple Store in San Francisco that I got this iPad years ago). I’ve never downloaded this many apps, or felt like paying for stuff, until owning the iPad. Colour me impressed.
  2. iPad apps cost a lot of money. NetNewsWire which might be free on the Mac desktop, come free on the iPhone, unless you get the Premium edition for $4.99, costs a mere $9.99 on the iPad! Instapaper has a free version for the iPhone, a Pro version for $4.99, and on the iPad it costs the same. Time charges you for every issue you buy – why? I’d rather read the dead tree edition at airports.
  3. The Bloomberg application (which I use on Symbian S60, BlackBerry, iPod Touch, and now iPad) is truly a thing of beauty. If you’re a finance geek, love the stock markets, and spend some time on it, you’ll want an iPad just for it. Charts, etc. are totally amazing at that size. And the touch interface is totally rocking.
  4. I am a bit disappointed that the Remote iPhone app from Apple to control Keynote does not work as an iPad native app. I would love to use my iPad as a clicker, compared to my iPod touch. Why? I can see my speaker notes, etc. on a larger screen. It becomes totally useful. Remember, I don’t want to give a presentation on my iPad – I still want to use my laptop; I just want to be able to walk around and use the iPad as a large clicker and see things on my screen. I have yet to purchase Pages or Keynote yet, I wonder if I’ll ever purchase Numbers? All $9.99 a pop.
  5. I played around with Adobe Ideas. Nice.
  6. Evernote is a must have application. It “just works”. I think its much better than the Notes application that Apple bundles.
  7. Don’t bother buying an iPad without an iTunes account. You’ll want to be buying apps to make it useful/interesting.
  8. Its funny they did not embed a PDF reader. You have to download (mostly buy) one.
  9. Having two copies of apps is stupid. For example, I have Wikipanion for iPad and Wikipanion for iPhone/iPod Touch. One is the regular, nice size, and one is about half the size (aka iPhone size).

Games? I’m the last to judge. I don’t play games. ‘Nuff said.

Developers? Go get your app in there during the land rush grab. I wonder if these premium prices on apps will last, or if its just a fad. Are people willing to spend a lot more on apps here? The iPhone AppStore is basically killed by $0.99-1.99 apps. Its hard to break out of those price points unless you’re uniquely providing value. On the iPad? For the near future, you can do whatever it is you want, and people are bound to play with it as the initial hype is there. Once it becomes more commonplace, I expect apps to get cheaper, and more free apps to become more high quality.

What will I use it for? So far, I’m browsing lots of stuff in Safari. I’m writing notes in Evernote. I’m checking out a lot of apps (Marvel is neat, some news apps, Twitter apps, etc.). The Bloomberg application just rocks. I’ve not seen much of this “just work” with the cloud – I can imagine Apple is working on this. Maybe I’ll finally purchase a .Mac account. Copy/Paste isn’t as seamless, in my opinion. Multitasking would make it a whole lot more useful – but then again, me switching apps at the moment is almost instantaneous, so it already feels like I’m multitasking.

Will I get the 3G version? Nope. First off, this whole micro-SIM will be a big issue for me (no provider in Malaysia supports it). Next, where do I use this – probably mostly at home, in a hotel room, or on a plane. What about a cafe? Well, I’ll carry around my portable 3G WiFi device and all will be well. What if you’re on a train/bus? The 3G connection will probably be unreliable as the cells switch, I would get pretty annoyed with connection drops. Besides, I don’t use data when roaming, so another minus for the 3G edition.

What’s missing? I’d like to grab the Camera Connector. Maybe someone will make a 3rd party GPS. Could be useful for mapping nuts, especially since it won’t be an A-GPS. I’m still contemplating spending USD$29 on the dock connector to VGA adapter. I don’t know if I’ll ever do a presentation using my iPad. I’d much rather use the Keynote Remote… if they make an iPad version.

Is this replacing my Sony Reader PRS-505? I’m not sure. One’s e-ink. One isn’t. I haven’t read on the iPad long enough to know if its going to annoy me or not (in iBooks, that is). Reading in Safari is very comfortable.

MySQL Conference Updates – The day before

‘Tis the day before the O’Reilly MySQL Conference & Expo 2010. You can still register onsite.

This one is long, and is divided into: Keynote Additions, Open Space, The Tweetup, and Videos/Live streaming of keynotes.

Keynote Additions
The earlier lineup was already excellent, and now we’ve filled it up more. In particular, let me draw attention to:

  1. Tuesday, 10.00-10.20am: MySQL at Facebook – Mark Callaghan. Last year Mark gave you insight into his work at Google, this year he will tell you more about MySQL at Facebook.
  2. Wednesday, 10.00-10.20am: Under New Management: Next Steps for the Community – Sheeri K. Cabral. Sheeri gave a community keynote last year, and it is repeated again this year, especially since we’ve had an interesting year.
  3. Thursday, 9.15-10.00am: The Engines of Community – Jono Bacon. He wrote a great book, The Art of Community, and he’s the Ubuntu Community Manager.
  4. Thursday, 10.00-10.20am: Best of Ignite MySQL. This one gets made up as we go along ;) Get a preview at the Ignite MySQL the day before.
  5. Thursday, 3.50-4.35pm: RethinkDB: Why Start a New Database Company in 2010 by Slava Akhmechet and Michael Glukhovsky. I’m particularly excited by this – Slava and Michael are the founders of RethinkDB, and their target? MySQL on SSDs.

Open Space
Last year we had MySQL Camp. This year we have an Open Space. Feel free to schedule talks, promote it guerilla style, and run your own side sessions. It does not even need to be sessions – organise hackfests, tutorials, etc.

Twitter much? There exists a Tweetup!
If you’re on Twitter, follow the #mysqlconf hashtag (and the @mysqlconf account for latest news, discounts, contests, events, general happenings, etc.). Why not, at 9pm Tuesday night, meetup at the Lobby Bar, for the MySQL Conference & Expo Tweetup. There will be drink coupons and then a no-host bar open afterwards, so come one, come all.

If you’re on Foursquare, why not come there, check in and try and get a Swarm badge?

Videos/Livestreaming available
Want to know what Edward Screeven has to say about MySQL at Oracle? Can’t be at the conference? Pay close attention the live stream. This is something we’ll do for keynotes. You can also look at recorded videos at the blip.tv channel. Ignite sessions will also be recorded. Main conference sessions will not be officially recorded, so come on by to the conference to see them happen!

MariaDB in Gentoo; updates for Solaris/Debian SPARC

Gentoo
It started with Brian Evans’ github repository, some good instructions on the mailing list for Building MariaDB on Gentoo, to a request for packaging, and guess what? Its now officially in Gentoo! Thanks Brian, and Robin Johnson!

SPARC builds – Debian, Solaris
Mark has now got a MariaDB category on his blog and the interesting things for you to grab are: 5.1.42 binaries for Debian Linux/SPARC and 5.1.42 binaries for Solaris 10/SPARC. Soon, you will see 5.1.44 binaries. Thanks a lot Mark!

MariaDB 5.1.44 released

Dear MariaDB users,

MariaDB 5.1.44, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released.

This release is based on MySQL 5.1.44. In includes performance improvements with Maria temporary tables, removal of mutexes and the aim of removing compiler errors is being achieved quite well! For an overview of what’s new in MariaDB 5.1.44, please check out the release notes.

For information on installing MariaDB 5.1.44 on new servers or upgrading to MariaDB 5.1.44 from previous releases, please see the installation guide.

MariaDB is available in source and binary form for a variety of platforms and is available from the download pages

We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more about working with the community.

Enjoy!

MariaDB: Community Developed. Feature Enhanced. Backward Compatible.

Abusing MySQL (& thoughts on NoSQL)

The NoSQL/relational database debate has been going on for quite some time. MariaDB, like MySQL is relational. And if you read these series of blog posts, you’ll realise that if you use MySQL correctly, you can achieve quite a lot.

  1. It all starts with Kellan Elliott-McCrea with his introductory post on Using, Abusing and Scaling MySQL at Flickr. Follow the entire series.
  2. He starts of the series with Ticket Servers: Distributed Unique Primary Keys on the Cheap. Flickr scales using shards, and ticket servers give unique integers to serve as PKs.
  3. Richard Crowley talks about OpenDNS MySQL abuses. Nothing too out of the ordinary, but it shows MySQL getting the job done.
  4. Mikhail Panchenko talks about using The Federated engine for his series.

If you’re using the Federated engine, know that MySQL disables FEDERATED by default. In MariaDB 5.1.42, you get FederatedX, which is a maintained fork of FEDERATED, by the author himself! Bugs are fixed, and this is a supported engine, so if you’re using the FEDERATED engine, it might be wise to try out FederatedX.

I’d also like to bring to attention, an interesting essay by Dennis Forbes: Getting Real about NoSQL and the SQL-Isn’t-Scalable Lie. Monty says: “NoSQL is for very smart people who need a very sharp knife. People who are not capable of mastering SQL should not even attempt to try out NoSQL.”


i