Practical MySQL Plugin Development

Roland Bouman (XCDSQL Solutions / Strukton Rail), Sergei Golubchik (MariaDB)
Average rating: *****
(5.00, 1 rating)

In this 3 hour tutorial, attendees will learn how to write plugins for the MySQL server.

The tutorial will have a strong focus on practical, hands-on development. The speakers will give live coding demonstrations and attendees are invited to raise questions at any time.

Basic C/C++ skills are recommended for attendees, although not required, in which case some programming skills in Java or PHP are hightly recommended. To allow attendees with no prior C/C++ skills to still gain knowledge and skills, a particular approach is taken that proved to be successful in last year’s UDF tutorial.

Attendees will be provided with a handout containing detailed, well-written labs and instructions to execute them. Accompanying scripts and code will be prepared and distributed at the start of the tutorial, allowing all attendees to build, deploy and test plugins and change the code to learn more about plugin implementation. Instructions and scripts will be prepared for Microsoft Windows (where applicable), GNU/Linux and Mac OSX.

Here is a high level outline of the topics that will be covered during the tutorial:

  1. Overview of the MySQL plugin API
  2. Architecture
  3. Components (important functions and structures, versioning, s ervices)
  4. Plugin deployment, configuration and administration
  5. the plugin.h header file
  1. Setting up a build environment
  2. compiling and linking plug-ins with gcc
  1. Getting started: Daemon plug-in
  2. Daemon plug-in specific interface
  3. Practical example: a heartbeat plugin
  1. FULLTEXT parser plug-in development
  2. FULLTEXT plug-in specific interface
  3. create a parser front end to filter out indexable content in complex documents for example XML files
  4. create a custom FULLTEXT parser for a particular non-english language
  1. INFORMATION_SCHEMA plug-in development
  2. Information schema plug in specific interface
  3. Learn how to report server internals such as the contents of the query cache in a custom information_schema table
  4. Create an information_schema plug-in to query data at the operating system level, such as the process list and the list of OS users
  1. Storage Engine plug-in
  2. Storage engine plug-in specific interface
  3. Create an engine that emulates an Oracle sequence
  4. Create an engine to read and write an arbitrary text file in a fixed or separated format
  1. A look at MySQL 6.0 plugins:
  2. Interface changes, new features
  3. New plugin type: Audit plugin
  4. Practical example
Photo of Roland Bouman

Roland Bouman

XCDSQL Solutions / Strukton Rail

I’m a Web Application and Business Intelligence developer and I authored two books about the Pentaho Open Source Business Intelligence stack: “Pentaho Solutions” (ISBN 978-0470484326) and "Pentaho Kettle Solutions (ISBN 978-0470635179). I’m an active member of the MySQL and Pentaho communities. In the past, I worked for Inter Access, MySQL AB, Sun Microsystems. I currently work for Strukton Rail.

Photo of Sergei Golubchik

Sergei Golubchik

MariaDB

I’m working in MySQL AB since 2000. Worked in 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. A primary architect of the plugin API. These days I also spend a lot of time doing code and architecture reviews for bug fixes and new features.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

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

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.