MySQL 5.1 Plugin Development and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading MySQL 5.1 Plugin Development on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL 5.1 Plugin Development [Paperback]

Andrew Hutchings , Sergei Golubchik
5.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 50.56
Price: CDN$ 49.64 & FREE Shipping. Details
You Save: CDN$ 0.92 (2%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 3 to 5 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition CDN $14.84  
Paperback CDN $49.64  

Book Description

Aug. 30 2010

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

  • A practical guide with working examples explained line by line
  • Add new functions to MySQL with User Defined Functions
  • Export information via SQL using the INFORMATION_SCHEMA plugins
  • Search within PDFs, MP3s, and images; offset user typing errors with fulltext parser plugins
  • Access your custom data formats with a storage engine plugin

In Detail

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.

A hands-on guide for MySQL application developers to creating feature-rich plug-ins

What you will learn from this book

  • 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

Approach

This book is written in a hands-on style that actively involves you while you read through its chapters. In every chapter you, along with the author, will be implementing one or more fully working example plugins. The process is accompanied with a detailed step-by-step explanation of the code, at the same time providing you with resources to create your own plugins.

Who this book is written for

If 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.


Customers Who Bought This Item Also Bought


Product Details


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
Format:Paperback
Highly recommended. If you want to develop MySQL extensions, buy this book. It's a must, written by two expert professionals who probably know more than anyone else on this matter. The book is full of practical examples explained with the theoretical information necessary to make it stick.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  2 reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent Aug. 5 2011
By Mark Callaghan - Published on Amazon.com
Format:Paperback
I read this book last year and was impressed. It is written by experts so there is a lot of valuable information. But they also took the time, a huge amount of time, to write this so that it is easy to read. I don't know the editor but will thank him/her as well. [...]
2 of 3 people found the following review helpful
5.0 out of 5 stars Great reference with plenty of practical examples Nov. 3 2010
By Giuseppe Maxia - Published on Amazon.com
Format:Paperback
Highly recommended. If you want to develop MySQL extensions, buy this book. It's a must, written by two expert professionals who probably know more than anyone else on this matter. The book is full of practical examples explained with the theoretical information necessary to make it stick.
Search Customer Reviews
Only search this product's reviews
ARRAY(0xb2ca42f4)

Look for similar items by category


Feedback