1

I am moving a MySQL slave from one set of HDs to another. The configuration of the machine denies me the ability to have both old and new hard drives on it at the same time. So I rsync'ed the data directory to another machine.

Whe the new hard drives came online, I rsyn'ed the data dir back. This worked fine.

However, I cannot start replication. This is the error I get.

120314  4:23:07 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem.
120314  4:23:07 [ERROR] Failed to open the relay log '/var/lib/mysqllogs/mysqld-relay-bin.000273' (relay_log_pos 677043943)
120314  4:23:07 [ERROR] Could not find target log during relay log initialization
120314  4:23:07 [ERROR] Failed to initialize the master info structure

I found this comment: https://serverfault.com/questions/61471/moving-a-mysql-slave-to-a-new-host-failed-to-open-the-relay-log

If it is just complaining about the relay logs, in most cases, they are disposable if the master still has the binary logs around. You can just run CHANGE MASTER TO on the slave and it will flush the existing relay logs and start anew. You don't need to make a new fresh copy.

This seems to suggest that I do not need these log files.

The host name is not changing.

My Questions:

Do I need these log files?

If not, what do I need to do to get replication started? Will it remember where it left off?

If I do need these log files, is there anything else I'm forgetting?

Community
  • 1
  • 1
Chris Stewart
  • 11
  • 3

1 Answers1

4

I don't think you need the relay bin loge files to get it to work. It might remember where it left off, did you try the command mysql>RESET SLAVE; ? You should get the position from the SLAVE by SHOW SLAVE STATUS; to see if still rememvers, then check to see if the logfile on the master server still exists, because it only keeps it for as long as you set the max file size. But try RESET SLAVE; if you haven't it does magic. You are probably going to have to start the whole process over by dumping the existing server data right after you lock the tables and do "SHOW MASTER STATUS" I wouldn't recommend trying to save this process if you have the option to start replication from scratch.

Neo
  • 11,078
  • 2
  • 68
  • 79