With great efforts finally I was able to setup Mysql replication (both on windows) from one host to other as simple one way asynchrounous master-slave replication. Now purpose of this replication is just to have upto date backup, and we can switch to slave server at the time of crash.
- How do I monitor slave status, can it email me if it could not contact host, or more number of failures occur.
- How to make sure replication is in sync and we are not loosing any data.
If there is any automated solution then great, otherwise if I have to write some tool by myself, I am still open to the idea.