Presented at MySQL Camp 2009 by Ewen Fortune of Percona. XtraDB is a storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB. XtraDB includes all of InnoDBs robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDBs limitations. We will talk about current status of XtraDB and directions of development.

presented at MySQL Camp 2009.

The 2009 MySQL Camp keynote speech was delivered by Brian Aker and entitled "The State of Open Source Databases".

Presented at the 2009 MySQL Camp: Grand Tour of the Information Schema and its Applications by Roland Bouman Description: The following topics will be covered: - Introduction of the information schema and its components - How to generate WIKI documentation from the information schema - Generating code (triggers, SPs) to maintain a rich history database - Creating a stored procedure to check violated foreign key constraints - Creating a stored procedure to create federated tables

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  []

As folks are making their plans to go to the MySQL User Conference, I just wanted to remind folks of the schedule of MySQL Camp.One feature I put together for MySQL Camp but anyone can use is a restaurant list for the hotel area. There's very little within walking distance, but many people will be local or will rent a car, so finding someone to drive with should not be a problem. The restaurant list is on the MySQL Forge Wiki at http://forge.mysql.com/wiki/SantaClaraRestaurants -- updates are welcome!About MySQL Camp: MySQL Camp is completely free, just walk on in and enjoy the sessions. All sessions are in the Bayshore room off the Mezzanine, and there will be signs directing you to the MySQL Camp room. I describe it as being like "an additional room for the MySQL Conference, but it's free." It also has some of the more technical, hands-on talks that did not make it to the conference.