Categories:
Contributing |
Development |
MySQLDevelopment |
MySQLUniversityMySQL University
MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.
To attend a session,
point your browser to this page. Dimdim (our conferencing system) requires a web browser with Flash and is known to work on Windows, Mac OS X, Linux, and Solaris. Note that the meeting room will open only 15 minutes before the hour.
By the way, the awesome
logo was created by Mike Zinner.
[edit] Upcoming Sessions
To attend a session, point your browser to this page. Note that the meeting room will open only 15 minutes before the hour.
| Date | Time | Session Title | Presenter | Host
|
| November 19, 2009
| 14:00 UTC / 6am PST (Pacific) / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT (London) / 15:00 CET (Central Europe) / 17:00 MDT (Moscow) / 19:30 IST (India)
| memcached Functions for MySQL (UDFs)
| Patrick Galbraith
| Stefan Hinz
|
| November 26, 2009
| 14:00 UTC / 6am PST (Pacific) / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT (London) / 15:00 CET (Central Europe) / 17:00 MDT (Moscow) / 19:30 IST (India)
| The Spider Storage Engine
| Giuseppe Maxia
| Paul DuBois
|
| December 3, 2009
| 16:00 UTC / 8am PST (Pacific) / 10am CST (Central) / 11am EST (Eastern) / 16:00 GMT (London) / 17:00 CET (Central Europe) / 19:00 MDT (Moscow) / 21:30 IST (India)
| Practical Full-Text Search in MySQL
| Bill Karwin
| Paul DuBois
|
| December 10, 2009 - January 14, 2010
| Winter Break
|
| January 21, 2010
| To be scheduled
|
| January 28, 2010
| 17:00 UTC / 9am PST (Pacific) / 11am CST (Central) / 12am EST (Eastern) / 17:00 GMT (London) / 18:00 CET (Central Europe) / 20:00 MDT (Moscow) / 22:30 IST (India)
| Introduction to the Drizzle Microkernel
| Brian Aker
| Stefan Hinz
|
[edit] Proposed Sessions
If you'd like to propose a new topic, or if you'd like to give a presentation yourself, please contact Stefan Hinz.
| Session Title | Presenter
|
| Patch Management With Quilt
| Stewart Smith
|
| Checking Threading and Locking With Helgrind
| Stewart Smith
|
| How to Run the Benchmark Suite
| (to be determined)
|
| Server Memory Management (when to use which alloc)
| (Konstantin Osipov or Sergei Golubchik)
|
| Stored Program Execution
| (to be determined)
|
| Prepared Statement Execution
| (Konstantin Osipov)
|
| The MySQL Statement Dispatcher
| (MySQL Runtime Team)
|
| How Pushbuild Works
| (to be determined)
|
| Simple MySQL DB Administration Concepts for MySQL Engineers
| (to be determined)
|
[edit] Previous Sessions
Previous sessions are intended to serve as a knowledge base for engineers and other interested parties. For older sessions, you can find slides (Wiki or PDF format), audio recordings, and chat transcripts, while for most newer sessions there's a combined Flash recording of slides and audio, and optionally a chat transcript.
| Date | Session Title | Presenter
|
| November 12, 2009
| Gearman for MySQL
| Giuseppe Maxia
|
| November 5, 2009
| GRAPH computation engine for MySQL
| Arjen Lentz
|
| October 29, 2009
| MySQL scalability on SPARC & INTEL X5500 (Nehalem)
| Benoit Chaffanjon
|
| October 22, 2009
| Dual Master Setups With MMM
| Walter Heck
|
| October 8, 2009
| Building MySQL Releases on Unix
| Jörg Brühe
|
| October 1, 2009
| InnoDB Internals: InnoDB File Formats and Source Code Structure
| Calvin Sun
|
| September 24, 2009
| Concurrency Control: How It Really Works
| Heikki Tuuri
|
| September 17, 2009
| Architecture of MySQL Backup
| Lars Thalmann
|
| September 10, 2009
| Customizing MySQL Enterprise Monitor
| Mark Leith
|
| September 3, 2009
| New Features in Connector/NET 6.1
| Reggie Burnett
|
| July 2, 2009
| Starring Sakila - A Data Warehouse Mini-Tutorial
| Roland Bouman
|
| June 25, 2009
| MySQL Code Contributions
| Lenz Grimmer
|
| June 11, 2009
| The New MySQL Release Model
| Tomas Ulin
|
| June 4, 2009
| Boosting Performance With MySQL 5.1 Partitioning
| Giuseppe Maxia
|
| May 28, 2009
| MySQL Replication: Walk-through of the new 5.1 and 6.0 features
| Lars Thalmann
|
| April 30, 2009
| Testing Multiple Servers With MySQL Sandbox
| Giuseppe Maxia
|
| April 16, 2009
| Going Nuts - How to write MySQL test cases in Perl
| Luis Soares, Alfranio Correia, Serge Kozlov, Lars Thalmann
|
| April 2, 2009
| How to Create a Test Case (updated session from 2007)
| Patrick Crews
|
| March 19, 2009
| How to Use Charsets and Collations Properly
| Susanne Ebrecht
|
| March 12, 2009
| MySQL and ZFS
| MC Brown
|
| March 5, 2009
| Good Coding Style
| Konstantin Osipov
|
| February 26, 2009
| Backing up MySQL using file system snapshots
| Lenz Grimmer
|
| February 19, 2009
| Developing MySQL on Solaris
| MC Brown & Trond Norbye
|
| February 12, 2008
| Using DTrace with MySQL
| MC Brown
|
| February 5, 2009
| MySQL Performance and Scalability Project - Issues and Opportunities
| Allan Packer
|
| January 29, 2009
| Scalability Challenges in an InnoDB-based Replication Environment
| David Lutz
|
| January 22, 2009
| Scalability by Design - Coding for Systems With Large CPU Counts
| Richard Smith
|
| January 15, 2009
| Low-Level Locking in mysqld and InnoDB - the Good, the Bad, and the Ugly
| Tim Cook
|
| December 11, 2008
| Random Query Generator
| Philip Stoev
|
| December 4, 2008
| What's New in MySQL Optimizer
| Sergey Petrunia
|
| November 20, 2008
| Using memcached in MySQL deployments
| MC Brown
|
| November 13, 2008
| MySQL and OpenSolaris
| MC Brown
|
| November 6, 2008
| Tour of Bazaar and Launchpad for Beginners
| Jay Pipes
|
| October 30, 2008
| Quick and Easy Testing With MySQL Sandbox
| Giuseppe Maxia
|
| October 23, 2008
| Working with PHP and MySQL in NetBeans
| Petr Pisl and David Van Couvering
|
| October 2, 2008 | Checking Performance with Kchachegrind | Stewart Smith
|
| September 11, 2008 | OpenSolaris Web Stack | Jyri Virkki & Murthy Chintalapati
|
| September 4, 2008 | Building MySQL Client Applications | Hartmut Holzgraefe
|
| July 3, 2008 | Advanced LUA Scripting | Giuseppe Maxia
|
| June 12, 2008 | MySQL University MySQL Sandbox | Giuseppe Maxia
|
| May 8, 2008 | Getting Started Using NDB | Stewart Smith
|
| March 27, 2008 | EC2 | Brian Aker
|
| March 6, 2008 | How to Add a Collation | Alexander Barkov
|
| February 28, 2008 | New Optimizer Features in MySQL 6.0 | Sergey Petrunia
|
| February 21, 2008 | Checking Memory With Valgrind | Stewart Smith
|
| February 14, 2008 | Building MySQL on Windows | Ignacio Galarza
|
| February 7, 2008 | C++ Coding Techniques and Principles | Mats Kindahl
|
| January 24, 2008 | Execution of INSERT (DELAYED) and UPDATE statements | Oleksandr Byelkin
|
| December 13, 2007 | Writing LUA Scripts for MySQL Proxy (Abstract) | Giuseppe Maxia
|
| December 6, 2007 | Interaction Between Optimizer and Storage Engine | Sergey Petrunia
|
| November 15, 2007 | How to Run MySQL With a Debugger | Guilhem Bichot
|
| November 8, 2007 | How to Use BitKeeper | Sergei Golubchik
|
| November 1, 2007 | How MySQL Handles ORDER BY, GROUP BY, and DISTINCT | Sergey Petrunia
|
| October 25, 2007 | How to Create a Test Case | Omer BarNir & Matthias Leich
|
| October 18, 2007 | Following a Query Back and Forth in the Server | Sergei Golubchik
|
| October 11, 2007 | Architecture of NDB | Mikael Ronström
|
| September 13, 2007 | MySQL Proxy Overview | Jan Kneschke
|
| September 6, 2007 | How to Build MySQL on Windows | Reggie Burnett
|
| July 19, 2007 | MySQL Memory Handling and Memory Handling in Falcon | Konstantin Osipov and Ann Harrison
|
| June 14, 2007 | Overview of Query Execution and Use of Temp Tables | Monty Widenius
|
| June 7, 2007 | How to Do a Good Code Review | Sergei Golubchik
|
| May 31, 2007 | MySQL Error Handling and Reporting | Tim Smith
|
| May 24, 2007 | Event Scheduler: How it Works and how to Add a Layer on Top of Stored Procedures | Andrey Hristov
|
| May 17, 2007 | Architecture of Falcon | Ann Harrison and Jim Starkey
|
| April 19, 2007 | How the Plugin Interface Works | Brian Aker
|
| April 12, 2007 | Architecture of Backup and Overview of Online Backup Plan | Lars Thalmann, Rafal Somla and Chuck Bell
|
| April 5, 2007 | How Does the MySQL Optimizer Work? | Timour Katchaounov
|
| March 22, 2007 | MySQL Lock Management | Konstantin Osipov
|
| March 15, 2007 | MySQL Storage Handler Interface | Brian Aker
|
| March 8, 2007 | Architecture of Replication | Lars Thalmann
|
| March 1, 2007 | mysys library and algorithms | Sergei Golubchik
|
[edit] Feedback
Primary contact for MySQL University is Stefan Hinz
[edit] Instructions for Moderators
Here are our fail-safe instructions for moderators.
- Schedule a Dimdim test session with the presenter if that person has never used Dimdim before. Make sure the presenter uses a headset with a microphone.
If the presenter doesn't have superior bandwidth, ask him to disable his laptop camera. If he/she doesn't Dimdim will use it, and this might have a serious impact on sound quality. Here are instructions on how to disable a built-in camera in Mac OS X.
- Go to the Dimdim sign-on page and log in using the MySQL University account credentials.
- On the overview page, start either a pre-scheduled session or a new one ("Host Session"). Start the session 15 minutes before the hour.
- Mute yourself (in Flash) – the host's voice is always garbled for some reason.
- Assign presenter status to the presenter as soon as he arrives.
- Remind the presenter to upload his presentation (PDF or PPT) as early as possible. Note: DimDim apparently imposes a 20MB limited on the size of uploaded files. Large presentations may need to be split into pieces.
- Say hello in the chat, and remind attendees that they can ask questions in the chat window.
- Press the "Recording" button when the presenter is ready to start.
- At the end of the session, thank the presenter and the audience, and say that the session will end now.
- Press the "Stop" button to stop the recording.
- Press the "End Meeting" button to end the meeting. You should be redirected to the overview page.
- On the overview page, click "Search Meetings" to find the meeting you've just hosted.
- After a few minutes, links to the recording and the chat transcript should appear.
- Copy those links to the appropriate MySQL University session page.
[edit] Templates
Here are slide templates that presenters can use. Please convert into PDF format before uploading to the session page.
[edit] Slides and sound tracks licensing
All the material released with MySQL University lessons, unless otherwise indicated in the material itself, is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported License
