Professional Web Applications Themes

tion Questions -Sync? Update? - MySQL

Recently an error in the db on my master caused the slave to fail. I noticed this after a few days when I looked at the status and it said "Slave_SQL_Running: No". After looking further I saw what the error was on the master. What is the best method of re-synching the databases? Is there a command to force a re-tion or synch of the dbs? Would you delete the slave's db and update over? In this case, is there a command to pull the data down from the master? I have verified that during this time data was not ...

  1. #1

    Default tion Questions -Sync? Update?

    Recently an error in the db on my master caused the slave to fail. I
    noticed this after a few days when I looked at the status and it said
    "Slave_SQL_Running: No". After looking further I saw what the error was
    on the master.

    What is the best method of re-synching the databases?

    Is there a command to force a re-tion or synch of the dbs? Would
    you delete the slave's db and update over? In this case, is there a
    command to pull the data down from the master?

    I have verified that during this time data was not sent over to the slave.
    George Guest

  2. #2

    Default Re: tion Questions -Sync? Update?

    George A. wrote: 

    if the master's binary logs have been intact since the failure, you can
    run this command on your slave machine

    start slave;

    and have it start to catch up. this will start both the i/o and sql
    threads on the slave server by reading from where it left off in the
    binary logs of the master.



    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  3. #3

    Default Re: tion Questions -Sync? Update?

    lark wrote: 
    >
    > if the master's binary logs have been intact since the failure, you can
    > run this command on your slave machine
    >
    > start slave;
    >
    > and have it start to catch up. this will start both the i/o and sql
    > threads on the slave server by reading from where it left off in the
    > binary logs of the master.
    >
    >
    >[/ref]

    Thank you, I did not know that it would automatically catch up. I see
    now that the data has been synced to between both servers.
    George Guest

Similar Threads

  1. Re-sync out of sync live streams
    By BenderB in forum Macromedia Flash Flashcom
    Replies: 4
    Last Post: February 19th, 02:45 AM
  2. questions about applying 3.5 JDBC update
    By carehart in forum Coldfusion Server Administration
    Replies: 2
    Last Post: August 8th, 05:57 PM
  3. Forced tion in File tion Services
    By James in forum Windows Server
    Replies: 0
    Last Post: July 16th, 03:45 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139