Hi all, As explained in the archive, a connection on port 3306 via a standard 'open socket' and close again, creates connection errors, resulting in a blocked host.
However - since we replicate our servers, to ensure high availabity, we like to poll if the primary is up. We do this, because when a host is down (not the mysql server, but the entire machine), it takes quite a long time for the client (in this case PHP) to realise that the server is not available. Therefore we use an optimized version of the code provided by Michael Tanoviceanu in his phpbuilder article (http://www.phpbuilder.com/columns/tanoviceanu20000912.php3). We're now forced to set the max_connect_errors to a high number and flush the hosts now and then, so I'd like to propose the following options: --disable-host-check: for people filtering the traffic to mysql --ignore-hosts: build a 'trust' environment for the webservers or other known clients If these are already available, then it's not obvious to me, which they are. If the can be compiled in or the host check can be compiled out, I'd love to know how. Otherwise, I'd like to know if you (the developer and the user) find these useful and/or if these will be implemented. Met vriendelijke groeten / With kind regards, IDG.nl Melvyn Sopacua WebMaster --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
