MHA基础知识

Node工具包(自动调用 无需手动执行):

save_binary_logs 保存和复制master的二进制日志

apply_diff_relay_logs 识别差异的中继日志事件并将其差异的事件应用于其他的slave

purge_relay_logs 清除中继日志（不会阻塞SQL线程 )

点击(此处)折叠或打开

1. ####################BEGIN#########
2. [server default]
3. manager_log=/tmp/app1.log
4. manager_workdir=/tmp
5. master_binlog_dir=/opt/mysql
6. user=mha
7. password=taomee
8. ping_interval=2
9. repl_password=taomee
10. repl_user=repl
11. ssh_user=root
12. master_ip_failover_script=/usr/bin/masterha_ip_failover
13. [server1]
14. hostname=10.1.99.216
15. port=3306
16. [server2]
17. hostname=10.1.99.215
18. port=3306
19. [server3]
20. hostname=10.1.99.214
21. port=3306
22. #######################END##########

点击(此处)折叠或打开

1. #!/usr/bin/env perl
   
2. 
   
3. # Copyright (C) 2011 DeNA Co.,Ltd.
   
4. #
   
5. # This program is free software; you can redistribute it and/or modify
   
6. # it under the terms of the GNU General Public License as published by
   
7. # the Free Software Foundation; either version 2 of the License, or
   
8. # (at your option) any later version.
   
9. #
   
10. # This program is distributed in the hope that it will be useful,
    
11. # but WITHOUT ANY WARRANTY; without even the implied warranty of
    
12. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    
13. # GNU General Public License for more details.
    
14. #
    
15. # You should have received a copy of the GNU General Public License
    
16. # along with this program; if not, write to the Free Software
    
17. # Foundation, Inc.,
    
18. # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
    
19. 
    
20. ## Note: This is a sample script and is not complete. Modify the script based on your environment.
    
21. 
    
22. use strict;
    
23. use warnings FATAL => 'all';
    
24. 
    
25. use Getopt::Long;
    
26. 
    
27. my (
    
28. $command, $ssh_user, $orig_master_host, $orig_master_ip,
    
29. $orig_master_port, $new_master_host, $new_master_ip, $new_master_port
    
30. );
    
31. 
    
32. my $vip = '10.1.99.233/24';
    
33. my $key = '0';
    
34. my $ssh_start_vip = "/sbin/ifconfig eth0:$key $vip";
    
35. my $ssh_stop_vip = "/sbin/ifconfig eth0:$key down";
    
36. my $ssh_Bcast_arp = "/usr/bin/arping -c 3 -A 10.1.99.233"; #ARP回复模式，更新邻居。要是不加则服务器会自动等到vip缓存失效，期间VIP会有一定时间的不可用。
    
37. 
    
38. GetOptions(
    
39. 'command=s' => \$command,
    
40. 'ssh_user=s' => \$ssh_user,
    
41. 'orig_master_host=s' => \$orig_master_host,
    
42. 'orig_master_ip=s' => \$orig_master_ip,
    
43. 'orig_master_port=i' => \$orig_master_port,
    
44. 'new_master_host=s' => \$new_master_host,
    
45. 'new_master_ip=s' => \$new_master_ip,
    
46. 'new_master_port=i' => \$new_master_port,
    
47. );
    
48. 
    
49. exit &main();
    
50. 
    
51. sub main {
    
52. 
    
53. print "\n\nIN SCRIPT TEST====$ssh_stop_vip==$ssh_start_vip===\n\n";
    
54. 
    
55. if ( $command eq "stop" || $command eq "stopssh" ) {
    
56. 
    
57. my $exit_code = 1;
    
58. eval {
    
59. print "Disabling the VIP on old master: $orig_master_host \n";
    
60. &stop_vip();
    
61. $exit_code = 0;
    
62. };
    
63. if ($@) {
    
64. warn "Got Error: $@\n";
    
65. exit $exit_code;
    
66. }
    
67. exit $exit_code;
    
68. }
    
69. elsif ( $command eq "start" ) {
    
70. 
    
71. my $exit_code = 10;
    
72. eval {
    
73. print "Enabling the VIP - $vip on the new master - $new_master_host \n";
    
74. &start_vip();
    
75. # &start_arp();
    
76. $exit_code = 0;
    
77. };
    
78. if ($@) {
    
79. warn $@;
    
80. exit $exit_code;
    
81. }
    
82. exit $exit_code;
    
83. }
    
84. elsif ( $command eq "status" ) {
    
85. print "Checking the Status of the script.. OK \n";
    
86. exit 0;
    
87. }
    
88. 
    
89. else {
    
90. &usage();
    
91. exit 1;
    
92. }
    
93. }
    
94. 
    
95. sub start_vip() {
    
96. `ssh $ssh_user\@$new_master_host \" $ssh_start_vip \"`;
    
97. }
    
98. sub start_arp() {
    
99. `ssh $ssh_user\@$new_master_host \" $ssh_Bcast_arp \"`;
    
100. }
     
101. sub stop_vip() {
     
102. `ssh $ssh_user\@$orig_master_host \" $ssh_stop_vip \"`;
     
103. }
     
104. 
     
105. sub usage {
     
106. print
     
107. "Usage: master_ip_failover --command=start|stop|stopssh|status --orig_master_host=host --orig_master_ip=ip --orig_master_port=port --new_master_host=host --new_master_ip=ip --new_master_port=port\n
108. }

参考：MySQL MHA 搭建&测试