Mastering MySQL, MariaDB and Drizzle Plugin Development

Sergei Golubchik (MariaDB), Andrew Hutchings (Hewlett-Packard)
Tutorial
Location: Ballroom A
Average rating: *....
(1.75, 4 ratings)

MySQL Plugins – first introduced in 5.1 – are server extensions that can be loaded into the running MySQL on the fly, without restart.

This tutorial will teach what tasks can be solved with plugins, what a plugin consists of, and how to write a plugin that helps with your specific problem.

We strongly believe in “learning by example” and this tutorial will be of a very practical, hands-on style. It will include useful fully working plugin examples and live demonstrations. In addition to GNU/Linux, we will cover Mac OS X, and Microsoft Windows.

During this three hours you learn

  • The underlying principles of the MySQL Plugin API, what different plugin types are available in MySQL
  • How to build and install a plugin, how to package it for distributing separately from MySQL
  • Basic plugin structure, common plugin features
  • What can be done with Daemon plugins, how to write a such a plugin
  • INFORMATION_SCHEMA plugin – when to use them and when not to use them; how they work
  • How to create full-text parser plugins; what can they do
  • Storage engines – basics, rows, indexes
  • Authentication plugins – external authentication with ease
  • New features in the Plugin API

Basic C/C++ and MySQL knowledge is expected, but no deep familiarity with either is required.

This tutorial will cover both MySQL and MariaDB – most of the material will equally apply to both.

  • NOTE: This tutorial runs all day, from 9AM – 5PM with a one-hour lunch
Photo of Sergei Golubchik

Sergei Golubchik

MariaDB

I was a MySQL developer since 1998. From 1999 to 2009 in MySQL AB, Sun, then in Monty Program AB on MariaDB. During these years I’ve touched almost almost every part of the server. To list a few projects – fulltext search, XA,
HANDLER, precision math library, parallel repair and bulk inserts in MyISAM, indexes in MERGE. I’m a primary architect of the plugin API and an author of the “MySQL 5.1 Plugin Development” book.

Photo of Andrew Hutchings

Andrew Hutchings

Hewlett-Packard

Andrew Hutchings is a Software Developer on the Drizzle project at Rackspace and co-author of the book MySQL 5.1 Plugins Development. He is based in the United Kingdom and has worked for MySQL/Sun since 2008. Before joining Rackspace he was a MySQL Support Engineer for Oracle Corporation specialising in MySQL Cluster and C/C++ APIs.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts