[LUNI] Failover script?

[Richard Reina]

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