MySQL 5.1 Plugin Development

Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins
Preview in Mapt

MySQL 5.1 Plugin Development

Andrew Hutchings, Sergei Golubchik

Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins
Mapt Subscription
FREE
$29.99/m after trial
eBook
$18.90
RRP $26.99
Save 29%
Print + eBook
$44.99
RRP $44.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$18.90
$44.99
$29.99 p/m after trial
RRP $26.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


MySQL 5.1 Plugin Development Book Cover
MySQL 5.1 Plugin Development
$ 26.99
$ 18.90
AJAX and PHP: Building Responsive Web Applications Book Cover
AJAX and PHP: Building Responsive Web Applications
$ 20.99
$ 14.70
Buy 2 for $32.20
Save $15.78
Add to Cart

Book Details

ISBN 139781849510608
Paperback288 pages

Book Description

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

Chapter 1: Compiling and Using MySQL Plugins
UDF libraries
Plugin libraries
Automatic builds, packaging
Summary
Chapter 2: User Defined Functions
Writing UDFs
A constant integer output UDF
An integer echoing UDF
A simple static text output UDF
A summing aggregate UDF
Further reading
Summary
Chapter 3: Daemon Plugins
A look inside a Daemon plugin
A Hello World! Daemon plugin
A system and status variables demo plugin
A simple monitoring plugin
System Status Variables plugin
Summary
Chapter 4: Information Schema Plugins
Why write Information Schema plugins
The creation of Information Schema plugins
A Static Table example
A System Information plugin
Summary
Chapter 5: Advanced Information Schema Plugins
Accessing MySQL internals
Condition pushdown
A User Variables Information Schema plugin
A Binary Logs Information Schema plugin
Summary
Chapter 6: Full-text Parser Plugins
The full-text parser plugin architecture
A PHP full-text parser
Summary
Chapter 7: Practical Full-text Parsers
Boolean parsers
A Boolean full-text parser
An Image Metadata processor
A Soundex full-text parser
Summary
Chapter 8: Storage Engine Plugins
Introducing storage engines
A read-only storage engine
Summary
Chapter 9: HTML Storage Engine—Reads and Writes
An idea of the HTML engine
Flashback
Creating, opening, and closing the table
Reading data
Updating the table
Optimizing and analyzing
What's left
Compiling and linking
Putting it all together
Summary
Chapter 10: TOCAB Storage Engine — Implementing Indexes
B-tree library
Storage engine API for indexes
Describing the engine
Creating, opening, and closing the table
Searching in the index
Rows and keys
Table scan and random access
Inserting rows
What's left
Compiling and linking
Putting it all together
Possible extensions
Summary

What You Will Learn

  • Build and install a plugin, and learn how to package it for distributing separately from MySQL
  • Add new functions to MySQL using the UDF interface
  • Declare new MySQL status and configuration variables from a plugin, and use Daemon plugins for a simple push style server monitoring
  • Add a new table to the INFORMATION_SCHEMA that shows anything you like with an INFORMATION_SCHEMA plugin
  • Use fulltext parser plugins to tolerate user errors, and search for text in binary data formats, for example, JPEG, or text that is stored outside the database
  • Store and retrieve rows and convert your custom data format to what MySQL understands using the storage engine plugin
  • Create a parser that indexes comments from JPEG files using the libexif library
  • Understand how the indexing API works, and how to work around the incompatibilities between your indexing engine and MySQL expectations
  • Learn about new features of the Plugin API, available beyond MySQL 5.1

Authors

Table of Contents

Chapter 1: Compiling and Using MySQL Plugins
UDF libraries
Plugin libraries
Automatic builds, packaging
Summary
Chapter 2: User Defined Functions
Writing UDFs
A constant integer output UDF
An integer echoing UDF
A simple static text output UDF
A summing aggregate UDF
Further reading
Summary
Chapter 3: Daemon Plugins
A look inside a Daemon plugin
A Hello World! Daemon plugin
A system and status variables demo plugin
A simple monitoring plugin
System Status Variables plugin
Summary
Chapter 4: Information Schema Plugins
Why write Information Schema plugins
The creation of Information Schema plugins
A Static Table example
A System Information plugin
Summary
Chapter 5: Advanced Information Schema Plugins
Accessing MySQL internals
Condition pushdown
A User Variables Information Schema plugin
A Binary Logs Information Schema plugin
Summary
Chapter 6: Full-text Parser Plugins
The full-text parser plugin architecture
A PHP full-text parser
Summary
Chapter 7: Practical Full-text Parsers
Boolean parsers
A Boolean full-text parser
An Image Metadata processor
A Soundex full-text parser
Summary
Chapter 8: Storage Engine Plugins
Introducing storage engines
A read-only storage engine
Summary
Chapter 9: HTML Storage Engine—Reads and Writes
An idea of the HTML engine
Flashback
Creating, opening, and closing the table
Reading data
Updating the table
Optimizing and analyzing
What's left
Compiling and linking
Putting it all together
Summary
Chapter 10: TOCAB Storage Engine — Implementing Indexes
B-tree library
Storage engine API for indexes
Describing the engine
Creating, opening, and closing the table
Searching in the index
Rows and keys
Table scan and random access
Inserting rows
What's left
Compiling and linking
Putting it all together
Possible extensions
Summary

Book Details

ISBN 139781849510608
Paperback288 pages
Read More

Read More Reviews

Recommended for You

AJAX and PHP: Building Responsive Web Applications Book Cover
AJAX and PHP: Building Responsive Web Applications
$ 20.99
$ 14.70
Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.50
Responsive Web Design by Example : Beginner's Guide Book Cover
Responsive Web Design by Example : Beginner's Guide
$ 26.99
$ 18.90
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
GLSL Essentials Book Cover
GLSL Essentials
$ 20.99
$ 14.70
MySQL Management and Administration with Navicat Book Cover
MySQL Management and Administration with Navicat
$ 17.99
$ 12.60