We have the following setup: a host A is running several web
applications from different customers, each application/customer
(virtual host) having it's own different incoming IP. A host B is
running a MySQL instance, which is being used by the applications on A.
Note that every customer has a different incoming IP, but for outgoing
connections, every application is using the same source IP, the first
one of A.
Now one of the applications on A is randomly wreaking havoc, leading the
MySQL server to block ("Host 'A' is blocked because of many connection
errors; unblock with 'mysqladmin flush-hosts'"). Since all customers'
applications are using the same source IP, all of them are blocked at once.
So my question is: how can we tell libmysql to use a particular source
IP, so that we can configure each customer to use a different one (e.g.
his incoming IP)?
There are both PHP and Perl users, so it should preferably be a solution
that works for both.
|• How to configure libmysql to use a particular source IP?||Christian Jaeger||16 Dec|