[LUNI] Failover script?

[Richard Reina]

Steve,

Thanks again for the response.  I looked into heartbeat and I am still considering it.  However, I am at least a little reluctant to have to configure, and maintain yet another piece of software on my network. 

As a result I am still also considering writing a script that test the database of a DBI->mysql comnnection call and redirects traffic to a replica in the event of unavailablity.

Does anyone have any experience or insight on such a method?



Steve Pribyl <linux at unliketea.com> wrote: > 2) Write perl script that switches the IP address of one of the slaves to
> that of the original master in event of the masters failure.  This seems
> like it will be easier but I am not sure of the hardware implications
> namely if my switch will get confused.

I just did this using heartbeat.  Works very well.  Not I did not use the
mysql module as that defeats the replication part, only migrated the ip
address.

Steve
> I have a couple database replica slaves that backup a master that serves
> as a DB server to about 1/2 a dozen local clients. I am trying to decide
> what the most orderly way to handle a failover strategy.  The two options
> I am considering are:
>
> 1) Replace all perl->DBI calls  where the local IP address is hardcoded in
> the APIs code so that it accesses some central module that can designate
> one of the slaves as the master in case of the original master's failure.
> This would be somewhat of a hassle.
>
> 2) Write perl script that switches the IP address of one of the slaves to
> that of the original master in event of the masters failure.  This seems
> like it will be easier but I am not sure of the hardware implications
> namely if my switch will get confused.
>
> I was wondering if anyone on he list might have experience with such
> scenarios as to recommend a course of action.
>
> Thanks in advance for any ideas.
>
> Richard
>
>
>
>
>
>
> Your beliefs become your thoughts.  Your thoughts become your words.  Your
> words become your actions.  Your actions become your habits.  Your habits
> become your values.  Your values become your destiny.  -- Mahatma Gandhi
> --
> Linux Users Of Northern Illinois - Technical Discussion
> http://luni.org/mailman/listinfo/luni
>
>

-- 
Linux Users Of Northern Illinois - Technical Discussion 
http://luni.org/mailman/listinfo/luni



Your beliefs become your thoughts.  Your thoughts become your words.  Your words become your actions.  Your actions become your habits.  Your habits become your values.  Your values become your destiny.  -- Mahatma Gandhi