Mailing List Archive

$B$O$8$a$^$7$F!"2,It$H?=$7$^$9!#(B

Pacemaker$B$N%N!<%I$r:F%$%s%9%H!<%k$9$k$H(BMySQL$B$N%l%W%j%1!<%7%g%s(B
$B$K<:GT$7$F$7$^$$!"G:$s$G$$$^$9!#0J2<$N$h$&$J%(%i!<$,(B /var/log/mysqld.log
$B$K=PNO$5$l$^$9$,!"%G!<%?%Y!<%9$N%P%C%/%"%C%W$r%j%9%H%"$7$F$$$^$9$7!"(B
$B%f!<%6$r;XDj$7$F%Q%9%o!<%I$r85$N$b$N$KJQ99$7$F$bF1$8%(%i!<$K$J$j$^$9!#(B

> [ERROR] Slave I/O thread: error connecting to master 'repl@vagrant-db1:3306': Error: 'Access denied for user 'repl'@'vagrant-db2' (using password: YES)'

$B6qBNE*$K$O0J2<$N$h$&$J%F%9%H$r$7$F$$$^$9!#4D6-$O(BCentOS 5.7$B$G$9!#(B

## 0. vagrant-db1$B$H(Bvagrant-db2$B$K(BCentOS 5.7$B$r?75,%$%s%9%H!<%k$9$k(B
## 1. vagrant-db1$B$H(Bvagrant-db2$B$K(BPacemaker$BEy$r%$%s%9%H!<%k$9$k(B

```
vagrant-db1$ sudo yum install mysql-server which
vagrant-db1$ cd /tmp
vagrant-db1$ wget
'http://osdn.jp/frs/redir.php?m=iij&f=%2Flinux-ha%2F61792%2Fpacemaker-1.0.13-2.1.el5.x86_64.repo.tar.gz'
vagrant-db1$ tar xfz pacemaker-1.0.13-2.1.el5.x86_64.repo.tar.gz
vagrant-db1$ cd pacemaker-1.0.13-2.1.el5.x86_64.repo
vagrant-db1$ sudo yum -c pacemaker.repo install heartbeat.x86_64
pacemaker.x86_64
```

## 2. vagrant-db1$B$H(Bvagrant-db2$B$G(BMySQL$B$N@_Dj$r$9$k(B

```
vagrant-db1$ sudo vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=1 # <= vagrant-db1$B$G$O(B1$B!"(Bvagrant-db2$B$G$O(B2
...
vagrant-db1$ sudo /sbin/service mysqld start
vagrant-db1$ mysql -u root -p
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'slavepass';
mysql> GRANT SUPER,REPLICATION SLAVE,REPLICATION CLIENT,PROCESS ON *.*
TO 'repl'@'localhost' IDENTIFIED BY 'slavepass';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
vagrant-db1$ sudo /sbin/chkconfig mysqld on
```

## 3. vagrant-db1$B$H(Bvagrant-db2$B$G(BHeartbeat$B$N@_Dj$r$9$k(B

```
vagrant-db1$ sudo vi /etc/ha.d/ha.cf
pacemaker on
logfacility local1

debug 0
udpport 694

keepalive 2
warntime 20
deadtime 24
initdead 48

bcast eth1

node vagrant-db1
node vagrant-db2
vagrant-db1$ sudo vi /etc/ha.d/authkeys
auth 1
1 sha1 centabcdefg
vagrant-db1$ sudo chown root:root /etc/ha.d/authkeys
vagrant-db1$ sudo chmod 600 /etc/ha.d/authkeys
vagrant-db1$ sudo /sbin/service heartbeat start
```

## 4. Pacemaker$B$N@_Dj$r$9$k(B

```
vagrant-db1$ sudo bash
vagrant-db1# export PATH=$PATH:/usr/sbin
vagrant-db1# crm node standby vagrant-db2
vagrant-db1# crm configure
crm(live)configure# primitive vip_192.168.179.100
ocf:heartbeat:IPaddr2 params ip="192.168.179.100" cidr_netmask="24"
nic="eth1"
crm(live)configure# property no-quorum-policy="ignore" stonith-enabled="false"
crm(live)configure# node vagrant-db1
crm(live)configure# node vagrant-db2
crm(live)configure# commit
crm(live)configure# quit
vagrant-db1# crm
crm(live)# cib new mysql_repl
crm(mysql_repl)# configure primitive mysql ocf:heartbeat:mysql params
binary=/usr/bin/mysqld_safe pid=/var/run/mysqld/mysqld.pid
replication_user=repl replication_passwd=slavepass op start interval=0
timeout=120s op stop interval=0 timeout=120s op monitor interval=20s
timeout=30s op monitor interval=10s role=Master timeout=30s op monitor
interval=30s role=Slave timeout=30s op promote interval=0 timeout=120s
op demote interval=0 timeout=120s op notify interval=0 timeout=90s
crm(mysql_repl)# cib commit mysql_repl
crm(mysql_repl)# quit
vagrant-db1# crm configure ms mysql-clone mysql meta master-max=1
master-node-max=1 clone-max=2 clone-node-max=1 notify=true
vagrant-db1# crm configure colocation vip_on_mysql inf:
vip_192.168.179.100 mysql-clone:Master
vagrant-db1# crm configure order vip_after_mysql inf:
mysql-clone:promote vip_192.168.179.100:start
vagrant-db1# crm node online vagrant-db2
```

## 5. $B$3$N;~E@$G$O%l%W%j%1!<%7%g%s$H%U%'%$%k%*!<%P!<$O>e<j$/F0:n$7$F$$$^$9(B
## 6. vagrant-db1$B$K>c32$,5/$-$?$H$7$F!"?75,%$%s%9%H!<%k$7$^$9(B

CentOS 5.7$B$r?75,%$%s%9%H!<%k$7$?8e!"0J2<$r<B9T$7$^$9!#(B

1. vagrant-db1$B$H(Bvagrant-db2$B$K(BPacemaker$BEy$r%$%s%9%H!<%k$9$k(B
3. vagrant-db1$B$H(Bvagrant-db2$B$G(BHeartbeat$B$N@_Dj$r$9$k(B

## 7. $B%G!<%?%Y!<%9$r%l%9%H%"$7$^$9(B

```
vagrant-db2# mysql -u root -p
vagrant-db2# mysqldump -u root -p -x --all-databases > /vagrant_data/db.dump
vagrant-db2# mysqldump -u root -p -x --allow-keywords mysql >
/vagrant_data/dbuser.dump
```

```
vagrant-db1$ sudo vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=1
...
vagrant-db1# /sbin/service mysqld start
vagrant-db1# /sbin/chkconfig mysqld on
vagrant-db1# mysql -u root -p < /vagrant_data/db.dump
vagrant-db1# mysql -u root -p mysql < /vagrant_data/dbuser.dump
vagrant-db1# mysql -u root -p
mysql> FLUSH PRIVILEGES;
```

## 8. crm_mon$B$H$7$F$O@5>o$K8+$($k$,!"(BMySQL$B$G$O%(%i!<$,H/@8$7$F$$$^$9(B

```
vagrant-db1# /sbin/service heartbeat restart
vagrant-db1# crm_mon
Online: [ vagrant-db1 vagrant-db2 ]
OFFLINE: [ vagrant-db1 ]

vip_192.168.179.100 (ocf::heartbeat:IPaddr2): Started vagrant-db2
Master/Slave Set: mysql-clone
Masters: [ vagrant-db1 ]
Slaves: [ vagrant-db2 ]
```

```
vagrant-db2# mysql -u root -p
mysql> SHOW SLAVE STATUS\G
...
Slave_IO_Running: No
Slave_SQL_Running: Yes
...
vagrant-db2# tail -1 /var/log/mysqld.log
150803 21:27:59 [ERROR] Slave I/O thread: error connecting to master
'repl@vagrant-db1:3306': Error: 'Access denied for user
'repl'@'vagrant-db2' (using password: YES)' 0
```


$B$*$=$i$/(BPacemaker$B$h$j$b(BMySQL$B$NCN<1$,ITB-$7$F$$$k$H;W$&$N$G$9$,!"%"%I%P%$%9$r$$$?$@$1$J$$$G$7$g$&$+!#(B

$B0J>e$h$m$7$/$*4j$$$7$^$9!#(B
--
Kiwamu Okabe
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan