hi,

how can we make slave to master and re-direct writes from master to slave, if master went down.

please help with this issue.

thanks in advance.

thanks
regards
raju

These are not accurate steps.

You have to create a custom script that can monitor master (a simple use your_db) and if master server is down for more than 60-180 seconds then.
1. Stop slave
2. Comment out read_only in my.cnf and restart Mysql.
3. Point all your webservers to slave IP.

hi,

thank you very much alex. could u tell me where can i find the script so that i can redirect all the writes from master to slave when it went down