mySQL SLAVE replication setup
Posted on 2007-07-26
I have an existing mysql replication setup, currently with 1 master and 2 slaves, I am trying to add a 3rd slave.
I've taken a copy of the DB from the master, and copied to the new slave, and made a note of the master log positions.
I've not got to the stage of starting the new slave yet as I get the following error when I do:
change master to MASTER_LOG_FILE="localhost-bin.017", MASTER_LOG_POS=185656024
Error Code : 1201
Could not initialize master info structure; more error messages can be found in the MySQL error log
(1672 ms taken)
The log file says:
070727 08:21:02 mysqld ended
070727 08:21:20 mysqld started
070727 8:21:20 [Warning] 'user' entry 'firstname.lastname@example.org' ignored in --skip-name-resolve mode.
070727 8:21:20 [ERROR] Failed to open the relay log './localhost-relay-bin.000001' (relay_log_pos 4)
070727 8:21:20 [ERROR] Could not find target log during relay log initialization
070727 8:21:20 [ERROR] Failed to initialize the master info structure
/usr/sbin/mysqld: ready for connections.
Version: '4.1.22-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070727 8:27:34 [ERROR] Failed to open the relay log './localhost-relay-bin.000001' (relay_log_pos 4)
070727 8:27:34 [ERROR] Could not find target log during relay log initialization
Any suggestions would be awesome!