tinygg / mysql-mha-setup

mysql-master-ha scripts
0 stars 0 forks source link

replication status check having error #87

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. slave not directly connect with master
2. we have ssh tunnel to access the master
3. at slave side we are running this command to connect with master
ssh  -C -f -L 10000:localhost:3306 root@192.168.1.73 -N
4. 192.168.1.73 is master and 192.168.1.72 is slave
5. slave side running this command
 change master to master_host='127.0.0.1',master_port=10000,master_user='slave',master_password='maven@12',master_log_file='mysql-bin.000003', Relay_Log_Pos=10017;

What is the expected output? What do you see instead?

Thu May  8 05:13:48 2014 - [info] MHA::MasterMonitor version 0.52.
Thu May  8 05:13:50 2014 - 
[error][/usr/lib64/perl5/vendor_perl/MHA/ServerManager.pm, ln621] Master 
127.0.0.1:10000 from which slave test2.maven.com(192.168.1.72:3306) replicates 
is not defined in the configuration file!
Thu May  8 05:13:50 2014 - 
[error][/usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm, ln315] Error happend 
on checking configurations.  at 
/usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm line 232.
Thu May  8 05:13:50 2014 - 
[error][/usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm, ln396] Error 
happened on monitoring servers.

What version of the product are you using? On what operating system?

version 0.52
Please provide any additional information below.

how to mention the slave side configuration on master-ha confige file

Original issue reported on code.google.com by niraj.v...@gmail.com on 8 May 2014 at 12:17

GoogleCodeExporter commented 8 years ago
Did you ever figure out a workaround for this? I'm fighting with the same 
problem.

Original comment by michael....@gatewaystaff.com on 30 Jul 2014 at 9:45

GoogleCodeExporter commented 8 years ago
Instead of ssh tunnel  I have used the normal connection with replication 
server and it solved the problem.
Instead of this 

master_host='127.0.0.1',master_port=10000,master_user='slave',master_password='m
aven@12',master_log_file='mysql-bin.000003', Relay_Log_Pos=10017;

I used this one (means remove ssh tunnel) and
master_host='192.168.1.2',master_port=3306,master_user='slave',master_password='
maven@12',master_log_file='mysql-bin.000003', Relay_Log_Pos=10017;

this  will solve the issue

Original comment by niraj.v...@gmail.com on 31 Jul 2014 at 4:35

GoogleCodeExporter commented 8 years ago
Yeah, that's my plan too, but with SSL on the replication connection so I get 
the same security I had with the SSH tunnel.

Thanks!

Original comment by michael....@gatewaystaff.com on 31 Jul 2014 at 2:28