Today at MySQL Conference & Expro 2009, I did a presentation introducing / explaining Q4M. Thank you to people who came to listen.

The presentation slides I used can be found on slideshare (slideshare).

Today’s Great Open Cloud Shootout was great fun — at least for me! I had the pleasure to tease these distinguished gentlemen with cloudy questions:

• Lew Tucker, Cloud CTO, Sun Microsystems
• Monty Taylor, MySQL Drizzle Geek, Sun Microsystems
• Jeremy Zawodny, MySQL hacker, craigslist
• Chander Kant, CEO, Zmanda
• Thorsten von Eicken, CTO, RightScale
• Prashant Malik, Cassandra Dude, Facebook
• Mike Culver, Evangelist, Amazon Web Services

I tried to provoke the panelists with questions around some areas I had thought out:

• So, what is a cloud anyway?
• Who is the cloud for?
• Why use the cloud?
• Cloud adoption barriers
• Are there cloud standards?
• Cloud Business Opportunities
• Cloud Competition
• Databases & Clouds

Well I just finished my SSD session.  I was concerned by the amount of slides I had so I  kept trimming them back.  What happened?  I finished early.  Why?  The problem with storage is it’s not really that sexy.  I mean nobody ( sane anyways ) drools over drive specs ( I do consider myself insane by the way , and do drool over some drives ).   CPU’s are sexy…  memory…  sexy …  graphics cards sexy…  drives…  are not.  We only had a small crowd turn out (50-60 people maybe), but they were vocal and interactive.  I got some great feedback from others who love IO performance as much as me.   In fact one antendee stopped me in the hall and thanked me , telling me I helped him make up his mind to purcahse some SSD drives,  which made it worthwhile.

We did it!

Here is the presentation (PDF):

Testing The Cluster With Anste View more presentations from Jorge Bernal.

And some interesting links:

• ANSTE
• ANSTE MySQL scripts

I sat down about 20 minutes ago to write a blog post that included a link to the slides of my EMT presentation. It turned into a long post about the presentation, how I feel EMT was received and my feelings on presentations in general. Here is the short post and the link to the slides.

The MySQL conference always inspires me to write so expect a longer post in a few days.

The presentation file for the Dojo toolkit presentation at the Users Conference is now available.

You can find it on the conference session page.

I’ll be uploading the example scripts that work to produce the examples I gave once I’m back in the office after the conference.

Video for the presentation at the 2009 MySQL Conference:

Optimizing MySQL Performance with ZFS
Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121

Watch the video at

read more

just managed to run the first join inside the data-nodes.
the query correspondce to

SELECT t1.*, t2.*
FROM T1 t1
LEFT OUTER JOIN T1 t2 on t1.pk = t2.pk
WHERE t1.pk = avalue

- the code inside the data-nodes is general...but incomplete (e.g leaks memory, doesnt handle error correctly...)
- there is no ndbapi and no SQL,the program testing is a hard-coded c-program sending messages using the ndb-cluster wire-protocol
- the result-set is not managed (the c-program just hangs)

Summary:
- there is *many* things left to do, when this will actually hit a release is very uncertain (or if it ever will...)
- this is the coolest thing i implemented in a long long time

Details:
- the code is written so that the query and the parameters are sent separately so that we in the future could have the queries permanently stored in the data …

I caught up with Marc Delisle (we have a relatively old interview with him on the MySQL DevZone) recently, and got him to give us an introduction to phpMyAdmin, the several books he’s written, and how the project gets new features from the Google Summer of Code. What’s really impressive? They continue winning awards (Marc won one from MySQL in 2009 as well!), and have a user base of nearly 18.5 million (this is downloads — not just users, considering how common it is in shared hosting environments). Watch the video for more.

…

At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101.

This presentation focused on the following four goals.

• Know what to monitor
• Know how you can monitor
• Learn practices to diagnose problems
• Have a foundation of historical information

MySQL Monitoring 101 View more presentations from Ronald Bradford.