This morning’s MySQL Conference keynotes had a number of inaccuracies, but one that I wish to point out is the characterizations of Drizzle. It looks to me like some Sun/Oracle/MySQL folks are trying to take credit, now that they’re seeing it become a resounding success, for the good work of the Drizzle project. It is not a technology incubator, nor is it the “MySQL Drizzle Project.” It is a new database server. It is Drizzle.

Video for the presentation at the 2009 MySQL Camp:
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)

Description:
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.

This session speaks about Innodb database recovery techniques (apart from recovering from back).

First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.

read more

Video for the presentation at the 2009 MySQL Conference:

High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)

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

read more

Video for the presentation at the 2009 MySQL Conference:

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
Thorsten von Eicken (RightScale, Inc)

Slides

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

Unfortunately, this video was cutoff, but most of the presentation is available.

read more

Video for the presentation at the 2009 MySQL Conference

Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)

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

Play the video directly in your browser
Download the video

The video for the 2009 MySQL Conference presentation:

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

Description

(no slides available at the time of the posting).

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

I’m presenting about Maatkit, the toolkit I created to make life better with MySQL, at the MySQL conference next week.

I’m going to give you a whirlwind tour throught some of Maatkit’s features and functionality. The toolkit is much too large and complex to cover more than a small part of it in depth. So here is your advance warning: I’m going to go through a lot of material, and I won’t be stopping for lengthy discussions :-) The Maatkit documentation is very thorough, and I hope to introduce you to things that could be of use to you, so you can go learn about those topics from the documentation.

Let me give you an idea: when I’m optimizing queries, I open up the output of mk-query-digest in …

Having written about what I think is cool about the upcoming MySQL Conference and the MySQL Camp, now I want to finish up with what I’d like to see at the Percona Performance Conference. Just to recap, this is a conference we created to serve those who want to learn about performance — not “learn about MySQL,” not “learn about database performance,” just learn about performance, period.

I want to see everything. I think this is going to be the single best conference I’ve ever been to. Even the way the conference is organized is exciting. For example, it’s running from early morning till late at night, nonstop. The sessions are also (mostly) only 25 minutes. This means if you decide a session isn’t all that interesting, you didn’t spend much time on it, and you don’t have long to wait for the next one.

So here is a small sample of the …