InnoDB Database Recovery Techniques Peter Zaitsev (Percona) Presented at the 2009 MySQL Camp by Peter Zaitsev of 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. Then we will look at Innodb storage data structure to see what foundations does it has for corruption discovery and recovery. Then we will go into approaches one can use to recover data including: * Recovering Innodb dictionary running our of sync with .idb files * Recovering minor  []

Unleash the Power of Your Data Using Open Source Business Intelligence Christopher Lavigne (Breadboard BI, Inc.) The official conference description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/5593 Download the PPT slides at http://assets.en.oreilly.com/1/event/21/Unleash%20the%20Power%20of%20Your%20Data%20Using%20Open%20Source%20Business%20Intelligence%20Presentation.ppt

Crash Recovery and Media Recovery in InnoDB Heikki Tuuri (Innobase / Oracle Corp.) From the official conference page at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6843 InnoDB provides a reliable, true-and-tested automatic crash recovery for MySQL database users. It is based on a redo log and write-ahead logging, two techniques that are used in most of the leading database engines in the world. We will explain these techniques in depth, and present some benchmarks of the crash recovery time. InnoDBs media recovery is done from a (hot) backup of a database, using the MySQL binlog to replay the transactions just as they happened originally. We will explain the difference between MySQLs statement-based and row-based replication and binlogging, and how they should be used to ensure a successful replay of transactions.

Map/Reduce and Queues for MySQL Using Gearman Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7346 Download the PDF slides from http://assets.en.oreilly.com/1/event/21/Map_Reduce%20and%20Queues%20for%20MySQL%20Using%20Gearman%20Presentation.pdf

High Performance Ruby on Rails and MySQL David Berube (Berube Consulting) From the official conference description is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942 MySQL is among the fastest relational databases commonly available today; unfortunately, the database alone is only part of the picture. For todays web applications, the one weak link in the entire performance chain from the network to the web application and ending in the database can cause an entire application to seem slow. Unfortunately, Ruby on Rails on exacerbates this problem: Rails makes it easy to develop complicated web applications fast, but it also makes it easy to access your databases in an extremely inefficient manner. Thousands of queries may be generated when just a few are necessary. Even if you can get past that problem, ActiveRecord itself can be a problem: it may create thousands or even millions of  []

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Download the PDF slides at http://assets.en.oreilly.com/1/event/21/Using%20the%20Event%20Scheduler_%20The%20Friendly%20Behind-the-Scenes%20Helper%20Presentation.pdf From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115 The Event Scheduler is a framework for executing SQL commands at specific times or at regular intervals. The basics of its architecture are simple. An event is a stored routine with a starting date and time, and a recurring tag. Once defined and activated, it will run when requested. Unlike triggers, events are not linked to specific table operations, but to dates and  []

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x"). And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html The slides can be downloaded as a PDF at http://technocation.org/files/doc/2008_12_New51.pdf or in Open Office presentation format at http://technocation.org/files/doc/2008_12_New51.odp

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture Moshe Shadmon (ScaleDB) Slides can be downloaded at http://assets.en.oreilly.com/1/event/21/The%20ScaleDB%20Storage%20Engine_%20%20Enabling%20High%20Performance%20and%20Scalability%20Using%20Materialized%20Views%20and%20a%20Shared-Disk%20Clustering%20Architecture%20Presentation.ppt The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112

If You Love It, Break It: Testing MySQL with the Random Query Generator by Philip Stoev (Sun Microsystems) The description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363 Download the presentation slides (ppt) at http://assets.en.oreilly.com/1/event/21/If%20You%20Love%20It,%20Break%20It_%20Testing%20MySQL%20with%20the%20Random%20Query%20Generator%20Presentation.ppt

Sheeri Cabral speaks about the changes in MySQL 5.1 and everything you need to know about upgrading. Get the slides at http://technocation.org/files/doc/2008_12_New51.pdf See the accompanying blog post with more information at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation

Chasing Bottlenecks by Morgan Tocker Description: The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Percona, OurDelta, and Google releases/patches). The slides are at http://www.slideshare.net/datacharmer/mysql-54-theory-and-practice

Advanced Query Manipulation with MySQL Proxy Kay Roepke (Sun Microsystems) From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040 Currently MySQL Proxy only comes with an incomplete tokenizer for a subset of the MySQL dialect. Many use cases require more knowledge about the query that a stream of tokens can provide and users are force to create their own parsers, most of which are handwritten and simplistic, in Lua. While this is often sufficient for special cases and specific applications, it cannot serve as an extensible and robust framework. For the purpose of query formatting in the MySQL Enterprise Monitor I have written a new parser using ANTLR, where I am a committer in the project. Due to the nature of ANTLR generated recognizers, it is possible to target different implementation languages with little effort and thus has been integrated with  []

Use Dtrace to monitor your queries.

Slides are online (and downloadable) at http://www.slideshare.net/Sheeri/scale-db-preso-for-boston-my-sql-meetup-92009 Mike Hogan, CEO of ScaleDB spoke about ScaleDB at the Boston MySQL User Group in September 2009: ScaleDB is a storage engine for MySQL that delivers shared-disk clustering. It has been described as the Oracle RAC of MySQL. Using ScaleDB, you can scale your cluster by simply adding nodes, without partitioning your data. Each node has full read/write capability, eliminating the need for slaves, while delivering cluster-level load balancing. ScaleDB is looking for additional beta testers, sign up at http://www.scaledb.com

A working "progress bar" for ALTER TABLE. Until MySQL / Drizzle can do this "natively", this is a pretty neat trick

Shows how to start MySQL Cluster 7.0 with 2 management nodes using the new ndb_mgmd behavior caching the configuration and distributing it to the other management nodes.

Shows how to do a rolling restart after a configuration change using MySQL Cluster 7.0 with two management nodes.

"There's a change of behaviour in MySQL 5.1.31 for Row Based Replication, if you have InnoDB transactions that also write to a MyISAM (or other non-transactional engine) table." "the moral of the story. Don't use non-transactional tables in the middle of a transaction. Ever. You will only cause yourself more pain than you can possibly imagine. Instead, move the writes to the non-transactional tables outside of the transaction."

MySQL DML Statistics using mysqlbinlog - 1 liner