<html><head></head><body><div class="ydp777fc379yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:10px;"><div></div>
<div><br></div><div><br></div>
</div><div id="ydpf02c7b85yahoo_quoted_5207515033" class="ydpf02c7b85yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;"><br clear="none"><div dir="ltr" data-setdir="false">>>So you drive without safety-belt and airbag (read: fencing)?<br><br>possibly? probably?<br><br>As I said Im flying blind with this all - I was asked to try and implement it, Ive tried the best I can to implement it but for all I know the how-tos and advice I found have nmissed what may be needed.<br><br>Ive looked for online tutorials but have failed to come up with anything much aside from "do these commands and there you have it". Which may not uinclude more belts and braces.<br><br clear="none"><div>>></div><div><br></div><div dir="ltr" data-setdir="false">you're asking the worng operson. Im given two systems, whose disks are on a SAN. Minbe is not to reason why etc.</div><div dir="ltr" data-setdir="false"><br></div><div>>> I wondered where the cluster is in those logs.</div><div><br></div><div dir="ltr" data-setdir="false">sorry - Ive not understood the questin here.</div><div dir="ltr" data-setdir="false"><br></div><br><br>happy to provide extracts form logs etc. Below Ive appended the "set up" commands/steps used to implement drbd_pcs+corosync on the systems if that helps outloine any more.<br><br>I'm just the guy that fires the bullets in effect, trying to aim as best he can...<br><br><div>ian</div><div><br></div><div>====</div><div><br></div><div># prep<br>umount /var/lib/mysql<br> - and remove /var/lib/mysql from /etc/fstab<br>yum remove mysql-community-server<br>cd /var/lib/mysql; rm -rf *<br>mkdir /var/lib/mysql<br>chown mysql:mysql /var/lib/mysql<br>chmod 755 /var/lib/mysql<br>reboot<br><br>yum makecache fast<br>yum -y install wget mlocate telnet lsof<br>updatedb<br><br><br># Install Pacemaker and Corosync<br>yum install -y pcs<br>yum install -y policycoreutils-python<br>echo "passwd" | passwd hacluster --stdin<br>systemctl start pcsd.service<br>systemctl enable pcsd.service<br><br>#Configure Corosync<br>#[estrela]]<br>pcs cluster auth estrela rafeiro -u hacluster -p passwd<br>pcs cluster setup --name mysql_cluster estrela rafeiro<br>pcs cluster start --all<br><br>## Install DRBD<br>## BOTH<br><br>yum install -y kmod-drbd90<br>yum install -y drbd90-utils<br>systemctl enable corosync<br>systemctl enable pacemaker<br>reboot<br><br># when back up<br>modprobe drbd<br>systemctl status pcsd<br>systemctl status corosync<br>systemctl status pacemaker<br><br>cat << EOL >/etc/drbd.d/mysql01.res<br>resource mysql01 {<br> protocol C;<br> meta-disk internal;<br> device /dev/drbd0;<br> disk /dev/vg_mysql/lv_mysql;<br> handlers {<br> split-brain "/usr/lib/drbd/notify-split-brain.sh root";<br> }<br> net {<br> allow-two-primaries no;<br> after-sb-0pri discard-zero-changes;<br> after-sb-1pri discard-secondary;<br> after-sb-2pri disconnect;<br> rr-conflict disconnect;<br> }<br> disk {<br> on-io-error detach;<br> }<br> syncer {<br> verify-alg sha1;<br> }<br> on estrela {<br> address 10.108.248.165:7789;<br> }<br> on rafeiro {<br> address 10.108.248.166:7789;<br> }<br>}<br>EOL<br><br>* clear previously created filesystem<br>dd if=/dev/zero of=/dev/vg_mysql/lv_mysql bs=1M count=128 <br><br><br>drbdadm create-md mysql01<br>systemctl start drbd<br>systemctl enable drbd<br>systemctl status drbd<br><br>#[estrela]<br>drbdadm primary --force mysql01<br>estrela: cat /sys/kernel/debug/drbd/resources/mysql01/connections/rafeiro/0/proc_drbd<br>rafeiro: cat /sys/kernel/debug/drbd/resources/mysql01/connections/estrela/0/proc_drbd<br>drbdadm status<br><br># WAIT UNTIL DRBD IS SYNCED<br><br>#[estrela]<br>mkfs.xfs -f -L drbd /dev/drbd0<br>mount /dev/drbd0 /mnt<br><br><br>## INSTALL MYSQL on all<br>## BOTH<br>yum install mysql-server -y<br><br># [estrela]<br>mysql_install_db --datadir=/mnt --user=mysql<br>systemctl stop mysqld<br>umount /mnt<br><br>#BOTH <br>cp -p /etc/my.cnf /etc/my.cnf.ORIG<br>set up my.cnf as needed (migtated from existing mysql server)<br><br>#BOTH<br>mv /var/lib/mysql /var/lib/mysql.orig<br>mkdir /var/lib/mysql<br>chown mysql:mysql /var/lib/mysql<br>chmod 751 /var/lib/mysql<br>mkdir /var/lib/mysql/innodb<br>chown mysql:mysql /var/lib/mysql/innodb<br>chmod 755 /var/lib/mysql/innodb<br><br><br># estrela<br>mount /dev/drbd0 /var/lib/mysql<br>systemctl start mysqld<br><br># set up mysql<br>grep 'temporary password' /var/log/mysqld.log<br>mysql_secure_installation<br>rm /root/.mysql_secret<br><br><br># set up grants<br><grants etc><br>flush privileges;<br><br># test grants<br>[estrela]# mysql -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -uroot --skip-column-names -A | sed 's/$/;/g'<br>[rafeiro]# mysql -h estrela -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -hestrela -uroot --skip-column-names -A | sed 's/$/;/g'<br>mysql -h mysqldbdynabookHA -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -hestrela -uroot --skip-column-names -A | sed 's/$/;/g'<br># stop test_200<br><br># [estrela]<br>systemctl stop mysqld<br>umount /var/lib/mysql<br><br># snapshot servers - pre-clustered<br><br># Configure Pacemaker Cluster<br># [estrela]<br>pcs cluster cib clust_cfg<br><br><br>pcs -f clust_cfg property set stonith-enabled=false<br>pcs -f clust_cfg property set no-quorum-policy=ignore<br>pcs -f clust_cfg resource defaults resource-stickiness=200<br>pcs -f clust_cfg resource create mysql_data01 ocf:linbit:drbd drbd_resource=mysql01 op monitor interval=30s<br>pcs -f clust_cfg resource master MySQLClone01 mysql_data01 master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true<br>#pcs -f clust_cfg resource create mysql_fs01 Filesystem device="/dev/drbd0" directory="/var/lib/mysql" fstype="ext4"<br>pcs -f clust_cfg resource create mysql_fs01 Filesystem device="/dev/drbd0" directory="/var/lib/mysql" fstype="xfs"<br>pcs -f clust_cfg constraint colocation add mysql_fs01 with MySQLClone01 INFINITY with-rsc-role=Master<br>pcs -f clust_cfg constraint order promote MySQLClone01 then start mysql_fs01<br>pcs -f clust_cfg resource create mysql_service01 ocf:heartbeat:mysql \<br> binary="/usr/sbin/mysqld" \<br> config="/etc/my.cnf" \<br> datadir="/var/lib/mysql" \<br> socket="/var/lib/mysql/mysql.sock" \<br> additional_parameters="--bind-address=0.0.0.0" \<br> op start timeout=60s \<br> op stop timeout=60s \<br> op monitor interval=20s timeout=30s<br>pcs -f clust_cfg constraint colocation add mysql_service01 with mysql_fs01 INFINITY<br>pcs -f clust_cfg constraint order mysql_fs01 then mysql_service01<br>pcs -f clust_cfg resource create mysql_VIP01 ocf:heartbeat:IPaddr2 ip=10.108.248.164 cidr_netmask=32 op monitor interval=30s<br>pcs -f clust_cfg constraint colocation add mysql_VIP01 with mysql_service01 INFINITY<br>pcs -f clust_cfg constraint order mysql_service01 then mysql_VIP01<br><br>pcs -f clust_cfg constraint <br>pcs -f clust_cfg resource show<br>pcs cluster cib-push clust_cfg<br>pcs status<br><br><br>#TEST service<br>[estrela]# mysql -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -uroot --skip-column-names -A | sed 's/$/;/g'<br>[rafeiro]# mysql -h estrela -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -hestrela -uroot --skip-column-names -A | sed 's/$/;/g'<br>mysql -hmysqldbdynabookHA -uroot --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql -hmysqldbdynabookHA -uroot --skip-column-names -A | sed 's/$/;/g'<br><br><br>===<br><br>test with<br>pcs status<br>pcs cluster stop <hostname><br>pcs status to check failover<br>above tests (grants etc) to vip address<br>cluster start and failover again etc.<br><br><br><br><br></div><div><br></div></div>
</div>
</div></body></html>