]]>
]]>

Custom Plugins for MySQL

You are here

Percona's developers are expert in creating MySQL extensions and plugins, such as UDFs. The MySQL server has a rich plugin mechanism that permits native-speed C and C++ plugins to be loaded without modifying the server itself. We can create high-quality, lightning-fast extensions that make your application's work more efficient and more convenient for developers. Examples include:

  • Create a new MySQL user-defined function (UDF), such as a custom string-replacement function.
  • Create a new INFORMATION_SCHEMA table.
  • Create a MySQL daemon plugin that runs a special-purpose thread inside the server.
  • Create a plugin that changes the full-text search parser, or pre-processes content before the full-text search parser indexes it.
  • Create, modify, or extend a pluggable storage engine that uses the MySQL storage engine API. (We wrote the initial version of the SphinxSE pluggable storage engine for Sphinx, for example.)

Why create a UDF or plugin instead of coding it as a stored procedure or in the application? In a word, speed! A MySQL UDF or plugin that is written in C can be much faster and more memory-efficient than stored routines, triggers, or stored procedures, and orders of magnitude more efficient than retrieving the data from MySQL and processing it in the application. It is often a good idea to prototype in a stored routine or stored procedure to define the requirements, and then replace it with a custom user-defined function written in C. Here is one success story of replacing a stored function with a custom UDF from Percona.

Costs will vary for each engagement, depending on its scope and complexity. To request a price quote, please contact us.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK Toll Free)
0-800-181-0665 (GER Toll Free)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>