I'm trying to setup a
mysql replication over an SSH tunnel. The odd thing about this setup is that I have one master with
mysql 5.0.60sp1-enterprise-gpl-log and one slave with
mysql 5.0.67-community-log. Could it be so that it's not possible to replicate between community and enterprise edition?
As you can see in my
log below, it's possible to login on the remote server with the
mysql client. But the replication get "Can't connect to
MySQL server on '127.0.0.1' (13)"
Is it any
log file I have forgotten to look in, to get more info?
[root@mysql1-av ~]#
mysql -uroot -p
Enter password:
Welcome to the
MySQL monitor. Commands end with ; or \g.
Your
MySQL connection id is 73
Server version: 5.0.67-community-log
MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
The version of the slave
mysql
[root@mysql1-av ~]# autossh -f -M 20001 -L 3307:10.200.200.200:3306
[email protected] -N
[root@mysql1-av ~]#
mysql -h127.0.0.1 --port 3307 -uroot -p
Enter password:
Welcome to the
MySQL monitor. Commands end with ; or \g.
Your
MySQL connection id is 5189
Server version: 5.0.60sp1-enterprise-gpl-log
MySQL Enterprise Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> Aborted
Login to the master
mysql with the
mysql client over the ssh tunnel.
[root@mysql1-av ~]#
mysql -uroot -p
Enter password:
Welcome to the
MySQL monitor. Commands end with ; or \g.
Your
MySQL connection id is 75
Server version: 5.0.67-community-log
MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> change master to master_host='127.0.0.1', MASTER_PORT=3307, master_user='xxxx', master_password='xxxx', master_log_file='bin.000001';
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 127.0.0.1
Master_User: replNSG
Master_Port: 3307
Connect_Retry: 60
Master_Log_File: bin.000001
Read_Master_Log_Pos: 4
Relay_Log_File: relay.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: bin.000001
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)
Start the replication, but it breaks on IO.
[root@mysql1-av ~]# tail /var/log/mysqld.
log
120921 22:17:59 [Note] Slave I/O thread killed while connecting to master
120921 22:17:59 [Note] Slave I/O thread exiting, read up to
log 'bin.000001', position 4
120921 22:17:59 [Note] Error reading relay
log event: slave SQL thread was killed
120921 22:29:36 [Note] Slave SQL thread initialized, starting replication in
log 'bin.000001' at position 4, relay
log '/var/lib/mysql/relay.000001' position: 4
120921 22:29:36 [ERROR] Slave I/O thread: error connecting to master '
[email protected]:3307': Error: 'Can't connect to
MySQL server on '127.0.0.1' (13)' errno: 2003 retry-time: 60 retries: 86400
Because it can't connect to the master server.
