GoogleCodeExporter
commented
9 years ago hosts
[root@mysql3 ~]# more /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.230.103 mysql1 --master
192.168.230.104 mysql2 --master
192.168.230.105 mysql3 --monitor
192.168.230.106 mysql4 --salve
My mha profile.
[root@mysql3 ~]# vi /etc/masterha/app1.cnf
[server default]
manager_workdir=/etc/masterha/app1
manager_log=/etc/masterha/app1/manager.log
user=mha_mon
password='123456'
ssh_user=root
repl_user=repl
repl_password='slavei
ping_interval=1
shutdown_script=""
master_ip_online_change_script=""
report_script=""
#master_ip_failover_script="/usr/local/bin/master_ip_failover"
[server1]
hostname=192.168.230.103
master_binlog_dir=/mydata/data/binlog/
#candidate_master=1
[server2]
hostname=192.168.230.104
master_binlog_dir=/mydata/data/binlog/
candidate_master=1
#[server3]
#hostname=192.168.230.105
#master_binlog_dir=/mydata/data/binlog/
[server4]
hostname=192.168.230.106
no_master=1
I test the new user "mha_mon" connect to "192.168.230.104" on the manger
node"mysql3",it works fine.Here "mysql2" is "192.168.230.104"
[root@mysql3 masterha]# mysql -u mha_mon -h mysql2 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34
Server version: 5.6.14-log MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select current_user();
+-------------------------+
| current_user() |
+-------------------------+
| mha_mon@192.168.230.105 |
+-------------------------+
1 row in set (0.00 sec)Original comment by flutters...@sina.com on 8 Oct 2013 at 7:02
Original issue reported on code.google.com by
flutters...@sina.comon 8 Oct 2013 at 6:58