4
The MySQL Protocol plugin allows MySQL compatible clients to connect to Drizzle.
4
:program:`mysql_protocol` implements the MySQL network protocol.
6
.. _mysql_protocol_loading:
11
This plugin is loaded by default, but it may need to be configured. See
12
the plugin's :ref:`mysql_protocol_configuration` and
13
:ref:`mysql_protocol_variables`.
15
To stop the plugin from loading by default, start :program:`drizzled`
18
--plugin-remove=mysql_protocol
20
.. seealso:: :doc:`/options` for more information about adding and removing plugins.
22
.. _mysql_protocol_configuration:
9
There are several server variables to control the MySQL Protocol.
27
These command line options configure the plugin when :program:`drizzled`
28
is started. See :doc:`/configuration` for more information about specifying
11
31
.. program:: drizzled
13
.. option:: --mysql-protocol.port arg (=3306)
15
The port number to use with MySQL connections (0 is the same as 3306)
17
.. option:: --mysql-protocol.connect-timeout arg (=10)
19
Connection timeout in seconds
21
.. option:: --mysql-protocol.read-timeout arg (=30)
23
Port read timeout in seconds
25
.. option:: --mysql-protocol.write-timeout arg (=60)
27
Port write timeout in seconds
29
.. option:: --mysql-protocol.retry-count arg (=10)
31
Retry count for the read and write timeout before killing the connection
33
.. option:: --mysql-protocol.buffer-length arg (=16384)
37
.. option:: --mysql-protocol.bind-address arg
41
.. option:: --mysql-protocol.max-connections arg (=1000)
43
Maximum simultaneous connections
45
.. option:: --mysql-protocol.admin-ip-addresses arg
47
A comma seprated list of IP addresses for admin tools to connect from
33
.. option:: --mysql-protocol.bind-address ARG
36
:Variable: :ref:`mysql_protocol_bind_address <mysql_protocol_bind_address>`
40
.. option:: --mysql-protocol.buffer-length ARG
43
:Variable: :ref:`mysql_protocol_buffer_length <mysql_protocol_buffer_length>`
47
.. option:: --mysql-protocol.connect-timeout ARG
50
:Variable: :ref:`mysql_protocol_connect_timeout <mysql_protocol_connect_timeout>`
54
.. option:: --mysql-protocol.max-connections ARG
57
:Variable: :ref:`mysql_protocol_max_connections <mysql_protocol_max_connections>`
59
Maximum simultaneous connections.
61
.. option:: --mysql-protocol.port ARG
64
:Variable: :ref:`mysql_protocol_port <mysql_protocol_port>`
66
Port number to use for connection or 0 for default to with MySQL
68
.. option:: --mysql-protocol.read-timeout ARG
71
:Variable: :ref:`mysql_protocol_read_timeout <mysql_protocol_read_timeout>`
75
.. option:: --mysql-protocol.retry-count ARG
78
:Variable: :ref:`mysql_protocol_retry_count <mysql_protocol_retry_count>`
82
.. option:: --mysql-protocol.write-timeout ARG
85
:Variable: :ref:`mysql_protocol_write_timeout <mysql_protocol_write_timeout>`
89
.. _mysql_protocol_variables:
94
These variables show the running configuration of the plugin.
95
See `variables` for more information about querying and setting variables.
97
.. _mysql_protocol_bind_address:
99
* ``mysql_protocol_bind_address``
103
:Option: :option:`--mysql-protocol.bind-address`
107
.. _mysql_protocol_buffer_length:
109
* ``mysql_protocol_buffer_length``
113
:Option: :option:`--mysql-protocol.buffer-length`
117
.. _mysql_protocol_connect_timeout:
119
* ``mysql_protocol_connect_timeout``
123
:Option: :option:`--mysql-protocol.connect-timeout`
127
.. _mysql_protocol_max_connections:
129
* ``mysql_protocol_max_connections``
133
:Option: :option:`--mysql-protocol.max-connections`
135
Maximum simultaneous connections.
137
.. _mysql_protocol_port:
139
* ``mysql_protocol_port``
143
:Option: :option:`--mysql-protocol.port`
145
Port number to use for connection or 0 for default to with MySQL
147
.. _mysql_protocol_read_timeout:
149
* ``mysql_protocol_read_timeout``
153
:Option: :option:`--mysql-protocol.read-timeout`
157
.. _mysql_protocol_retry_count:
159
* ``mysql_protocol_retry_count``
163
:Option: :option:`--mysql-protocol.retry-count`
167
.. _mysql_protocol_write_timeout:
169
* ``mysql_protocol_write_timeout``
173
:Option: :option:`--mysql-protocol.write-timeout`
177
.. _mysql_protocol_examples:
182
Sorry, there are no examples for this plugin.
184
.. _mysql_protocol_authors:
191
.. _mysql_protocol_version:
196
This documentation applies to **mysql_protocol 0.1**.
198
To see which version of the plugin a Drizzle server is running, execute:
200
.. code-block:: mysql
202
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='mysql_protocol'
209
* First Drizzle version.