MySQL Forums
Forum List  »  Replication

Persistent "Connecting to master" problem
Posted by: Nick Hill
Date: December 02, 2013 11:14AM

I'm trying to set up replication from a master server1 to a slave, server2.

So far I've:

1 - set up a "replication" user on server1, giving it Replication Slave permissions only.

2 - set up port forwarding on the router that server1 is connected to, forwarding traffic on port 3306 to server1.

3 - set serverIDs on both servers to unique values

4 - executed FLUSH TABLES WITH READ LOCK; on server1, and then got the current binary log filename & pos with SHOW MASTER STATUS;

5 - mysqldumped the contents of server1 to server2

6 - UNLOCK TABLES; on server1

7 - on server2, executed CHANGE MASTER TO MASTER_HOST='server1.domain.com', MASTER_USER='replication_user_name', MASTER_PASSWORD='replication_password', MASTER_LOG_FILE='recorded_log_file_name', MASTER_LOG_POS=recorded_log_position;

... substituting the relevant values from step 4.


However.... running SHOW SLAVE STATUS; on the slave I get, under Last_IO_Error:

error connecting to master 'repl@server1.domain.com:3306' - retry-time: 60 retries: 86400

Slave_IO_Running says "no". What have I missed?

Options: ReplyQuote


Subject
Views
Written By
Posted
Persistent "Connecting to master" problem
1725
December 02, 2013 11:14AM


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.