In my first day at the MySQL Conference and Expo 2007, I attended the Scaling and High Availability Architectures tutorial in the morning, and Real-world MySQL Performance Tuning in the afternoon. This is a brief article on each session’s Big Ideas, and a short blurb about the conference overall so far.
I’ll also be involved in at least three sessions at the conference, and I describe them.
If you’re interested in short overviews of the sessions I attend, keep watching for my articles. I will give you each session’s major ideas instead of writing stream-of-thought notes. You can look at the presenter’s slides for more.
The conference overall
This conference is well-organized and friendly. Attire is casual; most people are wearing jeans and t-shirts, or khakis and three-button shirts. I found lunch basic but good – catered food, with tables set up in a grassy area in the beautiful California sunshine; nicely dressed tables. I had a nice salad with vinaigrette and crumbled bleu cheese, penne with a sun-dried tomato sauce, red potato salad, and bread.
Pretty much everyone seems to be here. I don’t want to drop names, so I’ll just leave it at that (though I cannot avoid mentioning that I’m rooming with Alexey Kovyrin, who has just released an update to the MySQL Master-Master Replication tool). It is such a pleasure to meet the people I’ve been emailing with; people from all over the world, who use MySQL for all different kinds of things. I also met some people I’ve met at previous events, and whom I consider friends now. Here’s to all of my friends, new and old!
The downside is I miss my wife and Carbon, our loving Rhodesian Ridgeback dog. But I know he will Guard The House® even while I’m gone.
Scaling and High Availability Architectures
This tutorial featured Jeremy Cole and Eric Bergen of Proven Scaling LLC. You probably know them for their generous help giving people rides and passes to various parts of various events, and for contributing patches for things we all need.
Jeremy did most of the talking. The talk was organized roughly into identifying what scaling and high availability are (they’re not the same thing), what problems typically present at various stages of an application’s lifecycle, and some strategies to use and avoid. It promoted application partitioning for scaling, and master-master replication for high availability. All in all a very good discussion of the pros and cons of many concepts, both big and small.
This tutorial was mostly pretty high-level, but frequently got down to specifics.
One of the things I noticed the most from the audience’s questions was how differently many people understand the concept “partitioning.” There were at least three working definitions I heard, and they are not at all the same thing. I think one of the primary obstacles to teaching the principles this talk covered is conveying accurately what it means to partition. The definitions I heard were
- Dividing data into partitions (aka “shards”) and locating each on one of some number of servers.
- Dividing a large table into smaller tables on the same server.
- Using the partitioned tables available in MySQL 5.1.
I also heard people talking about partitioning by date, which I usually associate with archiving.
In the context of the talk, partitioning data means dividing it by something like user ID and locating each partition on one of some number of servers. This is key to horizontal scaling.
Real-world MySQL Performance Tuning
Ask Hansen’s talk was a broad overview of how to scale web applications, from start to finish. It included not only a lot of advice on MySQL, but also suggestions not related to MySQL, such as application-level caching, proxies, failover, etc. He covered a huge amount of material; his slides are interesting and varied, with nice illustrations. He often gave high-level advice, such as “cache aggressively,” but at least as often devoted entire slides to a low-level topic.
Jay’s talk covered much less ground. He focused on specific performance optimizations for MySQL. The topics included indexes, how to know when and how indexes are used, query plans, and server tuning. The slides showed a lot of code examples and the results of various query strategies and indexing changes.
You can catch me, with Mark Callaghan and Peter Zaitsev, tomorrow at lunchtime at an experts’ session on migrating MySQL from 4.0 to 5.0 (organized by solidDB). On Wednesday I’ll be part of a lightning session Lightning Rounds with Top MySQL Community Contributors.
On Thursday I will be giving a session myself, on how to use the innotop MySQL and InnoDB monitor. I designed this session to show you how to go beyond the surface with innotop; my design strategy with innotop is that you should be able to start it and see something useful immediately without the advanced features even being visible, but there’s a tremendous amount of power lurking in it.
I hope to meet you if you’re here, whether at one of my sessions or just in the hallways. Till then, be well and enjoy the conference!