MySQL Forums
Forum List  »  Replication

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
Re: Can't start slave using master replication coordinates
835
April 26, 2012 04:10AM


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.