Results 1 to 3 of 3

Thread: replication

  1. #1
    Join Date
    Jun 2009
    Posts
    10

    Unanswered: replication

    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
    Last edited by sarajusa; 07-06-09 at 18:11.

  2. #2
    Join Date
    Jan 2009
    Location
    NYC
    Posts
    11
    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.

  3. #3
    Join Date
    Jun 2009
    Posts
    10

    replication

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •