HI All,

I've got a MYSQL DATABASE ,I wish to create backup of the database into another machine(secondary) ,and also to link the equipment with original database(primary) Can there be in whatever way when primary database fails it select from the secondary database.

EDIT:How's this possible in window OS

its known as as clustering, check

http://www.mysql.com/products/cluster/