MySQL 5.1 Plugin Development : Extend MySQL to Suit Your Needs with This Unique Guide Into the World of MySQL Plugins
Saved in:
| Title: | MySQL 5.1 Plugin Development : Extend MySQL to Suit Your Needs with This Unique Guide Into the World of MySQL Plugins |
|---|---|
| Description: | Extend MySQL to suit your needs with this unique guide into the world of MySQL pluginsKey FeaturesA practical guide with working examples explained line by lineAdd new functions to MySQL with User Defined FunctionsExport information via SQL using the INFORMATION_SCHEMA pluginsSearch within PDFs, MP3s, and images; offset user typing errors with fulltext parser pluginsAccess your custom data formats with a storage engine pluginBook DescriptionMySQL 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.What you will learnBuild and install a plugin, and learn how to package it for distributing separately from MySQLAdd new functions to MySQL using the UDF interfaceDeclare new MySQL status and configuration variables from a plugin, and use Daemon plugins for a simple push style server monitoringAdd a new table to the INFORMATION_SCHEMA that shows anything you like with an INFORMATION_SCHEMA pluginUse 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 databaseStore and retrieve rows and convert your custom data format to what MySQL understands using the storage engine pluginCreate a parser that indexes comments from JPEG files using the libexif libraryUnderstand how the indexing API works, and how to work around the incompatibilities between your indexing engine and MySQL expectationsLearn about new features of the Plugin API, available beyond MySQL 5.1Who this book is forIf you are a MySQL application developer or a programmer who wants to interface with MySQL server, this book is for you. Basic knowledge of C/C++, SQL, and MySQL in particular is assumed in the book, but no deep familiarity with any of the topics is required. |
| Authors: | Andrew Hutchings, Sergei Golubchik |
| Resource Type: | eBook. |
| Subjects: | SQL (Computer program language), Plug-ins (Computer programs) |
| Categories: | COMPUTERS / Information Technology |
| Database: | eBook Collection (EBSCOhost) |
| Abstract: | Extend MySQL to suit your needs with this unique guide into the world of MySQL pluginsKey FeaturesA practical guide with working examples explained line by lineAdd new functions to MySQL with User Defined FunctionsExport information via SQL using the INFORMATION_SCHEMA pluginsSearch within PDFs, MP3s, and images; offset user typing errors with fulltext parser pluginsAccess your custom data formats with a storage engine pluginBook DescriptionMySQL 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.What you will learnBuild and install a plugin, and learn how to package it for distributing separately from MySQLAdd new functions to MySQL using the UDF interfaceDeclare new MySQL status and configuration variables from a plugin, and use Daemon plugins for a simple push style server monitoringAdd a new table to the INFORMATION_SCHEMA that shows anything you like with an INFORMATION_SCHEMA pluginUse 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 databaseStore and retrieve rows and convert your custom data format to what MySQL understands using the storage engine pluginCreate a parser that indexes comments from JPEG files using the libexif libraryUnderstand how the indexing API works, and how to work around the incompatibilities between your indexing engine and MySQL expectationsLearn about new features of the Plugin API, available beyond MySQL 5.1Who this book is forIf you are a MySQL application developer or a programmer who wants to interface with MySQL server, this book is for you. Basic knowledge of C/C++, SQL, and MySQL in particular is assumed in the book, but no deep familiarity with any of the topics is required. |
|---|---|
| ISBN: | 9781849510608 9781849510615 |
