MYSQL connection_control plugin installation

MYSQL connection_control plugin installation on windows

INSTALL PLUGIN CONNECTION_CONTROL SONAME 'connection_control.dll';

INSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS SONAME 'connection_control.dll';

Replace .dll with .so for non windows

SHOW VARIABLES LIKE '%connection_control_%'

These are the variables to consider to check according to your server requirements

connection_control_min_connection_delay
connection_control_failed_connections_threshold
connection_control_max_connection_delay

You can change the values by using the SET command as below

SET global connection_control_min_connection_delay = 100000