I'm having some trouble using replication when the machines are configured to use host names instead of IP addresses. The "skip-name-resolve" is OFF.
If I use IP addresses, everything is fine. Using DNS names, it all stops.
On the Master
Replication is configured with the following command:
GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'slavename.internal.domain' IDENTIFIED BY 'repl_pwd';
On the Slave
The slave connection is configured as such:
change master to master_host='mastername', master_user='repluser', master_password='repl_pwd', master_log_file='mastername.000001', master_log_pos=1;
The Error I am Getting
When starting the replication slave, the log file shows the following messages:
120127 14:07:48 [Note] Slave SQL thread initialized, starting replication in log 'mastername.000001' at position 4, relay log './mysql-relay-bin.000001' position: 4 120127 14:07:48 [ERROR] Slave I/O: error connecting to master 'repluser@mastername:3306' - retry-time: 60 retries: 86400, Error_code: 1130
If I then try to connect using the command line from the client machine using:
mysql -h mastername -u repluser -prepl_pwd
I get the error:
ERROR 1130 (HY000): Host 'the.ip.address.here' is not allowed to connect to this MySQL server
I really hope someone out there can help me with my domain resolution issues!!!