We have a simple monitoring that opens a TCP connection on port 3306 of the mariadb server to check if the server is reachable. mariadb logs this with the following message:
[Warning] Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication)
after 100 of these connections, mariadb does not allow any further connections from the monitoring-host:
Host 'IP' is blocked because of many connection errors; unblock with 'mariadb-admin flush-hosts'
of course we could set max_error_connections much higher or flush hosts regularly - but that's not what we want
is there a way to allow a specific host to make unlimited connections? or how could we solve the problem?