Failover-HA-Setup

[Eugene Grosbein]

On Wed, Jan 17, 2007 at 03:10:29PM +0100, Richard wrote:

> > Try '/usr/local/etc/rc.d/mysql-server forcestart'

> Hm, that's only a temporary solution.
> 
> As a background:
> 
> Heartbeat monitors the HA nodes via a UDP ping (or other method) and if
> one of the nodes goes down, it takes over a clustered IP and then starts
> services by issuing the corresponding scripts in [/usr/local|]/etc/rc.d
> with the argument start...
> 
> So your solution will not really work....

Just put another script into /usr/local/etc/rc.d that would
run /usr/local/etc/rc.d/mysql-server forcestart
if and only if a flag is present in your system.
Create the flag when system boots and before /usr/local/etc/rc.d/mysql-server
starts with rcorder. Remove the flag just after 
/usr/local/etc/rc.d/mysql-server has finished.

You can user crons '@reboot' feature to create a flag
and one more rc.d script that runs after mysql-server and removes flag.

Eugene Grosbein