Oracle didn't buy an open-source hippie commune in MySQL, but rather a tough-minded money machine.

Somewhat overshadowed in last week's headlines was news about the forthcoming MySQL 5.4 release, internally known as "Summit." While MySQL Engineering team was somewhat heads-down last year finalizing MySQL 5.1, this new version demonstrates a dramatically shorter release cycle by focusing on just two key issues: performance and scale.

read more

One of the common needs for a content management system (hey, that's what we make!) is some form of page ordering. Clients need to be able to manually order pages to suit their fancy, rather than relying on something arbitrary like update time or alphabetical order. For this we use a simple numeric field. On any given given page in the admin center, the user can shuffle around all that page's siblings, which are then posted and have their ordernum fields reset. Typically this is done with a query apiece, as one would expect when trying to update multiple rows with multiple different values on multiple keys. Wouldn't it be nice, though, if there were an easy way to perform this same entire action with a single query? ...

To me this is quite boring news. I already felt more distant to MySQL when it got scooped up by Sun and this sense of distance is the same now. Note this distance is still quite "travel-able" .. it just feels a bit like flying to another continent. Also I have essentially zero worries that Oracle will (try) to kill off MySQL or cripple it. MySQL is complementary to their current offerings. One thing I could see however is Oracle pushing for killing off some of the past cruft (and in the process beefing up Oracle compatibility). This last aspect brings me to something I consider much more interesting news.

EnterpriseDB (one of the companies that are active in the PostgreSQL eco-system) have teamed up with IBM to make DB2 more Oracle compatible. Given that IBM is an R&D heavy weight with plenty of developers on hand its quite impressive …

I decided to give a try to slideshare. So I uploaded the slides from my most recent talks, and will eventually catch up with the old ones. My slides repository is http://www.slideshare.net/datacharmer.

If you are looking for the slides from MySQL Conference 2009, here are the shortcuts:

• MySQL 5.1 Partitions tutorial
• MySQL 5.1 event scheduler
• Boost performance with MySQL 5.1 partitions
• …

The 2009 Percona Performance Conference finished up last week, and was overall a resounding success. Thanks to all of the speakers, O'Reilly, and Sun/MySQL for help making it happen! Most slides have been uploaded; look for the stragglers over the next couple of days.

Entry posted by Ryan Lowe | 4 comments

Add to: | …

It is always after the conference when you get home that you notice missing items.I think I left a zip-up storage bag in Conference room A after my presentation of Perl Stored Procedures which may contain a few cables and a laptop security lock.Annoying when stuff like that happens.

As I previously mentioned, on Friday I attended the Drizzle Developer Day at Sun in Santa Clara. While there I had the chance to speak to the group while everyone ate their salad, pizza, and cookies.

The talk was titles "What Craigslist wants and needs from Drizzle" and is available as a Google Docs presentation here. I've also embedded a version of the slides below.

I should note here, as I did at the talk, that this presentation is neither comprehensive or completely representative. That is to say that I'm sure there are things I've forgotten. Plus, the fact that I was working with MySQL in other high-volume web shops before coming to Craiglist means that there's definitely some personal bias and pet peeves addressed in there too.

Anyway, …

This weeks’ announcement Oracle to by Sun was a major talking point at the 2009 MySQL Conference & Expo. While it is too early to even speculate what the future holds with the official MySQL product, for myself a speaker on MySQL topics, Oracle Open World is now a target market.

In addition to many years of providing MySQL for the Oracle DBA Resources I have with the recent closure of call for papers submitted two sessions for consideration.

Integrating MySQL into your Oracle DBA management processes

Most large enterprise organizations use more then one RDBMS product to service business requirements. With the increase in MySQL usage for web …

As promised, here are more results running memcached on Sun's X2270 (Nehalem-based server). In my previous post, I mentioned that we got 350K ops/sec running a single instance of memcached at which point the throughput was hampered by the scalability issues of memcached. So we ran two instances of memcached on the same server, each using 15GB of memory and tested both 1.2.5 and 1.3.2 versions. Here are the results :

The maximum throughput was 470K ops/sec using 4 threads in memcached 1.3.2. Performance of 1.2.5 was just very slightly lower. At this throughput, the network capacity of the single 10gbe card was reached as the benchmark does a lot of small packet transfers. See my earlier post for a description of the server configuration and the benchmark. At the …