Mastering MySQL, MariaDB and Drizzle Plugin Development

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.

• 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