聊聊MySQL连接控制插件

复制# 动态安装 connection_control 插件  mysql> INSTALL PLUGIN CONNECTION_CONTROL SONAME connection_control.so;  Query OK,聊聊L连 0 rows affected (0.04 sec)  mysql> INSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS SONAME connection_control.so;  Query OK, 0 rows affected (0.01 sec)  # 验证插件状态  mysql> SELECT     -> PLUGIN_NAME,PLUGIN_STATUS       -> FROM     -> INFORMATION_SCHEMA.PLUGINS       -> WHERE     -> PLUGIN_NAME LIKEconnection%;  +------------------------------------------+---------------+ | PLUGIN_NAME                              | PLUGIN_STATUS |  +------------------------------------------+---------------+ | CONNECTION_CONTROL                       | ACTIVE        |  | CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | ACTIVE        |  +------------------------------------------+---------------+ # 安装完成后 可以看到相关系统变量  mysql> show variables likeconnection_control%;  +-------------------------------------------------+------------+ | Variable_name                                   | Value      |  +-------------------------------------------------+------------+ | connection_control_failed_connections_threshold | 3          |  | connection_control_max_connection_delay         | 2147483647 |  | connection_control_min_connection_delay         | 1000       |  +-------------------------------------------------+------------+ 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.