HA_Cluster: corosync+pacemaker+drbd+mysql

alighters 发布于2019-08-01 13:23 / 1513人阅读

摘要：本文主要讲述的资源配置各个软件的安装配置不再介绍配置资源基本配置关闭不具备法定票数时的行为忽略默认资源粘性为添加资源和都提供了的本人实验时发现使用提供的会出现无法选举节点的情况此处建议使用提供的如有人知道为什么的选不出

本文主要讲述HA_Cluster: corosync+pacemaker+drbd+mysql 的CRM资源配置, 各个软件的安装配置不再介绍

CRM配置DRBD资源:

1.基本配置:

crm(live)configure# property stonith-enabled=false #关闭stonith
crm(live)configure# property no-quorum-policy=ignore #不具备法定票数时的行为: 忽略
crm(live)configure# rsc_defaults resource-stickiness=100 #默认资源粘性为100
crm(live)configure# verify
crm(live)configure# commit

2.添加DRBD资源:

crm(live)configure# primitive drbd_data ocf:linbit:drbd params drbd_resource="data" op monitor role="Master" interval="50" timeout="30" op monitor role="Slave" interval
interval-origin=  interval=        
crm(live)configure# primitive drbd_data ocf:linbit:drbd params drbd_resource=data op monitor role=Master interval=50 timeout=30 op monitor role=Slave interval=60 timeout=30 op start timeout=240 op stop timeout=100
crm(live)configure# verify
crm(live)configure# ms ms_drbd_data drbd_data meta master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true
crm(live)configure# verify
crm(live)configure# commit

PS: heartbeat 和 linbit 都提供了drbd 的 RA ,本人实验时发现使用 heartbeat 提供的 RA 会出现无法选举 Master 节点的情况, 此处建议使用 linbit 提供的RA
如有人知道为什么 heartbeat 的 RA 选不出 Master 节点, 愿闻其详

测试DRBD服务:

root@drbd1:~# crm status
Last updated: Sun May 22 22:04:35 2016
Last change: Mon May 23 06:02:13 2016 via cibadmin on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
2 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd1 ]
     Slaves: [ drbd2 ]
root@drbd1:~# crm node standby #离线drbd1
root@drbd1:~# crm status
Last updated: Mon May 23 06:07:22 2016
Last change: Mon May 23 06:07:14 2016 via crm_attribute on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
2 Resources configured
 
 
Node drbd1 (168495249): standby
Online: [ drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd2 ]
     Stopped: [ drbd1 ]
root@drbd1:~# crm node online #上线drbd1
root@drbd1:~# crm status
Last updated: Mon May 23 06:09:11 2016
Last change: Mon May 23 06:09:09 2016 via crm_attribute on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
2 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd2 ]
     Slaves: [ drbd1 ]
root@drbd2:~# crm node standby #离线drbd2
root@drbd2:~# crm node online #上线drbd2
root@drbd2:~# crm status
Last updated: Sun May 22 22:11:47 2016
Last change: Mon May 23 06:11:18 2016 via crm_attribute on drbd2
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
2 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd1 ]
     Slaves: [ drbd2 ]
-------------正常---------------

配置Filesystem资源:

crm(live)configure# primitive mount ocf:heartbeat:Filesystem params device=/dev/drbd0 directory=/var/lib/mysql fstype=ext3 op start timeout=60 op stop timeout=60
crm(live)configure# verify
crm(live)configure# colocation mount_with_ms_drbd_data inf: mount ms_drbd_data:Master
crm(live)configure# order mount_after_ms_drbd_data Mandatory: ms_drbd_data:promote mount:start
crm(live)configure# verify
crm(live)configure# commit

测试Filesystem资源:

root@drbd2:~# crm status
Last updated: Mon May 23 20:28:19 2016
Last change: Mon May 23 20:27:37 2016 via crm_attribute on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
3 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd2 ]
     Slaves: [ drbd1 ]
 mount    (ocf::heartbeat:Filesystem):    Started drbd2 #现在drbd0挂载在drbd2上
root@drbd2:~# crm node standby
root@drbd2:~# crm node online
root@drbd2:~# crm status
Last updated: Mon May 23 20:28:31 2016
Last change: Mon May 23 20:28:28 2016 via crm_attribute on drbd2
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
3 Resources configured
 
 
Node drbd2 (168495262): standby
Online: [ drbd1 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd1 ]
     Stopped: [ drbd2 ]
 mount    (ocf::heartbeat:Filesystem):    Started drbd1 #成功转移到drbd1

配置mysql(此处直接使用apt-get安装)资源:

crm(live)configure# primitive mysqld lsb:mysql
crm(live)configure# primitive mysql_ip ocf:heartbeat:IPaddr params ip=10.11.8.200 cidr_netmask=23
crm(live)configure# verify
crm(live)configure# colocation mysql_ip_with_mount inf: mysql_ip mount
crm(live)configure# colocation mysqld_with_mount inf: mysqld mount
crm(live)configure# order mysqld_after_mount Mandatory: mount mysqld
crm(live)configure# verify
crm(live)configure# commit

查看CRM配置:

node $id="168495249" drbd1 
        attributes standby="off"
node $id="168495262" drbd2 
        attributes standby="off"
primitive drbd_data ocf:linbit:drbd 
        params drbd_resource="data" 
        op monitor role="Master" interval="50" timeout="30" 
        op monitor role="Slave" interval="60" timeout="30" 
        op start timeout="240" interval="0" 
        op stop timeout="100" interval="0"
primitive mount ocf:heartbeat:Filesystem 
primitive mount ocf:heartbeat:Filesystem 
        params device="/dev/drbd0" directory="/var/lib/mysql" fstype="ext3" 
        op start timeout="60" interval="0" 
        op stop timeout="60" interval="0" 
        meta target-role="Started"
primitive mysql_ip ocf:heartbeat:IPaddr 
        params ip="10.11.8.200" cidr_netmask="23"
primitive mysqld lsb:mysql
ms ms_drbd_data drbd_data 
        meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" target-role="Started"
colocation mount_with_ms_drbd_data inf: mount ms_drbd_data:Master
colocation mysql_ip_with_mount inf: mysql_ip mount
colocation mysqld_with_mount inf: mysqld mount
order mount_after_ms_drbd_data Mandatory: ms_drbd_data:promote mount:start
order mysqld_after_mount Mandatory: mount mysqld
property $id="cib-bootstrap-options" 
        dc-version="1.1.10-42f2063" 
        cluster-infrastructure="corosync" 
        stonith-enabled="false" 
        no-quorum-policy="ignore" 
        last-lrm-refresh="1464019270"
rsc_defaults $id="rsc-options" 
        resource-stickiness="100"

修改mysql监听所有地址:

root@drbd1:~# vim /etc/mysql/my.cnf
#bind-address           = 127.0.0.1 #注释这一行

测试服务:

root@drbd1:~# crm status
Last updated: Tue May 24 00:55:04 2016
Last change: Tue May 24 00:42:45 2016 via crmd on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
5 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd1 ]
     Slaves: [ drbd2 ]
 mount    (ocf::heartbeat:Filesystem):    Started drbd1
 mysqld    (lsb:mysql):    Started drbd1
 mysql_ip    (ocf::heartbeat:IPaddr):    Started drbd1

在drbd2上连接测试:

root@drbd2:~# mysql -h10.11.8.200 -ushiina -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 40
Server version: 5.6.30-0ubuntu0.14.04.1 (Ubuntu)
 
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type "help;" or "h" for help. Type "c" to clear the current input statement.
 
mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| #mysql50#lost+found |
| mysql               |
| performance_schema  |
+---------------------+
4 rows in set (0.01 sec)
 
mysql> create database ha_test;
Query OK, 1 row affected (0.00 sec)

离线drbd1后再drbd1上连接测试:

root@drbd1:~# crm status
Last updated: Mon May 23 21:13:24 2016
Last change: Mon May 23 21:13:22 2016 via cibadmin on drbd1
Stack: corosync
Current DC: drbd1 (168495249) - partition with quorum
Version: 1.1.10-42f2063
2 Nodes configured
5 Resources configured
 
 
Online: [ drbd1 drbd2 ]
 
Master/Slave Set: ms_drbd_data [drbd_data]
     Masters: [ drbd2 ]
     Slaves: [ drbd1 ]
 mount    (ocf::heartbeat:Filesystem):    Started drbd2
 mysql_ip    (ocf::heartbeat:IPaddr):    Started drbd2
 mysqld    (lsb:mysql):    Started drbd2
root@drbd1:~# mysql -h10.11.8.200 -ushiina -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 40
Server version: 5.6.30-0ubuntu0.14.04.1 (Ubuntu)
 
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type "help;" or "h" for help. Type "c" to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ha_test            |
| lost+found         |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

文章版权归作者所有，未经允许请勿转载,若此文章存在违规行为，您可以联系管理员删除。

转载请注明本文地址：https://www.ucloud.cn/yun/48628.html

Nginx+Keepalived实现站点高可用

摘要：在协议实现里，虚拟路由器使用作为虚拟地址，就是唯一的，这个地址同一时间只有一个物理路由器占用。在虚拟路由器里面的物理路由器组里面通过多播地址来定时发送通告消息。负责健康检查，包括常见的各种检查方式。公司内部 OA 系统要做线上高可用，避免单点故障，所以计划使用2台虚拟机通过 Keepalived 工具来实现 nginx 的高可用（High Avaiability），达到一台nginx...

Songlcy 2019-07-25 13:32 评论0 收藏0
如何确保应用程序在公共云中的可用性

摘要：这种集成使软件能够检测应用程序级别的任何和所有停机时间，无论其原因如何，其中包括各种云计算服务等级协议未涵盖的原因。采用云计算的注意事项是一种很好的建议。云计算服务提供商(CSP)都会承诺在其基础设施中提供高可用性，其服务水平协议(SLA)通常提供95%至99.99%的正常运行时间，而每月服务费退款率将达到10%到50%不等。但通常没有达到这样的门槛，正如IT的许多方面一样，重要的在...

asce1885 2019-06-28 11:08 评论0 收藏0
MySql 主从复制及配置实现

摘要：主从复制是指一台服务器充当主数据库服务器，另一台或多台服务器充当从数据库服务器，主服务器中的数据自动复制到从服务器之中。一、什么是Mysql主从复制 MySQL主从复制是其最重要的功能之一。主从复制是指一台服务器充当主数据库服务器，另一台或多台服务器充当从数据库服务器，主服务器中的数据自动复制到从服务器之中。对于多级复制，数据库服务器即可充当主机，也可充当从机。MySQL主从复制的基...

kelvinlee 2019-07-31 16:50 评论0 收藏0
[DRBD] UpToDate/DUnknown 故障恢复

摘要：故障如下状态没有可用的网络配置没有可用的复制或同步网路资源没有被连接或者是管理员使用进行了连接中断也有可能是认证失败或是产生脑裂而中断了连接查看日志查看服务状态其中为主节点为备节点解决方法确保故障如下: root@drbd1:~# drbd-overview 0:data/0 StandAlone Primary/Unknown UpToDate/DUnknown /data/m...

txgcwm 2019-05-29 18:34 评论0 收藏0
DRBD UpToDate/DUnknown 故障恢复

摘要：故障如下状态没有可用的网络配置没有可用的复制或同步网路资源没有被连接或者是管理员使用进行了连接中断也有可能是认证失败或是产生脑裂而中断了连接查看日志查看服务状态其中为主节点为备节点解决方法确保故障如下: root@drbd1:~# drbd-overview 0:data/0 StandAlone Primary/Unknown UpToDate/DUnknown /data/m...

gaara 2019-05-29 18:33 评论0 收藏0