Book Image

MySQL 5.1 Plugin Development

Book Image

MySQL 5.1 Plugin Development

Overview of this book

MySQL has introduced a Plugin API with its latest version – a robust, powerful, and easy way of extending the server functionality with loadable modules on the fly. But until now anyone wishing to develop a plugin would almost certainly need to dig into the MySQL source code and search the Web for missing bits of the information.This is the first book on the MySQL Plugin API. Written together with one of the Plugin API primary architects, it contains all the details you need to build a plugin. It shows what a plugin should contain and how to compile, install, and package it. Every chapter illustrates the material with thoroughly explained source code examples.Starting from the basic features, common to all plugin types, and the structure of the plugin framework, this book will guide you through the different plugin types, from simple examples to advanced ones. Server monitoring, full-text search in JPEG comments, typo-tolerant searches, getting the list of all user variables, system usage statistics, or a complete storage engine with indexes – these and other plugins are developed in different chapters of this book, demonstrating the power and versatility of the MySQL Plugin API and explaining the intricate details of MySQL Plugin programming.
Table of Contents (16 chapters)
MySQL 5.1 Plugin Development
Credits
About the Authors
About the Reviewer
Preface

The full-text parser plugin architecture


Full-text parsers were the first plugin type implemented in the Plugin API. In fact, both the Plugin API and the full-text parsers were developed at the same time within the same project. Unlike Information Schema tables or storage engines, MySQL did not support multiple full-text parsers originally. The support for them was added together with the full-text parser plugins. No wonder the full-text parser API was carefully designed specifically for plugins, and it managed to achieve almost a complete separation of a plugin from the server internals. As a result, the full-text parser API is simple and very stable; it has hardly changed since its inception in 2005, and full-text parser plugin binaries that worked back then can still be loaded in MySQL now and they will work as designed.

Three roles of a full-text parser plugin

When MySQL needs to parse a piece of text, be it for insertion into a full-text index, deletion from a full-text index, or during...