Mysql Simple Problem Summary (continuous update)

Master-Slave architecture related issues

Problem phenomenon: Slave connection host times error  [ERROR] Slave I/o: Error connecting to master ' [email protected]:3306 '-retry-time:60  retries:1, Error_code:2003  Possible reasons are: A, network does not pass (open firewall) b, copy user's password is not C, the specified Master_port port is not D, master mysql-bin.xxxxxx was mistakenly deleted E, The main library is full of disk space

Problem symptom: [[email protected] app1]# masterha_check_ssh--conf=/data/masterha/app1/app1.cnfcan ' t locate mha/sshcheck.pm in @ INC (@INC contains:/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/perl5/vendor_perl/usr/share/perl5/ Vendor_perl/usr/lib64/perl5/usr/share/perl5.) At/usr/bin/masterha_check_ssh line 25.BEGIN failed--compilation aborted At/usr/bin/masterha_check_ssh line 25. [[Email protected] app1]# problem location: Should be the problem of environment variables [[email protected] app1]# Find/-name sshcheck.pm/usr/lib/perl5/vendor_perl/ MHA/SSHCHECK.PM Add related paths to Perl5libexport perl5lib= $PERL 5lib:/usr/lib/perl5/vendor_perl/

Mysql Simple Problem Summary (continuous update)