Professional Web Applications Themes

'stuck' slave? - MySQL

Hi, I have a mysql slave database, that, for various reasons, got quite out of date with its master. Friday, when I left, it was happily chugging along playing catch-up, or so it seemed. However, now it looks as if it's just decided to leave off work with this file: Relay_Master_Log_File: mammut-bin.024 (other slave information) Master_Log_File: mammut-bin.024 Read_Master_Log_Pos: 205353759 Relay_Log_File: bisonte-relay-bin.058 Relay_Log_Pos: 4 Relay_Master_Log_File: mammut-bin.024 Slave_IO_Running: Yes Slave_SQL_Running: Yes te_do_db: ............ te_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 205353759 the problem is that there are newer files on the server: mammut-bin.025 mammut-bin.026 I'm looking for a way to give it ...

  1. #1

    Default 'stuck' slave?

    Hi,

    I have a mysql slave database, that, for various reasons, got quite out
    of date with its master. Friday, when I left, it was happily chugging
    along playing catch-up, or so it seemed. However, now it looks as if
    it's just decided to leave off work with this file:

    Relay_Master_Log_File: mammut-bin.024

    (other slave information)
    Master_Log_File: mammut-bin.024
    Read_Master_Log_Pos: 205353759
    Relay_Log_File: bisonte-relay-bin.058
    Relay_Log_Pos: 4
    Relay_Master_Log_File: mammut-bin.024
    Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
    te_do_db: ............
    te_ignore_db:
    Last_errno: 0
    Last_error:
    Skip_counter: 0
    Exec_master_log_pos: 205353759

    the problem is that there are newer files on the server:

    mammut-bin.025
    mammut-bin.026

    I'm looking for a way to give it a kick and make it fully catch up the
    main server. How might I accomplish this?

    Thankyou,
    Dave Welton

    davidnwelton@gmail.com Guest

  2. #2

    Default Re: 'stuck' slave?

    It turns out it was stuck trying to authenticate - someone fiddled with
    the /etc/hosts file, and that caused the authentication to get weird,
    so it wasn't authenticating. Solving that fixed everything.

    davidnwelton@gmail.com Guest

Similar Threads

  1. Slave crash
    By Markus Wenke in forum MySQL
    Replies: 1
    Last Post: September 1st, 03:54 PM
  2. Traffic for Master/Slave
    By Marco Dieckhoff in forum MySQL
    Replies: 3
    Last Post: October 24th, 09:54 AM
  3. CFC Query - stuck, stuck, stuck
    By Howard Perlman in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 7th, 02:56 PM
  4. using slave flash units
    By Jeff MacVicar in forum Photography
    Replies: 1
    Last Post: July 20th, 01:05 PM
  5. Which flash slave to use?
    By Chris Wakeen in forum Photography
    Replies: 1
    Last Post: July 14th, 05:27 AM

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