heartbeat 3.0.4-drbd 8.9-Mysql 5.6--双机互备高可用部署
发表于：2024-11-23 作者：千家信息网编辑
千家信息网最后更新 2024年11月23日，heartbeat 3.0.4-drbd 8.9-MySQL 5.6协同工作原理：首先，heartbeat作为高可用的控制角色，负责drbd存储服务目录的挂载（这里，drbd的启动个人理解是随主机启动
千家信息网最后更新 2024年11月23日heartbeat 3.0.4-drbd 8.9-Mysql 5.6--双机互备高可用部署
1、两台vmware linux 虚拟机arbiter和mymongo1(两台主机需要新添加虚拟硬盘sdb)，基本信息 mymongo1 [root@mymongo1 ~]# hostname mymongo1 [root@mymongo1 ~]# uname -a Linux mymongo1 2.6.32-642.el6.x86_64 #1 SMP Tue May 10 17:27:01 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux [root@mymongo1 ~]# fdisk -l
Disk /dev/sdb: 2147 MB, 2147483648 bytes 255 heads, 63 sectors/track, 261 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000
Disk /dev/sda: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00061eae
Device Boot Start End Blocks Id System /dev/sda1 * 1 39 307200 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 39 2350 18566144 83 Linux /dev/sda3 2350 2611 2097152 82 Linux swap / Solaris [root@mymongo1 ~]# cat /etc/redhat-release CentOS release 6.8 (Final) [root@mymongo1 ~]#
arbiter [root@arbiter ~]# uname -a Linux arbiter 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux [root@arbiter ~]# hostname arbiter [root@arbiter ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.4 (Santiago) [root@arbiter ~]# fdisk -l
Disk /dev/sda: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00078b06
Device Boot Start End Blocks Id System /dev/sda1 * 1 39 307200 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 39 549 4096000 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 549 2611 16567296 83 Linux
Disk /dev/sdb: 2147 MB, 2147483648 bytes 255 heads, 63 sectors/track, 261 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000
[root@arbiter ~]#
2、2台虚拟机sdb虚拟盘的分区表调整 [root@arbiter ~]# parted /dev/sdb mklabel gpt Information: You may need to update /etc/fstab. [root@arbiter ~]#
[root@mymongo1 ~]# parted /dev/sdb mklabel gpt Information: You may need to update /etc/fstab. [root@mymongo1 ~]#
3、2台虚拟机sdb（共2个G）分区成2个分区，一个分区一个G [root@mymongo1 ~]# parted /dev/sdb mkpart primary 0 1024 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@mymongo1 ~]# [root@mymongo1 ~]# parted /dev/sdb mkpart primary 1025 2146 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@mymongo1 ~]# parted /dev/sdb p Model: VMware, VMware Virtual S (scsi) Disk /dev/sdb: 2147MB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 1024MB 1024MB primary 2 1025MB 2146MB 1121MB primary [root@mymongo1 ~]#
[root@arbiter ~]# parted /dev/sdb mkpart primary 0 1024 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@arbiter ~]# parted /dev/sdb mkpart primary 1025 2146 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@arbiter ~]# parted /dev/sdb p Model: VMware, VMware Virtual S (scsi) Disk /dev/sdb: 2147MB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 1024MB 1024MB primary 2 1025MB 2146MB 1121MB primary [root@arbiter ~]#
4、2台虚拟机安装drbd，通过网络yum安装，保证两台主机能够联网 [root@arbiter ~]# wget ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm --2017-08-23 23:14:54-- http://ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm Resolving ftp.scientificlinux.org... 131.225.105.11 Connecting to ftp.scientificlinux.org|131.225.105.11|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 7464 (7.3K) [application/x-rpm] Saving to: ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?
100%[====================================================================================>] 7,464 --.-K/s in 0.01s
2017-08-23 23:14:56 (544 KB/s) - ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?.saved [7464/7464]
[root@arbiter ~]# ls anaconda-ks.cfg Documents heartbeat mysql-5.6.36 Public test cmake-2.8.10.2 Downloads install.log mysql-5.6.36.tar rpms Videos cmake-2.8.10.2.tar elrepo-release-6-6.el6.elrepo.noarch.rpm install.log.syslog Pictures select Desktop epel-release-6-8.noarch.rpm Music pkg Templates [root@arbiter ~]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@arbiter ~]# [root@arbiter ~]# ls anaconda-ks.cfg Downloads install.log mysql-5.6.36.tar select cmake-2.8.10.2 drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm install.log.syslog Pictures Templates cmake-2.8.10.2.tar elrepo-release-6-6.el6.elrepo.noarch.rpm kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm pkg test Desktop epel-release-6-8.noarch.rpm Music Public Videos Documents heartbeat mysql-5.6.36 rpms [root@arbiter ~]# rpm -ivh drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm warning: drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY Preparing... ########################################### [100%] 1:drbd84-utils ########################################### [100%] [root@arbiter ~]# [root@arbiter yum.repos.d]# ls elrepo.repo epel-testing.repo local.repo [root@arbiter yum.repos.d]# [root@arbiter yum.repos.d]# cat local.repo [local] name = local baseurl=file:///mnt/ enabled = 1 gpgcheck = 0 gpgkey =file://mnt/RPM-GPG-KEY-CentOS-6 [root@arbiter yum.repos.d]# [root@arbiter ~]# yum install -y kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:12 Setting up Install Process Examining kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 Marking kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Processing Dependency: kernel(__dynamic_dev_dbg) = 0x4b1a6158 for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Processing Dependency: kernel(dev_printk) = 0xabd7b07b for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Finished Dependency Resolution Error: Package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 (/kmod-drbd84-8.4.9-1.el6.elrepo.x86_64) Requires: kernel(__dynamic_dev_dbg) = 0x4b1a6158 Error: Package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 (/kmod-drbd84-8.4.9-1.el6.elrepo.x86_64) Requires: kernel(dev_printk) = 0xabd7b07b You could try using --skip-broken to work around the problem ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of mysql-libs [root@arbiter ~]# rpm -qa|grep kmod-drbd84 [root@arbiter ~]# yum install -y kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:10 local | 4.0 kB 00:00 ... local/primary_db | 4.7 MB 00:00 ... Setting up Install Process Examining kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 Marking kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Processing Dependency: kernel(__dynamic_dev_dbg) = 0x4b1a6158 for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Processing Dependency: kernel(dev_printk) = 0xabd7b07b for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Running transaction check ---> Package kernel.x86_64 0:2.6.32-642.el6 will be installed --> Processing Dependency: kernel-firmware >= 2.6.32-642.el6 for package: kernel-2.6.32-642.el6.x86_64 --> Processing Dependency: dracut-kernel >= 004-388.el6 for package: kernel-2.6.32-642.el6.x86_64 --> Running transaction check ---> Package dracut-kernel.noarch 0:004-303.el6 will be updated ---> Package dracut-kernel.noarch 0:004-409.el6 will be an update --> Processing Dependency: dracut = 004-409.el6 for package: dracut-kernel-004-409.el6.noarch ---> Package kernel-firmware.noarch 0:2.6.32-358.el6 will be updated ---> Package kernel-firmware.noarch 0:2.6.32-642.el6 will be an update --> Running transaction check ---> Package dracut.noarch 0:004-303.el6 will be updated ---> Package dracut.noarch 0:004-409.el6 will be an update --> Processing Conflict: kernel-2.6.32-642.el6.x86_64 conflicts bfa-firmware < 3.2.21.1-2 --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package bfa-firmware.noarch 0:3.0.3.1-1.el6 will be updated ---> Package bfa-firmware.noarch 0:3.2.23.0-2.el6 will be an update --> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================== Installing: kmod-drbd84 x86_64 8.4.9-1.el6.elrepo /kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 696 k Updating: bfa-firmware noarch 3.2.23.0-2.el6 local 3.2 M Installing for dependencies: kernel x86_64 2.6.32-642.el6 local 32 M Updating for dependencies: dracut noarch 004-409.el6 local 127 k dracut-kernel noarch 004-409.el6 local 28 k kernel-firmware noarch 2.6.32-642.el6 local 28 M
Transaction Summary =============================================================================================================================================== Install 2 Package(s) Upgrade 4 Package(s)
Total size: 64 M Total download size: 63 M Downloading Packages: ----------------------------------------------------------------------------------------------------------------------------------------------- Total 93 MB/s | 63 MB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of mysql-libs Updating : kernel-firmware-2.6.32-642.el6.noarch 1/10 Updating : dracut-004-409.el6.noarch 2/10 Updating : dracut-kernel-004-409.el6.noarch 3/10 Installing : kernel-2.6.32-642.el6.x86_64 4/10 Installing : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 5/10 Working. This may take some time ... Done. Updating : bfa-firmware-3.2.23.0-2.el6.noarch 6/10 Cleanup : dracut-kernel-004-303.el6.noarch 7/10 Cleanup : dracut-004-303.el6.noarch 8/10 Cleanup : kernel-firmware-2.6.32-358.el6.noarch 9/10 Cleanup : bfa-firmware-3.0.3.1-1.el6.noarch 10/10 Verifying : dracut-kernel-004-409.el6.noarch 1/10 Verifying : dracut-004-409.el6.noarch 2/10 Verifying : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 3/10 Verifying : bfa-firmware-3.2.23.0-2.el6.noarch 4/10 Verifying : kernel-firmware-2.6.32-642.el6.noarch 5/10 Verifying : kernel-2.6.32-642.el6.x86_64 6/10 Verifying : dracut-kernel-004-303.el6.noarch 7/10 Verifying : dracut-004-303.el6.noarch 8/10 Verifying : kernel-firmware-2.6.32-358.el6.noarch 9/10 Verifying : bfa-firmware-3.0.3.1-1.el6.noarch 10/10
Installed: kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo
Dependency Installed: kernel.x86_64 0:2.6.32-642.el6
Updated: bfa-firmware.noarch 0:3.2.23.0-2.el6
Dependency Updated: dracut.noarch 0:004-409.el6 dracut-kernel.noarch 0:004-409.el6 kernel-firmware.noarch 0:2.6.32-642.el6
Complete! [root@arbiter ~]#
[root@mymongo1 drbd]# wget ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm --2017-08-23 23:15:15-- http://ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm Resolving ftp.scientificlinux.org... 131.225.105.11 Connecting to ftp.scientificlinux.org|131.225.105.11|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 7464 (7.3K) [application/x-rpm] Saving to: ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?
100%[==========================================================================>] 7,464 --.-K/s in 0s
2017-08-23 23:15:16 (223 MB/s) - ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?.saved [7464/7464] --mymongo1节点drbd的安装 [root@mymongo1 drbd]# ls elrepo-release-6-6.el6.elrepo.noarch.rpm [root@mymongo1 drbd]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@mymongo1 drbd]# [root@mymongo1 drbd]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@mymongo1 drbd]# yum install drbd kmod-drbd84 -y Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile epel/metalink | 4.6 kB 00:00 * base: mirrors.cn99.com * elrepo: mirrors.tuna.tsinghua.edu.cn * epel: mirror.premi.st * extras: mirrors.tuna.tsinghua.edu.cn * updates: mirrors.tuna.tsinghua.edu.cn base | 3.7 kB 00:00 elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:27 epel | 4.3 kB 00:00 epel/primary_db | 5.9 MB 03:04 extras | 3.4 kB 00:00 updates | 3.4 kB 00:00 http://mirrors.tuna.tsinghua.edu.cn/centos/6.9/updates/x86_64/repodata/2b0cc62da054bcf7c883b783de2de48c2372b9e502074246f7e0b046336f123d-primary.sqlite.bz2: [Errno 12] Timeout on http://mirrors.tuna.tsinghua.edu.cn/centos/6.9/updates/x86_64/repodata/2b0cc62da054bcf7c883b783de2de48c2372b9e502074246f7e0b046336f123d-primary.sqlite.bz2: (28, 'Operation too slow. Less than 1 bytes/sec transfered the last 30 seconds') Trying other mirror. updates/primary_db | 3.1 MB 00:00 Resolving Dependencies --> Running transaction check ---> Package drbd84-utils.x86_64 0:8.9.8-1.el6.elrepo will be installed ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================== Package Arch Version Repository Size =================================================================================================================================== Installing: drbd84-utils x86_64 8.9.8-1.el6.elrepo elrepo 392 k kmod-drbd84 x86_64 8.4.9-1.el6.elrepo elrepo 198 k
Transaction Summary =================================================================================================================================== Install 2 Package(s)
Total download size: 590 k Installed size: 1.7 M Downloading Packages: (1/2): drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm | 392 kB 00:11 (2/2): kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm | 198 kB 00:18 ----------------------------------------------------------------------------------------------------------------------------------- Total 19 kB/s | 590 kB 00:31 warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-elrepo.org Importing GPG key 0xBAADAE52: Userid : elrepo.org (RPM Signing Key for elrepo.org) Package: elrepo-release-6-6.el6.elrepo.noarch (installed) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-elrepo.org Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of mysql-libs Installing : drbd84-utils-8.9.8-1.el6.elrepo.x86_64 1/2 Installing : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 2/2 Working. This may take some time ... Done. Verifying : drbd84-utils-8.9.8-1.el6.elrepo.x86_64 1/2 Verifying : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 2/2
Installed: drbd84-utils.x86_64 0:8.9.8-1.el6.elrepo kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo
Complete! [root@mymongo1 drbd]#
[root@arbiter ~]# rpm -qa|grep drbd kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 drbd84-utils-8.9.8-1.el6.elrepo.x86_64 [root@arbiter ~]# [root@mymongo1 ~]# rpm -qa|grep drbd drbd84-utils-8.9.8-1.el6.elrepo.x86_64 kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 [root@mymongo1 ~]#
5、将drbd加入内核并设置drbd开机自启动 [root@arbiter ~]# lsmod |grep drbd [root@arbiter ~]# modprobe drbd [root@arbiter ~]# lsmod |grep drbd drbd 374888 0 libcrc32c 1246 1 drbd [root@arbiter ~]# echo "modprobe drbd>/dev/null 2>&1">/etc/sysconfig/modules/drbd.modules [root@arbiter ~]#
[root@mymongo1 ~]# lsmod |grep drbd [root@mymongo1 ~]# modprobe drbd [root@mymongo1 ~]# lsmod |grep drbd drbd 374888 0 libcrc32c 1246 1 drbd [root@mymongo1 ~]# echo "modprobe drbd>/dev/null 2>&1">/etc/sysconfig/modules/drbd.modules [root@mymongo1 ~]#
6、编辑2个节点的drbd控制文件 [root@mymongo1 ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@mymongo1 ~]# cat /etc/drbd.conf global{ #minor-count 64; #dialog-refresh 5; #5 seconds #disable-ip-verification; usage-count no; }
common{ protocol C; disk { on-io-error detach; no-disk-flushes; no-md-flushes; } net { sndbuf-size 512k; #timout 60; #60 seconds #connect-int 10; #10 seconds #ping-int 10; #10seconds #ping-timeout 5; #500 ms max-buffers 8000; unplug-watermark 1024; max-epoch-size 8000; #ko-count 4; #allow-two-primaries; cram-hmac-alg "sha1"; shared-secret "hdhwXes23sYEhart8t"; after-sb-0pri disconnect; after-sb-1pri disconnect; after-sb-2pri disconnect; rr-conflict disconnect; #data-integrity-alg "md5"; #no-tcp-cork; } syncer{ rate 330M; al-extents 517; } } resource data { on arbiter { device /dev/drbd0; disk /dev/sdb1; address 192.168.144.111:7788; meta-disk /dev/sdb2 [0]; } on mymongo1 { device /dev/drbd0; disk /dev/sdb1; address 192.168.144.132:7788; meta-disk /dev/sdb2 [0]; } }
[root@mymongo1 ~]# [root@mymongo1 ~]# scp /etc/drbd.conf arbiter:/etc/ root@arbiter's password: drbd.conf 100% 994 1.0KB/s 00:00 [root@mymongo1 ~]#
7、初始化两个节点drbd源数据 [root@mymongo1 ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@mymongo1 ~]# [root@arbiter ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@arbiter ~]#
8、启动并查看drbd [root@mymongo1 ~]# drbdadm up data [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:WFConnection ro:Secondary/Unknown ds:Inconsistent/DUnknown C r----s ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@mymongo1 ~]# [root@arbiter ~]# drbdadm up data [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent C r----- ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@arbiter ~]#
[root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent C r----- ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@mymongo1 ~]#
9、设置drbd角色，这里设置mymongo1为主节点 [root@mymongo1 ~]# drbdadm -- --overwrite-data-of-peer primary data [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r---n- ns:334220 nr:0 dw:0 dr:339075 al:8 bm:0 lo:0 pe:2 ua:5 ap:0 ep:1 wo:d oos:667184 [=====>..............] sync'ed: 33.9% (667184/999984)K finish: 0:00:06 speed: 110,932 (110,932) K/sec [root@mymongo1 ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:SyncTarget ro:Secondary/Primary ds:Inconsistent/UpToDate C r----- ns:0 nr:896000 dw:894976 dr:0 al:8 bm:0 lo:2 pe:5 ua:1 ap:0 ep:1 wo:d oos:105008 [================>...] sync'ed: 89.8% (105008/999984)K finish: 0:00:00 speed: 99,440 (99,440) want: 102,400 K/sec [root@arbiter ~]#
完成同步 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:999983 dw:999983 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:999983 nr:0 dw:0 dr:1000662 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]#
10、2端机器创建相同的挂载点 [root@mymongo1 /]# mkdir data [root@mymongo1 /]#
[root@arbiter /]# mkdir data [root@arbiter /]#
11、格式化drbd0设备（只在主节点） [root@mymongo1 /]# mkfs.ext4 -b 4096 /dev/drbd0 mke2fs 1.41.12 (17-May-2010) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 62592 inodes, 249995 blocks 12499 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=260046848 8 block groups 32768 blocks per group, 32768 fragments per group 7824 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376
Writing inode tables: done Creating journal (4096 blocks): done Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 39 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. [root@mymongo1 /]# [root@mymongo1 /]# mount /dev/drbd0 /data [root@mymongo1 /]# pwd / [root@mymongo1 /]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@mymongo1 /]#
12、测试2端的数据同步 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001355 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032457 dw:1032457 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
测试 [root@mymongo1 ~]# cp glib-2.22.5.tar /data/ [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001355 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032485 nr:0 dw:32502 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072313 nr:0 dw:72330 dr:1001371 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072325 nr:0 dw:72342 dr:1001371 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]#
[root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032457 dw:1032457 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032485 dw:1032485 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032485 dw:1032485 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1072325 dw:1072325 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
备节点查看 [root@arbiter ~]# drbdadm down data [root@arbiter ~]# mount /dev/sdb1 /mnt [root@arbiter ~]# cd /mnt [root@arbiter mnt]# ll total 39816 -rw-r--r--. 1 root root 40755200 Aug 24 01:53 glib-2.22.5.tar drwx------ 2 root root 16384 Aug 24 01:50 lost+found [root@arbiter mnt]#
备节点恢复 [root@arbiter ~]# drbdadm up data [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:0 dw:0 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
二、heartbeat接管drbd服务资源 1、修改heartbeat的haresource配置文件，2个节点相同 [root@mymongo1 ~]# cat /etc/ha.d/haresources arbiter IPaddr::192.168.144.121/24/eth2 httpd
mymongo1 IPaddr::192.168.144.122/24/eth2 drbddisk::data Filesystem::/dev/drbd0::/data::ext4
#mysql master #arbiter IPaddr::192.168.144.11/24/eth2 mysqld
#mysql salve #mymongo1 IPaddr::192.168.144.12/24/eth2 [root@mymongo1 ~]# 2、重启heartbeat服务 [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. --查看heartbeat的vip [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# --查看drbd状态 [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072437 nr:8 dw:72462 dr:1002067 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# --查看drbd是否自动挂载 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@mymongo1 ~]#
arbiter节点处理 [root@arbiter ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@arbiter ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:8 nr:112 dw:120 dr:696 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]#
3、heartbeat接管drbd资源的测试 --停止mymongo1的heartbeat模拟故障 [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# --查看备节点drbd服务目录的接管 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:8 nr:112 dw:120 dr:696 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:12 nr:116 dw:128 dr:1392 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@arbiter ~]# --查看主节点drbd服务目录资源的释放 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:1072441 nr:12 dw:72470 dr:1002067 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# --从实验看当主节点出故障后，heartbeat能够自动接管drbd资源 --调整drbd、heartbeat不开机自动启动，防止生产中数据破坏或数据不一致，首先人工处理 注意2节点最好对drbd、heartbeat不要自动启动 [root@arbiter ~]# chkconfig heartbeat off [root@arbiter ~]# chkconfig drbd off
[root@mymongo1 ~]# chkconfig heartbeat off [root@mymongo1 ~]# chkconfig drbd off
--drbd重新连接数据 drbdadm connect data
heartbeat接管drbdadm的配置完成
三、在drbd的主节点（当前是mymongo1）初始化mysql数据库 1、在drbd数据分区中安装mysql数据库 修改/data/mysql5.6的权限宿主 [root@mymongo1 scripts]# chown -R mysql:mysql /data/mysql5.6/ [root@mymongo1 scripts]# chmod 775 /data/mysql5.6/ [root@mymongo1 scripts]#cd /application/mysql-5.6.36 [root@mymongo1 scripts]# pwd /application/mysql/scripts [root@mymongo1 scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/data/mysql5.6/data --user=mysql 2、修改mysql启动控制文件 [root@mymongo1 scripts]# cat /etc/my.cnf [client] port = 3306 socket =/data/mysql5.6/tmp/mysql.sock
[mysql] no-auto-rehash
[mysqld] datadir=/data/mysql5.6/data socket=/data/mysql5.6/tmp/mysql.sock user=mysql port=3306 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-bin=/data/mysql5.6/mysql-bin open_files_limit =1024 back_log = 600 max_connections = 800 max_connect_errors = 3000 #table_cache = 614 external-locking =FALSE thread_stack =192k #transaction_isolation=READ-COMMITTED tmp_table_size =2M max_heap_table_size=2M long_query_time=1 pid-file =/data/mysql5.6/run/mysqld/mysql_mysqld.pid relay-log =/data/mysql5.6/relay-bin relay-log-info-file = /data/mysql5.6/relay-log.info binlog_cache_size =1M max_binlog_cache_size=1M max_binlog_size=2M expire_logs_days=7 key_buffer_size=16M read_buffer_size =1M read_rnd_buffer_size=1M bulk_insert_buffer_size=1M lower_case_table_names=1 skip-name-resolve slave-skip-errors=1031,1062 replicate-ignore-db=mysql server-id=1 innodb_additional_mem_pool_size=4M
[mysqld_safe] log-error=/data/mysql5.6/log/mysql.log pid-file=/data/mysql5.6/run/mysqld/mysqld.pid [root@mymongo1 scripts]#
3、安装数据库 [root@mymongo1 scripts]# ./mysql_install_db --basedir=/application/mysql --datadir=/data/mysql5.6/data --user=mysql Installing MySQL system tables...2017-08-24 23:14:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-24 23:14:36 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-24 23:14:36 0 [Note] /application/mysql/bin/mysqld (mysqld 5.6.36-log) starting as process 26813 ... 2017-08-24 23:14:36 7fbd0d5fd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-08-24 23:14:36 26813 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-24 23:14:36 26813 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-24 23:14:36 26813 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-24 23:14:36 26813 [Note] InnoDB: Memory barrier is not used 2017-08-24 23:14:36 26813 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-24 23:14:36 26813 [Note] InnoDB: Using CPU crc32 instructions 2017-08-24 23:14:36 26813 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-24 23:14:36 26813 [Note] InnoDB: Completed initialization of buffer pool 2017-08-24 23:14:36 26813 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Database physically writes the file full: wait... 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-08-24 23:14:36 26813 [Warning] InnoDB: New log files created, LSN=45781 2017-08-24 23:14:36 26813 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-08-24 23:14:36 26813 [Note] InnoDB: Doublewrite buffer created 2017-08-24 23:14:36 26813 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-24 23:14:36 26813 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-08-24 23:14:36 26813 [Note] InnoDB: Foreign key constraint system tables created 2017-08-24 23:14:36 26813 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-08-24 23:14:36 26813 [Note] InnoDB: Tablespace and datafile system tables created. 2017-08-24 23:14:36 26813 [Note] InnoDB: Waiting for purge to start 2017-08-24 23:14:36 26813 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-08-24 23:14:37 26813 [Note] Binlog end 2017-08-24 23:14:37 26813 [Note] InnoDB: FTS optimize thread exiting. 2017-08-24 23:14:37 26813 [Note] InnoDB: Starting shutdown... 2017-08-24 23:14:38 26813 [Note] InnoDB: Shutdown completed; log sequence number 1625977 OK
Filling help tables...2017-08-24 23:14:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-24 23:14:38 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-24 23:14:38 0 [Note] /application/mysql/bin/mysqld (mysqld 5.6.36-log) starting as process 26835 ... 2017-08-24 23:14:38 7f5a5b3cd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-08-24 23:14:38 26835 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-24 23:14:38 26835 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-24 23:14:38 26835 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-24 23:14:38 26835 [Note] InnoDB: Memory barrier is not used 2017-08-24 23:14:38 26835 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-24 23:14:38 26835 [Note] InnoDB: Using CPU crc32 instructions 2017-08-24 23:14:38 26835 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-24 23:14:38 26835 [Note] InnoDB: Completed initialization of buffer pool 2017-08-24 23:14:38 26835 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-24 23:14:38 26835 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-24 23:14:38 26835 [Note] InnoDB: Waiting for purge to start 2017-08-24 23:14:38 26835 [Note] InnoDB: 5.6.36 started; log sequence number 1625977 2017-08-24 23:14:38 26835 [Note] Binlog end 2017-08-24 23:14:38 26835 [Note] InnoDB: FTS optimize thread exiting. 2017-08-24 23:14:38 26835 [Note] InnoDB: Starting shutdown... 2017-08-24 23:14:39 26835 [Note] InnoDB: Shutdown completed; log sequence number 1625987 OK
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:
/application/mysql/bin/mysqladmin -u root password 'new-password' /application/mysql/bin/mysqladmin -u root -h 192.168.144.132 password 'new-password'
Alternatively you can run:
/application/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /application/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
WARNING: Found existing config file /application/mysql/my.cnf on the system. Because this file might be in use, it was not replaced, but was used in bootstrap (unless you used --defaults-file) and when you later start the server. The new default config file was created as /application/mysql/my-new.cnf, please compare it with your file and take the changes you need.
WARNING: Default config file /etc/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server [root@mymongo1 scripts]#
4、启动数据库 [root@mymongo1 log]# mkdir -p /data/mysql5.6/run/mysqld [root@mymongo1 log]# chown -R mysql:mysql /data/mysql5.6/run/mysqld [root@mymongo1 scripts]# mkdir /data/mysql5.6/tmp -p [root@mymongo1 log]# chmod 755 /data/mysql5.6/run/mysqld [root@mymongo1 scripts]# chown -R mysql:mysql /data/mysql5.6/tmp [root@mymongo1 scripts]# mkdir -p /data/mysql5.6/log/ [root@mymongo1 scripts]# chown mysql:mysql /data/mysql5.6/log/ [root@mymongo1 scripts]# chmod 775 /data/mysql5.6/log/ -R [root@mymongo1 scripts]# touch /data/mysql5.6/log/mysql.log [root@mymongo1 log]# chown mysql:mysql /data/mysql5.6/log/mysql.log [root@mymongo1 scripts]# ps -ef|grep mysql root 26877 20324 0 23:18 pts/2 00:00:00 grep mysql [root@mymongo1 scripts]# cd .. [root@mymongo1 log]# /etc/init.d/mysqld start Starting MySQL. SUCCESS! [root@mymongo1 log]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@mymongo1 log]# --主节点停止mysql，到备节点启动mysql [root@arbiter ~]# /etc/init.d/mysqld start Starting MySQL.. SUCCESS! [root@arbiter ~]# ps -ef|grep mysql root 5344 1 0 01:13 pts/2 00:00:00 /bin/sh /application/mysql-5.6/bin/mysqld_safe --datadir=/data/mysql5.6/data --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid mysql 5860 5344 8 01:13 pts/2 00:00:01 /application/mysql-5.6/bin/mysqld --basedir=/application/mysql-5.6 --datadir=/data/mysql5.6/data --plugin-dir=/application/mysql-5.6/lib/plugin --user=mysql --log-error=/data/mysql5.6/log/mysql.log --open-files-limit=1024 --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid --socket=/data/mysql5.6/tmp/mysql.sock --port=3306 root 5893 4987 0 01:13 pts/2 00:00:00 grep mysql [root@arbiter ~]# netstat -antup|grep 33 tcp 0 0 :::3306 :::* LISTEN 5860/mysqld tcp 0 0 :::11733 :::* LISTEN 1983/rpc.statd [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@arbiter ~]#
5、修改2个节点的heartbeat的资源配置文件haresources [root@mymongo1 ~]# cat /etc/ha.d/haresources arbiter IPaddr::192.168.144.121/24/eth2 httpd
mymongo1 IPaddr::192.168.144.122/24/eth2 drbddisk::data Filesystem::/dev/drbd0::/data::ext4 mysqld
#mysql master #arbiter IPaddr::192.168.144.11/24/eth2 mysqld
#mysql salve #mymongo1 IPaddr::192.168.144.12/24/eth2 [root@mymongo1 ~]#
6、启动heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@mymongo1 ~]#
[root@arbiter ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@arbiter ~]#
7、查看状态 --drbd的同步状态 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:2333919 nr:0 dw:1333936 dr:1011915 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# --drbd的存储挂载 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 113M 784M 13% /data [root@mymongo1 ~]# --heartbeat高可用的虚拟IP的状态 [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 --mysql的3306端口的状态 [root@mymongo1 ~]# ss -antup|grep 33 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",26363,17)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 0 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) --mysql登录测试-主节点 [root@mymongo1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> [root@mymongo1 ~]# --对端节点arbir [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:464 dw:464 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ip add |grep 192.168.144.122 [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]#
8、heartbeat的资源切换接管测试 --当前主节点停止heartbeart [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# ps -ef|grep mysql root 27156 3962 0 01:28 pts/2 00:00:00 grep mysql [root@mymongo1 ~]# --有进程在，好奇怪 [root@mymongo1 ~]# netstat -antup|grep 3306 tcp 0 0 127.0.0.1:6013 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6011 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6012 0.0.0.0:* LISTEN 3306/sshd tcp 0 52 192.168.144.132:22 192.168.144.1:49249 ESTABLISHED 3306/sshd tcp 0 0 ::1:6013 :::* LISTEN 3306/sshd tcp 0 0 ::1:6010 :::* LISTEN 3306/sshd tcp 0 0 ::1:6011 :::* LISTEN 3306/sshd tcp 0 0 ::1:6012 :::* LISTEN 3306/sshd [root@mymongo1 ~]# --备节点查看drbd服务目录、mysql服务的接管情况 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:456 nr:656 dw:1112 dr:7028 al:6 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot /dev/drbd0 946M 113M 784M 13% /data [root@arbiter ~]# ss -antup|grep 3306 tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",8356,17)) [root@arbiter ~]# [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@arbiter ~]#
--测试heartbeat-drbd-mysql配合下mysql的数据同步 [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.36-log Source distribution Copyright (c) 2000, 2017, 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> create database zhulei; Query OK, 1 row affected (0.00 sec) mysql> use zhulei Database changed mysql> create table tt(id int,name varchar(15)); Query OK, 0 rows affected (0.06 sec) mysql> insert into tt values(1,'zhulei'); Query OK, 1 row affected (0.01 sec) mysql> select * from tt; +------+--------+ | id | name | +------+--------+ | 1 | zhulei | +------+--------+ 1 row in set (0.01 sec) mysql> quit Bye [root@arbiter ~]# --在mymongo1启动heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@mymongo1 ~]# --查看mymongo1的资源状态 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:2334487 nr:2032 dw:1336536 dr:1019079 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 114M 784M 13% /data [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# ss -antup|grep 3306 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",28610,18)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 120 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) [root@mymongo1 ~]# ps -ef|grep mysql root 28093 1 0 01:33 ? 00:00:00 /bin/sh /application/mysql-5.6/bin/mysqld_safe --datadir=/data/mysql5.6/data --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid mysql 28610 28093 1 01:33 ? 00:00:00 /application/mysql-5.6/bin/mysqld --basedir=/application/mysql-5.6 --datadir=/data/mysql5.6/data --plugin-dir=/application/mysql-5.6/lib/plugin --user=mysql --log-error=/data/mysql5.6/log/mysql.log --open-files-limit=1024 --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid --socket=/data/mysql5.6/tmp/mysql.sock --port=3306 root 28672 5393 0 01:34 pts/3 00:00:00 grep mysql [root@mymongo1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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 | | mysql | | performance_schema | | test | | zhulei | +--------------------+ 5 rows in set (0.01 sec)
mysql> use zhulei; Database changed mysql> show tables; +------------------+ | Tables_in_zhulei | +------------------+ | tt | +------------------+ 1 row in set (0.00 sec)
mysql> select * from tt; +------+--------+ | id | name | +------+--------+ | 1 | zhulei | +------+--------+ 1 row in set (0.02 sec)
mysql> quit Bye [root@mymongo1 ~]#
--节点arbiter的资源释放情况 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:2032 nr:1180 dw:3212 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# ps -ef|grep mysql root 9105 4987 0 01:36 pts/2 00:00:00 grep mysql [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# netstat -antup|grep 3306 [root@arbiter ~]# 到此，实验完成！
附录： 正常停止Mysql-drbd-hearbeart 无资源节点先停止heartbeat [root@arbiter ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@arbiter ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:2032 nr:1180 dw:3212 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# ps -ef|grep mysql root 9105 4987 0 01:36 pts/2 00:00:00 grep mysql [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# netstat -antup|grep 3306 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r----- ns:2032 nr:1388 dw:3420 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# 资源节点停止heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r----- ns:2334859 nr:2032 dw:1336908 dr:1019395 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# ss -antup|grep 3306 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 52 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) [root@mymongo1 ~]# [root@mymongo1 ~]# /etc/init.d/drbd stop Stopping all DRBD resources: . [root@mymongo1 ~]#
[root@arbiter ~]# /etc/init.d/drbd stop Stopping all DRBD resources: . [root@arbiter ~]#
heartbeat 3.0.4-drbd 8.9-MySQL 5.6协同工作原理：首先，heartbeat作为高可用的控制角色，负责drbd存储服务目录的挂载（这里，drbd的启动个人理解是随主机启动自动
启动的，其作用就是将主节点本地的一块盘与对端备节点的一块盘做数据同步、保证两端主机drbd相关的数据盘中数据完全一致），drbd的存储目录只在主节点挂载、接受读
写，而备机保持不可用；当heartbeat完成drbd存储目录挂载后，启动mysql数据库，同时heartbeat负责检测drbd存储、mysql服务的状态，当服务异常，通过超时机制将资源
在备机启动，从而达到mysql双机互备高可用的目的。
前提条件：
按照博文linux-ha heartbeat高可用的安装配置（http服务高可用）完成heartbeat的安装配置
按照博文MySQL 5.6 for REHL 6.4编译安装完成mysql的安装配置
| 主机名称 | mymongo1 | arbiter |
| 管理IP | eth0:192.168.199.131 | eth0:192.168.199.134 |
| DRBD管理名称 | /data | /data |
| DRBD逻辑设备 | /dev/drbd0 | /dev/drbd0 |
| DRBD对接IP | eth2:192.168.144.132 | eth2:192.168.144.111 |
| DRBD存储设备 | /dev/sdb1 | /dev/sdb1 |
| DRBD META设备 | /dev/sdb2 [0] | /dev/sdb2 [0] |
| 虚拟IP | eth2:192.168.144.122 | eth2:192.168.144.122 |
1、两台vmware linux 虚拟机arbiter和mymongo1(两台主机需要新添加虚拟硬盘sdb)，基本信息 mymongo1 [root@mymongo1 ~]# hostname mymongo1 [root@mymongo1 ~]# uname -a Linux mymongo1 2.6.32-642.el6.x86_64 #1 SMP Tue May 10 17:27:01 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux [root@mymongo1 ~]# fdisk -l
Disk /dev/sdb: 2147 MB, 2147483648 bytes 255 heads, 63 sectors/track, 261 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000
Disk /dev/sda: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00061eae
Device Boot Start End Blocks Id System /dev/sda1 * 1 39 307200 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 39 2350 18566144 83 Linux /dev/sda3 2350 2611 2097152 82 Linux swap / Solaris [root@mymongo1 ~]# cat /etc/redhat-release CentOS release 6.8 (Final) [root@mymongo1 ~]#
arbiter [root@arbiter ~]# uname -a Linux arbiter 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux [root@arbiter ~]# hostname arbiter [root@arbiter ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.4 (Santiago) [root@arbiter ~]# fdisk -l
Disk /dev/sda: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00078b06
Device Boot Start End Blocks Id System /dev/sda1 * 1 39 307200 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 39 549 4096000 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 549 2611 16567296 83 Linux
Disk /dev/sdb: 2147 MB, 2147483648 bytes 255 heads, 63 sectors/track, 261 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000
[root@arbiter ~]#
2、2台虚拟机sdb虚拟盘的分区表调整 [root@arbiter ~]# parted /dev/sdb mklabel gpt Information: You may need to update /etc/fstab. [root@arbiter ~]#
[root@mymongo1 ~]# parted /dev/sdb mklabel gpt Information: You may need to update /etc/fstab. [root@mymongo1 ~]#
3、2台虚拟机sdb（共2个G）分区成2个分区，一个分区一个G [root@mymongo1 ~]# parted /dev/sdb mkpart primary 0 1024 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@mymongo1 ~]# [root@mymongo1 ~]# parted /dev/sdb mkpart primary 1025 2146 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@mymongo1 ~]# parted /dev/sdb p Model: VMware, VMware Virtual S (scsi) Disk /dev/sdb: 2147MB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 1024MB 1024MB primary 2 1025MB 2146MB 1121MB primary [root@mymongo1 ~]#
[root@arbiter ~]# parted /dev/sdb mkpart primary 0 1024 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@arbiter ~]# parted /dev/sdb mkpart primary 1025 2146 Warning: The resulting partition is not properly aligned for best performance. Ignore/Cancel? Ignore Information: You may need to update /etc/fstab. [root@arbiter ~]# parted /dev/sdb p Model: VMware, VMware Virtual S (scsi) Disk /dev/sdb: 2147MB Sector size (logical/physical): 512B/512B Partition Table: gpt Number Start End Size File system Name Flags 1 17.4kB 1024MB 1024MB primary 2 1025MB 2146MB 1121MB primary [root@arbiter ~]#
4、2台虚拟机安装drbd，通过网络yum安装，保证两台主机能够联网 [root@arbiter ~]# wget ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm --2017-08-23 23:14:54-- http://ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm Resolving ftp.scientificlinux.org... 131.225.105.11 Connecting to ftp.scientificlinux.org|131.225.105.11|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 7464 (7.3K) [application/x-rpm] Saving to: ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?
100%[====================================================================================>] 7,464 --.-K/s in 0.01s
2017-08-23 23:14:56 (544 KB/s) - ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?.saved [7464/7464]
[root@arbiter ~]# ls anaconda-ks.cfg Documents heartbeat mysql-5.6.36 Public test cmake-2.8.10.2 Downloads install.log mysql-5.6.36.tar rpms Videos cmake-2.8.10.2.tar elrepo-release-6-6.el6.elrepo.noarch.rpm install.log.syslog Pictures select Desktop epel-release-6-8.noarch.rpm Music pkg Templates [root@arbiter ~]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@arbiter ~]# [root@arbiter ~]# ls anaconda-ks.cfg Downloads install.log mysql-5.6.36.tar select cmake-2.8.10.2 drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm install.log.syslog Pictures Templates cmake-2.8.10.2.tar elrepo-release-6-6.el6.elrepo.noarch.rpm kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm pkg test Desktop epel-release-6-8.noarch.rpm Music Public Videos Documents heartbeat mysql-5.6.36 rpms [root@arbiter ~]# rpm -ivh drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm warning: drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY Preparing... ########################################### [100%] 1:drbd84-utils ########################################### [100%] [root@arbiter ~]# [root@arbiter yum.repos.d]# ls elrepo.repo epel-testing.repo local.repo [root@arbiter yum.repos.d]# [root@arbiter yum.repos.d]# cat local.repo [local] name = local baseurl=file:///mnt/ enabled = 1 gpgcheck = 0 gpgkey =file://mnt/RPM-GPG-KEY-CentOS-6 [root@arbiter yum.repos.d]# [root@arbiter ~]# yum install -y kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:12 Setting up Install Process Examining kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 Marking kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Processing Dependency: kernel(__dynamic_dev_dbg) = 0x4b1a6158 for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Processing Dependency: kernel(dev_printk) = 0xabd7b07b for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Finished Dependency Resolution Error: Package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 (/kmod-drbd84-8.4.9-1.el6.elrepo.x86_64) Requires: kernel(__dynamic_dev_dbg) = 0x4b1a6158 Error: Package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 (/kmod-drbd84-8.4.9-1.el6.elrepo.x86_64) Requires: kernel(dev_printk) = 0xabd7b07b You could try using --skip-broken to work around the problem ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of mysql-libs [root@arbiter ~]# rpm -qa|grep kmod-drbd84 [root@arbiter ~]# yum install -y kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:10 local | 4.0 kB 00:00 ... local/primary_db | 4.7 MB 00:00 ... Setting up Install Process Examining kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 Marking kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Processing Dependency: kernel(__dynamic_dev_dbg) = 0x4b1a6158 for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Processing Dependency: kernel(dev_printk) = 0xabd7b07b for package: kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 --> Running transaction check ---> Package kernel.x86_64 0:2.6.32-642.el6 will be installed --> Processing Dependency: kernel-firmware >= 2.6.32-642.el6 for package: kernel-2.6.32-642.el6.x86_64 --> Processing Dependency: dracut-kernel >= 004-388.el6 for package: kernel-2.6.32-642.el6.x86_64 --> Running transaction check ---> Package dracut-kernel.noarch 0:004-303.el6 will be updated ---> Package dracut-kernel.noarch 0:004-409.el6 will be an update --> Processing Dependency: dracut = 004-409.el6 for package: dracut-kernel-004-409.el6.noarch ---> Package kernel-firmware.noarch 0:2.6.32-358.el6 will be updated ---> Package kernel-firmware.noarch 0:2.6.32-642.el6 will be an update --> Running transaction check ---> Package dracut.noarch 0:004-303.el6 will be updated ---> Package dracut.noarch 0:004-409.el6 will be an update --> Processing Conflict: kernel-2.6.32-642.el6.x86_64 conflicts bfa-firmware < 3.2.21.1-2 --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package bfa-firmware.noarch 0:3.0.3.1-1.el6 will be updated ---> Package bfa-firmware.noarch 0:3.2.23.0-2.el6 will be an update --> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================== Installing: kmod-drbd84 x86_64 8.4.9-1.el6.elrepo /kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 696 k Updating: bfa-firmware noarch 3.2.23.0-2.el6 local 3.2 M Installing for dependencies: kernel x86_64 2.6.32-642.el6 local 32 M Updating for dependencies: dracut noarch 004-409.el6 local 127 k dracut-kernel noarch 004-409.el6 local 28 k kernel-firmware noarch 2.6.32-642.el6 local 28 M
Transaction Summary =============================================================================================================================================== Install 2 Package(s) Upgrade 4 Package(s)
Total size: 64 M Total download size: 63 M Downloading Packages: ----------------------------------------------------------------------------------------------------------------------------------------------- Total 93 MB/s | 63 MB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-2.2.el6_1.x86_64 has missing requires of mysql-libs Updating : kernel-firmware-2.6.32-642.el6.noarch 1/10 Updating : dracut-004-409.el6.noarch 2/10 Updating : dracut-kernel-004-409.el6.noarch 3/10 Installing : kernel-2.6.32-642.el6.x86_64 4/10 Installing : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 5/10 Working. This may take some time ... Done. Updating : bfa-firmware-3.2.23.0-2.el6.noarch 6/10 Cleanup : dracut-kernel-004-303.el6.noarch 7/10 Cleanup : dracut-004-303.el6.noarch 8/10 Cleanup : kernel-firmware-2.6.32-358.el6.noarch 9/10 Cleanup : bfa-firmware-3.0.3.1-1.el6.noarch 10/10 Verifying : dracut-kernel-004-409.el6.noarch 1/10 Verifying : dracut-004-409.el6.noarch 2/10 Verifying : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 3/10 Verifying : bfa-firmware-3.2.23.0-2.el6.noarch 4/10 Verifying : kernel-firmware-2.6.32-642.el6.noarch 5/10 Verifying : kernel-2.6.32-642.el6.x86_64 6/10 Verifying : dracut-kernel-004-303.el6.noarch 7/10 Verifying : dracut-004-303.el6.noarch 8/10 Verifying : kernel-firmware-2.6.32-358.el6.noarch 9/10 Verifying : bfa-firmware-3.0.3.1-1.el6.noarch 10/10
Installed: kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo
Dependency Installed: kernel.x86_64 0:2.6.32-642.el6
Updated: bfa-firmware.noarch 0:3.2.23.0-2.el6
Dependency Updated: dracut.noarch 0:004-409.el6 dracut-kernel.noarch 0:004-409.el6 kernel-firmware.noarch 0:2.6.32-642.el6
Complete! [root@arbiter ~]#
[root@mymongo1 drbd]# wget ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm --2017-08-23 23:15:15-- http://ftp.scientificlinux.org/linux/scientific/6.9/x86_64/os/Packages/elrepo-release-6-6.el6.elrepo.noarch.rpm Resolving ftp.scientificlinux.org... 131.225.105.11 Connecting to ftp.scientificlinux.org|131.225.105.11|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 7464 (7.3K) [application/x-rpm] Saving to: ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?
100%[==========================================================================>] 7,464 --.-K/s in 0s
2017-08-23 23:15:16 (223 MB/s) - ?.lrepo-release-6-6.el6.elrepo.noarch.rpm?.saved [7464/7464] --mymongo1节点drbd的安装 [root@mymongo1 drbd]# ls elrepo-release-6-6.el6.elrepo.noarch.rpm [root@mymongo1 drbd]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@mymongo1 drbd]# [root@mymongo1 drbd]# rpm -ivh elrepo-release-6-6.el6.elrepo.noarch.rpm warning: elrepo-release-6-6.el6.elrepo.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ########################################### [100%] 1:elrepo-release ########################################### [100%] [root@mymongo1 drbd]# yum install drbd kmod-drbd84 -y Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile epel/metalink | 4.6 kB 00:00 * base: mirrors.cn99.com * elrepo: mirrors.tuna.tsinghua.edu.cn * epel: mirror.premi.st * extras: mirrors.tuna.tsinghua.edu.cn * updates: mirrors.tuna.tsinghua.edu.cn base | 3.7 kB 00:00 elrepo | 2.9 kB 00:00 elrepo/primary_db | 692 kB 00:27 epel | 4.3 kB 00:00 epel/primary_db | 5.9 MB 03:04 extras | 3.4 kB 00:00 updates | 3.4 kB 00:00 http://mirrors.tuna.tsinghua.edu.cn/centos/6.9/updates/x86_64/repodata/2b0cc62da054bcf7c883b783de2de48c2372b9e502074246f7e0b046336f123d-primary.sqlite.bz2: [Errno 12] Timeout on http://mirrors.tuna.tsinghua.edu.cn/centos/6.9/updates/x86_64/repodata/2b0cc62da054bcf7c883b783de2de48c2372b9e502074246f7e0b046336f123d-primary.sqlite.bz2: (28, 'Operation too slow. Less than 1 bytes/sec transfered the last 30 seconds') Trying other mirror. updates/primary_db | 3.1 MB 00:00 Resolving Dependencies --> Running transaction check ---> Package drbd84-utils.x86_64 0:8.9.8-1.el6.elrepo will be installed ---> Package kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo will be installed --> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================== Package Arch Version Repository Size =================================================================================================================================== Installing: drbd84-utils x86_64 8.9.8-1.el6.elrepo elrepo 392 k kmod-drbd84 x86_64 8.4.9-1.el6.elrepo elrepo 198 k
Transaction Summary =================================================================================================================================== Install 2 Package(s)
Total download size: 590 k Installed size: 1.7 M Downloading Packages: (1/2): drbd84-utils-8.9.8-1.el6.elrepo.x86_64.rpm | 392 kB 00:11 (2/2): kmod-drbd84-8.4.9-1.el6.elrepo.x86_64.rpm | 198 kB 00:18 ----------------------------------------------------------------------------------------------------------------------------------- Total 19 kB/s | 590 kB 00:31 warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-elrepo.org Importing GPG key 0xBAADAE52: Userid : elrepo.org (RPM Signing Key for elrepo.org) Package: elrepo-release-6-6.el6.elrepo.noarch (installed) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-elrepo.org Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of mysql-libs Installing : drbd84-utils-8.9.8-1.el6.elrepo.x86_64 1/2 Installing : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 2/2 Working. This may take some time ... Done. Verifying : drbd84-utils-8.9.8-1.el6.elrepo.x86_64 1/2 Verifying : kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 2/2
Installed: drbd84-utils.x86_64 0:8.9.8-1.el6.elrepo kmod-drbd84.x86_64 0:8.4.9-1.el6.elrepo
Complete! [root@mymongo1 drbd]#
[root@arbiter ~]# rpm -qa|grep drbd kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 drbd84-utils-8.9.8-1.el6.elrepo.x86_64 [root@arbiter ~]# [root@mymongo1 ~]# rpm -qa|grep drbd drbd84-utils-8.9.8-1.el6.elrepo.x86_64 kmod-drbd84-8.4.9-1.el6.elrepo.x86_64 [root@mymongo1 ~]#
5、将drbd加入内核并设置drbd开机自启动 [root@arbiter ~]# lsmod |grep drbd [root@arbiter ~]# modprobe drbd [root@arbiter ~]# lsmod |grep drbd drbd 374888 0 libcrc32c 1246 1 drbd [root@arbiter ~]# echo "modprobe drbd>/dev/null 2>&1">/etc/sysconfig/modules/drbd.modules [root@arbiter ~]#
[root@mymongo1 ~]# lsmod |grep drbd [root@mymongo1 ~]# modprobe drbd [root@mymongo1 ~]# lsmod |grep drbd drbd 374888 0 libcrc32c 1246 1 drbd [root@mymongo1 ~]# echo "modprobe drbd>/dev/null 2>&1">/etc/sysconfig/modules/drbd.modules [root@mymongo1 ~]#
6、编辑2个节点的drbd控制文件 [root@mymongo1 ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@mymongo1 ~]# cat /etc/drbd.conf global{ #minor-count 64; #dialog-refresh 5; #5 seconds #disable-ip-verification; usage-count no; }
common{ protocol C; disk { on-io-error detach; no-disk-flushes; no-md-flushes; } net { sndbuf-size 512k; #timout 60; #60 seconds #connect-int 10; #10 seconds #ping-int 10; #10seconds #ping-timeout 5; #500 ms max-buffers 8000; unplug-watermark 1024; max-epoch-size 8000; #ko-count 4; #allow-two-primaries; cram-hmac-alg "sha1"; shared-secret "hdhwXes23sYEhart8t"; after-sb-0pri disconnect; after-sb-1pri disconnect; after-sb-2pri disconnect; rr-conflict disconnect; #data-integrity-alg "md5"; #no-tcp-cork; } syncer{ rate 330M; al-extents 517; } } resource data { on arbiter { device /dev/drbd0; disk /dev/sdb1; address 192.168.144.111:7788; meta-disk /dev/sdb2 [0]; } on mymongo1 { device /dev/drbd0; disk /dev/sdb1; address 192.168.144.132:7788; meta-disk /dev/sdb2 [0]; } }
[root@mymongo1 ~]# [root@mymongo1 ~]# scp /etc/drbd.conf arbiter:/etc/ root@arbiter's password: drbd.conf 100% 994 1.0KB/s 00:00 [root@mymongo1 ~]#
7、初始化两个节点drbd源数据 [root@mymongo1 ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@mymongo1 ~]# [root@arbiter ~]# drbdadm create-md data initializing activity log NOT initializing bitmap Writing meta data... New drbd meta data block successfully created. [root@arbiter ~]#
8、启动并查看drbd [root@mymongo1 ~]# drbdadm up data [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:WFConnection ro:Secondary/Unknown ds:Inconsistent/DUnknown C r----s ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@mymongo1 ~]# [root@arbiter ~]# drbdadm up data [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent C r----- ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@arbiter ~]#
[root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent C r----- ns:0 nr:0 dw:0 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:999984 [root@mymongo1 ~]#
9、设置drbd角色，这里设置mymongo1为主节点 [root@mymongo1 ~]# drbdadm -- --overwrite-data-of-peer primary data [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r---n- ns:334220 nr:0 dw:0 dr:339075 al:8 bm:0 lo:0 pe:2 ua:5 ap:0 ep:1 wo:d oos:667184 [=====>..............] sync'ed: 33.9% (667184/999984)K finish: 0:00:06 speed: 110,932 (110,932) K/sec [root@mymongo1 ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:SyncTarget ro:Secondary/Primary ds:Inconsistent/UpToDate C r----- ns:0 nr:896000 dw:894976 dr:0 al:8 bm:0 lo:2 pe:5 ua:1 ap:0 ep:1 wo:d oos:105008 [================>...] sync'ed: 89.8% (105008/999984)K finish: 0:00:00 speed: 99,440 (99,440) want: 102,400 K/sec [root@arbiter ~]#
完成同步 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:999983 dw:999983 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:999983 nr:0 dw:0 dr:1000662 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]#
10、2端机器创建相同的挂载点 [root@mymongo1 /]# mkdir data [root@mymongo1 /]#
[root@arbiter /]# mkdir data [root@arbiter /]#
11、格式化drbd0设备（只在主节点） [root@mymongo1 /]# mkfs.ext4 -b 4096 /dev/drbd0 mke2fs 1.41.12 (17-May-2010) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 62592 inodes, 249995 blocks 12499 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=260046848 8 block groups 32768 blocks per group, 32768 fragments per group 7824 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376
Writing inode tables: done Creating journal (4096 blocks): done Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 39 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. [root@mymongo1 /]# [root@mymongo1 /]# mount /dev/drbd0 /data [root@mymongo1 /]# pwd / [root@mymongo1 /]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@mymongo1 /]#
12、测试2端的数据同步 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001355 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032457 dw:1032457 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
测试 [root@mymongo1 ~]# cp glib-2.22.5.tar /data/ [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001355 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032457 nr:0 dw:32474 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1032485 nr:0 dw:32502 dr:1001363 al:19 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072313 nr:0 dw:72330 dr:1001371 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072325 nr:0 dw:72342 dr:1001371 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]#
[root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032457 dw:1032457 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032485 dw:1032485 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1032485 dw:1032485 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:1072325 dw:1072325 dr:0 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
备节点查看 [root@arbiter ~]# drbdadm down data [root@arbiter ~]# mount /dev/sdb1 /mnt [root@arbiter ~]# cd /mnt [root@arbiter mnt]# ll total 39816 -rw-r--r--. 1 root root 40755200 Aug 24 01:53 glib-2.22.5.tar drwx------ 2 root root 16384 Aug 24 01:50 lost+found [root@arbiter mnt]#
备节点恢复 [root@arbiter ~]# drbdadm up data [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:0 dw:0 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]#
二、heartbeat接管drbd服务资源 1、修改heartbeat的haresource配置文件，2个节点相同 [root@mymongo1 ~]# cat /etc/ha.d/haresources arbiter IPaddr::192.168.144.121/24/eth2 httpd
mymongo1 IPaddr::192.168.144.122/24/eth2 drbddisk::data Filesystem::/dev/drbd0::/data::ext4
#mysql master #arbiter IPaddr::192.168.144.11/24/eth2 mysqld
#mysql salve #mymongo1 IPaddr::192.168.144.12/24/eth2 [root@mymongo1 ~]# 2、重启heartbeat服务 [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. --查看heartbeat的vip [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# --查看drbd状态 [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:1072437 nr:8 dw:72462 dr:1002067 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# --查看drbd是否自动挂载 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@mymongo1 ~]#
arbiter节点处理 [root@arbiter ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@arbiter ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:8 nr:112 dw:120 dr:696 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]#
3、heartbeat接管drbd资源的测试 --停止mymongo1的heartbeat模拟故障 [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# --查看备节点drbd服务目录的接管 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:8 nr:112 dw:120 dr:696 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:12 nr:116 dw:128 dr:1392 al:1 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 8.3G 6.4G 57% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot /dev/drbd0 946M 1.3M 896M 1% /data [root@arbiter ~]# --查看主节点drbd服务目录资源的释放 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:1072441 nr:12 dw:72470 dr:1002067 al:22 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 6.6G 9.9G 40% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# --从实验看当主节点出故障后，heartbeat能够自动接管drbd资源 --调整drbd、heartbeat不开机自动启动，防止生产中数据破坏或数据不一致，首先人工处理 注意2节点最好对drbd、heartbeat不要自动启动 [root@arbiter ~]# chkconfig heartbeat off [root@arbiter ~]# chkconfig drbd off
[root@mymongo1 ~]# chkconfig heartbeat off [root@mymongo1 ~]# chkconfig drbd off
--drbd重新连接数据 drbdadm connect data
heartbeat接管drbdadm的配置完成
三、在drbd的主节点（当前是mymongo1）初始化mysql数据库 1、在drbd数据分区中安装mysql数据库 修改/data/mysql5.6的权限宿主 [root@mymongo1 scripts]# chown -R mysql:mysql /data/mysql5.6/ [root@mymongo1 scripts]# chmod 775 /data/mysql5.6/ [root@mymongo1 scripts]#cd /application/mysql-5.6.36 [root@mymongo1 scripts]# pwd /application/mysql/scripts [root@mymongo1 scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/data/mysql5.6/data --user=mysql 2、修改mysql启动控制文件 [root@mymongo1 scripts]# cat /etc/my.cnf [client] port = 3306 socket =/data/mysql5.6/tmp/mysql.sock
[mysql] no-auto-rehash
[mysqld] datadir=/data/mysql5.6/data socket=/data/mysql5.6/tmp/mysql.sock user=mysql port=3306 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-bin=/data/mysql5.6/mysql-bin open_files_limit =1024 back_log = 600 max_connections = 800 max_connect_errors = 3000 #table_cache = 614 external-locking =FALSE thread_stack =192k #transaction_isolation=READ-COMMITTED tmp_table_size =2M max_heap_table_size=2M long_query_time=1 pid-file =/data/mysql5.6/run/mysqld/mysql_mysqld.pid relay-log =/data/mysql5.6/relay-bin relay-log-info-file = /data/mysql5.6/relay-log.info binlog_cache_size =1M max_binlog_cache_size=1M max_binlog_size=2M expire_logs_days=7 key_buffer_size=16M read_buffer_size =1M read_rnd_buffer_size=1M bulk_insert_buffer_size=1M lower_case_table_names=1 skip-name-resolve slave-skip-errors=1031,1062 replicate-ignore-db=mysql server-id=1 innodb_additional_mem_pool_size=4M
[mysqld_safe] log-error=/data/mysql5.6/log/mysql.log pid-file=/data/mysql5.6/run/mysqld/mysqld.pid [root@mymongo1 scripts]#
3、安装数据库 [root@mymongo1 scripts]# ./mysql_install_db --basedir=/application/mysql --datadir=/data/mysql5.6/data --user=mysql Installing MySQL system tables...2017-08-24 23:14:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-24 23:14:36 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-24 23:14:36 0 [Note] /application/mysql/bin/mysqld (mysqld 5.6.36-log) starting as process 26813 ... 2017-08-24 23:14:36 7fbd0d5fd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-08-24 23:14:36 26813 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-24 23:14:36 26813 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-24 23:14:36 26813 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-24 23:14:36 26813 [Note] InnoDB: Memory barrier is not used 2017-08-24 23:14:36 26813 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-24 23:14:36 26813 [Note] InnoDB: Using CPU crc32 instructions 2017-08-24 23:14:36 26813 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-24 23:14:36 26813 [Note] InnoDB: Completed initialization of buffer pool 2017-08-24 23:14:36 26813 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Database physically writes the file full: wait... 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-08-24 23:14:36 26813 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-08-24 23:14:36 26813 [Warning] InnoDB: New log files created, LSN=45781 2017-08-24 23:14:36 26813 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-08-24 23:14:36 26813 [Note] InnoDB: Doublewrite buffer created 2017-08-24 23:14:36 26813 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-24 23:14:36 26813 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-08-24 23:14:36 26813 [Note] InnoDB: Foreign key constraint system tables created 2017-08-24 23:14:36 26813 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-08-24 23:14:36 26813 [Note] InnoDB: Tablespace and datafile system tables created. 2017-08-24 23:14:36 26813 [Note] InnoDB: Waiting for purge to start 2017-08-24 23:14:36 26813 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-08-24 23:14:37 26813 [Note] Binlog end 2017-08-24 23:14:37 26813 [Note] InnoDB: FTS optimize thread exiting. 2017-08-24 23:14:37 26813 [Note] InnoDB: Starting shutdown... 2017-08-24 23:14:38 26813 [Note] InnoDB: Shutdown completed; log sequence number 1625977 OK
Filling help tables...2017-08-24 23:14:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-24 23:14:38 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-24 23:14:38 0 [Note] /application/mysql/bin/mysqld (mysqld 5.6.36-log) starting as process 26835 ... 2017-08-24 23:14:38 7f5a5b3cd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-08-24 23:14:38 26835 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-24 23:14:38 26835 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-24 23:14:38 26835 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-24 23:14:38 26835 [Note] InnoDB: Memory barrier is not used 2017-08-24 23:14:38 26835 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-24 23:14:38 26835 [Note] InnoDB: Using CPU crc32 instructions 2017-08-24 23:14:38 26835 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-24 23:14:38 26835 [Note] InnoDB: Completed initialization of buffer pool 2017-08-24 23:14:38 26835 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-24 23:14:38 26835 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-24 23:14:38 26835 [Note] InnoDB: Waiting for purge to start 2017-08-24 23:14:38 26835 [Note] InnoDB: 5.6.36 started; log sequence number 1625977 2017-08-24 23:14:38 26835 [Note] Binlog end 2017-08-24 23:14:38 26835 [Note] InnoDB: FTS optimize thread exiting. 2017-08-24 23:14:38 26835 [Note] InnoDB: Starting shutdown... 2017-08-24 23:14:39 26835 [Note] InnoDB: Shutdown completed; log sequence number 1625987 OK
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:
/application/mysql/bin/mysqladmin -u root password 'new-password' /application/mysql/bin/mysqladmin -u root -h 192.168.144.132 password 'new-password'
Alternatively you can run:
/application/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /application/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
WARNING: Found existing config file /application/mysql/my.cnf on the system. Because this file might be in use, it was not replaced, but was used in bootstrap (unless you used --defaults-file) and when you later start the server. The new default config file was created as /application/mysql/my-new.cnf, please compare it with your file and take the changes you need.
WARNING: Default config file /etc/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server [root@mymongo1 scripts]#
4、启动数据库 [root@mymongo1 log]# mkdir -p /data/mysql5.6/run/mysqld [root@mymongo1 log]# chown -R mysql:mysql /data/mysql5.6/run/mysqld [root@mymongo1 scripts]# mkdir /data/mysql5.6/tmp -p [root@mymongo1 log]# chmod 755 /data/mysql5.6/run/mysqld [root@mymongo1 scripts]# chown -R mysql:mysql /data/mysql5.6/tmp [root@mymongo1 scripts]# mkdir -p /data/mysql5.6/log/ [root@mymongo1 scripts]# chown mysql:mysql /data/mysql5.6/log/ [root@mymongo1 scripts]# chmod 775 /data/mysql5.6/log/ -R [root@mymongo1 scripts]# touch /data/mysql5.6/log/mysql.log [root@mymongo1 log]# chown mysql:mysql /data/mysql5.6/log/mysql.log [root@mymongo1 scripts]# ps -ef|grep mysql root 26877 20324 0 23:18 pts/2 00:00:00 grep mysql [root@mymongo1 scripts]# cd .. [root@mymongo1 log]# /etc/init.d/mysqld start Starting MySQL. SUCCESS! [root@mymongo1 log]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@mymongo1 log]# --主节点停止mysql，到备节点启动mysql [root@arbiter ~]# /etc/init.d/mysqld start Starting MySQL.. SUCCESS! [root@arbiter ~]# ps -ef|grep mysql root 5344 1 0 01:13 pts/2 00:00:00 /bin/sh /application/mysql-5.6/bin/mysqld_safe --datadir=/data/mysql5.6/data --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid mysql 5860 5344 8 01:13 pts/2 00:00:01 /application/mysql-5.6/bin/mysqld --basedir=/application/mysql-5.6 --datadir=/data/mysql5.6/data --plugin-dir=/application/mysql-5.6/lib/plugin --user=mysql --log-error=/data/mysql5.6/log/mysql.log --open-files-limit=1024 --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid --socket=/data/mysql5.6/tmp/mysql.sock --port=3306 root 5893 4987 0 01:13 pts/2 00:00:00 grep mysql [root@arbiter ~]# netstat -antup|grep 33 tcp 0 0 :::3306 :::* LISTEN 5860/mysqld tcp 0 0 :::11733 :::* LISTEN 1983/rpc.statd [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@arbiter ~]#
5、修改2个节点的heartbeat的资源配置文件haresources [root@mymongo1 ~]# cat /etc/ha.d/haresources arbiter IPaddr::192.168.144.121/24/eth2 httpd
mymongo1 IPaddr::192.168.144.122/24/eth2 drbddisk::data Filesystem::/dev/drbd0::/data::ext4 mysqld
#mysql master #arbiter IPaddr::192.168.144.11/24/eth2 mysqld
#mysql salve #mymongo1 IPaddr::192.168.144.12/24/eth2 [root@mymongo1 ~]#
6、启动heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@mymongo1 ~]#
[root@arbiter ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@arbiter ~]#
7、查看状态 --drbd的同步状态 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:2333919 nr:0 dw:1333936 dr:1011915 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# --drbd的存储挂载 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 113M 784M 13% /data [root@mymongo1 ~]# --heartbeat高可用的虚拟IP的状态 [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 --mysql的3306端口的状态 [root@mymongo1 ~]# ss -antup|grep 33 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",26363,17)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 0 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) --mysql登录测试-主节点 [root@mymongo1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> [root@mymongo1 ~]# --对端节点arbir [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:0 nr:464 dw:464 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ip add |grep 192.168.144.122 [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]#
8、heartbeat的资源切换接管测试 --当前主节点停止heartbeart [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done.
[root@mymongo1 ~]# [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# ps -ef|grep mysql root 27156 3962 0 01:28 pts/2 00:00:00 grep mysql [root@mymongo1 ~]# --有进程在，好奇怪 [root@mymongo1 ~]# netstat -antup|grep 3306 tcp 0 0 127.0.0.1:6013 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6011 0.0.0.0:* LISTEN 3306/sshd tcp 0 0 127.0.0.1:6012 0.0.0.0:* LISTEN 3306/sshd tcp 0 52 192.168.144.132:22 192.168.144.1:49249 ESTABLISHED 3306/sshd tcp 0 0 ::1:6013 :::* LISTEN 3306/sshd tcp 0 0 ::1:6010 :::* LISTEN 3306/sshd tcp 0 0 ::1:6011 :::* LISTEN 3306/sshd tcp 0 0 ::1:6012 :::* LISTEN 3306/sshd [root@mymongo1 ~]# --备节点查看drbd服务目录、mysql服务的接管情况 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:456 nr:656 dw:1112 dr:7028 al:6 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot /dev/drbd0 946M 113M 784M 13% /data [root@arbiter ~]# ss -antup|grep 3306 tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",8356,17)) [root@arbiter ~]# [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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> quit Bye [root@arbiter ~]#
--测试heartbeat-drbd-mysql配合下mysql的数据同步 [root@arbiter ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.36-log Source distribution Copyright (c) 2000, 2017, 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> create database zhulei; Query OK, 1 row affected (0.00 sec) mysql> use zhulei Database changed mysql> create table tt(id int,name varchar(15)); Query OK, 0 rows affected (0.06 sec) mysql> insert into tt values(1,'zhulei'); Query OK, 1 row affected (0.01 sec) mysql> select * from tt; +------+--------+ | id | name | +------+--------+ | 1 | zhulei | +------+--------+ 1 row in set (0.01 sec) mysql> quit Bye [root@arbiter ~]# --在mymongo1启动heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat start Starting High-Availability services: INFO: Resource is stopped INFO: Resource is stopped Done. [root@mymongo1 ~]# --查看mymongo1的资源状态 [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r----- ns:2334487 nr:2032 dw:1336536 dr:1019079 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot /dev/drbd0 946M 114M 784M 13% /data [root@mymongo1 ~]# ip add|grep 192.168.144.122 inet 192.168.144.122/24 brd 192.168.144.255 scope global secondary eth2 [root@mymongo1 ~]# ss -antup|grep 3306 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 :::3306 :::* users:(("mysqld",28610,18)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 120 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) [root@mymongo1 ~]# ps -ef|grep mysql root 28093 1 0 01:33 ? 00:00:00 /bin/sh /application/mysql-5.6/bin/mysqld_safe --datadir=/data/mysql5.6/data --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid mysql 28610 28093 1 01:33 ? 00:00:00 /application/mysql-5.6/bin/mysqld --basedir=/application/mysql-5.6 --datadir=/data/mysql5.6/data --plugin-dir=/application/mysql-5.6/lib/plugin --user=mysql --log-error=/data/mysql5.6/log/mysql.log --open-files-limit=1024 --pid-file=/data/mysql5.6/run/mysqld/mysql_mysqld.pid --socket=/data/mysql5.6/tmp/mysql.sock --port=3306 root 28672 5393 0 01:34 pts/3 00:00:00 grep mysql [root@mymongo1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.36-log Source distribution
Copyright (c) 2000, 2017, 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 | | mysql | | performance_schema | | test | | zhulei | +--------------------+ 5 rows in set (0.01 sec)
mysql> use zhulei; Database changed mysql> show tables; +------------------+ | Tables_in_zhulei | +------------------+ | tt | +------------------+ 1 row in set (0.00 sec)
mysql> select * from tt; +------+--------+ | id | name | +------+--------+ | 1 | zhulei | +------+--------+ 1 row in set (0.02 sec)
mysql> quit Bye [root@mymongo1 ~]#
--节点arbiter的资源释放情况 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:2032 nr:1180 dw:3212 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# ps -ef|grep mysql root 9105 4987 0 01:36 pts/2 00:00:00 grep mysql [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# netstat -antup|grep 3306 [root@arbiter ~]# 到此，实验完成！
附录： 正常停止Mysql-drbd-hearbeart 无资源节点先停止heartbeat [root@arbiter ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@arbiter ~]# [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r----- ns:2032 nr:1180 dw:3212 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# ip add|grep 192.168.144.122 [root@arbiter ~]# ps -ef|grep mysql root 9105 4987 0 01:36 pts/2 00:00:00 grep mysql [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# netstat -antup|grep 3306 [root@arbiter ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r----- ns:2032 nr:1388 dw:3420 dr:7220 al:9 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@arbiter ~]# ss -antup|grep 3306 [root@arbiter ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 9.3G 5.4G 64% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 59M 210M 22% /boot [root@arbiter ~]# 资源节点停止heartbeat [root@mymongo1 ~]# /etc/init.d/heartbeat stop Stopping High-Availability services: Done. [root@mymongo1 ~]# [root@mymongo1 ~]# cat /proc/drbd version: 8.4.9-1 (api:1/proto:86-101) GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by mockbuild@Build64R6, 2016-12-13 18:38:15 0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r----- ns:2334859 nr:2032 dw:1336908 dr:1019395 al:190 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d oos:0 [root@mymongo1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.8G 6.8G 60% / tmpfs 935M 72K 935M 1% /dev/shm /dev/sda1 283M 39M 229M 15% /boot [root@mymongo1 ~]# ip add|grep 192.168.144.122 [root@mymongo1 ~]# ss -antup|grep 3306 tcp LISTEN 0 128 127.0.0.1:6013 *:* users:(("sshd",3306,23)) tcp LISTEN 0 128 ::1:6013 :::* users:(("sshd",3306,20)) tcp LISTEN 0 128 127.0.0.1:6010 *:* users:(("sshd",3306,8)) tcp LISTEN 0 128 ::1:6010 :::* users:(("sshd",3306,7)) tcp LISTEN 0 128 127.0.0.1:6011 *:* users:(("sshd",3306,13)) tcp LISTEN 0 128 ::1:6011 :::* users:(("sshd",3306,10)) tcp LISTEN 0 128 127.0.0.1:6012 *:* users:(("sshd",3306,18)) tcp LISTEN 0 128 ::1:6012 :::* users:(("sshd",3306,15)) tcp ESTAB 0 52 192.168.144.132:22 192.168.144.1:49249 users:(("sshd",3306,3)) [root@mymongo1 ~]# [root@mymongo1 ~]# /etc/init.d/drbd stop Stopping all DRBD resources: . [root@mymongo1 ~]#
[root@arbiter ~]# /etc/init.d/drbd stop Stopping all DRBD resources: . [root@arbiter ~]#
节点
数据
资源
服务
配置
状态
目录
存储
测试
主机
数据库
同步
文件
设备
控制
编译
相同
一致
名称
情况
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
orx操作风险数据库
小程序买什么数据库
数据库清空表
数据库CEO籍贯
网络安全和电脑基本操作
fm2022数据库选择不了
添加dfs第二台服务器报错
佛山市昇昊软件开发有限公司
e窗通软件开发公司
把握以网络技术 信息技术
如何使用数据库设计成绩表
网络安全流程和规范
津南区电子网络技术不二之选
魔域私服数据库错误
公安网络安全管理岗位面试
上海卓岚串口服务器固件
爱哇卡连接服务器超市
数据库文件很小还原时间很长
国泰安怎么批量拉数据库
阿里巴巴云服务器如何升级
汉化游戏怎么将数据库切换到繁体
数据库按姓氏查找学生
如何监控服务器状态
有主播的服务器
校园网络安全内容咋写
云管理控制服务器
应用程序服务器找不到
数据库统计学生的人数
北京戴尔服务器经销商
岚客互联网科技有限公司
