graceful-master-takeover is not OK

146 views
Skip to first unread message

xiao...@gmail.com

unread,
Aug 10, 2019, 11:55:25 PM8/10/19
to orchestrator-mysql
Hi,

    Three mysql node, one master,two slave。Three orchestrator raft mode, I try 'orchestrator-client  -c graceful-master-takeover -i mysql-a -d mysql-b', mysql-b  becomes master, mysql-c slave success,but mysql-a start slave report error!!!

Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1593
                Last_IO_Error: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated.



Retry change master to ***   
start slave;  is OK.  

Why????  Thanks..

Shlomi Noach

unread,
Aug 11, 2019, 2:42:25 AM8/11/19
to xiao...@gmail.com, orchestrator-mysql
orchestrator does not know what the replication credentials are.


On MySQL 5.6 and above, and if using master_info_repository = 'TABLE', let orchestrator have access to the mysql.slave_master_info table. This will allow orchestrator to grab replication credentials if need be.

GRANT SELECT ON mysql.slave_master_info TO 'orchestrator'@'orch_host';


--
You received this message because you are subscribed to the Google Groups "orchestrator-mysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orchestrator-my...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orchestrator-mysql/d08058fa-c446-4214-bbcd-9ba44f67b66e%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages