Im currently running mysql 3.23.49 on 2 linux box 7.1, i successfully did replication via network, My question now is about fail save procedure. If the master when down for some reason....will it be possible for the slave to take over and step down once the master db is up again. Currently im using a php scripts to connect to my master and redirect connection once master when down, but i dont have any idea how to revert things back the normal way...please help...many thanks below is part of my php function that does the connection to master db
host------->master
host1------->slave

function connect()
{
if (!$this->linkID = @mysql_connect($this->$host,$this->user,$this->pass))
{
if (!$this->linkID = @mysql_connect($this->$host1,$this->user,$this->pass))

}
}