Username 'test' after graceful-master-takeover

[Samuel Kervella]

I get an error when I trigger a master takeover.

I have two percona-server with orchestrator on it. (Master/slave)

Here is the topology :

root@debianPercona1:~# orchestrator-client -c topology -a debianPercona1
debianPercona1:3306 [0s,ok,5.7.31-34-log,rw,ROW,>>,GTID]

• debianPercona2:3306 [0s,ok,5.7.31-34-log,rw,ROW,>>,GTID]

Here is what I have when I query slave_master_info table:
(On the master)
mysql> select User_name,User_password from slave_master_info;
x - - - - - - - - - - -   +- - - - - - - - - - - - - - -   +
|....User_name...|....User_password....|
+- - - - - - - - - - -    +- - - - - - - - - - - - - - -   +
|........test............|.................................|
+- - - - - - - - - - -    +- - - - - - - - - - - - - - -   +

(On the slave)
mysql> select User_name,User_password from mysql.slave_master_info;
x - - - - - - - - - - -   +- - - - - - - - - - - - - - -   +
|...User_name....|....User_password....|
+- - - - - - - - - - -    +- - - - - - - - - - - - - - -   +
|...repl_user........|.............root..............|
+- - - - - - - - - - -    +- - - - - - - - - - - - - - -   + 

The test user on the master is unexpected and when i want to make a graceful-master-takeover (debianPercona1 > debianPercona2)
debianPercona1 can't connect to the new master :

Last_IO_Error: error connecting to master 'test@debianPercona2:3306' - retry-time: 60 retries: 1

Is it possible to change the credentials in any config file ? So that when the master falls he retrieve the credentials of the slave ?

Percona config file on the master :

[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql explicit_defaults_for_timestamp server-id = 1 log-bin = mysql-bin binlog_format = row gtid-mode=ON enforce-gtid-consistency log-slave-updates session_track_gtids=ALL_GTIDS log-error = /var/log/mysql/error.log binlog-ignore-db = orchestrator binlog-ignore-db = mysql sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES master_info_repository=TABLE symbolic-links=0

Percona config file on the slave :

[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql explicit_defaults_for_timestamp server-id = 2 log-bin = mysql-bin relay-log = relay-log-server read-only = OFF gtid-mode=ON enforce-gtid-consistency log-slave-updates session_track_gtids=ALL_GTIDS log-error = /var/log/mysql/error.log replicate-ignore-db = orchestrator replicate-ignore-db = mysql binlog-ignore-db = orchestrator binlog-ignore-db = mysql sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES master_info_repository=TABLE symbolic-links=0

Thanks in advance for your assistance.