MySQL Conference 2009 daily summary: Wednesday

Busy day again: today the Percona conference joined the regular schedule, so more stuff to attend!

What did I attend?

Maria In Depth, Monty Widenius, MontyProgram AB (Percona conference): Monty was discussing Maria performance-wise as opposed to his later session which was feature-wise). He did delve just a little bit into the decision making issues in MySQL and in his new company. He also spoke (and I believe this took the most weight of the session, even if not the most time) of his new company, what he wants to achieve and how.

Build Your Own MySQL Time Machine, (Sun Microsystems), Mats Kindahl (Sun Microsystems). A web based utility for creating online backups and performing a point in time restoration was presented. The system is based on MySQL 6.0’s new backup mechanism, and runs on a slave. The presenters showed how easy it would be to say “I would like to restore data to as it was yesterday 14:56pm”. Hope to see such final product in the future!

Fighting MySQL Replication Lag, Peter Zaitsev (Percona conference). Peter explained the causes for replication lag, the types of measurements which should be made, how to make them, and of course, hot to avoid replication lag. He discussed solutions starting from tuning queries in such way that the slave need not repeat complicated work done by the master; ways of warming up the slaves (for example, using Maatkit’s mk-slave-prefetch) and more. It was an interesting short session. I must say that the short session idea is a pretty good one. It keeps you awake and concentrated.

Monitoring 101: Simple Stuff to Save Your Bacon Ronald Bradford (42SQL): Ronald made a convincing argument for using proper and system wide monitoring mechanisms, by following some customer stories. He presented OS level (disk, memory, CPU, network) monitoring and diagnosing utilities; has lay down the basics for monitoring MySQL (SHOW STATUS, SHOW PROCESSLIST etc.), and finally discussed some common monitoring utilities. It was a good overview of the needs and capabilities of monitoring.

Innodb Database Recovery Techniques Peter Zaitsev: Peter presented some sophisticated techniques, some of which were developed by Percona, to recover from InnoDB corruption. He also explained the innodb recovery mechanism and the innodb_recovery_level parameter.

Quick wins with third party MySQL patches, Morgan Tocker, Percona (Percona conference): Morgan presented some of the Percona patches. Again, this was a short session, and to the point.

In between I entered and left some more talks, which did not catch my attention. A busy day, all in all!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.