Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. I was successful in streaming the live video on www.ustream.tv, and you can see it in totality at http://www.ustream.tv/recorded/352479.

The slides are available in pdf form. And here are some of the links I spoke about:

cacti
nagios
rt

MySQL 5.0 manual
…

Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played directly in your browser or you can download the 147MB .wmv file. (Please do not download the movie on the conference wireless system!)

I finally realized who Jonathan Schwartz reminds me of:

That’s right, comedian and magician Penn Jillette.

Schwartz started by saying, “enough of this free software stuff!” It got lots of laughs. He started to talk about Sun’s agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well — particularly that each engineer has his/her own opinion.

But Schwartz goes on in earnest to say “The …

• Suicide
  • having no backups
  • depending on slaves for backup
  • keeping backups on same SAN
  • having a single DBA - Frank didn't like this one at all
  • not keeping binlogs
• Restoring from backup
  • how much time?
  • uncompressed backup ready to mount?
  • separate network for recovery?
• In Fotolog, 1TB of data was severely hit.
  • first problem: backup was highly compressed (tar.gz)
  • uncompressing took hours
  • so keep uncompressed backups (at least last N days)
  • it should be mountable, rather than transferable
• Frank going over recovery modes at …

I had a chance to visit the Kickfire booth after the keynotes and before the first presentation. They gave me a kicking t-shirt, followed by a presentation on the newly announced Kickfire appliance (now in beta, shipping in Fall 2008). Here are some notes I jotted down:

• von Neumann bottleneck
• SQL chip (SQC), packs the power of 10s of conventional CPUs
• Query parallelization on the chip
• On-chip memory - 64GB. No registers - no von Neumann bottleneck
• Beats the performance of a given 3 server, 32 CPU, 130TB box (1TB of actual data - space is used for distributing IO)
• SQC uses column-store, compression, intelligent indexing
• SQL Chip, PCI connection, plugs into a Linux server
  • SQL execution
  • Memory management
  • Loader acceleration
• KDB (Kickfire storage engine), plugs into MySQL …

• Baron Schwartz presents
• only works for SELECTs
• nobody dares admit if they've never seen EXPLAIN
• MySQL actually executes the query
• at each JOIN, instead of executing the query, it fills the EXPLAIN result set
• everything is a JOIN (even SELECT 1)
• Columns in EXPLAIN
  • id: which SELECT the row belongs to
  • select_type
    • simple
    • subquery
    • derived
    • union
    • union result
  • table: the table accessed or its alias
  • type:
    • join
    • range
    • …
  • possible_keys: which indexes looked useful to the …

• Robin Schumacher
• gives overview of MySQL products
• MySQL Enterprise
• MySQL 5.1 announced
  • table/index partitioning -> great for data warehouses, range, cache, key, list, composite, subpartitioning. Partition pruning. Response time greatly improved with proper partitioning.
  • row-based/hybrid replication -> safer and smarter
  • disk-based cluster -> supports bigger DBs
  • built-in job scheduler -> simplified task management
  • problem SQL identification -> easier troubleshooting. Dynamic query tracing is now available, no need to trace things in slow query logs.
  • faster full-text search -> 500% increase in some cases
  • 5.1.24RC available for the conference
• MySQL 6.0
  …

I made it to the US safely, even though I almost missed my connecting flight in Heathrow (even my luggage made it, hooray!). I reached the Hotel just in time to directly head off to the traditional pre-conference party at Mårten's house. However, we just stayed there shortly (barely long enough to say hi to everybody) and then headed to the MySQL pre-conference dinner (organized by Arjen). It was nice meeting such a large number of the key MySQL community people in one place! I was especially surprised about the presence of Jonathan Schwartz and Rich Green - this added a nice touch!

Today I am attending Stewart's …

I finally made it yesterday in Santa Clara. My flight on Saturday got cancelled, so I missed the party on Sunday at Marten Mickos' place.. I really looked forward to that, well maybe next year!
Today, Monday, the first day, it started nicely with breakfast meeting lots of colleagues and getting registered. We got a small bag with some spa.. flyers, and stuff. The coffee is good. At least I'm awake.
Right now Jan Kneschke is talking about MySQL Proxy together with Giuseppe Maxia. It started with the command:
 mysql> make coffee;
Woohoo!!!

Were there too many "my"'s in that title? Anyway… this week's MySQL conference is promising to be really busy and exciting. I can't wait to finally be there and experience it in all its glory. Thanks to the O'Reilly personal conference planner and scheduler and the advice of my fellow conference goers, I was able to easily (not really) pick out the speeches I am most interested in attending.

Here goes (my pass doesn't include Monday ):

Tuesday

8:30am Tuesday, 04/15/2008

State of MySQL

…

If you can’t attend the MySQL Conference, you can still virtually attend

Simply visit
http://www.ustream.tv/channel/oursql-the-mysql-database-videocast

2-3 pm PDT on Tuesday, April 15th for the “Best Practices for Database Administrators” session,

and

11:55 am -12:40 pm PDT on Thursday, April 17th for the “Database Security Using White-Hat Google Hacking” session.

You need nothing but your web browser; unlike some other live meetings, audio streams from the website too, so there’s no phone number to call or participant code or anything. There’s also a live chat so you can participate and ask questions while the session is going on.

See you soon, virtually!