mysql 4.x master/slave setup

[freaky]

I am considering doing a master/slave setup for redundancy reasons. Id like the slave to collect the updates and take over in case the master goes down. Is there any automated process that will do the 'taking over'? Or is the only way of doing that is by editing config.php and manually changing the server ip? And what happens when the master goes down, slave takes over and then the master comes back up? Wouldnt the master now need the updates that were made in the slaves? So does two way replication needs to be setup? How reliable is this setup and what are the chances of data corruption?

Thank you for any help. :)

[edivad82]

I am considering doing a master/slave setup for redundancy reasons. Id like the slave to collect the updates and take over in case the master goes down. Is there any automated process that will do the 'taking over'? Or is the only way of doing that is by editing config.php and manually changing the server ip? And what happens when the master goes down, slave takes over and then the master comes back up? Wouldnt the master now need the updates that were made in the slaves? So does two way replication needs to be setup? How reliable is this setup and what are the chances of data corruption?

Thank you for any help. :)
:D we have done a similar question :D

http://www.vbulletin.com/forum/showthread.php?t=119396

master slave server doesn't have any integrated failover manager...if the master goes down i don't have the certainty that the slave is up to date to the last query...only with the bin-log on master server i have the certainty...and the slave, if it become master needs to be manually configured

sorry for my bad bad english :p