Description:
Dear all,
i am testing mysqlrplsync introduced in 1.4.2 rc release.
I have 2 MySQL 5.6.17 GA servers as master->slave.
Master host IP: 192.168.1.77 (hostname: linuxsrv3)
Slave host IP: 192.168.1.88 (hostname: linuxsrv4)
And it is working without any problem.
Here is the portion from master's my.cnf:
# BINARY LOGGING #
server_id = 1
log_bin = /var/lib/mysql/data/mysql-bin
log_bin_index = /var/lib/mysql/data/mysql-bin
expire_logs_days = 14
sync_binlog = 1
binlog_format = row
gtid-mode = on
enforce-gtid-consistency = true
master-info-repository = TABLE
relay-log-info-repository = TABLE
slave-parallel-workers = 2
binlog-checksum = CRC32
master-verify-checksum = 1
slave-sql-verify-checksum = 1
binlog-rows-query-log_events = 1
log_slave_updates = 1
Here is from slave's my.cnf:
# BINARY LOGGING #
server_id = 2
report_host = 192.168.1.88
log_bin = /var/lib/mysql/data/mysql-bin
log_bin_index = /var/lib/mysql/data/mysql-bin
expire_logs_days = 14
sync_binlog = 1
binlog_format = row
relay_log = /var/lib/mysql/data/mysql-relay-bin
log_slave_updates = 1
read_only = 1
gtid-mode = on
enforce-gtid-consistency = true
master-info-repository = TABLE
relay-log-info-repository = TABLE
#slave-parallel-workers = 2
binlog-checksum = CRC32
master-verify-checksum = 1
slave-sql-verify-checksum = 1
binlog-rows-query-log_events = 1
In fact slave is connected to master:
mysql> show slave hosts\G
*************************** 1. row ***************************
Server_id: 2
Host: 192.168.1.88
Port: 3306
Master_id: 1
Slave_UUID: 5a70670a-d99e-11e3-8dea-080027304b04
1 row in set (0,00 sec)
When i use with following syntax it works well:
[root@linuxsrv3 ~]# mysqlrplsync --master=root:12345@localhost --slaves='remote':'$Slavepass45#'@192.168.1.88 -vvv
# Checking users permission to perform consistency check.
#
#
# GTID differences between Master and Slaves:
# - Slave '192.168.1.88@3306' is 9674 transactions behind Master.
# Missing GTIDs: 1f29cdda-d5ac-11e3-b42e-0800274da480:1-9674
#
# Checking data consistency.
.
.
#...done.
#
# SUMMARY: 1 data consistency issue found.
#
But with following syntax i have encountered an issue:
[root@linuxsrv3 ~]# mysqlrplsync --master=root:12345@localhost --discover-slaves-login='remote':'$Slavepass45#' -vvv
# Discovering slaves for master at localhost:3306
WARNING: There are slaves that had connection errors.
# Checking users permission to perform consistency check.
#
ERROR: No slaves found with GTID support and GTID_MODE=ON.
There is no valuable debug information here so, i decide to mistype password:
[root@linuxsrv3 ~]# mysqlrplsync --master=root:12345@localhost --discover-slaves-login='remote':'Slavepass45#' -vvv
# Discovering slaves for master at localhost:3306
Error connecting to a slave as remote@192.168.1.88: Cannot connect to the slave server.
Error Access denied for user 'remote'@'192.168.1.77' (using password: YES)
WARNING: There are slaves that had connection errors.
# Checking users permission to perform consistency check.
#
ERROR: No slaves found with GTID support and GTID_MODE=ON.
So going further there is a connection here:
"Error connecting to a slave as remote@192.168.1.88: Cannot connect to the slave server" -> it really unclear what kind of connection it is.
And again there is another connection as 'remote'@'192.168.1.77'.
How to repeat:
Setup manually master->slave replication with my.cnfs that i stated in desctiption section.
Then Try to use:
1.
mysqlrplsync --master=root:12345@localhost --discover-slaves-login='remote':'$Slavepass45#' -vvv
2.
mysqlrplsync --master=root:12345@localhost --discover-slaves-login='remote':'Slavepass45#' -vvv
Suggested fix:
No idea