MySQL Camp 2009 Sessions
[edit] Sunday 12 noon - 12 midnight
Games day on the mezzanine tables at the Hyatt. More info, including games that will appear.
[edit] Monday 9:00 am - 12:00 pm
Hackfest
Mark Callaghan. Pick a MySQL feature to add or extend (or a bug to fix) and Mark will walk you through the important basics and help one or more groups hack away!
[edit] Monday 1:30 pm - 5:00 pm
Ask a Guru
Drop-in sessions. Come with your questions, and leading MySQL experts will provide help free of charge. Or just come to listen.
[edit] Tuesday 10:50 am - 11:35 pm
(45 min)
Matt Yonkovit (Sun/MySQL, Waffle Grid, Big DBA Head, [blog]) presents Learning from others' MySQL Performance Mistakes. Matt: has spent the last couple of years helping customers who are all dealing with the same MySQL related problems over and over again. During this session he will give you some of the most common issues in MySQL deployments he sees on a day to day basis, and how to fix or avoid them. These include:
* More is not always better * Text Fields are not cool * Data Size does matter * Fun with Data Conversions * Its all about IO * Left join love * Self Induced fragmentations * MySQL is not Oracle
and more!!!! Come and join the fun.
[edit] Tuesday 11:55 am - 12:35 pm
Intro to XtraDB, a Scalable InnoDB-based Storage Engine Ewen Fortune (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 InnoDB’s 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 InnoDB’s limitations. Vadim will talk about current status of XtraDB and directions of development.
Watch the presentation video online at http://www.youtube.com/watch?v=kTCUZ3s1iIY
[edit] Tuesday Lunch
See a list of restaurants near the MySQL Conference and MySQL Camp.
[edit] Tuesday 2:00 pm - 2:45 pm
Roland Bouman will present a session on Grand Tour of the Information Schema and its Applications
The following topics will be covered:
Introduction of the information schema and it’s 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
Watch the video online at http://www.youtube.com/watch?v=M3ryKyMkiQY
[edit] Tuesday 3:05 pm - 3:50 pm
Setting up MySQL on Amazon Web Services (AWS)
Ronald Bradford, Principal at 42SQL will step you though getting started with AWS.
This introduction will assume you know nothing about AWS, and have no account. With Internet access via a Browser and a valid Credit Card, you can have your own running Web Server on the Internet in under 10 minutes, just point and click.
We will step into some more detail using the available online and supplied command line tools for more advanced usage.
The slides from this presentation are available [1]
[edit] Tuesday 4:25 pm - 5:10 pm
Yves Trudeau (Sun/MySQL, Waffle Grid, Big DBA Head ) presents NBD (MySQL Cluster) performance tuning and pitfalls. In the recent months Yves has worked on many NDB Cluster engagements and come through many unusual situations that are relevant to people interested in NDB Cluster. Here is a brief list of the topics to be covered:
- Identifying bottleneck
- Minimizing disk footprint
- Minimizing latency (logger type application)
- Realtime options
- Using CPUs efficiently
- The e1000 pitfall
[edit] Tuesday 5:15 pm - 6:00 pm
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)
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 corruptions using innodb_force_recovery and build-in MySQL Features
- Recovering deleted data and dropped tables using Innodb Recovery Tools package
- Dealing with complex data loss scenarios such as failed filesystem or failed RAID subsystem.
Play the video online at http://www.youtube.com/watch?v=yuU40p_V9Ic
[edit] Wednesday 10:50 am - 11:35 pm
Chasing Bottlenecks by Morgan Tocker
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.
Watch the video at http://www.youtube.com/watch?v=1L8TwuKMg3M
[edit] Wednesday 11:55 am - 12:35 pm
Christos Kalantzis (profile) will give a session on Running Two MySQL Instances Using One Installation.
As hardware gets really powerful and cheap, server consolidation is very important to save Datacenter real estate and power consumption. Virtualization is the knee-jerk reaction, but inefficient because you have to allocate resources for each instances full stack (OS, network, etc..)
This session will be covering how to install and run multiple instances of MySQL on one OS installation.
[edit] Wednesday Lunch
See a list of restaurants near the MySQL Conference and MySQL Camp.
[edit] Wednesday 2:00 pm - 2:45 pm
Practical Object-Oriented Models in SQL by Bill Karwin
aka "SQL is from Mars, Objects are from Venus"
This talk is for software developers who know SQL but are stuck trying to implement common object-oriented structures in an SQL database. Mimicking polymorphism, extensibility, and hierarchical data in the relational database paradigm can be confusing and awkward, but they don't have to be.
- Polymorphism: Suppose your blog supports comments, but then your comments need to reference multiple types of content, for example news, blog articles, and videos. What then?
- Extensibility: We've all designed customizable software, allowing customers to extend a data model with new data attributes. See how to design flexible systems, while using efficient SQL queries.
- Hierarchies: Tree-structured data relationships are common, but working with trees in SQL usually implies recursive queries. There are a few solutions to solve this more cleanly.
- ActiveRecord Dos and Dont's: Web development frameworks have popularized the use of design patterns, but when it comes to multi-table queries, complex views, and assignment of OO responsibilities, ActiveRecord falls short as a one-size-fits-all Domain Model.
Slides are selections from Bill's "SQL Antipatterns" presentation, which is available at SlideShare.net/BillKarwin
[edit] Wednesday 3:05 pm - 3:50 pm
Open Source for Newbies
Leslie Hawthorn (Google)
As adoption of Open Source code and development practices continues to gain momentum, more newcomers have become interested in getting involved and contributing to Open Source. However, getting started contributing to an Open Source project is not as easy as those of us who are already here might imagine. This talk will examine some of these barriers to entry for newbies and how to overcome them. Do you want to get involved with Open Source and don't know where to start or would you like to help ease the way for newcomers to your project?
This session will give you an overview of where and how to dive in, including:
- How to choose an Open Source project
- Areas for contribution for non-programmers
- Understanding and effectively articulating what you can offer to your chosen community
- Project communication mechanisms and how to best make use of them when starting out
- Social interaction in Open Source projects
- Welcoming newbies into your community and helping them be productive
[edit] Wednesday 4:25 pm - 5:10 pm
Top 10 MySQL Pet Peeves and How to Workaround Them Matt Yonkovit
http://www.youtube.com/watch?v=yxx2XbbTiP0
[edit] Wednesday 5:15 pm - 6:00 pm
DHT-based P2P storage engine for MySQL by Davi Arnaut
Demonstrate how a distributed hash table (DHTs) can be used to build a robust, scalable and neat relational database. Dive into the details of implementing a MySQL storage engine and indexing data on top of a generic DHT service.
[edit] Thursday 10:50 am - 11:35 pm
8 Rules for Designing More Secure Applications
Augusto Bott (bott@pythian.com) & Nicklas Westerlund (westerlund@pythian.com)
In this session we'll present 8 simple rules to help you focus on designing more secure applications. We hope that at the end of this session, the attendees will be presented to a number of simple techniques to build applications secure by design. We're not security experts: we're paranoid architects.
Topics: Architecture and Technology, Security and Database Administration
Abstract
By checking some of the ramifications of the below, focusing on suggestions on how to to keep your data secure we’ll present lessons learned while designing secure and efficient architectures at the same time. We’ll bring to your attention some of the tradeofs between easiness of operations versus a hard-to-break design. Unfortunately, we can’t foresee every single possible security flaw in advance, but in this session you will learn techniques to help you do a good design at the same time you minimize the risk.
- Do not trust anything that comes from outside the Firewall
- Do use of stored procedures and views to isolate your data from the Application
- Isolate your data from the application user
- Make sure you have proper Credentials Management
- Do not send data in plain text (ever!)
- Do not store passwords anywhere
- Make sure your Application is Auditable
- Make sure your Application is Recoverable
At the end of this session, we hope you take back with you some nice ideas to help you protect your data through real world examples.
[edit] Thursday 11:55 am - 12:35 pm
Test Drive MySQL 6.1
Peter Gulutzan and Konstantin Osipov will have a live, hands-on demo of downloadable publicly available as-of-April-20 MySQL 6.1.
This is an "educational" and "how-to" and "hands on" show of what you can do now if you take up the latest source. You're looking over our shoulders while we use foreign keys, utf32, performance schema, EXECUTE IMMEDIATE, and so on.
[edit] Thursday Lunch
See a list of restaurants near the MySQL Conference and MySQL Camp.
[edit] Thursday 2:00 pm - 2:45 pm
Title: Predicting Performance with Queuing Models
Speaker: David Lutz (Sun Microsystems)
Description: Queuing models provide a foundation for predictive performance analysis and capacity planning, and make it possible to examine "what if" scenarios for changing workloads and system configurations. In this session, we will examine the basic metrics, relationships, and algorithms used in queuing models, and will look at applications of these models, from simple hand calculations to more complex open source and commercial modeling software.
Abstract: Given a few key metrics, such as service demand and either transaction arrival rate or user population and think time, along with a simplified view of the components in a computer system, we can predict throughput and response time for a given workload. In the simplest case, a few hand calculations will provide bottleneck identification and upper and lower bounds on response time and throughput. More sophisticated models, using open source software such as Performance Dynamics' PDQ tool kit or the Politecnico di Milano's JMT suite, or commercial products such as TeamQuest Performance Software, can provide reasonably accurate predictions of specific throughput and response time. Given a validated model, we can examine the impact of component upgrades, increased user demand, or workload consolidation. This session will provide a brief overview of basic algorithms, system metrics, and available modeling software.
Slides: The slides for this session are available here.
[edit] Thursday 2:50 pm - 3:35 pm
Closing Keynote: The State of Open Source Databases Brian Aker, Sun
Watch the video online at http://www.youtube.com/watch?v=m2V-hvD_icA