Re: master master replication - hostname change - slaves fails
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 but this gave me a very similar error - I forget now as i reinstalled from scratch. i now get this error 080522 13:49:34 [ERROR] Slave: Error 'Table 'db' already exists' on query. Default database: 'mysql' which to me is odd as i have the following in my my.cnf binlog-ignore-db=mysql so i would have thought it would not try and replicate that db ? Although i did not need that in my previous configuration. Any thoughts ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
master master replication - hostname change - slaves fails
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.03' (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.03 -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.01 -rw-rw 1 mysql mysql 4 May 22 11:54 prdnagios01-relay-bin.02 -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? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: master master replication - hostname change - slaves fails
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.03' (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.03 -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.01 -rw-rw 1 mysql mysql 4 May 22 11:54 prdnagios01-relay-bin.02 -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? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: master master replication - hostname change - slaves fails
On Thu, May 22, 2008 at 9:20 AM, Tom Brown [EMAIL PROTECTED] 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.03' (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.03 -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.01 -rw-rw 1 mysql mysql 4 May 22 11:54 prdnagios01-relay-bin.02 -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/[EMAIL PROTECTED]
Re: master master replication - hostname change - slaves fails
On Thu, May 22, 2008 at 10:00 AM, Tom Brown [EMAIL PROTECTED] wrote: 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 but this gave me a very similar error - I forget now as i reinstalled from scratch. Don't jump the gun to reinstall so fast, your last spot was easier to fix. i now get this error 080522 13:49:34 [ERROR] Slave: Error 'Table 'db' already exists' on query. Default database: 'mysql' which to me is odd as i have the following in my my.cnf binlog-ignore-db=mysql so i would have thought it would not try and replicate that db ? Although i did not need that in my previous configuration. Any thoughts ? Well if your master ever fails and you make the slave your new mater you will be missing your mysql database. User mostly will be missing, which might not be a big thing in your situation. Are there any other logs before and after? Mike