[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