MySQL Forums
Forum List  »  Replication

Could not perform failover testing with "mysqlrpladmin"
Posted by: Paul.LKW Leong
Date: February 26, 2018 03:19AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Could not perform failover testing with "mysqlrpladmin"
605
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.