MySQL MHA部署笔记

一。环境

操作系统:Redhat 6.3

MySQL:MySQL 5.5

MHA:mha4mysql-manager-0.55,mha4mysql-node-0.54

二。安装

MHA Node:

$ yum install perl-DBD-MySQL
$ rpm -ivh mha4mysql-node-X.Y-0.noarch.rpm

MHA Manager:

  $ perl -MCPAN -e "install Config::Tiny"
 $ perl -MCPAN -e "install Log::Dispatch"
 $ perl -MCPAN -e "install Parallel::ForkManager"
 $ tar
-zxf mha4mysql-manager-X.Y.tar.gz
 $ perl
Makefile.PL
 $ make
 $ sudo make install

三。Running MHA Manager from daemontools

Currently MHA Manager process does not run as a daemon. If failover completed successfully or the master process was killed by accident, the manager stops working. To run as a daemon, daemontool. or any external daemon program can be used. Here is an example to run from daemontools.

1. Install daemontools

ForRedHat

1.下载daemontools

wget ftp://ftp.pbone.net/mirror/ftp5.gwdg.de/pub/opensuse/repositories/utilities/RHEL_6/x86_64/daemontools-doc-0.76-2.2.x86_64.rpm

2. Create run file under /service/masterha(app_name)/run

manager_host# mkdir /service/masterha_app1

注:第一级目录必须是/service,不能使用其它名字,试着把/service改成/mha等,尝试多很多次都未果,现在还没有找到原因,有可能是daemontools默认约定;

  第二级目录根据实际情况重命名

  第三级文件的名字必须是run

 manager_host# cat /service/masterha_test1/run

#!/bin/sh

 exec masterha_manager --global_conf=/etc/mha/masterha_default.cnf --conf=/etc/mha/masterha_test1/conf/app.conf --wait_on_monitor_error=60 --wait_on_failover_error=60 >> /var/log/masterha/test1/app.log 2>&1

开启snc服务

manager_host# /usr/bin/svscanboot

注:如果不开启此服务,启动如下命令会报错“找不到文件”之类的。

manager_host# chmod 755 /service/masterha_test1/run

You can stop/restart monitoring by daemontool commands.
## stopping monitoring
 manager_host
# svc -d /service/masterha_test1

## starting monitoring

 manager_host# svc -u /service/masterha_test1

## 启动后将会看到supervise进程

 manager_host# ps -efwww|grep supervise

root     21528  1206  0 15:25 ?        00:00:00 supervise masterha_test1


 manager_host# ps -efwww|grep manager

root     21529 21528  0 15:25 ?        00:00:05 perl /usr/local/bin/masterha_manager --global_conf=/etc/mha/masterha_default.cnf --conf=/etc/mha/masterha_test1/conf/app.conf --wait_on_monitor_error=60 --wait_on_failover_error=60



参考:

https://code.google.com/p/mysql-master-ha/wiki/Installation

http://cr.yp.to/daemontools.html



本文出自 “MySQL一点一滴” 博客,请务必保留此出处http://iamadba.blog.51cto.com/1034125/1375826

MySQL MHA部署笔记,布布扣,bubuko.com

MySQL MHA部署笔记

上一篇:MongoDB 学习笔记(一)—— 安装入门


下一篇:oracle 多行合并成一行