Re: master master replication - hostname change - slaves fails

[Mike <lunarblu@xxxxxxxxx>]

On Thu, May 22, 2008 at 9:20 AM, Tom Brown <tom@xxxxxxxx> wrote:

>
>  Hi
>>
>> I had master-master working fin in dev - i move them to prd now and so
>> change the hostnames, on starting i see this error
>>
>> 080522 11:53:40  mysqld started
>> 080522 11:53:40  InnoDB: Started; log sequence number 0 213274351
>> 080522 11:53:40 [ERROR] Failed to open the relay log
>> './devnagios01-relay-bin.000003' (relay_log_pos 949012)
>> 080522 11:53:40 [ERROR] Could not find target log during relay log
>> initialization
>> 080522 11:53:40 [ERROR] Failed to initialize the master info structure
>>
>> in mysql data directory i see this
>>
>> -rw-rw----  1 mysql mysql 949012 May 22 11:40 devnagios01-relay-bin.000003
>> -rw-rw----  1 mysql mysql     34 May 19 16:08 devnagios01-relay-bin.index
>> -rw-rw----  1 mysql mysql      4 May 22 11:53 prdnagios01-relay-bin.000001
>> -rw-rw----  1 mysql mysql      4 May 22 11:54 prdnagios01-relay-bin.000002
>> -rw-rw----  1 mysql mysql     68 May 22 11:54 prdnagios01-relay-bin.index
>>
>> is there a way to 'flush' this or simalar so i can start the slaves again?
>>
>>
> hmm actually on one of the db's i see this
>
> mysql> show slave status\G
> *************************** 1. row ***************************
>            Slave_IO_State:
>               Master_Host: 192.168.12.225
>
> thats the OLD dev IP and not the prd one - even though i have updated the
> master host IP in the my.cnf file. How can i change this value?
>

I don't think you need to flush your bin logs.

CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.



>
> thanks
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=lunarblu@xxxxxxxxx
>
>