We have a situation where I am using an external webserver authenticating to a database locally, and it works fine. The issue I am working on is that we have a Multi-WAN setup on our firewall with automatic failover. In the .htaccess file is there a way to configure multiple AuthMySQLHost directives so that if one fails, it will try the other?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have a situation where I am using an external webserver authenticating to a database locally, and it works fine. The issue I am working on is that we have a Multi-WAN setup on our firewall with automatic failover. In the .htaccess file is there a way to configure multiple AuthMySQLHost directives so that if one fails, it will try the other?
http://forge.mysql.com/wiki/MySQL_Proxy
maybe the mysql proxy can help you. i don't have any experience with it but it sounds like it can solve your problem.
Sorry, mod_auth_mysql isn't set up to handle multiple servers.
As Christian indicated (thanks, Christian!), the mysql proxy might help. But I have no experience with it, either.
Sorry.
Thanks for the info, I will check into the mysql proxy