Sessions of interest at MySQL Conference and Expo 2009Sat, Apr 11, 2009 in Conferences Databases Open Source
I haven’t really decided my schedule yet during the conference, but I thought I’d mention these sessions that look interesting to me.
I’m presenting a session on how to use Maatkit, which I think attendees will get a lot of benefit from.
- This is Not a Web App: The Evolution of a MySQL Deployment at Google (keynote). Mark Callaghan, need I say more?
- MySQL and Search at Craigslist. Jeremy has gotten back into technical work after a career at Yahoo! that seemed to lead him away from his heart’s desire. I’d like to hear about the things he’s done, especially since I understand it involves replacing a lot of overloaded MySQL machines with a few underloaded Sphinx machines.
- Distributed Innodb Caching with memcached. Matt and Yves have been doing really ground-breaking work here. It might not seem revolutionary, but it is: they’re dipping their toes into the future when optimizing code for slow, sequential-access disks is a crime.
- Rethinking MySQL, Enter Drizzle. I doubt I’ll be able to get in the door for this one.
- If You Love It, Break It: Testing MySQL with the Random Query Generator. Ah, that sounds nifty.
- The PBXT Storage Engine: Meeting Future Challenges. I continue to watch PBXT keenly. IMO it is one of the key storage engines of the future.
- Advanced Query Manipulation with MySQL Proxy. Proxy is a tool that’ll only become more useful in the future, too.
- Introduction to Using DTrace with MySQL. I’d like to learn about DTrace.
- Solving Common SQL Problems with the SeqEngine. It’s Beat Vontobel – he always amazes and delights the audience.
- MySQL Proxy Meets: Binlogs. Hmm, I think there’s a lot going on behind the scenes here. I think Jan is being shy and has something really nifty to unwrap.
- Understanding and Control of MySQL Query Optimizer: Traditional and Novel Tools and Techniques. Sergey’s talks are always interesting for true propeller heads.
- Faster Data Reduction and Smoothing for Analysis & Archival in MySQL. I think a lot of my clients could benefit from this!
- The Percona Performance Conference. From 8:30 AM to 10:30 PM, and I think every single session is a must-see. But I’m biased, because I helped pick sessions.
- Using Q4M: A Message Queue Storage Engine for MySQL. Queues are one of the hardest design patterns to scale with traditional techniques. Anyone who has a queue (jobs to process, comments to moderate, articles to approve, clicks to aggregate, “stuff to do and then mark as done”) should get something from this.
- libdrizzle: A New Client Library for Drizzle and MySQL. I really think the Drizzle developers’ work will have far-reaching impacts.
- Monitoring 101: Simple Stuff to Save Your Bacon. What it says.
- High Availability and Scalability Patches from Google. Good luck fitting in the door on this one, too.
- SAN Performance on a Internal Disk Budget: The Coming Solid State Disk Revolution. More from Matt Yonkovit.
- Innodb Database Recovery Techniques. Obligatory plug – Peter Zaitsev.
- MySQL Performance on EC2. Mark Callaghan? Mark Callaghan! But I have not a clue about this one. I didn’t know he was into EC2. Google doesn’t outsource their infrastructure, do they?
- There are several time slots on Wednesday when there is nothing of great interest to me. I will be at the Maatkit dot-org booth in the expo hall during this time, or maybe at the Percona conference.
- More Percona Performance Conference. Fill your brain! More, more, more!
- Deep-inspecting MySQL with DTrace. I can’t decide whether this or the earlier one is likely to be better. Domas is a wizard.
- Map/Reduce and Queues for MySQL Using Gearman. Gearman is something I have my eyes on – either that or Spread. For a secret project.
- MySQL Support Internals. They run a world-class operation and they’re my competition.
- Dormando’s Proxy for MySQL. Just because.
- Advanced Master-Slave Replication with Tungsten Failover. I keep meaning to evaluate this, but haven’t had time.
- Memory Management in MySQL and Drizzle. A specialized topic, and Stewart knows a lot of stuff.
- memcached Functions for MySQL: Seemless Caching in MySQL. There’s a lot of neat stuff here.
- MySQL Row Change Event Extraction and Publish. From Google. What else are they up to?
- InnoDB Performance and Usability Patches. By Vadim. This is a must-see for anyone who wants leading edge InnoDB features and performance. Percona’s work isn’t very well documented (yet) so this will be a great way to learn about the stuff we’ve done that you might not otherwise find out.
- SPIDER Storage Engine: Database Sharding by Storage Engine. This one is interesting. It looks like Federated with parallelism and potentially other features. I looked at the source, but it is really unclear to me what it does, and there is nary a comment to be found.
- Make Your Life Easier with Maatkit. I think I’ll attend this one, since I’m presenting. I’ll be spreading my time out over a lot of different things, and I don’t think I’ll be getting much sleep at the conference, so I’ll have to see what I can fit in. But these are the sessions I think look the most interesting.
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.