[Pacemaker] Working in virtual environment but not in physical.
Cayab, Jefrey E.
jcayab at gmail.com
Tue Jun 24 16:58:35 UTC 2014
Hi all,
I used the same steps in the attached guide to build the cluster in
physical environment but when i got to "crm_mon -1", i always get this
error:
Crm verify: Could not establish cib_ro connection: connection refused (111)
Connection to cluster failed: transport endpoint is not Connected.
Corosync configuration file is also attached. According to the network
team, the private network that I'm using (192.168.1.0/24) doesn't go
via firewall.
Please note that I was able to make this work in VMware Fusion; it
just don't want to cooperate in physical environment.
Could this be due to network issue on the private network?
I also noticed that with these steps, Pacemaker doesn't start on boot
even though Corosync starts fine.
Please let me know if there are missing packages that I need to install.
Appreciate your feedback(s).
Thanks,
Jef
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20140625/603f537f/attachment-0003.html>
-------------- next part --------------
[root at tstmysql04 ~]# cat anaconda-ks.cfg
# Kickstart file automatically generated by anaconda.
#version=DEVEL
install
cdrom
lang en_US.UTF-8
keyboard us
network --onboot yes --device eth0 --bootproto dhcp --noipv6
network --onboot yes --device eth1 --bootproto dhcp --noipv6
rootpw --iscrypted $6$wtzL/awjELmNIOri$wSICKvZWV4cwdVN6nAQMZiVF6I8rNXIPfm2I4CJF8IkMyn.9XpZWY3BPhTf.ZZkpo54.5p9Zy8TkSq.FVsPNp1
firewall --service=ssh
authconfig --enableshadow --passalgo=sha512
selinux --enforcing
timezone Asia/Singapore
bootloader --location=mbr --driveorder=sda --append="crashkernel=auto rhgb quiet"
# The following is the partition information you requested
# Note that any partitions you deleted are not expressed
# here so unless you clear all partitions first, this is
# not guaranteed to work
#clearpart --none
#part /boot --fstype=ext4 --asprimary --size=200
#part pv.008002 --grow --size=200
#volgroup vg00 --pesize=4096 pv.008002
#logvol /var/log/audit --fstype=ext4 --name=lvaudit --vgname=vg00 --size=5120
#logvol /home --fstype=ext4 --name=lvhome --vgname=vg00 --size=1024
#logvol /opt --fstype=ext4 --name=lvopt --vgname=vg00 --size=1024
#logvol / --fstype=ext4 --name=lvroot --vgname=vg00 --size=10240
#logvol swap --name=lvswap --vgname=vg00 --size=4096
#logvol /tmp --fstype=ext4 --name=lvtmp --vgname=vg00 --size=5120
#logvol /var --fstype=ext4 --name=lvvar --vgname=vg00 --size=5120
#logvol /var/log --fstype=ext4 --name=lvvarlog --vgname=vg00 --size=10240
%packages
@core
@server-policy
%end
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lvroot 9.9G 778M 8.6G 9% /
tmpfs 935M 0 935M 0% /dev/shm
/dev/sda1 194M 28M 156M 16% /boot
/dev/mapper/vg00-lvhome 1008M 34M 924M 4% /home
/dev/mapper/vg00-lvopt 1008M 34M 924M 4% /opt
/dev/mapper/vg00-lvtmp 5.0G 138M 4.6G 3% /tmp
/dev/mapper/vg00-lvvar 5.0G 159M 4.6G 4% /var
/dev/mapper/vg00-lvvarlog 9.9G 152M 9.2G 2% /var/log
/dev/mapper/vg00-lvaudit 5.0G 139M 4.6G 3% /var/log/audit
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
[root at tstmysql04 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
TYPE=Ethernet
UUID=694252de-b37b-416c-923e-c651610cfcaf
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=static
IPADDR=172.16.45.158
PREFIX=24
GATEWAY=172.16.45.2
HWADDR=00:0C:29:3F:EA:36
DEFROUTE=yes
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth0"
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth1
[root at tstmysql04 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
TYPE=Ethernet
UUID=c4ed117f-44bb-4689-b4c5-1f87d140ca62
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=static
IPADDR=192.168.131.134
PREFIX=24
HWADDR=00:50:56:2D:4C:B2
DEFROUTE=yes
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth1"
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vi /etc/sysconfig/network
[root at tstmysql04 ~]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=tstmysql04
GATEWAYDEV=eth0
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# shutdown -r now
[root at tstmysql04 ~]#
After reboot:
[root at tstmysql04 ~]# uptime
12:12:08 up 3 min, 1 user, load average: 0.00, 0.00, 0.00
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:3F:EA:36
inet addr:172.16.45.158 Bcast:172.16.45.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe3f:ea36/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:559 errors:0 dropped:0 overruns:0 frame:0
TX packets:300 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:52141 (50.9 KiB) TX bytes:40277 (39.3 KiB)
eth1 Link encap:Ethernet HWaddr 00:50:56:2D:4C:B2
inet addr:192.168.131.134 Bcast:192.168.131.255 Mask:255.255.255.0
inet6 addr: fe80::250:56ff:fe2d:4cb2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5 errors:0 dropped:0 overruns:0 frame:0
TX packets:15 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:340 (340.0 b) TX bytes:1010 (1010.0 b)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
[root at tstmysql04 ~]#
Second node:
[root at tstmysql05 ~]# cat anaconda-ks.cfg
# Kickstart file automatically generated by anaconda.
#version=DEVEL
install
cdrom
lang en_US.UTF-8
keyboard us
network --onboot yes --device eth0 --bootproto dhcp --noipv6
network --onboot yes --device eth1 --bootproto dhcp --noipv6
rootpw --iscrypted $6$5axDCh1AvGG8LumD$nCu3rRK6digBObEc5VGY/7P0nojy9icdwua2IUygG7E7/4EiU/znBqZy8uAk4x99/0QwAe6cVf4EYtQJJbNRE1
firewall --service=ssh
authconfig --enableshadow --passalgo=sha512
selinux --enforcing
timezone Asia/Singapore
bootloader --location=mbr --driveorder=sda --append="crashkernel=auto rhgb quiet"
# The following is the partition information you requested
# Note that any partitions you deleted are not expressed
# here so unless you clear all partitions first, this is
# not guaranteed to work
#clearpart --none
#part /boot --fstype=ext4 --asprimary --size=200
#part pv.008002 --grow --size=200
#volgroup vg00 --pesize=4096 pv.008002
#logvol /var/log/audit --fstype=ext4 --name=lvaudit --vgname=vg00 --size=5120
#logvol /home --fstype=ext4 --name=lvhome --vgname=vg00 --size=1024
#logvol /opt --fstype=ext4 --name=lvopt --vgname=vg00 --size=1024
#logvol / --fstype=ext4 --name=lvroot --vgname=vg00 --size=10240
#logvol swap --name=lvswap --vgname=vg00 --size=4096
#logvol /tmp --fstype=ext4 --name=lvtmp --vgname=vg00 --size=5120
#logvol /var --fstype=ext4 --name=lvvar --vgname=vg00 --size=5120
#logvol /var/log --fstype=ext4 --name=lvvarlog --vgname=vg00 --size=10240
%packages
@core
@server-policy
%end[root at tstmysql05 ~]#
[root at tstmysql05 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lvroot 9.9G 778M 8.6G 9% /
tmpfs 935M 0 935M 0% /dev/shm
/dev/sda1 194M 28M 156M 16% /boot
/dev/mapper/vg00-lvhome 1008M 34M 924M 4% /home
/dev/mapper/vg00-lvopt 1008M 34M 924M 4% /opt
/dev/mapper/vg00-lvtmp 5.0G 138M 4.6G 3% /tmp
/dev/mapper/vg00-lvvar 5.0G 159M 4.6G 4% /var
/dev/mapper/vg00-lvvarlog 9.9G 152M 9.2G 2% /var/log
/dev/mapper/vg00-lvaudit 5.0G 138M 4.6G 3% /var/log/audit
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
[root at tstmysql05 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
TYPE=Ethernet
UUID=70527a19-bd87-4138-b585-12d480ffd98e
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=static
IPADDR=172.16.45.159
PREFIX=24
GATEWAY=172.16.45.2
HWADDR=00:0C:29:4B:A7:D9
DEFROUTE=yes
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth0"
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth1
[root at tstmysql05 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
TYPE=Ethernet
UUID=92e54e37-5f66-4c4e-ac00-d03a354af703
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=static
IPADDR=192.168.131.135
PREFIX=24
HWADDR=00:50:56:3B:FD:7A
DEFROUTE=yes
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth1"
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vi /etc/sysconfig/network
[root at tstmysql05 ~]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=tstmysql05
GATEWAYDEV=eth0
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# shutdown -r now
After reboot:
[root at tstmysql05 ~]# uptime
12:27:10 up 0 min, 1 user, load average: 0.03, 0.01, 0.00
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:4B:A7:D9
inet addr:172.16.45.159 Bcast:172.16.45.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe4b:a7d9/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:59 errors:0 dropped:0 overruns:0 frame:0
TX packets:47 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:7297 (7.1 KiB) TX bytes:6443 (6.2 KiB)
eth1 Link encap:Ethernet HWaddr 00:50:56:3B:FD:7A
inet addr:192.168.131.135 Bcast:192.168.131.255 Mask:255.255.255.0
inet6 addr: fe80::250:56ff:fe3b:fd7a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5 errors:0 dropped:0 overruns:0 frame:0
TX packets:15 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:340 (340.0 b) TX bytes:1010 (1010.0 b)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# mkdir /mnt/iso
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# mount -o loop /dev/sr0 /mnt/iso
[root at tstmysql04 ~]# cp /mnt/iso/media.repo /etc/yum.repos.d/dvd.repo
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# echo -en "enabled=1\nbaseurl=file:///mnt/iso/Server" >> /etc/yum.repos.d/dvd.repo
[root at tstmysql04 ~]# cat /etc/yum.repos.d/dvd.repo
[InstallMedia]
name=Red Hat Enterprise Linux 6.5
mediaid=1384196515.415715
metadata_expire=-1
gpgcheck=0
cost=500
enabled=1
baseurl=file:///mnt/iso/Server[root@tstmysql04 ~]#
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# yum -y install nc nmap libedit openssh-clients wget perl parted libaio libesmtp OpenIPMI-libs cifs-utils gnutls keyutils libevent libgssglue libtalloc libtdb libtevent libtirpc libtool-ltdl lm_sensors-libs net-snmp-libs nfs-utils nfs-utils-lib openhpi-libs perl-TimeDate quota redhat-rpm-config rpcbind rsync samba-common samba-winbind samba-winbind-clients tcp_wrappers
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mkdir /mnt/iso
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mount -o loop /dev/sr0 /mnt/iso
[root at tstmysql05 ~]# cp /mnt/iso/media.repo /etc/yum.repos.d/dvd.repo
[root at tstmysql05 ~]# echo -en "enabled=1\nbaseurl=file:///mnt/iso/Server" >> /etc/yum.repos.d/dvd.repo
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# cat /etc/yum.repos.d/dvd.repo
[InstallMedia]
name=Red Hat Enterprise Linux 6.5
mediaid=1384196515.415715
metadata_expire=-1
gpgcheck=0
cost=500
enabled=1
baseurl=file:///mnt/iso/Server[root@tstmysql05 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# yum -y install nc nmap libedit openssh-clients wget perl parted libaio libesmtp OpenIPMI-libs cifs-utils gnutls keyutils libevent libgssglue libtalloc libtdb libtevent libtirpc libtool-ltdl lm_sensors-libs net-snmp-libs nfs-utils nfs-utils-lib openhpi-libs perl-TimeDate quota redhat-rpm-config rpcbind rsync samba-common samba-winbind samba-winbind-clients tcp_wrappers
[root at tstmysql05 ~]#
Add the additional disk for DRBD if not yet added.
[root at tstmysql04 ~]# fdisk -l /dev/sdb
Disk /dev/sdb: 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: 0x00000000
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# pvcreate /dev/sdb
Physical volume "/dev/sdb" successfully created
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vgcreate dbvg /dev/sdb
Volume group "dbvg" successfully created
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# lvcreate -L 10G -n mysqldata dbvg
Logical volume "mysqldata" created
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# lvs
LV VG Attr LSize Pool Origin Data% Move Log Cpy%Sync Convert
mysqldata dbvg -wi-a----- 10.00g
lvaudit vg00 -wi-ao---- 5.00g
lvhome vg00 -wi-ao---- 1.00g
lvopt vg00 -wi-ao---- 1.00g
lvroot vg00 -wi-ao---- 10.00g
lvswap vg00 -wi-ao---- 4.00g
lvtmp vg00 -wi-ao---- 5.00g
lvvar vg00 -wi-ao---- 5.00g
lvvarlog vg00 -wi-ao---- 10.00g
[root at tstmysql04 ~]#
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# fdisk -l /dev/sdb
Disk /dev/sdb: 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: 0x00000000
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# pvcreate /dev/sdb
Physical volume "/dev/sdb" successfully created
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vgcreate dbvg /dev/sdb
Volume group "dbvg" successfully created
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# lvcreate -L 10G -n mysqldata dbvg
Logical volume "mysqldata" created
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# lvs
LV VG Attr LSize Pool Origin Data% Move Log Cpy%Sync Convert
mysqldata dbvg -wi-a----- 10.00g
lvaudit vg00 -wi-ao---- 5.00g
lvhome vg00 -wi-ao---- 1.00g
lvopt vg00 -wi-ao---- 1.00g
lvroot vg00 -wi-ao---- 10.00g
lvswap vg00 -wi-ao---- 4.00g
lvtmp vg00 -wi-ao---- 5.00g
lvvar vg00 -wi-ao---- 5.00g
lvvarlog vg00 -wi-ao---- 10.00g
[root at tstmysql05 ~]#
Copy Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz to both nodes then extract it:
[root at tstmysql04 ~]# ls -lrt
total 9708
-rw-r--r--. 1 root root 3161 Jun 7 12:02 install.log.syslog
-rw-r--r--. 1 root root 10544 Jun 7 12:03 install.log
-rw-------. 1 root root 1468 Jun 7 12:03 anaconda-ks.cfg
-rw-r--r--. 1 root root 9918677 Jun 7 12:54 Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# mkdir RPMs
[root at tstmysql04 ~]# tar -xvzf Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz -C RPMs/
URL.txt
cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-devel-1.0.12-0.rc1.6.3.x86_64.rpm
corosync-1.4.5-2.4.x86_64.rpm
corosync-debuginfo-1.4.5-2.4.x86_64.rpm
corosynclib-1.4.5-2.4.x86_64.rpm
corosynclib-devel-1.4.5-2.4.x86_64.rpm
crmsh-2.0+git46-1.1.x86_64.rpm
crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm
crmsh-test-2.0+git46-1.1.x86_64.rpm
drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
ldirectord-3.9.5-3.7.x86_64.rpm
libqb-debuginfo-0.14.4-1.4.x86_64.rpm
libqb-devel-0.14.4-1.4.x86_64.rpm
libqb0-0.14.4-1.4.x86_64.rpm
pacemaker-1.1.9-2.7.x86_64.rpm
pacemaker-cli-1.1.9-2.7.x86_64.rpm
pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm
pacemaker-cts-1.1.9-2.7.x86_64.rpm
pacemaker-debuginfo-1.1.9-2.7.x86_64.rpm
pacemaker-doc-1.1.9-2.7.x86_64.rpm
pacemaker-libs-1.1.9-2.7.x86_64.rpm
pacemaker-libs-devel-1.1.9-2.7.x86_64.rpm
pacemaker-remote-1.1.9-2.7.x86_64.rpm
pssh-2.3.1-4.1.x86_64.rpm
pssh-debuginfo-2.3.1-4.1.x86_64.rpm
python-pssh-2.3.1-4.1.x86_64.rpm
resource-agents-3.9.5-3.7.x86_64.rpm
resource-agents-debuginfo-3.9.5-3.7.x86_64.rpm
sbd-1.1-4.6.x86_64.rpm
sbd-debuginfo-1.1-4.6.x86_64.rpm
xfsprogs-3.1.1-14.el6.x86_64.rpm
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# ls -lrt
total 9708
-rw-r--r--. 1 root root 3161 Jun 7 12:02 install.log.syslog
-rw-r--r--. 1 root root 10544 Jun 7 12:03 install.log
-rw-------. 1 root root 1468 Jun 7 12:03 anaconda-ks.cfg
-rw-r--r--. 1 root root 9918677 Jun 7 12:54 Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mkdir RPMs
[root at tstmysql05 ~]# tar -xvzf Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz -C RPMs/
URL.txt
cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-devel-1.0.12-0.rc1.6.3.x86_64.rpm
corosync-1.4.5-2.4.x86_64.rpm
corosync-debuginfo-1.4.5-2.4.x86_64.rpm
corosynclib-1.4.5-2.4.x86_64.rpm
corosynclib-devel-1.4.5-2.4.x86_64.rpm
crmsh-2.0+git46-1.1.x86_64.rpm
crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm
crmsh-test-2.0+git46-1.1.x86_64.rpm
drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
ldirectord-3.9.5-3.7.x86_64.rpm
libqb-debuginfo-0.14.4-1.4.x86_64.rpm
libqb-devel-0.14.4-1.4.x86_64.rpm
libqb0-0.14.4-1.4.x86_64.rpm
pacemaker-1.1.9-2.7.x86_64.rpm
pacemaker-cli-1.1.9-2.7.x86_64.rpm
pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm
pacemaker-cts-1.1.9-2.7.x86_64.rpm
pacemaker-debuginfo-1.1.9-2.7.x86_64.rpm
pacemaker-doc-1.1.9-2.7.x86_64.rpm
pacemaker-libs-1.1.9-2.7.x86_64.rpm
pacemaker-libs-devel-1.1.9-2.7.x86_64.rpm
pacemaker-remote-1.1.9-2.7.x86_64.rpm
pssh-2.3.1-4.1.x86_64.rpm
pssh-debuginfo-2.3.1-4.1.x86_64.rpm
python-pssh-2.3.1-4.1.x86_64.rpm
resource-agents-3.9.5-3.7.x86_64.rpm
resource-agents-debuginfo-3.9.5-3.7.x86_64.rpm
sbd-1.1-4.6.x86_64.rpm
sbd-debuginfo-1.1-4.6.x86_64.rpm
xfsprogs-3.1.1-14.el6.x86_64.rpm
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# cd RPMs/
[root at tstmysql04 RPMs]# rpm -ivh kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
warning: kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY
error: Failed dependencies:
drbd84-utils >= 8.4.4 is needed by kmod-drbd84-8.4.4-1.el6.elrepo.x86_64
[root at tstmysql04 RPMs]#
[root at tstmysql04 RPMs]# rpm -ivh drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
warning: drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY
Preparing... ########################################### [100%]
1:drbd84-utils ########################################### [100%]
[root at tstmysql04 RPMs]#
[root at tstmysql04 RPMs]# rpm -ivh kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
warning: kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY
Preparing... ########################################### [100%]
1:kmod-drbd84 ########################################### [100%]
Working. This may take some time ...
Done.
[root at tstmysql04 RPMs]# rpm -ivh xfsprogs-3.1.1-14.el6.x86_64.rpm
warning: xfsprogs-3.1.1-14.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:xfsprogs ########################################### [100%]
[root at tstmysql04 RPMs]#
[root at tstmysql04 RPMs]# modprobe drbd
[root at tstmysql04 RPMs]# lsmod | grep dr
drbd 333755 0
libcrc32c 1246 1 drbd
cdrom 39085 1 sr_mod
[root at tstmysql04 RPMs]#
[root at tstmysql04 RPMs]# cd
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lrt
total 230196
-rw-r--r--. 1 root root 3161 Jun 7 12:02 install.log.syslog
-rw-r--r--. 1 root root 10544 Jun 7 12:03 install.log
-rw-------. 1 root root 1468 Jun 7 12:03 anaconda-ks.cfg
-rw-r--r--. 1 root root 9918677 Jun 7 12:54 Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz
drwxr-xr-x. 2 root root 4096 Jun 7 12:55 RPMs
-rw-r--r--. 1 root root 225772294 Jun 7 13:25 V44510-01.zip
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# unzip V44510-01.zip
Archive: V44510-01.zip
extracting: MySQL-shared-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-shared-compat-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-embedded-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-test-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm
extracting: MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
extracting: README.txt
[root at tstmysql04 ~]#
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lrt
total 450688
-rw-r--r--. 1 root root 18434960 Apr 10 10:34 MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 3301304 Apr 10 10:34 MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 85937880 Apr 10 10:34 MySQL-embedded-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 62388140 Apr 10 10:34 MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 2021976 Apr 10 10:34 MySQL-shared-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 3945160 Apr 10 10:34 MySQL-shared-compat-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 49740592 Apr 10 10:35 MySQL-test-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 990 Apr 14 18:22 README.txt
-rw-r--r--. 1 root root 3161 Jun 7 12:02 install.log.syslog
-rw-r--r--. 1 root root 10544 Jun 7 12:03 install.log
-rw-------. 1 root root 1468 Jun 7 12:03 anaconda-ks.cfg
-rw-r--r--. 1 root root 9918677 Jun 7 12:54 Pacemaker_Corosync_RPMs_for_RHEL6.5.tgz
drwxr-xr-x. 2 root root 4096 Jun 7 12:55 RPMs
-rw-r--r--. 1 root root 225772294 Jun 7 13:25 V44510-01.zip
[root at tstmysql04 ~]#
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# rpm -ivh MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel-advanced ########################################### [100%]
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# rpm -ivh MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client-advanced ########################################### [100%]
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# rpm -ivh MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm --replacefiles
Preparing... ########################################### [100%]
1:MySQL-server-advanced ########################################### [100%]
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
2014-06-07 13:29:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-07 13:29:02 12015 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-07 13:29:02 12015 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-07 13:29:02 12015 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-07 13:29:02 12015 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-07 13:29:02 12015 [Note] InnoDB: Using Linux native AIO
2014-06-07 13:29:02 12015 [Note] InnoDB: Using CPU crc32 instructions
2014-06-07 13:29:02 12015 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-07 13:29:02 12015 [Note] InnoDB: Completed initialization of buffer pool
2014-06-07 13:29:02 12015 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-06-07 13:29:02 12015 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-06-07 13:29:02 12015 [Note] InnoDB: Database physically writes the file full: wait...
2014-06-07 13:29:02 12015 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-06-07 13:29:02 12015 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-06-07 13:29:03 12015 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-06-07 13:29:03 12015 [Warning] InnoDB: New log files created, LSN=45781
2014-06-07 13:29:03 12015 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-06-07 13:29:03 12015 [Note] InnoDB: Doublewrite buffer created
2014-06-07 13:29:03 12015 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-07 13:29:03 12015 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-06-07 13:29:03 12015 [Note] InnoDB: Foreign key constraint system tables created
2014-06-07 13:29:03 12015 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-06-07 13:29:03 12015 [Note] InnoDB: Tablespace and datafile system tables created.
2014-06-07 13:29:03 12015 [Note] InnoDB: Waiting for purge to start
2014-06-07 13:29:03 12015 [Note] InnoDB: 5.6.18 started; log sequence number 0
2014-06-07 13:29:03 12015 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-07 13:29:03 12015 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
A random root password has been set. You will find it in '/root/.mysql_secret'.
2014-06-07 13:29:03 12015 [Note] Binlog end
2014-06-07 13:29:03 12015 [Note] InnoDB: FTS optimize thread exiting.
2014-06-07 13:29:03 12015 [Note] InnoDB: Starting shutdown...
2014-06-07 13:29:05 12015 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2014-06-07 13:29:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-07 13:29:05 12038 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-07 13:29:05 12038 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-07 13:29:05 12038 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-07 13:29:05 12038 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-07 13:29:05 12038 [Note] InnoDB: Using Linux native AIO
2014-06-07 13:29:05 12038 [Note] InnoDB: Using CPU crc32 instructions
2014-06-07 13:29:05 12038 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-07 13:29:05 12038 [Note] InnoDB: Completed initialization of buffer pool
2014-06-07 13:29:05 12038 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-07 13:29:05 12038 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-07 13:29:05 12038 [Note] InnoDB: Waiting for purge to start
2014-06-07 13:29:05 12038 [Note] InnoDB: 5.6.18 started; log sequence number 1625977
2014-06-07 13:29:05 12038 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-07 13:29:05 12038 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-06-07 13:29:05 12038 [Note] Binlog end
2014-06-07 13:29:05 12038 [Note] InnoDB: FTS optimize thread exiting.
2014-06-07 13:29:05 12038 [Note] InnoDB: Starting shutdown...
2014-06-07 13:29:06 12038 [Note] InnoDB: Shutdown completed; log sequence number 1625987
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test database.
This is strongly recommended for production servers.
See the manual for more instructions.
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
New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
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 at tstmysql04 ~]#
I installed the rest of the RPMs manually to know the sequence for script creation.
Here's the result of the script which I executed in the other node:
[root at tstmysql05 ~]# tar -xvzf DRBD_Pacemaker_Corosync_Installer_for_RHEL6.5.tgz -C RPMs/
cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm
cluster-glue-libs-devel-1.0.12-0.rc1.6.3.x86_64.rpm
corosync-1.4.5-2.4.x86_64.rpm
corosync-debuginfo-1.4.5-2.4.x86_64.rpm
corosynclib-1.4.5-2.4.x86_64.rpm
corosynclib-devel-1.4.5-2.4.x86_64.rpm
crmsh-2.0+git46-1.1.x86_64.rpm
crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm
crmsh-test-2.0+git46-1.1.x86_64.rpm
drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
installRPMs.sh
kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
ldirectord-3.9.5-3.7.x86_64.rpm
libqb0-0.14.4-1.4.x86_64.rpm
libqb-debuginfo-0.14.4-1.4.x86_64.rpm
libqb-devel-0.14.4-1.4.x86_64.rpm
MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm
pacemaker-1.1.9-2.7.x86_64.rpm
pacemaker-cli-1.1.9-2.7.x86_64.rpm
pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm
pacemaker-cts-1.1.9-2.7.x86_64.rpm
pacemaker-debuginfo-1.1.9-2.7.x86_64.rpm
pacemaker-doc-1.1.9-2.7.x86_64.rpm
pacemaker-libs-1.1.9-2.7.x86_64.rpm
pacemaker-libs-devel-1.1.9-2.7.x86_64.rpm
pacemaker-remote-1.1.9-2.7.x86_64.rpm
pssh-2.3.1-4.1.x86_64.rpm
pssh-debuginfo-2.3.1-4.1.x86_64.rpm
python-pssh-2.3.1-4.1.x86_64.rpm
resource-agents-3.9.5-3.7.x86_64.rpm
resource-agents-debuginfo-3.9.5-3.7.x86_64.rpm
sbd-1.1-4.6.x86_64.rpm
sbd-debuginfo-1.1-4.6.x86_64.rpm
URL.txt
xfsprogs-3.1.1-14.el6.x86_64.rpm
[root at tstmysql05 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# cd RPMs/
[root at tstmysql05 RPMs]#
[root at tstmysql05 RPMs]#
[root at tstmysql05 RPMs]# ls -lrt
total 93164
-rw-r--r--. 1 501 games 182164 Oct 15 2013 kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
-rw-r--r--. 1 501 games 302728 Oct 25 2013 drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
-rw-r--r--. 1 501 games 119704 Apr 7 20:19 cluster-glue-libs-devel-1.0.12-0.rc1.6.3.x86_64.rpm
-rw-r--r--. 1 501 games 578676 Apr 7 20:26 resource-agents-3.9.5-3.7.x86_64.rpm
-rw-r--r--. 1 501 games 741636 Jun 1 00:44 xfsprogs-3.1.1-14.el6.x86_64.rpm
-rwxrwxrwx. 1 501 games 180752 Jun 2 02:13 corosync-1.4.5-2.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 248768 Jun 2 02:13 cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm
-rwxrwxrwx. 1 501 games 129996 Jun 2 02:13 cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm
-rwxrwxrwx. 1 501 games 694288 Jun 2 02:13 cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm
-rwxrwxrwx. 1 501 games 159216 Jun 2 02:13 corosynclib-1.4.5-2.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 1027104 Jun 2 02:13 corosync-debuginfo-1.4.5-2.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 186712 Jun 2 02:13 corosynclib-devel-1.4.5-2.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 610624 Jun 2 02:13 crmsh-2.0+git46-1.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 22300 Jun 2 02:13 crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 103172 Jun 2 02:13 crmsh-test-2.0+git46-1.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 90552 Jun 2 02:13 ldirectord-3.9.5-3.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 196092 Jun 2 02:13 libqb-debuginfo-0.14.4-1.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 65308 Jun 2 02:14 libqb-devel-0.14.4-1.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 73088 Jun 2 02:14 libqb0-0.14.4-1.4.x86_64.rpm
-rwxrwxrwx. 1 501 games 497888 Jun 2 02:14 pacemaker-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 134076 Jun 2 02:14 pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 247364 Jun 2 02:14 pacemaker-cli-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 242072 Jun 2 02:14 pacemaker-cts-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 1902736 Jun 2 02:14 pacemaker-debuginfo-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 125440 Jun 2 02:14 pacemaker-doc-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 486704 Jun 2 02:14 pacemaker-libs-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 1382744 Jun 2 02:15 pacemaker-libs-devel-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 128880 Jun 2 02:15 pacemaker-remote-1.1.9-2.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 27088 Jun 2 02:15 pssh-2.3.1-4.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 5184 Jun 2 02:15 pssh-debuginfo-2.3.1-4.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 43172 Jun 2 02:15 python-pssh-2.3.1-4.1.x86_64.rpm
-rwxrwxrwx. 1 501 games 171880 Jun 2 02:15 resource-agents-debuginfo-3.9.5-3.7.x86_64.rpm
-rwxrwxrwx. 1 501 games 37392 Jun 2 02:15 sbd-1.1-4.6.x86_64.rpm
-rwxrwxrwx. 1 501 games 53036 Jun 2 02:15 sbd-debuginfo-1.1-4.6.x86_64.rpm
-rwxrwxrwx. 1 501 games 105 Jun 2 02:16 URL.txt
-rw-r--r--. 1 root root 3301304 Jun 7 14:26 MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 18434960 Jun 7 14:26 MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
-rw-r--r--. 1 root root 62388140 Jun 7 14:26 MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm
-rwxr--r--. 1 root root 1289 Jun 7 14:37 installRPMs.sh
[root at tstmysql05 RPMs]#
[root at tstmysql05 RPMs]#
[root at tstmysql05 RPMs]#
[root at tstmysql05 RPMs]# sh -x installRPMs.sh
+ rpm -ivh ./drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm
warning: ./drbd84-utils-8.4.4-2.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY
Preparing... ########################################### [100%]
1:drbd84-utils ########################################### [100%]
+ rpm -ivh ./kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm
warning: ./kmod-drbd84-8.4.4-1.el6.elrepo.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID baadae52: NOKEY
Preparing... ########################################### [100%]
1:kmod-drbd84 ########################################### [100%]
Working. This may take some time ...
Done.
+ modprobe drbd
+ rpm -ivh ./xfsprogs-3.1.1-14.el6.x86_64.rpm
warning: ./xfsprogs-3.1.1-14.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:xfsprogs ########################################### [100%]
+ rpm -ivh ./MySQL-devel-advanced-5.6.18-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel-advanced ########################################### [100%]
+ rpm -ivh ./MySQL-client-advanced-5.6.18-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client-advanced ########################################### [100%]
+ rpm -ivh ./MySQL-server-advanced-5.6.18-1.el6.x86_64.rpm --replacefiles
Preparing... ########################################### [100%]
1:MySQL-server-advanced ########################################### [100%]
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
2014-06-07 14:39:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-07 14:39:53 12101 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-07 14:39:53 12101 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-07 14:39:53 12101 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-07 14:39:53 12101 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-07 14:39:53 12101 [Note] InnoDB: Using Linux native AIO
2014-06-07 14:39:53 12101 [Note] InnoDB: Using CPU crc32 instructions
2014-06-07 14:39:53 12101 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-07 14:39:53 12101 [Note] InnoDB: Completed initialization of buffer pool
2014-06-07 14:39:53 12101 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-06-07 14:39:53 12101 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-06-07 14:39:53 12101 [Note] InnoDB: Database physically writes the file full: wait...
2014-06-07 14:39:53 12101 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-06-07 14:39:54 12101 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-06-07 14:39:54 12101 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-06-07 14:39:54 12101 [Warning] InnoDB: New log files created, LSN=45781
2014-06-07 14:39:54 12101 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-06-07 14:39:54 12101 [Note] InnoDB: Doublewrite buffer created
2014-06-07 14:39:54 12101 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-07 14:39:54 12101 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-06-07 14:39:54 12101 [Note] InnoDB: Foreign key constraint system tables created
2014-06-07 14:39:54 12101 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-06-07 14:39:54 12101 [Note] InnoDB: Tablespace and datafile system tables created.
2014-06-07 14:39:54 12101 [Note] InnoDB: Waiting for purge to start
2014-06-07 14:39:54 12101 [Note] InnoDB: 5.6.18 started; log sequence number 0
2014-06-07 14:39:54 12101 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-07 14:39:54 12101 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
A random root password has been set. You will find it in '/root/.mysql_secret'.
2014-06-07 14:39:54 12101 [Note] Binlog end
2014-06-07 14:39:54 12101 [Note] InnoDB: FTS optimize thread exiting.
2014-06-07 14:39:54 12101 [Note] InnoDB: Starting shutdown...
2014-06-07 14:39:56 12101 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2014-06-07 14:39:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-07 14:39:56 12124 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-07 14:39:56 12124 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-07 14:39:56 12124 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-07 14:39:56 12124 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-07 14:39:56 12124 [Note] InnoDB: Using Linux native AIO
2014-06-07 14:39:56 12124 [Note] InnoDB: Using CPU crc32 instructions
2014-06-07 14:39:56 12124 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-07 14:39:56 12124 [Note] InnoDB: Completed initialization of buffer pool
2014-06-07 14:39:56 12124 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-07 14:39:56 12124 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-07 14:39:56 12124 [Note] InnoDB: Waiting for purge to start
2014-06-07 14:39:56 12124 [Note] InnoDB: 5.6.18 started; log sequence number 1625977
2014-06-07 14:39:56 12124 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-07 14:39:56 12124 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-06-07 14:39:56 12124 [Note] Binlog end
2014-06-07 14:39:56 12124 [Note] InnoDB: FTS optimize thread exiting.
2014-06-07 14:39:56 12124 [Note] InnoDB: Starting shutdown...
2014-06-07 14:39:58 12124 [Note] InnoDB: Shutdown completed; log sequence number 1625987
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test database.
This is strongly recommended for production servers.
See the manual for more instructions.
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
New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
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
+ rpm -ivh ./sbd-debuginfo-1.1-4.6.x86_64.rpm
warning: ./sbd-debuginfo-1.1-4.6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:sbd-debuginfo ########################################### [100%]
+ rpm -ivh ./cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm
warning: ./cluster-glue-libs-1.0.12-0.rc1.6.3.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:cluster-glue-libs ########################################### [100%]
+ rpm -ivh ./cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm
warning: ./cluster-glue-debuginfo-1.0.12-0.rc1.6.3.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:cluster-glue-debuginfo ########################################### [100%]
+ rpm -ivh ./libqb0-0.14.4-1.4.x86_64.rpm
warning: ./libqb0-0.14.4-1.4.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:libqb0 ########################################### [100%]
+ rpm -ivh ./pacemaker-libs-1.1.9-2.7.x86_64.rpm
warning: ./pacemaker-libs-1.1.9-2.7.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:pacemaker-libs ########################################### [100%]
+ rpm -ivh ./corosync-debuginfo-1.4.5-2.4.x86_64.rpm
warning: ./corosync-debuginfo-1.4.5-2.4.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:corosync-debuginfo ########################################### [100%]
+ rpm -ivh ./crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm
warning: ./crmsh-debuginfo-2.0+git46-1.1.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:crmsh-debuginfo ########################################### [100%]
+ rpm -ivh ./corosynclib-1.4.5-2.4.x86_64.rpm --nodeps
warning: ./corosynclib-1.4.5-2.4.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:corosynclib ########################################### [100%]
+ rpm -ivh ./corosync-1.4.5-2.4.x86_64.rpm
warning: ./corosync-1.4.5-2.4.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:corosync ########################################### [100%]
+ rpm -ivh ./pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm
warning: ./pacemaker-cluster-libs-1.1.9-2.7.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:pacemaker-cluster-libs ########################################### [100%]
+ rpm -ivh ./sbd-1.1-4.6.x86_64.rpm
warning: ./sbd-1.1-4.6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:sbd ########################################### [100%]
+ rpm -ivh ./pacemaker-cli-1.1.9-2.7.x86_64.rpm
warning: ./pacemaker-cli-1.1.9-2.7.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:pacemaker-cli ########################################### [100%]
+ rpm -ivh ./python-pssh-2.3.1-4.1.x86_64.rpm
warning: ./python-pssh-2.3.1-4.1.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:python-pssh ########################################### [100%]
+ rpm -ivh ./pssh-2.3.1-4.1.x86_64.rpm
warning: ./pssh-2.3.1-4.1.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:pssh ########################################### [100%]
+ rpm -ivh ./cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm
warning: ./cluster-glue-1.0.12-0.rc1.6.3.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:cluster-glue ########################################### [100%]
+ rpm -ivh ./resource-agents-3.9.5-3.7.x86_64.rpm --replacefiles
warning: ./resource-agents-3.9.5-3.7.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:resource-agents ########################################### [100%]
+ rpm -ivh ./pacemaker-1.1.9-2.7.x86_64.rpm
warning: ./pacemaker-1.1.9-2.7.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:pacemaker ########################################### [100%]
+ rpm -ivh ./crmsh-2.0+git46-1.1.x86_64.rpm
warning: ./crmsh-2.0+git46-1.1.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 17280ddf: NOKEY
Preparing... ########################################### [100%]
1:crmsh ########################################### [100%]
[root at tstmysql05 RPMs]#
Time to configure DRBD:
[root at tstmysql04 RPMs]# cp -pr /etc/drbd.conf /etc/drbd.conf-DIST
[root at tstmysql04 RPMs]# sha1sum /etc/drbd.conf
8a6c5f3c21b84c66049456d34b4c4980468bcfb3 /etc/drbd.conf
[root at tstmysql04 RPMs]#
root at tstmysql04 RPMs]# vi /etc/drbd.conf
[root at tstmysql04 RPMs]# cat /etc/drbd.conf
# You can find an example in /usr/share/doc/drbd.../drbd.conf.example
include "drbd.d/global_common.conf";
include "drbd.d/*.res";
resource data {
protocol C;
net {
cram-hmac-alg sha1;
shared-secret "8a6c5f3c21b84c66049456d34b4c4980468bcfb3";
after-sb-0pri discard-zero-changes;
after-sb-1pri discard-secondary;
after-sb-2pri disconnect;
rr-conflict disconnect;
}
device /dev/drbd0;
disk /dev/dbvg/mysqldata;
meta-disk internal;
on tstmysql04 {
address 192.168.131.134:7789;
}
on tstmysql05 {
address 192.168.131.135:7789;
}
}
[root at tstmysql04 RPMs]#
root at tstmysql05 RPMs]# cp -pr /etc/drbd.conf /etc/drbd.conf-DIST
[root at tstmysql05 RPMs]# cd
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# sha1sum /etc/drbd.conf
8a6c5f3c21b84c66049456d34b4c4980468bcfb3 /etc/drbd.conf
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vi /etc/drbd.conf
[root at tstmysql05 ~]# cat /etc/drbd.conf
# You can find an example in /usr/share/doc/drbd.../drbd.conf.example
include "drbd.d/global_common.conf";
include "drbd.d/*.res";
resource data {
protocol C;
net {
cram-hmac-alg sha1;
shared-secret "8a6c5f3c21b84c66049456d34b4c4980468bcfb3";
after-sb-0pri discard-zero-changes;
after-sb-1pri discard-secondary;
after-sb-2pri disconnect;
rr-conflict disconnect;
}
device /dev/drbd0;
disk /dev/dbvg/mysqldata;
meta-disk internal;
on tstmysql04 {
address 192.168.131.134:7789;
}
on tstmysql05 {
address 192.168.131.135:7789;
}
}
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# drbdadm create-md data
--== Thank you for participating in the global usage survey ==--
The server's response is:
you are the 10050th user to install this version
Writing meta data...
initializing activity log
NOT initializing bitmap
New drbd meta data block successfully created.
success
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# drbdadm create-md data
--== Thank you for participating in the global usage survey ==--
The server's response is:
you are the 10051th user to install this version
Writing meta data...
initializing activity log
NOT initializing bitmap
New drbd meta data block successfully created.
success
[root at tstmysql05 ~]#
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# drbdadm up data
[root at tstmysql04 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# drbdadm up data
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# iptables -I INPUT -p tcp -s 192.168.131.135 --dport 7789 -j ACCEPT
[root at tstmysql04 ~]# iptables -I INPUT -p udp -m state --state NEW -m multiport --dports 5404,5405,5409,5411 -j ACCEPT
[root at tstmysql04 ~]# iptables -I INPUT -p tcp -m tcp --dport 7788 -j ACCEPT
[root at tstmysql04 ~]# iptables -I INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# iptables -I INPUT -p tcp -s 192.168.131.134 --dport 7789 -j ACCEPT
[root at tstmysql05 ~]# iptables -I INPUT -p udp -m state --state NEW -m multiport --dports 5404,5405,5409,5411 -j ACCEPT
[root at tstmysql05 ~]# iptables -I INPUT -p tcp -m tcp --dport 7788 -j ACCEPT
[root at tstmysql05 ~]# iptables -I INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent 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:f oos:10485404
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent 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:f oos:10485404
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# drbdadm -- --overwrite-data-of-peer primary data
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r-----
ns:32724 nr:0 dw:0 dr:33760 al:0 bm:1 lo:0 pe:1 ua:2 ap:0 ep:1 wo:f oos:10452892
[>....................] sync'ed: 0.4% (10204/10236)M
finish: 0:42:29 speed: 4,064 (4,064) K/sec
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:SyncTarget ro:Secondary/Primary ds:Inconsistent/UpToDate C r-----
ns:0 nr:8256 dw:8256 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:10477148
[>....................] sync'ed: 0.2% (10228/10236)M
finish: 1:23:09 speed: 2,064 (2,064) want: 3,480 K/sec
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r-----
ns:8117248 nr:0 dw:0 dr:8117912 al:0 bm:495 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:2368156
[==============>.....] sync'ed: 77.5% (2312/10236)M
finish: 0:00:55 speed: 42,892 (36,400) K/sec
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
ns:10485404 nr:0 dw:0 dr:10486068 al:0 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Primary ds:UpToDate/UpToDate C r-----
ns:0 nr:10485404 dw:10485404 dr:0 al:0 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql05 ~]
[root at tstmysql04 ~]# mkfs.ext4 /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
655360 inodes, 2621351 blocks
131067 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2684354560
80 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 21 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# mkdir /mysql
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# mount /dev/drbd0 /mysql
[root at tstmysql04 ~]# rmdir /mysql/lost+found/
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lvroot 9.9G 1.9G 7.6G 20% /
tmpfs 935M 0 935M 0% /dev/shm
/dev/sda1 194M 28M 156M 16% /boot
/dev/mapper/vg00-lvhome 1008M 34M 924M 4% /home
/dev/mapper/vg00-lvopt 1008M 34M 924M 4% /opt
/dev/mapper/vg00-lvtmp 5.0G 138M 4.6G 3% /tmp
/dev/mapper/vg00-lvvar 5.0G 289M 4.4G 7% /var
/dev/mapper/vg00-lvvarlog 9.9G 152M 9.2G 2% /var/log
/dev/mapper/vg00-lvaudit 5.0G 139M 4.6G 3% /var/log/audit
/dev/drbd0 9.9G 151M 9.2G 2% /mysql
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# umount /mysql
[root at tstmysql04 ~]# drbdadm secondary data
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r-----
ns:10783176 nr:0 dw:297772 dr:10486785 al:79 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r-----
ns:0 nr:10783176 dw:10783176 dr:0 al:0 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# drbdadm primary data
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
ns:0 nr:10783176 dw:10783176 dr:664 al:0 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mkdir /mysql
[root at tstmysql05 ~]# mount /dev/drbd0 /mysql
[root at tstmysql05 ~]# rmdir /mysql/lost+found/
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lvroot 9.9G 1.7G 7.8G 18% /
tmpfs 935M 0 935M 0% /dev/shm
/dev/sda1 194M 28M 156M 16% /boot
/dev/mapper/vg00-lvhome 1008M 34M 924M 4% /home
/dev/mapper/vg00-lvopt 1008M 34M 924M 4% /opt
/dev/mapper/vg00-lvtmp 5.0G 138M 4.6G 3% /tmp
/dev/mapper/vg00-lvvar 5.0G 289M 4.4G 7% /var
/dev/mapper/vg00-lvvarlog 9.9G 152M 9.2G 2% /var/log
/dev/mapper/vg00-lvaudit 5.0G 139M 4.6G 3% /var/log/audit
/dev/sr0 3.6G 3.6G 0 100% /mnt/iso
/dev/drbd0 9.9G 151M 9.2G 2% /mysql
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# umount /mysql
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# drbdadm secondary data
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Secondary/Secondary ds:UpToDate/UpToDate C r-----
ns:8 nr:10783176 dw:10783184 dr:1013 al:1 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# drbdadm primary data
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# cat /proc/drbd
version: 8.4.4 (api:1/proto:86-101)
GIT-hash: 599f286440bd633d15d5ff985204aff4bccffadd build by phil at Build64R6, 2013-10-14 15:33:06
0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
ns:10783176 nr:8 dw:297780 dr:10487449 al:79 bm:640 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# service mysql start
Starting MySQL. SUCCESS!
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# service mysql status
SUCCESS! MySQL running (12569)
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# cat .mysql_secret
# The random password set for the root user at Sat Jun 7 13:29:03 2014 (local time): QAjBRlKuiyVBirt1
[root at tstmysql04 ~]# mysql_secure_installation
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Cleaning up...
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.6.18-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2014, 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 |
+--------------------+
3 rows in set (0.00 sec)
mysql>
mysql> CREATE DATABASE testdb;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| testdb |
+--------------------+
4 rows in set (0.00 sec)
mysql>
mysql> \q
Bye
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# service mysql start
Starting MySQL.. SUCCESS!
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# service mysql status
SUCCESS! MySQL running (12525)
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# cat .mysql_secret
# The random password set for the root user at Sat Jun 7 14:39:54 2014 (local time): Ri_7rymFjqqSmBVa
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mysql_secure_installation
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Cleaning up...
[root at tstmysql05 ~]#
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.6.18-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2014, 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 |
+--------------------+
3 rows in set (0.00 sec)
mysql>
mysql> \q
Bye
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# cp /etc/my.cnf /etc/my.cnf.orig
[root at tstmysql04 ~]# service mysql stop
Shutting down MySQL.. SUCCESS!
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# cp -arv /var/lib/mysql/* /mysql/
`/var/lib/mysql/auto.cnf' -> `/mysql/auto.cnf'
`/var/lib/mysql/ibdata1' -> `/mysql/ibdata1'
`/var/lib/mysql/ib_logfile0' -> `/mysql/ib_logfile0'
`/var/lib/mysql/ib_logfile1' -> `/mysql/ib_logfile1'
`/var/lib/mysql/mysql' -> `/mysql/mysql'
`/var/lib/mysql/mysql/time_zone.frm' -> `/mysql/mysql/time_zone.frm'
`/var/lib/mysql/mysql/help_topic.frm' -> `/mysql/mysql/help_topic.frm'
`/var/lib/mysql/mysql/innodb_table_stats.frm' -> `/mysql/mysql/innodb_table_stats.frm'
`/var/lib/mysql/mysql/time_zone_leap_second.MYI' -> `/mysql/mysql/time_zone_leap_second.MYI'
`/var/lib/mysql/mysql/slave_relay_log_info.frm' -> `/mysql/mysql/slave_relay_log_info.frm'
`/var/lib/mysql/mysql/db.frm' -> `/mysql/mysql/db.frm'
`/var/lib/mysql/mysql/general_log.CSV' -> `/mysql/mysql/general_log.CSV'
`/var/lib/mysql/mysql/time_zone_leap_second.MYD' -> `/mysql/mysql/time_zone_leap_second.MYD'
`/var/lib/mysql/mysql/proxies_priv.MYI' -> `/mysql/mysql/proxies_priv.MYI'
`/var/lib/mysql/mysql/slow_log.CSM' -> `/mysql/mysql/slow_log.CSM'
`/var/lib/mysql/mysql/ndb_binlog_index.MYI' -> `/mysql/mysql/ndb_binlog_index.MYI'
`/var/lib/mysql/mysql/proc.MYI' -> `/mysql/mysql/proc.MYI'
`/var/lib/mysql/mysql/help_category.MYI' -> `/mysql/mysql/help_category.MYI'
`/var/lib/mysql/mysql/event.MYI' -> `/mysql/mysql/event.MYI'
`/var/lib/mysql/mysql/help_relation.MYI' -> `/mysql/mysql/help_relation.MYI'
`/var/lib/mysql/mysql/time_zone_transition.MYD' -> `/mysql/mysql/time_zone_transition.MYD'
`/var/lib/mysql/mysql/servers.frm' -> `/mysql/mysql/servers.frm'
`/var/lib/mysql/mysql/help_keyword.MYD' -> `/mysql/mysql/help_keyword.MYD'
`/var/lib/mysql/mysql/servers.MYI' -> `/mysql/mysql/servers.MYI'
`/var/lib/mysql/mysql/help_category.frm' -> `/mysql/mysql/help_category.frm'
`/var/lib/mysql/mysql/help_relation.MYD' -> `/mysql/mysql/help_relation.MYD'
`/var/lib/mysql/mysql/time_zone_transition_type.MYD' -> `/mysql/mysql/time_zone_transition_type.MYD'
`/var/lib/mysql/mysql/time_zone.MYI' -> `/mysql/mysql/time_zone.MYI'
`/var/lib/mysql/mysql/columns_priv.frm' -> `/mysql/mysql/columns_priv.frm'
`/var/lib/mysql/mysql/columns_priv.MYI' -> `/mysql/mysql/columns_priv.MYI'
`/var/lib/mysql/mysql/plugin.MYD' -> `/mysql/mysql/plugin.MYD'
`/var/lib/mysql/mysql/time_zone_transition_type.MYI' -> `/mysql/mysql/time_zone_transition_type.MYI'
`/var/lib/mysql/mysql/help_topic.MYD' -> `/mysql/mysql/help_topic.MYD'
`/var/lib/mysql/mysql/help_category.MYD' -> `/mysql/mysql/help_category.MYD'
`/var/lib/mysql/mysql/help_keyword.frm' -> `/mysql/mysql/help_keyword.frm'
`/var/lib/mysql/mysql/help_topic.MYI' -> `/mysql/mysql/help_topic.MYI'
`/var/lib/mysql/mysql/slow_log.frm' -> `/mysql/mysql/slow_log.frm'
`/var/lib/mysql/mysql/columns_priv.MYD' -> `/mysql/mysql/columns_priv.MYD'
`/var/lib/mysql/mysql/plugin.frm' -> `/mysql/mysql/plugin.frm'
`/var/lib/mysql/mysql/time_zone_name.MYD' -> `/mysql/mysql/time_zone_name.MYD'
`/var/lib/mysql/mysql/tables_priv.MYD' -> `/mysql/mysql/tables_priv.MYD'
`/var/lib/mysql/mysql/general_log.frm' -> `/mysql/mysql/general_log.frm'
`/var/lib/mysql/mysql/time_zone.MYD' -> `/mysql/mysql/time_zone.MYD'
`/var/lib/mysql/mysql/time_zone_transition.MYI' -> `/mysql/mysql/time_zone_transition.MYI'
`/var/lib/mysql/mysql/slave_master_info.frm' -> `/mysql/mysql/slave_master_info.frm'
`/var/lib/mysql/mysql/slave_worker_info.frm' -> `/mysql/mysql/slave_worker_info.frm'
`/var/lib/mysql/mysql/general_log.CSM' -> `/mysql/mysql/general_log.CSM'
`/var/lib/mysql/mysql/help_keyword.MYI' -> `/mysql/mysql/help_keyword.MYI'
`/var/lib/mysql/mysql/servers.MYD' -> `/mysql/mysql/servers.MYD'
`/var/lib/mysql/mysql/procs_priv.MYI' -> `/mysql/mysql/procs_priv.MYI'
`/var/lib/mysql/mysql/slow_log.CSV' -> `/mysql/mysql/slow_log.CSV'
`/var/lib/mysql/mysql/proxies_priv.frm' -> `/mysql/mysql/proxies_priv.frm'
`/var/lib/mysql/mysql/slave_master_info.ibd' -> `/mysql/mysql/slave_master_info.ibd'
`/var/lib/mysql/mysql/event.MYD' -> `/mysql/mysql/event.MYD'
`/var/lib/mysql/mysql/user.frm' -> `/mysql/mysql/user.frm'
`/var/lib/mysql/mysql/proc.MYD' -> `/mysql/mysql/proc.MYD'
`/var/lib/mysql/mysql/slave_worker_info.ibd' -> `/mysql/mysql/slave_worker_info.ibd'
`/var/lib/mysql/mysql/func.MYD' -> `/mysql/mysql/func.MYD'
`/var/lib/mysql/mysql/innodb_index_stats.ibd' -> `/mysql/mysql/innodb_index_stats.ibd'
`/var/lib/mysql/mysql/ndb_binlog_index.frm' -> `/mysql/mysql/ndb_binlog_index.frm'
`/var/lib/mysql/mysql/innodb_table_stats.ibd' -> `/mysql/mysql/innodb_table_stats.ibd'
`/var/lib/mysql/mysql/slave_relay_log_info.ibd' -> `/mysql/mysql/slave_relay_log_info.ibd'
`/var/lib/mysql/mysql/db.MYI' -> `/mysql/mysql/db.MYI'
`/var/lib/mysql/mysql/proxies_priv.MYD' -> `/mysql/mysql/proxies_priv.MYD'
`/var/lib/mysql/mysql/func.MYI' -> `/mysql/mysql/func.MYI'
`/var/lib/mysql/mysql/time_zone_name.MYI' -> `/mysql/mysql/time_zone_name.MYI'
`/var/lib/mysql/mysql/func.frm' -> `/mysql/mysql/func.frm'
`/var/lib/mysql/mysql/proc.frm' -> `/mysql/mysql/proc.frm'
`/var/lib/mysql/mysql/time_zone_leap_second.frm' -> `/mysql/mysql/time_zone_leap_second.frm'
`/var/lib/mysql/mysql/time_zone_transition.frm' -> `/mysql/mysql/time_zone_transition.frm'
`/var/lib/mysql/mysql/db.MYD' -> `/mysql/mysql/db.MYD'
`/var/lib/mysql/mysql/help_relation.frm' -> `/mysql/mysql/help_relation.frm'
`/var/lib/mysql/mysql/procs_priv.frm' -> `/mysql/mysql/procs_priv.frm'
`/var/lib/mysql/mysql/user.MYD' -> `/mysql/mysql/user.MYD'
`/var/lib/mysql/mysql/time_zone_name.frm' -> `/mysql/mysql/time_zone_name.frm'
`/var/lib/mysql/mysql/innodb_index_stats.frm' -> `/mysql/mysql/innodb_index_stats.frm'
`/var/lib/mysql/mysql/ndb_binlog_index.MYD' -> `/mysql/mysql/ndb_binlog_index.MYD'
`/var/lib/mysql/mysql/event.frm' -> `/mysql/mysql/event.frm'
`/var/lib/mysql/mysql/plugin.MYI' -> `/mysql/mysql/plugin.MYI'
`/var/lib/mysql/mysql/time_zone_transition_type.frm' -> `/mysql/mysql/time_zone_transition_type.frm'
`/var/lib/mysql/mysql/tables_priv.MYI' -> `/mysql/mysql/tables_priv.MYI'
`/var/lib/mysql/mysql/user.MYI' -> `/mysql/mysql/user.MYI'
`/var/lib/mysql/mysql/tables_priv.frm' -> `/mysql/mysql/tables_priv.frm'
`/var/lib/mysql/mysql/procs_priv.MYD' -> `/mysql/mysql/procs_priv.MYD'
`/var/lib/mysql/performance_schema' -> `/mysql/performance_schema'
`/var/lib/mysql/performance_schema/session_account_connect_attrs.frm' -> `/mysql/performance_schema/session_account_connect_attrs.frm'
`/var/lib/mysql/performance_schema/socket_summary_by_event_name.frm' -> `/mysql/performance_schema/socket_summary_by_event_name.frm'
`/var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm' -> `/mysql/performance_schema/table_lock_waits_summary_by_table.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm' -> `/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm'
`/var/lib/mysql/performance_schema/performance_timers.frm' -> `/mysql/performance_schema/performance_timers.frm'
`/var/lib/mysql/performance_schema/socket_instances.frm' -> `/mysql/performance_schema/socket_instances.frm'
`/var/lib/mysql/performance_schema/events_stages_current.frm' -> `/mysql/performance_schema/events_stages_current.frm'
`/var/lib/mysql/performance_schema/events_statements_current.frm' -> `/mysql/performance_schema/events_statements_current.frm'
`/var/lib/mysql/performance_schema/host_cache.frm' -> `/mysql/performance_schema/host_cache.frm'
`/var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm' -> `/mysql/performance_schema/table_io_waits_summary_by_table.frm'
`/var/lib/mysql/performance_schema/file_instances.frm' -> `/mysql/performance_schema/file_instances.frm'
`/var/lib/mysql/performance_schema/events_statements_history_long.frm' -> `/mysql/performance_schema/events_statements_history_long.frm'
`/var/lib/mysql/performance_schema/hosts.frm' -> `/mysql/performance_schema/hosts.frm'
`/var/lib/mysql/performance_schema/threads.frm' -> `/mysql/performance_schema/threads.frm'
`/var/lib/mysql/performance_schema/mutex_instances.frm' -> `/mysql/performance_schema/mutex_instances.frm'
`/var/lib/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm' -> `/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm'
`/var/lib/mysql/performance_schema/session_connect_attrs.frm' -> `/mysql/performance_schema/session_connect_attrs.frm'
`/var/lib/mysql/performance_schema/db.opt' -> `/mysql/performance_schema/db.opt'
`/var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm' -> `/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm' -> `/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_statements_history.frm' -> `/mysql/performance_schema/events_statements_history.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm' -> `/mysql/performance_schema/events_waits_summary_global_by_event_name.frm'
`/var/lib/mysql/performance_schema/users.frm' -> `/mysql/performance_schema/users.frm'
`/var/lib/mysql/performance_schema/socket_summary_by_instance.frm' -> `/mysql/performance_schema/socket_summary_by_instance.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm' -> `/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm' -> `/mysql/performance_schema/events_statements_summary_by_digest.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm' -> `/mysql/performance_schema/events_statements_summary_global_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm' -> `/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm'
`/var/lib/mysql/performance_schema/file_summary_by_event_name.frm' -> `/mysql/performance_schema/file_summary_by_event_name.frm'
`/var/lib/mysql/performance_schema/setup_timers.frm' -> `/mysql/performance_schema/setup_timers.frm'
`/var/lib/mysql/performance_schema/events_stages_history_long.frm' -> `/mysql/performance_schema/events_stages_history_long.frm'
`/var/lib/mysql/performance_schema/cond_instances.frm' -> `/mysql/performance_schema/cond_instances.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm' -> `/mysql/performance_schema/events_waits_summary_by_instance.frm'
`/var/lib/mysql/performance_schema/events_waits_history_long.frm' -> `/mysql/performance_schema/events_waits_history_long.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm' -> `/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm'
`/var/lib/mysql/performance_schema/setup_actors.frm' -> `/mysql/performance_schema/setup_actors.frm'
`/var/lib/mysql/performance_schema/setup_consumers.frm' -> `/mysql/performance_schema/setup_consumers.frm'
`/var/lib/mysql/performance_schema/events_waits_current.frm' -> `/mysql/performance_schema/events_waits_current.frm'
`/var/lib/mysql/performance_schema/accounts.frm' -> `/mysql/performance_schema/accounts.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm' -> `/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm' -> `/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm' -> `/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm'
`/var/lib/mysql/performance_schema/setup_objects.frm' -> `/mysql/performance_schema/setup_objects.frm'
`/var/lib/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm' -> `/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm' -> `/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm' -> `/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_waits_history.frm' -> `/mysql/performance_schema/events_waits_history.frm'
`/var/lib/mysql/performance_schema/file_summary_by_instance.frm' -> `/mysql/performance_schema/file_summary_by_instance.frm'
`/var/lib/mysql/performance_schema/setup_instruments.frm' -> `/mysql/performance_schema/setup_instruments.frm'
`/var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm' -> `/mysql/performance_schema/events_stages_summary_global_by_event_name.frm'
`/var/lib/mysql/performance_schema/events_stages_history.frm' -> `/mysql/performance_schema/events_stages_history.frm'
`/var/lib/mysql/performance_schema/objects_summary_global_by_type.frm' -> `/mysql/performance_schema/objects_summary_global_by_type.frm'
`/var/lib/mysql/performance_schema/rwlock_instances.frm' -> `/mysql/performance_schema/rwlock_instances.frm'
`/var/lib/mysql/RPM_UPGRADE_HISTORY' -> `/mysql/RPM_UPGRADE_HISTORY'
`/var/lib/mysql/RPM_UPGRADE_MARKER-LAST' -> `/mysql/RPM_UPGRADE_MARKER-LAST'
`/var/lib/mysql/testdb' -> `/mysql/testdb'
`/var/lib/mysql/testdb/db.opt' -> `/mysql/testdb/db.opt'
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# chown mysql:mysql /mysql
[root at tstmysql04 ~]# chcon -R --reference=/var/lib/mysql /mysql
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lZ /var/lib | grep mysql
drwxr-xr-x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lZ / | grep mysql
drwxr-xr-x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lZ /var/lib/mysql/
-rw-r--r--. root root unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_HISTORY
-rw-r--r--. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_MARKER-LAST
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 auto.cnf
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ib_logfile0
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ib_logfile1
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ibdata1
drwx--x--x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 performance_schema
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 testdb
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# ls -lZ /mysql/
-rw-r--r--. root root unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_HISTORY
-rw-r--r--. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_MARKER-LAST
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 auto.cnf
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ib_logfile0
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ib_logfile1
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ibdata1
drwx--x--x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 performance_schema
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 testdb
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# chown mysql.mysql /mysql
[root at tstmysql05 ~]# chcon -R --reference=/var/lib/mysql /mysql
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# ls -lZ /var/lib | grep mysql
drwxr-xr-x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# ls -lZ / | grep mysql
drwxr-xr-x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# > /etc/my.cnf
[root at tstmysql04 ~]# vi /etc/my.cnf
[root at tstmysql04 ~]# cat /etc/my.cnf
[client]
port = 3306
socket = /mysql/mysql.sock
[mysqld]
port = 3306
socket = /mysql/mysql.sock
datadir = /mysql
bind-address = 127.0.0.1
user = mysql
memlock = 1
symbolic-links = 0
table_open_cache = 3072
table_definition_cache = 1024
max_heap_table_size = 64M
tmp_table_size = 64M
# Connections
max_connections = 505
max_user_connections = 500
max_allowed_packet = 16M
thread_cache_size = 32
# Buffers
sort_buffer_size = 8M
join_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
# Query Cache
query_cache_size = 64M
# MyISAM
myisam_recover = backup,force
# Logging
general-log = 0
general_log_file = /var/log/mysql/mysql.log
log_warnings = 2
log_error = /var/log/mysql/mysql_error.log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql_slow.log
long_query_time = 0.5
log_queries_not_using_indexes = 1
min_examined_row_limit = 20
# Binary Log / Replication
server_id = 1
log-bin = mysql-bin
binlog_cache_size = 1M
sync_binlog = 8
binlog_format = row
expire_logs_days = 7
max_binlog_size = 128M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no_auto_rehash
[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
open-files-limit = 8192
log-error = /var/log/mysql/mysql_error.log
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# > /etc/my.cnf
[root at tstmysql05 ~]# vi /etc/my.cnf
[root at tstmysql05 ~]# cat /etc/my.cnf
[client]
port = 3306
socket = /mysql/mysql.sock
[mysqld]
port = 3306
socket = /mysql/mysql.sock
datadir = /mysql
bind-address = 127.0.0.1
user = mysql
memlock = 1
symbolic-links = 0
table_open_cache = 3072
table_definition_cache = 1024
max_heap_table_size = 64M
tmp_table_size = 64M
# Connections
max_connections = 505
max_user_connections = 500
max_allowed_packet = 16M
thread_cache_size = 32
# Buffers
sort_buffer_size = 8M
join_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
# Query Cache
query_cache_size = 64M
# MyISAM
myisam_recover = backup,force
# Logging
general-log = 0
general_log_file = /var/log/mysql/mysql.log
log_warnings = 2
log_error = /var/log/mysql/mysql_error.log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql_slow.log
long_query_time = 0.5
log_queries_not_using_indexes = 1
min_examined_row_limit = 20
# Binary Log / Replication
server_id = 1
log-bin = mysql-bin
binlog_cache_size = 1M
sync_binlog = 8
binlog_format = row
expire_logs_days = 7
max_binlog_size = 128M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no_auto_rehash
[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
open-files-limit = 8192
log-error = /var/log/mysql/mysql_error.log
[root at tstmysql04 ~]# ls -lZ /etc/my.cnf*
-rw-r--r--. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf
-rw-r--r--. root root unconfined_u:object_r:etc_t:s0 /etc/my.cnf.orig
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# ls -lZ /etc/my.cnf*
-rw-r--r--. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf
-rw-r--r--. root root unconfined_u:object_r:etc_t:s0 /etc/my.cnf.orig
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# cp -p /etc/logrotate.d/mysql /etc/logrotate.d/mysql.orig
[root at tstmysql04 ~]# vi /etc/logrotate.d/mysql
[root at tstmysql04 ~]# cat /etc/logrotate.d/mysql
# The log file name and location can be set in
# /etc/my.cnf by setting the "log-error" option
# in either [mysqld] or [mysqld_safe] section as
# follows:
#
# [mysqld]
# log-error=/var/lib/mysql/mysqld.log
#
# In case the root user has a password, then you
# have to create a /root/.my.cnf configuration file
# with the following content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: The /root/.my.cnf file should be readable
# _ONLY_ by root !
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mysql-query.log {
# create 600 mysql mysql
notifempty
daily
rotate 5
missingok
compress
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &>/dev/null
then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vi /root/.my.cnf
[root at tstmysql04 ~]# cat /root/.my.cnf
[mysqladmin]
password = C2y2bJE!
user= root
[root at tstmysql04 ~]# chmod 0400 /root/.my.cnf
[root at tstmysql04 ~]# ls -l /root/.my.cnf
-r--------. 1 root root 44 Jun 7 15:36 /root/.my.cnf
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# cp -p /etc/logrotate.d/mysql /etc/logrotate.d/mysql.orig
[root at tstmysql05 ~]# vi /etc/logrotate.d/mysql
[root at tstmysql05 ~]# cat /etc/logrotate.d/mysql
# The log file name and location can be set in
# /etc/my.cnf by setting the "log-error" option
# in either [mysqld] or [mysqld_safe] section as
# follows:
#
# [mysqld]
# log-error=/var/lib/mysql/mysqld.log
#
# In case the root user has a password, then you
# have to create a /root/.my.cnf configuration file
# with the following content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: The /root/.my.cnf file should be readable
# _ONLY_ by root !
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mysql-query.log {
# create 600 mysql mysql
notifempty
daily
rotate 5
missingok
compress
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &>/dev/null
then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# vi /root/.my.cnf
[root at tstmysql05 ~]# cat /root/.my.cnf
[mysqladmin]
password = C2y2bJE!
user= root
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# chmod 0400 /root/.my.cnf
[root at tstmysql05 ~]# ls -l /root/.my.cnf
-r--------. 1 root root 44 Jun 7 15:35 /root/.my.cnf
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# corosync-keygen
Corosync Cluster Engine Authentication key generator.
Gathering 1024 bits for key from /dev/random.
Press keys on your keyboard to generate entropy.
Writing corosync key to /etc/corosync/authkey.
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# scp -p /etc/corosync/authkey 172.16.45.159:/etc/corosync/
root at 172.16.45.159's password:
authkey 100% 128 0.1KB/s 00:00
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# vi /etc/corosync/corosync.conf
[root at tstmysql04 ~]# cat /etc/corosync/corosync.conf
compatibility: whitetank
aisexec {
# Run as root - this is necessary to be able to manage resources with Pacemaker
user: root
group: root
}
service {
# Load the Pacemaker Cluster Resource Manager
ver: 0
name: pacemaker
use_logd: yes
}
totem {
version: 2
secauth: off
threads: 0
rrp_mode: passive
interface {
ringnumber: 0
bindnetaddr: 192.168.131.0
mcastaddr: 239.255.1.177
mcastport: 5409
}
interface {
ringnumber: 1
bindnetaddr: 172.16.45.0
mcastaddr: 239.255.1.178
mcastport: 5411
}
}
logging {
fileline: off
to_stderr: yes
to_logfile: yes
to_syslog: yes
logfile: /var/log/corosync.log
# debug: off
debug: on
timestamp: on
logger_subsys {
subsys: AMF
debug: off
}
}
amf {
mode: disabled
}
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# scp -p /etc/corosync/corosync.conf 172.16.45.159:/etc/corosync/
root at 172.16.45.159's password:
corosync.conf 100% 1079 1.1KB/s 00:00
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# chkconfig mysql off
[root at tstmysql04 ~]# chkconfig corosync on
[root at tstmysql04 ~]# chkconfig --add logd
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# service corosync start
Starting Corosync Cluster Engine (corosync): [ OK ]
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# chkconfig mysql off
[root at tstmysql05 ~]# chkconfig corosync on
[root at tstmysql05 ~]# chkconfig --add logd
[root at tstmysql05 ~]# service corosync start
Starting Corosync Cluster Engine (corosync): [ OK ]
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# corosync-cfgtool -s
Printing ring status.
Local node ID -2038191936
RING ID 0
id = 192.168.131.134
status = ring 0 active with no faults
RING ID 1
id = 172.16.45.158
status = ring 1 active with no faults
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# corosync-objctl runtime.totem.pg.mrp.srp.members
runtime.totem.pg.mrp.srp.-2038191936.ip=r(0) ip(192.168.131.134) r(1) ip(172.16.45.158)
runtime.totem.pg.mrp.srp.-2038191936.join_count=1
runtime.totem.pg.mrp.srp.-2038191936.status=joined
runtime.totem.pg.mrp.srp.-2021414720.ip=r(0) ip(192.168.131.135) r(1) ip(172.16.45.159)
runtime.totem.pg.mrp.srp.-2021414720.join_count=1
runtime.totem.pg.mrp.srp.-2021414720.status=joined
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# crm_mon -1
Last updated: Sat Jun 7 15:47:11 2014
Last change: Sat Jun 7 15:44:15 2014 via crmd on tstmysql04
Stack: classic openais (with plugin)
Current DC: tstmysql04 - partition with quorum
Version: 1.1.9-2.7-2db99f1
2 Nodes configured, 2 expected votes
0 Resources configured.
Online: [ tstmysql04 tstmysql05 ]
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# corosync-cfgtool -s
Printing ring status.
Local node ID -2021414720
RING ID 0
id = 192.168.131.135
status = ring 0 active with no faults
RING ID 1
id = 172.16.45.159
status = ring 1 active with no faults
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# corosync-objctl runtime.totem.pg.mrp.srp.members
runtime.totem.pg.mrp.srp.-2021414720.ip=r(0) ip(192.168.131.135) r(1) ip(172.16.45.159)
runtime.totem.pg.mrp.srp.-2021414720.join_count=1
runtime.totem.pg.mrp.srp.-2021414720.status=joined
runtime.totem.pg.mrp.srp.-2038191936.ip=r(0) ip(192.168.131.134) r(1) ip(172.16.45.158)
runtime.totem.pg.mrp.srp.-2038191936.join_count=1
runtime.totem.pg.mrp.srp.-2038191936.status=joined
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# crm_mon -1
Last updated: Sat Jun 7 15:46:59 2014
Last change: Sat Jun 7 15:44:15 2014 via crmd on tstmysql04
Stack: classic openais (with plugin)
Current DC: tstmysql04 - partition with quorum
Version: 1.1.9-2.7-2db99f1
2 Nodes configured, 2 expected votes
0 Resources configured.
Online: [ tstmysql04 tstmysql05 ]
[root at tstmysql05 ~]#
[root at tstmysql04 ~]# crm configure
crm(live)configure# property no-quorum-policy="ignore" pe-warn-series-max="1000" pe-input-series-max="1000" pe-error-series-max="1000" cluster-recheck-interval="5min"
crm(live)configure# property stonith-enabled=false
crm(live)configure# commit
crm(live)configure# exit
bye
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# crm configure show
node tstmysql04
node tstmysql05
property cib-bootstrap-options: \
dc-version=1.1.9-2.7-2db99f1 \
cluster-infrastructure="classic openais (with plugin)" \
expected-quorum-votes=2 \
no-quorum-policy=ignore \
pe-warn-series-max=1000 \
pe-input-series-max=1000 \
pe-error-series-max=1000 \
cluster-recheck-interval=5min \
stonith-enabled=false
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# crm configure
crm(live)configure# property expected-quorum-votes="2"
crm(live)configure# property default-action-timeout="180s"
crm(live)configure# property start-failure-is-fatal="false"
crm(live)configure# rsc_defaults resource-stickiness=100
crm(live)configure# primitive p_ip_mysql ocf:heartbeat:IPaddr2 params ip="172.16.45.160" cidr_netmask="24" op monitor interval="30s"
crm(live)configure# primitive p_drbd_mysql ocf:linbit:drbd params drbd_resource="data" op start timeout="90s" op stop timeout="180s" op promote timeout="180s" op demote timeout="180s" op monitor interval="30s" role="Slave" op monitor interval="29s" role="Master"
crm(live)configure# primitive p_mysql lsb:mysql op monitor interval="20s" timeout="10s" op start timeout="120s" op stop timeout="120s"
crm(live)configure# primitive p_fs_mysql ocf:heartbeat:Filesystem params device="/dev/drbd0" directory="/mysql" fstype="ext4" options="noatime" op start timeout="60s" op stop timeout="180s" op monitor interval="60s" timeout="60s"
crm(live)configure# group g_mysql p_fs_mysql p_mysql p_ip_mysql meta migration-threshold="5"
crm(live)configure# ms ms_drbd_mysql p_drbd_mysql meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"
crm(live)configure# colocation c_mysql_on_drbd inf: g_mysql ms_drbd_mysql:Master
crm(live)configure# order o_drbd_before_mysql inf: ms_drbd_mysql:promote g_mysql:start
crm(live)configure# commit
WARNING: p_drbd_mysql: specified timeout 90s for start is smaller than the advised 240
WARNING: p_mysql: specified timeout 10s for monitor is smaller than the advised 15
crm(live)configure#
crm(live)configure# exit
bye
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# crm configure show
node tstmysql04
node tstmysql05
primitive p_drbd_mysql ocf:linbit:drbd \
params drbd_resource=data \
op start timeout=90s interval=0 \
op stop timeout=180s interval=0 \
op promote timeout=180s interval=0 \
op demote timeout=180s interval=0 \
op monitor interval=30s role=Slave \
op monitor interval=29s role=Master
primitive p_fs_mysql Filesystem \
params device="/dev/drbd0" directory="/mysql" fstype=ext4 options=noatime \
op start timeout=60s interval=0 \
op stop timeout=180s interval=0 \
op monitor interval=60s timeout=60s
primitive p_ip_mysql IPaddr2 \
params ip=172.16.45.160 cidr_netmask=24 \
op monitor interval=30s
primitive p_mysql lsb:mysql \
op monitor interval=20s timeout=10s \
op start timeout=120s interval=0 \
op stop timeout=120s interval=0
group g_mysql p_fs_mysql p_mysql p_ip_mysql \
meta migration-threshold=5
ms ms_drbd_mysql p_drbd_mysql \
meta master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true
colocation c_mysql_on_drbd inf: g_mysql ms_drbd_mysql:Master
order o_drbd_before_mysql inf: ms_drbd_mysql:promote g_mysql:start
property cib-bootstrap-options: \
dc-version=1.1.9-2.7-2db99f1 \
cluster-infrastructure="classic openais (with plugin)" \
expected-quorum-votes=2 \
no-quorum-policy=ignore \
pe-warn-series-max=1000 \
pe-input-series-max=1000 \
pe-error-series-max=1000 \
cluster-recheck-interval=5min \
stonith-enabled=false \
default-action-timeout=180s \
start-failure-is-fatal=false
rsc_defaults rsc-options: \
resource-stickiness=100
[root at tstmysql04 ~]#
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# crm_mon -1
Last updated: Sat Jun 7 16:00:02 2014
Last change: Sat Jun 7 15:56:23 2014 via cibadmin on tstmysql04
Stack: classic openais (with plugin)
Current DC: tstmysql04 - partition with quorum
Version: 1.1.9-2.7-2db99f1
2 Nodes configured, 2 expected votes
5 Resources configured.
Online: [ tstmysql04 tstmysql05 ]
Resource Group: g_mysql
p_fs_mysql (ocf::heartbeat:Filesystem): Started tstmysql05
p_mysql (lsb:mysql): Stopped
p_ip_mysql (ocf::heartbeat:IPaddr2): Stopped
Master/Slave Set: ms_drbd_mysql [p_drbd_mysql]
Masters: [ tstmysql05 ]
Slaves: [ tstmysql04 ]
Failed actions:
p_mysql_start_0 (node=tstmysql04, call=45, rc=1, status=complete): unknown error
p_mysql_start_0 (node=tstmysql05, call=66, rc=1, status=complete): unknown error
[root at tstmysql04 ~]#
[root at tstmysql05 ~]# crm_mon -1
Last updated: Sat Jun 7 16:00:29 2014
Last change: Sat Jun 7 15:56:23 2014 via cibadmin on tstmysql04
Stack: classic openais (with plugin)
Current DC: tstmysql04 - partition with quorum
Version: 1.1.9-2.7-2db99f1
2 Nodes configured, 2 expected votes
5 Resources configured.
Online: [ tstmysql04 tstmysql05 ]
Resource Group: g_mysql
p_fs_mysql (ocf::heartbeat:Filesystem): Started tstmysql05
p_mysql (lsb:mysql): Stopped
p_ip_mysql (ocf::heartbeat:IPaddr2): Stopped
Master/Slave Set: ms_drbd_mysql [p_drbd_mysql]
Masters: [ tstmysql05 ]
Slaves: [ tstmysql04 ]
Failed actions:
p_mysql_start_0 (node=tstmysql04, call=45, rc=1, status=complete): unknown error
p_mysql_start_0 (node=tstmysql05, call=66, rc=1, status=complete): unknown error
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lvroot 9.9G 1.7G 7.8G 18% /
tmpfs 935M 22M 914M 3% /dev/shm
/dev/sda1 194M 28M 156M 16% /boot
/dev/mapper/vg00-lvhome 1008M 34M 924M 4% /home
/dev/mapper/vg00-lvopt 1008M 34M 924M 4% /opt
/dev/mapper/vg00-lvtmp 5.0G 138M 4.6G 3% /tmp
/dev/mapper/vg00-lvvar 5.0G 289M 4.4G 7% /var
/dev/mapper/vg00-lvvarlog 9.9G 153M 9.2G 2% /var/log
/dev/mapper/vg00-lvaudit 5.0G 139M 4.6G 3% /var/log/audit
/dev/sr0 3.6G 3.6G 0 100% /mnt/iso
/dev/drbd0 9.9G 151M 9.2G 2% /mysql
[root at tstmysql05 ~]#
[root at tstmysql05 ~]# service corosync restart
Signaling Corosync Cluster Engine (corosync) to terminate: [ OK ]
Waiting for corosync services to unload:. [ OK ]
Starting Corosync Cluster Engine (corosync): [ OK ]
[root at tstmysql05 ~]#
If the VIP is not coming up when doing manual failover, shutdown both nodes then power them up after a minute.
Don't forget to check SELinux and permission on mysql datadir and log files
[root at tstmysql04 ~]# chcon -R --reference=/var/log/mysqld.log /var/log/mysql*
[root at tstmysql04 ~]#
[root at tstmysql04 ~]# chown mysql:mysql /mysql/
[root at tstmysql04 ~]#
-------------- next part --------------
A non-text attachment was scrubbed...
Name: corosync.conf
Type: application/octet-stream
Size: 875 bytes
Desc: not available
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20140625/603f537f/attachment-0003.obj>
More information about the Pacemaker
mailing list