Re: unixODBC failover

[Herbie <technowombat@yahoo.com>]

Well, I'm waiting to hear back from the apps maker exactly what it does 
when the server is unavailable. I know that the app itself does not handle 
a failover server.

The multiple CNAME entry, or DNS round-robin, is only going to be useful 
as a cheap load sharing device, rather than a failover, what I mean is, 
that dependent on how your server caches hostnames, it will either show 
Server A or Server B when queried, so the load will be applied between 
both servers.

What I'm looking for is a more logical

Unless Server A is down, use Server A
else use Server B

where Server A should handle the load under normal circumstance, with 
Server B only being used if Server A is unavailable.

This is the method used in pam_ldap and nss_ldap, and some other LDAP 
based apps, I guess I was just surprised it wasn't that simple under 
mySQL. So does anyone know some mySQL proxy software that will do this 
assuming the manufacturer tells me their app tries the server more than 
once?

h.

On Thu, 19 Dec 2013, Danny Sauer wrote:

> If it automatically retries at the app level then it could be as easy as a cname with multiple entries. If not, then I think you're sick using some kind of proxy in between; nothing I'm aware of at the mysql protocol level does the retry thing for you. Ideally the backend for the odbc layer can? :)
> --Danny
>
> Herbie <technowombat@yahoo.com> wrote:
>> I'm playing with an app that uses the unixODBC layer to communicate
>> with a
>> mySQL database. I'm trying to figure if there's an easy way I can make
>> it
>> failover to a backup database if the first one is unavailable. In an
>> ldap.conf it's as easy as adding an extra server on the host line.
>>
>> h.
>>
>> -
>> To unsubscribe, send email to majordomo@luci.org with
>> "unsubscribe luci-discuss" in the body.
>

-
To unsubscribe, send email to majordomo@luci.org with
"unsubscribe luci-discuss" in the body.