10bet网址
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr)- 36.3Mb
PDF (A4)- 36.3Mb
Man Pages (TGZ)- 235.6Kb
Man Pages (Zip)- 347.2Kb
Info (Gzip)- 3.3Mb
Info (Zip)- 3.3Mb
Excerpts from this Manual

5.5 MySQL Server Plugins

MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The plugins supported by this interface include, but are not limited to, storage engines,INFORMATION_SCHEMAtables, full-text parser plugins, partitioning support, and server extensions.

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. SeeSection 6.2.13, “Pluggable Authentication”.

  • A connection-control plugin that enables administrators to introduce an increasing delay after a certain number of consecutive failed client connection attempts. SeeSection 6.4.2, “The Connection-Control Plugins”.

  • A password-validation plugin implements password strength policies and assesses the strength of potential passwords. SeeSection 6.4.3, “The Password Validation Plugin”.

  • Semisynchronous replication plugins implement an interface to replication capabilities that permit the source to proceed as long as at least one replica has responded to each transaction. SeeSection 16.3.9, “Semisynchronous Replication”.

  • Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and resolution, and group membership services all built-in. SeeChapter 17,Group Replication.

  • MySQL企业版包括一个thread pool plugin that manages connection threads to increase server performance by efficiently managing statement execution threads for large numbers of client connections. SeeSection 5.5.3, “MySQL Enterprise Thread Pool”.

  • MySQL Enterprise Edition includes an audit plugin for monitoring and logging of connection and query activity. SeeSection 6.4.5, “MySQL Enterprise Audit”.

  • MySQL Enterprise Edition includes a firewall plugin that implements an application-level firewall to enable database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. SeeSection 6.4.6, “MySQL Enterprise Firewall”.

  • A query rewrite plugin examines statements received by MySQL Server and possibly rewrites them before the server executes them. SeeSection 5.5.4, “The Rewriter Query Rewrite Plugin”.

  • Version Tokens 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 aversion_tokensplugin and a set of loadable functions. SeeSection 5.5.5, “Version Tokens”.

  • Keyring plugins provide secure storage for sensitive information. SeeSection 6.4.4, “The MySQL Keyring”.

  • X Plugin extends MySQL Server to be able to function as a document store. Running X Plugin enables MySQL Server to communicate with clients using the X Protocol, which is designed to expose the ACID compliant storage abilities of MySQL as a document store. SeeSection 19.4, “X Plugin”.

  • Test framework plugins test server services. For information about these plugins, see the Plugins for Testing Plugin Services section of the MySQL Server Doxygen documentation, available at//www.delbede.com/doc/index-other.html.

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, seeThe MySQL Plugin API.