首页 / MYSQL / mysql mha高可用性安装配置

mysql mha高可用性安装配置

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql mha高可用性安装配置，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含9322字，纯文字阅读大概需要14分钟。

内容图文

Home
Advantages
Architecture
CommercialSupport
Configuration
Downloads
FAQ
GTID_Based_Failover
HowMHAWorks
Installation
masterha_check_repl
masterha_check_status
masterha_conf_host
masterha_manager
masterha_master_switch
Show 15 more pages…

Clone this wiki locally

Installation
- Downloading MHA Node and MHA Manager
- Installing MHA Node
- Installing MHA Manager

Installation

MHA consists of MHA Manager and MHA Node packages. MHA Manager runs on a manager server, and MHA Node runs on each MySQL server. MHA Node programs do not run always, but are invoked from MHA manager programs when needed (at configuration check, failover, etc). Both MHA Manager and MHA Node are written in Perl.

Downloading MHA Node and MHA Manager

MHA Node and MHA Manager can be downloaded from "Downloads" section. These are stable packages.

If you want to try development source trees, check out GitHub source trees. MHA Manager is hosted here, and MHA Node is hosted here.

Installing MHA Node

MHA Node has scripts and dependent perl modules that do the following.

save_binary_logs: Saving and copying dead master‘s binary logs
apply_diff_relay_logs: Identifying differential relay log events and applying all necessary log events
purge_relay_logs: Purging relay log files

You need to install MHA Node to all MySQL servers (both master and slave). You also need to install MHA Node on a management server because MHA Manager modules internally depend on MHA Node modules. MHA Manager internally connects to managed MySQL servers via SSH and executes MHA Node scripts. MHA Node does not depend on any external Perl modules except DBD::mysql so you should be able to install easily.

On RHEL/CentOS distribution, you can install MHA Node rpm package as below.

## If you have not installed DBD::mysql, install it like below, or install from source.
# yum install perl-DBD-MySQL

## Get MHA Node rpm package from "Downloads" section.
# rpm -ivh mha4mysql-node-X.Y-0.noarch.rpm

On Ubuntu/Debian distribution, you can install MHA Node deb package as below.

## If you have not installed DBD::mysql, install it like below, or install from source.
# apt-get install libdbd-mysql-perl

## Get MHA Node deb package from "Downloads" section.
# dpkg -i mha4mysql-node_X.Y_all.deb

You can also install MHA Node from source.

## Install DBD::mysql if not installed
$ tar -zxf mha4mysql-node-X.Y.tar.gz
$ perl Makefile.PL
$ make
$ sudo make install

Installing MHA Manager

MHA Manager has administrative command line programs such as masterha_manager, masterha_master_switch, etc, and dependent Perl modules. MHA Manager depends on the following Perl modules. You need to install them before installing MHA Manager. Do not forget to install MHA Node.

MHA Node package
DBD::mysql
Config::Tiny
Log::Dispatch
Parallel::ForkManager
Time::HiRes (included from Perl v5.7.3)

On RHEL/CentOS distribution, you can install MHA Manager rpm package as below.

## Install dependent Perl modules
# yum install perl-DBD-MySQL
# yum install perl-Config-Tiny
# yum install perl-Log-Dispatch
# yum install perl-Parallel-ForkManager

## Install MHA Node, since MHA Manager uses some modules provided by MHA Node.
# rpm -ivh mha4mysql-node-X.Y-0.noarch.rpm

## Finally you can install MHA Manager
# rpm -ivh mha4mysql-manager-X.Y-0.noarch.rpm

On Ubuntu/Debian distribution, you can install MHA Manager deb package as below.

## Install dependent Perl modules
# apt-get install libdbd-mysql-perl
# apt-get install libconfig-tiny-perl
# apt-get install liblog-dispatch-perl
# apt-get install libparallel-forkmanager-perl

## Install MHA Node, since MHA Manager uses some modules provided by MHA Node.
# dpkg -i mha4mysql-node_X.Y_all.deb

## Finally you can install MHA Manager
# dpkg -i mha4mysql-manager_X.Y_all.deb

You can also install MHA Manager from source.

## Install dependent Perl modules
# MHA Node (See above)
# Config::Tiny
## perl -MCPAN -e "install Config::Tiny"
# Log::Dispatch
## perl -MCPAN -e "install Log::Dispatch"
# Parallel::ForkManager 
## perl -MCPAN -e "install Parallel::ForkManager"
## Installing MHA Manager
$ tar -zxf mha4mysql-manager-X.Y.tar.gz
$ perl Makefile.PL
$ make
$ sudo make install

Configuration

bmildren edited this page on 27 Jan 2016 · 1 revision

Pages 30

Home
Advantages
Architecture
CommercialSupport
Configuration
Downloads
FAQ
GTID_Based_Failover
HowMHAWorks
Installation
masterha_check_repl
masterha_check_status
masterha_conf_host
masterha_manager
masterha_master_switch
Show 15 more pages…

Clone this wiki locally

Writing an application configuration file
Writing a global configuration file
Binlog server

Writing an application configuration file

To make MHA work, you have to create a configuration file and set parameters. Parameters include hostname of each MySQL server, MySQL username and password, working directory name, etc. The whole parameters are described at Parameters page.

The below is an example configuration file.

manager_host$ cat /etc/app1.cnf

[server default]
# mysql user and password
user=root
password=mysqlpass
# working directory on the manager
manager_workdir=/var/log/masterha/app1
# manager log file
manager_log=/var/log/masterha/app1/app1.log
# working directory on MySQL servers
remote_workdir=/var/log/masterha/app1

[server1]
hostname=host1

[server2]
hostname=host2

[server3]
hostname=host3

All parameters must follow "param=value" syntax. For example, the below parameter setting is incorrect.

[server1]
hostname=host1
# incorrect: must be "no_master=1"
no_master

Application-scope parameters should be written in [server default] block. In [serverN] blocks, you should set local-scope parameters. hostname is mandatory local-scope parameter so has to be written here. Block name should start from "server". Internally server configurations are sorted by block name, and sorted order matters when MHA decides new master (See FAQ for details).

Writing a global configuration file

If you plan to manage two or more MySQL applications ((master, slaves) pairs) from a single manager server, creating a global configuration file makes it much easier to configure. Once you write parameters in the global configuration file, you do not need to set parameters for each application. If you create a file at /etc/masterha_default.cnf, MHA Manager scripts automatically reads the file as a global configuration file.

You can set application scope parameters in the global configuration file. For example, if MySQL administrative user and password are identical on all MySQL servers, you can set "user" and "password" here.

Global Configuration Example:

Global configuration file (/etc/masterha_default.cnf)

[server default]
user=root
password=rootpass
ssh_user=root
master_binlog_dir= /var/lib/mysql
remote_workdir=/data/log/masterha
secondary_check_script= masterha_secondary_check -s remote_host1 -s remote_host2
ping_interval=3
master_ip_failover_script=/script/masterha/master_ip_failover
shutdown_script= /script/masterha/power_manager
report_script= /script/masterha/send_master_failover_mail

These parameters are applied to all applications monitored by MHA Manager running on the host.

Application configuration file should be written separately. The below example is configuraing app1 (host1-4) and app2 (host11-14).

app1:

manager_host$ cat /etc/app1.cnf

[server default]
manager_workdir=/var/log/masterha/app1
manager_log=/var/log/masterha/app1/app1.log

[server1]
hostname=host1
candidate_master=1

[server2]
hostname=host2
candidate_master=1

[server3]
hostname=host3

[server4]
hostname=host4
no_master=1

In the above case, MHA Manager generates working files (including status files) under /var/log/masterha/app1, and generates log file at /var/log/masterha/app1/app1.log. You need to set unique directory/file names when monitoring other applications.

app2:

manager_host$ cat /etc/app2.cnf

[server default]
manager_workdir=/var/log/masterha/app2
manager_log=/var/log/masterha/app2/app2.log

[server1]
hostname=host11
candidate_master=1

[server2]
hostname=host12
candidate_master=1

[server3]
hostname=host13

[server4]
hostname=host14
no_master=1

If you set same parameters on both global configuration file and application configuration file, the latter (application configuration) is used.

Binlog server

Starting from MHA version 0.56, MHA supports new section [binlogN]. In binlog section, you can define mysqlbinlog streaming servers. When MHA does GTID based failover, MHA checks binlog servers, and if binlog servers are ahead of other slaves, MHA applies differential binlog events to the new master before recovery. When MHA does non-GTID based (traditional) failover, MHA ignores binlog servers.

Below is an example configuration.

manager_host$ cat /etc/app1.cnf

[server default]
# mysql user and password
user=root
password=mysqlpass
# working directory on the manager
manager_workdir=/var/log/masterha/app1
# manager log file
manager_log=/var/log/masterha/app1/app1.log
# working directory on MySQL servers
remote_workdir=/var/log/masterha/app1

[server1]
hostname=host1

[server2]
hostname=host2

[server3]
hostname=host3

[binlog1]
hostname=binlog_host1

[binlog2]
hostname=binlog_host2

转自： https://github.com/yoshinorim/mha4mysql-manager/wiki

mysql mha高可用性安装配置

标签：mysql mha

本文系统来源：http://132408.blog.51cto.com/122408/1896843

内容总结

以上是互联网集市为您收集整理的mysql mha高可用性安装配置全部内容，希望文章能够帮你解决mysql mha高可用性安装配置所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/474746.html

来源：【匿名】

【上一篇】mysql查询当天所有数据sql语句【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【mysql mha高可用性安装配置】教程文章相关的互联网学习教程文章

在阿里云服务器中安装配置mysql数据库完整教程【图】

阿里云ECS服务器CentOS7上安装MySql服务 (可选)1.确保服务器系统处于最新状态 [root@localhost ~]# yum -y update如果显示以下内容说明已经更新完成 Replaced:grub2.x86_64 1:2.02-0.64.el7.centos grub2-tools.x86_64 1:2.02-0.64.el7.centos Complete!（可选）2.重启服务器 [root@localhost ~]# reboot3.首先检查是否已经安装，如果已经安装先删除以前版本，以免安装不成功[root@localhost ~]# php -v或[root@localhost ~]# r...

MySQL-5.6.13解压版（zip版）安装配置教程

来源：http://www.splaybow.com/post/mysql-5-6-13-zip-install.html[下载MySQL 5.6.13]从MySQL官方网站mysql.com找到MySQL Community Server 5.6.13的下载地址为http://dev.mysql.com/downloads/mysql/，在这里可以选择操作系统平台。洪哥选择的是Microsoft Windows平台。下面有三个可选的下载文件，第一个是MySQL Installer 5.6 for Windows，这将下载下来一个.msi可执行安装文件。另外有两个解压版（Zip版）分别是Windows (...

mysql-5.7.11-winx64.zip 安装配置【代码】

1、下载http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip2.解压缩zip包；D:\Program Files\mysql-5.7.11-winx64 3.配置环境变量，3.1 添加path路径，D:\Program Files\mysql-5.7.11-winx64\bin 3.2.修改mysql-default.ini配置文件，原# These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = .....改为# These are commonly set, re...

mysql-5.7.17-winx64的安装配置【图】

第一步：下载mysql-5.7.17-winx64解压版本：http://dev.mysql.com/downloads/mysql/第二步：解压到安装目录，如：C:\myprogram\mysql-5.7.17-winx64第三步：设置环境变量操作如下： 1）右键单击我的电脑->属性->高级系统设置(高级)->环境变量点击系统变量下的新建按钮输入变量名：MYSQL_HOME 输入变量值：C:\myprogram\mysql-5.7.17-winx64 2）选择系统变量中的Path 点击编辑按钮在变量值中添...

Centos 7.2 安装配置 Nginx、PHP7、Mysql、JDK、Tomcat、Redis、【代码】

Centos 7.2 安装配置 Nginx、PHP7、Mysql、JDK、Tomcat、Redis、RAP 以下操作均在阿里云 ECS（Centos 7.2）环境下执行，其他系统环境可能会有些许差别，仅供参考软件更新由于系统驱动的兼容性等问题，当前云服务器 ECS Linux 不支持内核升级操作（更多相关说明，可以参阅 ECS 使用须知）。一般拿到一台新的服务器，我喜欢先进行软件升级。阿里云ECS不建议升级服务器的内核和操作系统版本，所以，在进行系统软件更新操作时，应该将其...

Mac Yosemite安装配置nginx+php+mysql+memcached环境【代码】【图】

一个命令全搞定sudo port install php55 php55-fpm php55-curl php55-exif php55-gd php55-gettext php55-iconv php55-mbstring php55-mcrypt php55-mysql php55-memcache php55-odbc php55-opcache php55-openssl php55-oracle php55-postgresql php55-sockets php55-sqlite php55-xmlrpc php55-zip memcached nginx mysql55然后就是去配置点东西了...配置php进入配置目录 /opt/local/etc/php55sudo cp ./php-fpm.conf.default ./...

MySQL Linux环境的安装配置【代码】【图】

在Kali中已经内置了MySQL（镜像可以从mysql.com/downloads/ 下载安装）奇怪的是博主我的kali内置的是mariaDB数据库，所以我也懒得弄MySQL了！直接mariaDB吧！差不多【PS:据博主所致，mariaDB的操作和MySQL一样哦！在这后面有一段故事有兴趣的可以去了解哦】启动服务：（如果你是mysql的话！所有mariadb换成mysql即可，特殊地方会说明的）service mariadb start服务启动后，输入：mariadb -u root -p即可进入数据库，遇到 Enter pas...

YUM CentOS 7 64位下mysql5.7安装配置【代码】【图】

配置YUM源在MySQL官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/#下载mysql源安装包# wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm# 安装mysql源# yum localinstall mysql57-community-release-el7-8.noarch.rpm 检查mysql源是否安装成功# yum repolist enabled | grep "mysql.*-community.*"看到下图表示安装成功安装MySQL# yum install mysql-community-server 启动MySQ...

CentOS 6.5 下安装配置MySQL数据库【代码】【图】

一、mysql简介说到数据库，我们大多想到的是关系型数据库，比如mysql、oracle、sqlserver等等，这些数据库软件在windows上安装都非常的方便，在Linux上如果要安装数据库，咱不得不首先推荐的是mysql数据库了，而且Mysql数据库的第一个版本就是发行在Linux系统上的。MySQL是一个关系型数据库管理系统，由瑞典MySQL AB公司开发，目前属于Oracle公司。MySQL是一种关联数据库管理系统，关联数据库将数据保存在不同的表中，而不是将所有...

linux小白 mysql5.0源码安装配置

安装mysql-5.0.45.tar.gz(该软件包下载地址：http://www.filewatcher.com/m/mysql-5.0.45.tar.gz.24433261-0.html)# groupadd mysql #添加mysql组# useradd -g mysql mysql #添加mysql用户，且加入mysql组--------------------编译过程----------------------------------# tar zxvf mysql-5.0.45.tar.gz #解压后在当前目录下ls下，会出现mysql-5.0.45目录# cd mysql-5.0.45 ...

CentOS 6.2 yum安装配置lnmp服务器(Nginx+PHP+MySQL)【图】

准备篇：1、配置防火墙，开启80端口、3306端口 vi /etc/sysconfig/iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT（允许80端口通过防火墙） -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT（允许3306端口通过防火墙）特别提示：很多网友把这两条规则添加到防火墙配置的最后一行，导致防火墙启动失败，正确的应该是添加到默认的22端口这条规则的下面添加...

Linux下MySQL安装配置 MySQL配置参数详解

一、下载编译安装#cd /usr/local/src/ #wget http://mysql.byungsoo.net/Downloads/MySQL-5.1/mysql-5.1.38.tar.gz #tar –xzvf mysql-5.1.38.tar.gz ../software/ #./configure --prefix=/usr/local/mysql //MySQL安装目录 --datadir=/mydata //数据库存放目录 --with-charset=utf8 //使用UTF8格式 --with-extra-charsets=complex //安装所有的扩展字符集 --enable-thread-safe-client //启用客户端安全线程 --with-big-tables //...

MySQL免安装配置步骤【代码】【图】

此方式为直接解压压缩包安装MySQL1.下载相关压缩包官网下载地址：https://dev.mysql.com/downloads/mysql/下载后将压缩包解压至自己想要的文件路径即可2.新建my.ini文件在解压后的的根目录下新建一个my.ini文件编辑文件内容为：[mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\MySQL # 设置mysql数据库的数据的存放目录 datadir=D:\MySQLData # 允许最大连接数 max_connections=200 # 允许连接失败的次数。这...

windows 2003 iis+php5+mysql+phpmyadmin 详细安装配置

windows 2003 iis+php5+mysql+phpmyadmin 详细安装步骤支持asp .net php mysql gmail一、安装iis这就不要说了要注意的就是安装是注意选上asp.net 二、接下来就是安装php了；找个地方下个php5 的源码包比如 http://www.phpchina.com/manual/php/php-5.2.0-Win32.zip 下好以后解压到c:\php\ 目录下（php 目录自己建的哦） 1、先把那两个注册文件导进去 2、然后把扩展名为才.dll的文件复制到c:\WINDOWS\...

python操作mysql③python操作mysql的orm工具sqlaichemy安装配置和使用【代码】

python操作mysql③python操作mysql的orm工具sqlaichemy安装配置和使用手册地址： http://docs.sqlalchemy.org/en/rel_1_1/orm/index.html安装 D:\software\source_tar>pip install SQLALchemy检测是否安装成功 D:\software\source_tar>python Python 3.5.2 (v3.5.2:4def2a2901a5, Jun 25 2016, 22:18:55) [MSC v.1900 64 bit (AMD64)] on win32 Type "help", "copyright", "credits"or"license"for more information. >>> import s...

MYSQL - 技术教程分类

MySQL 教程 MySQL 安装 MySQL 管理 MySQL PHP 语法 MySQL 连接 MySQL 创建数据库 MySQL 删除数据库 MySQL 选择数据库 MySQL 数据类型 MySQL 创建数据表 MySQL 删除数据表 MySQL 插入数据 MySQL 查询数据 MySQL WHERE 子句 MySQL UPDATE 更新 MySQL DELETE 语句 MySQL LIKE 子句 MySQL UNION MySQL 排序 MySQL 分组 MySQL 连接的使用 MySQL NULL 值处理 MySQL 事务 MySQL ALTER命令 MySQL 索引 MySQL 临时表 MySQL 复制表 MySQL 元数据 MySQL 序列使用 MySQL 处理重复数据 MySQL 及 SQL 注入 MySQL 导出数据 MySQL 导入数据 MySQL 函数 MySQL 运算符 mysql 全部

MYSQL - 最热教程

sql分组取最大记录方法 mysql如何设置默认值 mysql创建数据表时指定默认值教程 MySQL 5.7 的初始化操作（root初始密码...Oracle中合并数据集(多行变一行)mysql 相同内容的字段合并为一条的方法解决mysql设置时区时的错误Unknown or ...解决ubuntu下mysql的'Access denied fo...ubuntu系统中MysqlERROR1045(28000)报错...mysql数据库设置不区分大小写

首页 / MYSQL / mysql mha高可用性安装配置

mysql mha高可用性安装配置

内容导读

内容图文

Clone this wiki locally

Installation

Downloading MHA Node and MHA Manager

Installing MHA Node

Installing MHA Manager

Configuration

Pages 30

Clone this wiki locally

Writing an application configuration file

Writing a global configuration file

Global Configuration Example:

Binlog server

内容总结

内容备注

内容手机端

【mysql mha高可用性安装配置】教程文章相关的互联网学习教程文章

MYSQL - 相关标签

安装 - 相关标签

配置 - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程