ãŠä¸–話ã«ãªã‚Šã¾ã™ã€‚
先般ã€PG-REXã§ã®Pacemaker構築ã«ã¦ä¸Šæ‰‹ãã„ã‹ãªã‹ã£ãŸã®ã§ã€å‹‰å¼·ãŒã¦ã‚‰
pcsコマンドã«ã¦å†æ§‹ç¯‰ã‚’è¡Œã„ã¾ã—ãŸã€‚
[環境]
OS :CentOS7.1
PostgresSQL :postgresql-server-9.2.13-1
Pacemaker :pacemaker-1.1.12-22
構築後ã«è«¸ã€…å•é¡Œç‚¹ãŒç™ºç”Ÿã—ã¦ãŠã‚Šã€ã”åŠ©å‹¢é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚
以下ã€çŠ¶æ³ã‚’é †ã«è¨˜ã—ã¾ã™ã€‚
(1)構築後ã®çŠ¶æ³
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# crm_mon -Arf -1
Last updated: Tue Jan 5 21:39:19 2016
Last change: Tue Jan 5 21:38:46 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix01(1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Masters: [ zabbix01 ]
Slaves: [ zabbix02 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Started zabbix01
Node Attributes:
* Node zabbix01:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 1000
+ pgsql-data-status : LATEST
+ pgsql-master-baseline : 0000000016000080
+ pgsql-status : PRI
* Node zabbix02:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 100
+ pgsql-data-status : STREAMING|ASYNC
+ pgsql-status : HS:async
Migration summary:
* Node zabbix02:
* Node zabbix01:
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(ï¼’)Slaveã¸ã®åˆ‡æ›¿
切替テストã¨ã—ã¦ã€Zabbix01ã®Postgresqlã‚’åœæ¢ã—ã¾ã—ãŸã€‚
åœæ¢å¾Œã®ã‚¯ãƒ©ã‚¹ã‚¿ã®çŠ¶æ…‹(下記)ã¨ã—ã¦ã¯å•é¡Œãªã„ã¨æ€ã£ã¦ã¾ã™ã€‚
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# crm_mon -Arf -1
Last updated: Wed Jan 6 00:45:32 2016
Last change: Wed Jan 6 00:30:22 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix01 (1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Masters: [ zabbix02 ]
Stopped: [ zabbix01 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Started zabbix02p
Node Attributes:
* Node zabbix01:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-status : STOP
* Node zabbix02:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 1000
+ pgsql-data-status : LATEST
+ pgsql-master-baseline : 0000000017000080
+ pgsql-status : PRI
Migration summary:
* Node zabbix02:
* Node zabbix01:
pgsql: migration-threshold=1 fail-count=1 last-failure='Wed Jan 6
00:30:13 2016'
Failed actions:
pgsql_monitor_3000 on zabbix01 'unknown error' (1): call=126,
status=complete, last-rc-change='Wed Jan 6 00:30:13 2016', queued=0ms,
exec=0ms
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(3)
ã“ã®å¾Œã€åˆ‡æˆ»ã—ã‚’è¡Œã†éš›ã«å½“æ–¹ã®ä¸æ‰‹éš›ã§ã€Master(Zabbix01)ã¨Slave(Zabbix02)
ã®OSåœæ¢ã‚’ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚
åœæ¢å¾Œã€ä¸¡æ©Ÿã‚’èµ·å‹•ã—ã¾ã—ãŸãŒã€ã€Œpcs statusã€ãŠã‚ˆã³ã€Œcrm_mon -Arf -1ã€
ã§ã®master-group(VIP_01)ã€msPostgresql(pgsql)ã®ãƒªã‚½ãƒ¼ã‚¹ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ãŒã€
ã€stopped〟ã¨ãªã£ã¦ã„ã¾ã—ãŸã€‚
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# pcs status
Cluster name: zabbixcluster
Last updated: Thr Jan 7 17:11:58 2016
Last change: Thr Jan 7 15:57:37 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix02 (1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Stopped: [ zabbix01 zabbix02 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Stopped
PCSD Status:
zabbix01 (192.168.252.182): Online
zabbix02 (192.168.252.183): Online
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
<確èªï¼‘>
 Slave(æ–°Master)ã«ã¦ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼å¾Œã®çŠ¶æ…‹ã‚’継続ã™ã‚‹ã‚‚ã®ã¨æƒ³å®šã—ã¦
 ã„ã¾ã—ãŸãŒã€OSåœæ¢ã‚’ã—ãŸå ´åˆã¯ã“ã®æ§˜ãªæŒ™å‹•ã«ãªã‚‹ã®ã¯æ£ã—ã„ã®ã§ã—ょã†ã‹ï¼Ÿ
(4)復旧
pg_basebackupã€pg_ctl promoteç‰ã‚’è¡Œã„ã€PostgreSQLã®æˆ»ã—ã‚’è¡Œã„ã¾ã—ãŸã€‚
(※「psql -h localhost -c "SELECT pg_is_in_recovery();"ã€ã«ã¦
両PostgresSQLã®èµ·å‹•çŠ¶æ…‹(Zabbix01:fã€Zabbix02:t)ã¨ã€ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°
レプリケーションã®å‹•ä½œã‚’確èªæ¸ˆ)
PostgreSQLã®çŠ¶æ…‹å¾©æ—§ã‚’è¡Œã£ãŸå¾Œã«ã€
 ①pcs resource cleanup msPostgresqlã¨pcs resource cleanup master-group
 ②pcs cluster stop --allã¨pcs cluster start --all
ã«ã¦å¾©æ—§ã‚’試ã¿ã¾ã—ãŸãŒã€ä¸¡ãƒªã‚½ãƒ¼ã‚¹ã®çŠ¶æ…‹ã¯ã€stopped〟ã®ã¾ã¾ã§ã™ã€‚
<確èªï¼’>
 クラスタã®å¾©æ—§ä½œæ¥ã¨ã—ã¦â‘ ã¨â‘¡ä»¥å¤–ã«è¡Œã†ã“ã¨ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ
 (※VIP_01ã¯debug-atartã«ã¦å¼·åˆ¶èµ·å‹•ã—ã€PostgreSQLã¯æ‰‹å‹•èµ·å‹•ã—ã¾ã—ãŸãŒã€
 未ã ã€stopped〟ã®ã¾ã¾ã§ã™ã€‚)
<確èªï¼“>
 ãã‚‚ãã‚‚ã®è©±ãªã®ã§ã™ãŒã€ã‚¯ãƒ©ã‚¹ã‚¿èµ·å‹•æ™‚ã«VIP付与ã¨PostgreSQLèµ·å‹•ãŒ
 ã•ã‚Œãªã„状態ã§ã™ã€‚(PostgreSQLã¯æ‰‹å‹•èµ·å‹•ã—ã¦ã¾ã™)
 è¨å®šå†…容を以下ã«ç¤ºã™ã®ã§ã€ä¸è¶³ã—ã¦ã„ã‚‹è¨å®šã‚’ã”教示願ã„ã¾ã™ã€‚
â– è¨å®šå†…容
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
pcs -f cluster_cfg property set no-quorum-policy="ignore"
pcs -f cluster_cfg property set stonith-enabled="false"
pcs -f cluster_cfg resource defaults resource-stickiness="INFINITY"
pcs -f cluster_cfg resource defaults migration-threshold="1"
pcs -f cluster_cfg resource create VIP_01 IPaddr2 \
ip="192.168.252.184" \
nic="enp0s3" \
cidr_netmask="24" \
op start timeout="60s" interval="0s" on-fail="restart" \
op monitor timeout="60s" interval="10s" on-fail="restart" \
op stop timeout="60s" interval="0s" on-fail="block"
pcs -f cluster_cfg resource create pgsql pgsql \
pgctl="/usr/bin/pg_ctl" \
psql="/usr/bin/psql" \
pgdata="/var/lib/pgsql/data/" \
rep_mode="async" \
node_list="zabbix01 zabbix02" \
restore_command="cp /var/lib/pgsql/pg_archive/%f %p" \
primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5
keepalives_count=5" \
master_ip="192.168.252.184" \
restart_on_promote='true' \
op start timeout="60s" interval="0s" on-fail="restart" \
op monitor timeout="60s" interval="4s" on-fail="restart" \
op monitor timeout="60s" interval="3s" on-fail="restart"
role="Master" \
op promote timeout="60s" interval="0s" on-fail="restart" \
op demote timeout="60s" interval="0s" on-fail="stop" \
op stop timeout="60s" interval="0s" on-fail="block" \
op notify timeout="60s" interval="0s"
pcs -f cluster_cfg resource master msPostgresql pgsql \
master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true
pcs -f cluster_cfg resource group add master-group VIP_01
pcs -f pgsql_cfg constraint colocation add master-group with Master
msPostgresql INFINITY
pcs -f pgsql_cfg constraint order promote msPostgresql then start
master-group symmetrical=false score=INFINITY
pcs -f pgsql_cfg constraint order demote msPostgresql then stop
master-group symmetrical=false score=0
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(上記を「pcs cluster cib-push cluster_cfgã€ã«ã¦åæ˜ ã—ã¦ã„ã¾ã™)
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan
先般ã€PG-REXã§ã®Pacemaker構築ã«ã¦ä¸Šæ‰‹ãã„ã‹ãªã‹ã£ãŸã®ã§ã€å‹‰å¼·ãŒã¦ã‚‰
pcsコマンドã«ã¦å†æ§‹ç¯‰ã‚’è¡Œã„ã¾ã—ãŸã€‚
[環境]
OS :CentOS7.1
PostgresSQL :postgresql-server-9.2.13-1
Pacemaker :pacemaker-1.1.12-22
構築後ã«è«¸ã€…å•é¡Œç‚¹ãŒç™ºç”Ÿã—ã¦ãŠã‚Šã€ã”åŠ©å‹¢é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚
以下ã€çŠ¶æ³ã‚’é †ã«è¨˜ã—ã¾ã™ã€‚
(1)構築後ã®çŠ¶æ³
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# crm_mon -Arf -1
Last updated: Tue Jan 5 21:39:19 2016
Last change: Tue Jan 5 21:38:46 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix01(1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Masters: [ zabbix01 ]
Slaves: [ zabbix02 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Started zabbix01
Node Attributes:
* Node zabbix01:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 1000
+ pgsql-data-status : LATEST
+ pgsql-master-baseline : 0000000016000080
+ pgsql-status : PRI
* Node zabbix02:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 100
+ pgsql-data-status : STREAMING|ASYNC
+ pgsql-status : HS:async
Migration summary:
* Node zabbix02:
* Node zabbix01:
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(ï¼’)Slaveã¸ã®åˆ‡æ›¿
切替テストã¨ã—ã¦ã€Zabbix01ã®Postgresqlã‚’åœæ¢ã—ã¾ã—ãŸã€‚
åœæ¢å¾Œã®ã‚¯ãƒ©ã‚¹ã‚¿ã®çŠ¶æ…‹(下記)ã¨ã—ã¦ã¯å•é¡Œãªã„ã¨æ€ã£ã¦ã¾ã™ã€‚
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# crm_mon -Arf -1
Last updated: Wed Jan 6 00:45:32 2016
Last change: Wed Jan 6 00:30:22 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix01 (1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Masters: [ zabbix02 ]
Stopped: [ zabbix01 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Started zabbix02p
Node Attributes:
* Node zabbix01:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-status : STOP
* Node zabbix02:
+ #cluster-name : zabbixcluster
+ #site-name : zabbixcluster
+ master-pgsql : 1000
+ pgsql-data-status : LATEST
+ pgsql-master-baseline : 0000000017000080
+ pgsql-status : PRI
Migration summary:
* Node zabbix02:
* Node zabbix01:
pgsql: migration-threshold=1 fail-count=1 last-failure='Wed Jan 6
00:30:13 2016'
Failed actions:
pgsql_monitor_3000 on zabbix01 'unknown error' (1): call=126,
status=complete, last-rc-change='Wed Jan 6 00:30:13 2016', queued=0ms,
exec=0ms
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(3)
ã“ã®å¾Œã€åˆ‡æˆ»ã—ã‚’è¡Œã†éš›ã«å½“æ–¹ã®ä¸æ‰‹éš›ã§ã€Master(Zabbix01)ã¨Slave(Zabbix02)
ã®OSåœæ¢ã‚’ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚
åœæ¢å¾Œã€ä¸¡æ©Ÿã‚’èµ·å‹•ã—ã¾ã—ãŸãŒã€ã€Œpcs statusã€ãŠã‚ˆã³ã€Œcrm_mon -Arf -1ã€
ã§ã®master-group(VIP_01)ã€msPostgresql(pgsql)ã®ãƒªã‚½ãƒ¼ã‚¹ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ãŒã€
ã€stopped〟ã¨ãªã£ã¦ã„ã¾ã—ãŸã€‚
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
# pcs status
Cluster name: zabbixcluster
Last updated: Thr Jan 7 17:11:58 2016
Last change: Thr Jan 7 15:57:37 2016 by hacluster via crmd on zabbix01
Stack: corosync
Current DC: zabbix02 (1) - partition with quorum
Version: 1.1.12-561c4cf
2 Nodes configured
3 Resources configured
Online: [ zabbix01 zabbix02 ]
Full list of resources:
Master/Slave Set: msPostgresql [pgsql]
Stopped: [ zabbix01 zabbix02 ]
Resource Group: master-group
VIP_01 (ocf::heartbeat:IPaddr2): Stopped
PCSD Status:
zabbix01 (192.168.252.182): Online
zabbix02 (192.168.252.183): Online
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
<確èªï¼‘>
 Slave(æ–°Master)ã«ã¦ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼å¾Œã®çŠ¶æ…‹ã‚’継続ã™ã‚‹ã‚‚ã®ã¨æƒ³å®šã—ã¦
 ã„ã¾ã—ãŸãŒã€OSåœæ¢ã‚’ã—ãŸå ´åˆã¯ã“ã®æ§˜ãªæŒ™å‹•ã«ãªã‚‹ã®ã¯æ£ã—ã„ã®ã§ã—ょã†ã‹ï¼Ÿ
(4)復旧
pg_basebackupã€pg_ctl promoteç‰ã‚’è¡Œã„ã€PostgreSQLã®æˆ»ã—ã‚’è¡Œã„ã¾ã—ãŸã€‚
(※「psql -h localhost -c "SELECT pg_is_in_recovery();"ã€ã«ã¦
両PostgresSQLã®èµ·å‹•çŠ¶æ…‹(Zabbix01:fã€Zabbix02:t)ã¨ã€ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°
レプリケーションã®å‹•ä½œã‚’確èªæ¸ˆ)
PostgreSQLã®çŠ¶æ…‹å¾©æ—§ã‚’è¡Œã£ãŸå¾Œã«ã€
 ①pcs resource cleanup msPostgresqlã¨pcs resource cleanup master-group
 ②pcs cluster stop --allã¨pcs cluster start --all
ã«ã¦å¾©æ—§ã‚’試ã¿ã¾ã—ãŸãŒã€ä¸¡ãƒªã‚½ãƒ¼ã‚¹ã®çŠ¶æ…‹ã¯ã€stopped〟ã®ã¾ã¾ã§ã™ã€‚
<確èªï¼’>
 クラスタã®å¾©æ—§ä½œæ¥ã¨ã—ã¦â‘ ã¨â‘¡ä»¥å¤–ã«è¡Œã†ã“ã¨ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ
 (※VIP_01ã¯debug-atartã«ã¦å¼·åˆ¶èµ·å‹•ã—ã€PostgreSQLã¯æ‰‹å‹•èµ·å‹•ã—ã¾ã—ãŸãŒã€
 未ã ã€stopped〟ã®ã¾ã¾ã§ã™ã€‚)
<確èªï¼“>
 ãã‚‚ãã‚‚ã®è©±ãªã®ã§ã™ãŒã€ã‚¯ãƒ©ã‚¹ã‚¿èµ·å‹•æ™‚ã«VIP付与ã¨PostgreSQLèµ·å‹•ãŒ
 ã•ã‚Œãªã„状態ã§ã™ã€‚(PostgreSQLã¯æ‰‹å‹•èµ·å‹•ã—ã¦ã¾ã™)
 è¨å®šå†…容を以下ã«ç¤ºã™ã®ã§ã€ä¸è¶³ã—ã¦ã„ã‚‹è¨å®šã‚’ã”教示願ã„ã¾ã™ã€‚
â– è¨å®šå†…容
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
pcs -f cluster_cfg property set no-quorum-policy="ignore"
pcs -f cluster_cfg property set stonith-enabled="false"
pcs -f cluster_cfg resource defaults resource-stickiness="INFINITY"
pcs -f cluster_cfg resource defaults migration-threshold="1"
pcs -f cluster_cfg resource create VIP_01 IPaddr2 \
ip="192.168.252.184" \
nic="enp0s3" \
cidr_netmask="24" \
op start timeout="60s" interval="0s" on-fail="restart" \
op monitor timeout="60s" interval="10s" on-fail="restart" \
op stop timeout="60s" interval="0s" on-fail="block"
pcs -f cluster_cfg resource create pgsql pgsql \
pgctl="/usr/bin/pg_ctl" \
psql="/usr/bin/psql" \
pgdata="/var/lib/pgsql/data/" \
rep_mode="async" \
node_list="zabbix01 zabbix02" \
restore_command="cp /var/lib/pgsql/pg_archive/%f %p" \
primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5
keepalives_count=5" \
master_ip="192.168.252.184" \
restart_on_promote='true' \
op start timeout="60s" interval="0s" on-fail="restart" \
op monitor timeout="60s" interval="4s" on-fail="restart" \
op monitor timeout="60s" interval="3s" on-fail="restart"
role="Master" \
op promote timeout="60s" interval="0s" on-fail="restart" \
op demote timeout="60s" interval="0s" on-fail="stop" \
op stop timeout="60s" interval="0s" on-fail="block" \
op notify timeout="60s" interval="0s"
pcs -f cluster_cfg resource master msPostgresql pgsql \
master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true
pcs -f cluster_cfg resource group add master-group VIP_01
pcs -f pgsql_cfg constraint colocation add master-group with Master
msPostgresql INFINITY
pcs -f pgsql_cfg constraint order promote msPostgresql then start
master-group symmetrical=false score=INFINITY
pcs -f pgsql_cfg constraint order demote msPostgresql then stop
master-group symmetrical=false score=0
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
(上記を「pcs cluster cib-push cluster_cfgã€ã«ã¦åæ˜ ã—ã¦ã„ã¾ã™)
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan