I’ve just pushed the last batch of changes into 5.2 tree. The most important change was renaming Maria engine to Aria (with old maria* compatibility variables). Other — smaller — changes included adding all plugins to the windows .zip distribution (sphinx and oqgraph too), building mysqld.exe with federatedx, not old federated engine, refactoring of mysql-test-run suite to support pluggable per-suite extensions, print the plugin configuration in the ./configure script, and other even smaller changes. Together with all bug fixes that 5.2 has accumulated over time it made the tree ready for the next release – 5.2.2!

If you want to know more about MySQL and MariaDB plugins read below. Our (Andrew Hutchings and mine) book MySQL 5.1 Plugins Development was just published by Packt. As far as I know it’s the first and the only book completely dedicated to MySQL Plugin API. It covers all existing in 5.1 plugin types, from Daemon to Storage Engines, and does not shun from explaining less known or poorly understood features of the plugin API. It describes newer plugin API extensions too – such as authentication plugins and recent CREATE TABLE extension. Also there is one chapter dedicated to UDFs.

This a “learning by example” style book, very different from the reference manual style. It is written around 23 fully working and thoroughly explained plugins example – simple demos as well as practically useful ones. My personal favorites are

  • getrusage daemon plugin
  • condition pushdown I_S plugin
  • exif full-text parser
  • Tocab storage engine (with b-tree indexes!)
  • USB authentication plugin

See the complete list in the table of contents.

What others think: