MySQL高可用集群架构尼古拉斯 - 行业资讯 - 肥雀云

MHAMaster HighAvailabilityMySQLDeNAyoushimatonFacebookMySQLMySQLMHA0 ~ 30尼古拉斯

尼古拉斯<强> <强> <强> <强>

尼古拉斯Managermaster-slaveslaveMHA NodeMySQLMHA Managermastermasterslavemasterslavemaster

5.5 MHAMHAsshMHAMySQL mhaslavemhaslave MySQL5.5MySQL

<强> <强> <强>

MySQLcrash

<强> <强> <强>

继电器logTCP/IP

MySQLMasterBinlogSlaveMaster/奴隶
, MySQL5.5masterSlavesalve

<强>

HAMHAMySQL ReplicationMasterSlaveSlaveMasterSlave

主(binlogevents)

奴隶

——(中继日志)奴隶

主(binlogevents)

-slavemaster -slavemaster

<强> <强>

部署环境如下:

角色IP主机名osmaster192.168.137.134mastercentos 6.5, x86_64Candidate192.168.137.130Candidate奴隶+ manage192.168.137.146slave

<强>

wget - o/etc/yum.repos.d/CentOS-Base。回购http://mirrors.aliyun.com/repo/centos回购

6. - rpm -ivh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel -释放- 6 - 8. - noarch.rpm

2, <强> ,

<强>

root@master ~ # ssh - keygen - t rsa - p”,,,,

chmod 600 . ssh/*

. ssh/id_rsa猫。酒吧祝辞。ssh/authorized_keys

scp - p,。ssh id_rsa/. ssh/authorized_keys 192.168.137.130:/根/sh

scp - p,。ssh id_rsa/. ssh/authorized_keys 192.168.137.146:/根/sh

<强>

<强>主授权:

格兰特复制奴隶,复制客户端> <李>

所有mysql节点安装,

rpm -ivh perl - dbd - mysql - 4.013 - 3. - el6.i686。rpm, [yum - y安装perl-DBD-MySQL]

,,,, rpm -ivh mha4mysql -节点- 0.56 - 0. - el6.noarch.rpm

2。管理需安装依赖的perl包,

,,,, rpm -ivh perl -配置-小- 2.12 - 7.1.el6.noarch.rpm

,,,, rpm -ivh perl - dbd - mysql - 4.013 - 3. - el6.i686。rpm, (yum - y安装perl-DBD-MySQL)

,,,, rpm -ivh兼容- db43 4.3.29 - 15. - el6.x86_64.rpm

,,,, rpm -ivh perl -邮件发送者- 0.8.16 - 3. - el6.noarch.rpm

,,,, rpm -ivh perl -平行forkmanager 0.7.9 - 1. - el6.noarch.rpm

,,,, rpm -ivh perl - timedate - 1.16 - 11.1.el6.noarch.rpm

,,,, rpm -ivh perl - mime类型- 1.28 - 2. - el6.noarch.rpm

,,,, rpm -ivh perl - mailtools - 2.04 - 4. - el6.noarch.rpm

,,,, rpm -ivh perl -邮件-日期-格式- 1.002 - 5. - el6.noarch.rpm

,,,, rpm -ivh perl - params -验证- 0.92 - 3. - el6.x86_64.rpm

,,,, rpm -ivh perl - mime - lite - 3.027 - 2. - el6.noarch.rpm

,,,, rpm -ivh perl -邮件发送邮件- 0.79 - 12. - el6.noarch.rpm

,,,, rpm -ivh perl -日志调度- 2.27 - 1. - el6.noarch.rpm

,,,,使用yum安装- y perl -时间-招聘- 1.9721 - 144. - el6。x86_64

,,,, rpm -ivh mha4mysql -经理- 0.56 - 0. - el6.noarch。rpm

3。配置尼古拉斯

配置文件位于管理节点,通常包括每一个mysql服务器的主机名,mysql用户名:密码,工作目录等等。

mkdir /etc/masterha/

vim /etc/masterha app1.cnf

(服务器默认)

用户=mhauser密码=123456

manager_workdir=/数据/masterha/app1

manager_log=/数据/masterha/app1/经理。日志

remote_workdir=/数据/masterha/app1

ssh_user=根

repl_user=repl

repl_password=123456

ping_interval=1

(server1)主机名=192.168.137.134

=3306港

master_binlog_dir=/usr/地方/mysql/数据

candidate_master=1

[server2]

主机名=192.168.137.130

=3306港

master_binlog_dir=/usr/地方/mysql/数据

candidate_master=1

[server3]主机名=192.168.137.146

=3306港

master_binlog_dir=/usr/地方/mysql/数据

no_master=1

<强>配关配置项的解释:

manager_workdir=/masterha/app1//设置经理的工作目录

manager_log=/masterha/app1 manager.log//设置经理的日志

用户=经理//设置监控用户经理

密码=123456,//监控用户经理的密码

ssh_user=root //ssh连接用户

repl_user=mharep //主从复制用户