Could not perform failover testing with "mysqlrpladmin"
I just created the MySQL replication, and checked the data could be sync to slave with out problem, however when I try to make failover switch with below command I get some error message
# mysqlrpladmin --slaves=root:some-pass@ET-POC-RH01:3306,root:some-pass@ET-POC-RH02:3306 --candidates=root:some-pass@ET-POC-RH01:3306 --rpl-user=replicate:some-pass --demote-master failover --verbose --log=log.txt
Error:
WARNING: Using a password on the command line interface can be insecure.
# Checking privileges.
# Checking privileges on candidates.
# Performing failover.
# Checking eligibility of slave ET-POC-RH01:3306 for candidate.
# GTID_MODE=ON ... Ok
# Replication user exists ... FAIL
# Candidate ET-POC-RH01:3306 does not meet the requirements.
WARNING: None of the candidates was the best slave.
# Checking eligibility of slave ET-POC-RH01:3306 for candidate.
# GTID_MODE=ON ... Ok
# Replication user exists ... FAIL
# Checking eligibility of slave ET-POC-RH02:3306 for candidate.
# GTID_MODE=ON ... Ok
# Replication user exists ... Ok
# Candidate slave ET-POC-RH02:3306 will become the new master.
# Checking slaves status (before failover).
# ERROR: Server 'ET-POC-RH01@3306' is not acting as a slave.
ERROR: Server 'ET-POC-RH01@3306' is not acting as a slave. Note: To ignore this issue use the utility with the --force option.
Any idea about this error?
Thanks in advance.
Subject
Views
Written By
Posted
Could not perform failover testing with "mysqlrpladmin"
723
February 26, 2018 03:19AM
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.