江苏龙网

  1. 主页 > 生活百科 > >

MySQL Router高可用搭建，你学会了吗？( 七 )

mysql


Last updated: Thu Feb 23 15:55:27 2023:最后一次更新集群状态信息的时间为 2023 年 2 月 23 日 15:55:27 。
Last change: Thu Feb 23 15:53:55 2023 by hacluster via crmd on gdb2 :最后一次更改集群配置的时间为 2023 年 2 月 23 日 15:53:55，由用户 hacluster 通过 crmd 在节点 gdb2 上执行 。
3 nodes configured:该集群配置了 3 个节点 。
2 resource instances configured:该集群中配置了 2 个资源实例 。
Online: [ gdb1 gdb2 gdb3 ]:当前在线的节点为 gdb1、gdb2 和 gdb3 。
Full list of resources:列出了该集群中所有的资源，包括资源名称、资源类型和所在节点，以及资源的启动状态和当前状态 。其中，dbservice 是资源组名称，lvs 是类型为 ocf::heartbeat:ldirectord 的资源，vip 是类型为 ocf::heartbeat:IPaddr 的资源 。
Daemon Status:列出了 Pacemaker 各个组件的运行状态，包括 corosync、pacemaker 和 pcsd 。corosync、pacemaker 和 pcsd 均为 active/enabled 状态，表示它们都在运行并且已经启用 。

  1. 在上面pcs status输出的vip Started gdb3的gdb3服务器上启动ldirectord服务
[#19#root@gdb3 ~ 11:50:51]19 systemctl start ldirectord[#20#root@gdb3 ~ 11:50:58]20 [#20#root@gdb3 ~ 11:50:59]20 systemctl status ldirectord● ldirectord.service - LSB: Control Linux Virtual Server via ldirectord on non-heartbeat systemsLoaded: loaded (/etc/rc.d/init.d/ldirectord; bad; vendor preset: disabled)Active: active (running) since 四 2023-02-23 11:50:58 CST; 2s agoDocs: man:systemd-sysv-generator(8)Process: 1472 ExecStop=/etc/rc.d/init.d/ldirectord stop (code=exited, status=0/SUCCESS)Process: 1479 ExecStart=/etc/rc.d/init.d/ldirectord start (code=exited, status=0/SUCCESS)Tasks: 1Memory: 15.8MCGroup: /system.slice/ldirectord.service└─1484 /usr/bin/perl -w /usr/sbin/ldirectord start2月 23 11:50:58 gdb3 ldirectord[1479]: at /usr/sbin/ldirectord line 838.2月 23 11:50:58 gdb3 ldirectord[1479]: Subroutine main::unpack_sockaddr_in6 redefined at /usr/share/perl5/vendor_perl/Exporter.pm line 66.2月 23 11:50:58 gdb3 ldirectord[1479]: at /usr/sbin/ldirectord line 838.2月 23 11:50:58 gdb3 ldirectord[1479]: Subroutine main::sockaddr_in6 redefined at /usr/share/perl5/vendor_perl/Exporter.pm line 66.2月 23 11:50:58 gdb3 ldirectord[1479]: at /usr/sbin/ldirectord line 838.2月 23 11:50:58 gdb3 ldirectord[1479]: Subroutine main::pack_sockaddr_in6 redefined at /usr/sbin/ldirectord line 3078.2月 23 11:50:58 gdb3 ldirectord[1479]: Subroutine main::unpack_sockaddr_in6 redefined at /usr/sbin/ldirectord line 3078.2月 23 11:50:58 gdb3 ldirectord[1479]: Subroutine main::sockaddr_in6 redefined at /usr/sbin/ldirectord line 3078.2月 23 11:50:58 gdb3 ldirectord[1479]: success2月 23 11:50:58 gdb3 systemd[1]: Started LSB: Control Linux Virtual Server via ldirectord on non-heartbeat systems.[#21#root@gdb3 ~ 11:51:01]21通过上述操作即完成集群启动 。
集群停止
  1. 停止resource
# pcs resource disable vip lvs 或者 pcs resource disable dbservice# systemctl stop corosync pacemaker pcsd ldirectord卸载集群# pcs cluster stop# pcs cluster destroy# systemctl stop pcsd pacemaker corosync ldirectord# systemctl disable pcsd pacemaker corosync ldirectord# yum remove -y pacemaker corosync pcs ldirectord# rm -rf /var/lib/pcsd/* /var/lib/corosync/*# rm -f /etc/ha.d/ldirectord.cf三、高可用及负载均衡测试
  1. 在172.17.139.62上通过for循环，访问VIP，观察负载均衡情况
注意：VIP无法在real server服务器上进行访问，因此需要第4台服务器进行访问验证
# for x in {1..100}; do mysql -uroot -pAbc1234567* -h172.17.129.1 -P6446 -N -e 'select sleep(60)' 2> /dev/null & done在pcs resource lvs运行的服务器上，执行ipvsadm -Ln
[#26#root@gdb1 ~ 15:52:28]26 ipvsadm -LnIP Virtual Server version 1.2.1 (size=4096)Prot LocalAddress:Port Scheduler Flags-> RemoteAddress:PortForward Weight ActiveConn InActConnTCP172.17.129.1:6446 rr-> 172.17.139.164:6446Route1330-> 172.17.140.24:6446Route1340-> 172.17.140.25:6446Route1330TCP172.17.129.1:6447 rr-> 172.17.139.164:6447Route100-> 172.17.140.24:6447Route100-> 172.17.140.25:6447Route100[#27#root@gdb1 ~ 15:52:29]27可以看到访问被平均负载到每个服务器上了 。
在每个服务器上，通过netstat -alntp| grep 172.17.139.62确认请求的存在，其中172.17.139.62是发起请求的IP地址 。
[#28#root@gdb1 ~ 15:53:10]28 netstat -alntp| grep 172.17.139.62 | grep 6446tcp00 172.17.129.1:6446172.17.139.62:54444ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54606ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54592ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54492ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54580ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54432ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54586ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54552ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54404ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54566ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54516ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54560ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54450ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54480ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54540ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54522ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54462ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54528ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54534ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54598ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54498ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54426ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54510ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54504ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54412ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54612ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54456ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54468ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54474ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54486ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54574ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54438ESTABLISHED 1902/./mysqlroutertcp00 172.17.129.1:6446172.17.139.62:54546ESTABLISHED 1902/./mysqlrouter[#29#root@gdb1 ~ 15:53:13]29


推荐阅读


上一篇：没有了

下一篇：征服 Rust 编程世界的终极指南