Skip navigation links

MySQL Forums :: Replication :: Can't start slave using master replication coordinates


Advanced Search

Re: Can't start slave using master replication coordinates
Posted by: Philipp Kropp ()
Date: April 26, 2012 04:10AM

Hi,

what information you have in your master?
mysql> SHOW MASTER STATUS;

Maybe it is not set to the very first log?
Did you use following command?
mysql> RESET MASTER;

Normally that should result in something like this:
+------------------+----------+----------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+----------------+------------------+
| mysql-bin.000001 | 106 | replication-db | |
+------------------+----------+----------------+------------------+
1 row in set (0.00 sec)


How do you set the Slave?
Is it already running, when you reset the master?
mysql> SHOW SLAVE STATUS\G
mysql> RESET SLAVE;

Normally it should look like this:
mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.100', MASTER_USER='replication-user', MASTER_PASSWORD='secret', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=106;

Did you copy the data from master database with stopped slave?
There is also a command for preventing slave start atfer mysql restart called "skip_slave_start". That command is only useful for initializing the Slave I think.

Options: ReplyQuote


Subject Views Written By Posted
Can't start slave using master replication coordinates 1009 Eric Coll 04/25/2012 04:13PM
Re: Can't start slave using master replication coordinates 657 Philipp Kropp 04/26/2012 04:10AM
Re: Can't start slave using master replication coordinates 748 Eric Coll 04/27/2012 10:42AM
Re: Can't start slave using master replication coordinates 452 Rick James 04/28/2012 02:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.