MySQL supports a plugin API that enables creation of server
components. Plugins can be loaded at server startup, or loaded and
unloaded at runtime without restarting the server. The components
supported by this interface include, but are not limited to,
full-text parser plugins, partitioning support, and server
MySQL distributions include several plugins that implement server extensions:
Plugins for authenticating attempts by clients to connect to MySQL Server. Plugins are available for several authentication protocols. See Section 6.3.8, “Pluggable Authentication”.
A password-validation plugin for implementing password strength policies and assessing the strength of potential passwords. See Section 6.4.2, “The Password Validation Plugin”.
Semisynchronous replication plugins implement an interface to replication capabilities that permit the master to proceed as long as at least one slave has responded to each transaction. See Section 17.3.8, “Semisynchronous Replication”.
A query rewrite plugin that examines statements received by MySQL Server and possibly rewrites them before the server executes them. See Section 188.8.131.52, “The Rewriter Query Rewrite Plugin”
Version Tokens is a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. Version Tokens is based on a plugin library that implements a
version_tokensplugin and a set of user-defined functions. See Section 184.108.40.206, “Version Tokens”.
A keyring plugin that provides secure storage for sensitive information. See Section 6.4.3, “The MySQL Keyring”.
The following sections describe how to install and uninstall plugins, and how to determine at runtime which plugins are installed and obtain information about them. For information about writing plugins, see Section 25.2, “The MySQL Plugin API”.