Bug #88527 Flush method for counter of max_connect_errors (Like MySQL Server's max_connect_
Submitted: 17 Nov 2017 0:53 Modified: 16 Mar 2018 5:18
Reporter: Yoshiaki Yamasaki Email Updates:
Status: Verified Impact on me:
Category:MySQL Router Severity:S4 (Feature request)
Version:2.1 OS:Any
Assigned to: CPU Architecture:Any

[17 Nov 2017 0:53] Yoshiaki Yamasaki
I want to flush method for counter of max_connect_errors.

MySQL Server's max_connect_errors has following flush methods.

 - FLUSH HOSTS statement
 - mysqladmin flush-hosts command

 * https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_connect_er...

However, I can't flush MySQL Router's max_connect_errors, except MySQL Router restart. It is inconvenient.

How to repeat:

Suggested fix:
Adding flush method for counter of max_connect_errors
[16 Mar 2018 5:18] MySQL Verification Team
Hello Yamasaki-San,

Thank you for the report and feature request!