[LUNI] Failover script?

[Steve Pribyl]

> 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
>
>