E-book details

MySQL 5.1 Plugin Development. Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins

MySQL 5.1 Plugin Development. Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins

Sergei Golubchik, Andrew Hutchings, Andrew Hutchings, Sergii Golubchyk

Ebook
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.
  • MySQL 5.1 Plugin Development
    • Table of Contents
    • MySQL 5.1 Plugin Development
    • Credits
    • About the Authors
    • About the Reviewer
    • Preface
      • History of the Plugin API
      • Idea of this book
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Errata
        • Piracy
        • Questions
    • 1. Compiling and Using MySQL Plugins
      • UDF libraries
        • Linux
        • Mac OS X
        • Windows
        • Installing a UDF
      • Plugin libraries
        • Linux
        • Mac OS X
        • Windows
        • Installing a plugin
      • Automatic builds, packaging
        • UDFs and standalone plugins
        • Plugins that are built from the MySQL source tree
          • plug.in
          • Makefile.am
          • CMakeLists.txt
      • Summary
    • 2. User Defined Functions
      • Writing UDFs
        • Why write UDFs
        • Installing and using UDFs
        • Defining UDFs
        • Execution sequence of a UDF
        • UDF error handling
        • UDF security
        • Gotchas with UDFs
      • A constant integer output UDF
      • An integer echoing UDF
      • A simple static text output UDF
      • A summing aggregate UDF
      • Further reading
      • Summary
    • 3. Daemon Plugins
      • A look inside a Daemon plugin
        • Why write a Daemon plugin
        • Installing and using Daemon plugins
        • The role of a version
        • Defining Daemon plugins
          • Status variables
          • System variables
      • A Hello World! Daemon plugin
      • A system and status variables demo plugin
      • A simple monitoring plugin
      • System Status Variables plugin
      • Summary
    • 4. Information Schema Plugins
      • Why write Information Schema plugins
        • Installing and using Information Schema plugins
      • The creation of Information Schema plugins
        • Defining Information Schema plugins
      • A Static Table example
      • A System Information plugin
      • Summary
    • 5. Advanced Information Schema Plugins
      • Accessing MySQL internals
      • Condition pushdown
        • Using condition pushdown
        • A condition pushdown example
      • A User Variables Information Schema plugin
      • A Binary Logs Information Schema plugin
      • Summary
    • 6. Full-text Parser Plugins
      • The full-text parser plugin architecture
        • Three roles of a full-text parser plugin
        • Installing and using a full-text parser plugin
        • Structure of a full-text parser plugin
      • A PHP full-text parser
      • Summary
    • 7. Practical Full-text Parsers
      • Boolean parsers
      • A Boolean full-text parser
      • An Image Metadata processor
        • How to access Exif data
        • Writing the plugin
        • Test run
      • A Soundex full-text parser
        • The Soundex algorithm
        • The plugin
        • Trying it out
      • Summary
    • 8. Storage Engine Plugins
      • Introducing storage engines
      • A read-only storage engine
        • ha_text.cc
      • Summary
    • 9. HTML Storage EngineReads and Writes
      • An idea of the HTML engine
      • Flashback
      • Creating, opening, and closing the table
      • Reading data
      • Updating the table
      • Optimizing and analyzing
      • Whats left
        • ha_html.h
        • htmlutils.cc
      • Compiling and linking
      • Putting it all together
      • Summary
    • 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
    • A. Beyond MySQL 5.1
      • Server services
        • my_snprintf
        • thd_alloc
      • Audit plugins
      • Authentication plugins
        • How it works
        • Authentication pluginsserver side
        • Authentication pluginsclient side
      • SQL extension by Storage Engine plugins
        • Putting it to use
        • Test drive
      • Summary
    • Index
  • Title: MySQL 5.1 Plugin Development. Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins
  • Author: Sergei Golubchik, Andrew Hutchings, Andrew Hutchings, Sergii Golubchyk
  • Original title: MySQL 5.1 Plugin Development. Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins
  • ISBN: 9781849510615, 9781849510615
  • Date of issue: 2010-08-26
  • Format: Ebook
  • Item ID: e_3ce1
  • Publisher: Packt Publishing