Re: [Pacemaker] Daemon Start attempt on wrong Server

2014-11-11 Thread Alexandre
You should use an opt out cluster. Set the cluster option
symmetrical=false. This will tell corosync not to place a resource anywhere
on the cluster, unless a location rule explicitly tell the cluster where it
should run.

Corosync will still monitor sql resources on www hosts and return rc 5 but
this is expected and works.
Le 11 nov. 2014 13:22, Hauke Homburg hhomb...@w3-creative.de a écrit :

 Hello,

 I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3 Nodes
 for Postgres.

 My Cluster Config is

 node kvm-node1
 node sql-node1
 node sql-node2
 node sql-node3
 node www-node1
 node www-node2
 node www-node3
 primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.41 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.31 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive pri_www_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.21 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive res_apache ocf:heartbeat:apache \
 params configfile=/etc/apache2/apache2.conf \
 op start interval=0 timeout=40 \
 op stop interval=0 timeout=60 \
 op monitor interval=60 timeout=120 start-delay=0 \
 meta target-role=Started
 primitive res_pgsql ocf:heartbeat:pgsql \
 params pgctl=/usr/lib/postgresql/9.1/bin/pg_ctl
 psql=/usr/bin/psql start_opt= pgdata=/var/lib/postgresql/9.1/main
 config=/etc/postgresql/9.1/main/postgresql.conf pgdba=postgres \
 op start interval=0 timeout=120s \
 op stop interval=0 timeout=120s \
 op monitor interval=30s timeout=30s depth=0
 location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
 location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
 location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
 location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
 location loc_sql_srv_node1 res_pgsql inf: sql-node1
 location loc_sql_srv_node2 res_pgsql inf: sql-node2
 location loc_sql_srv_node3 res_pgsql inf: sql-node3
 location loc_www_ip_node1 pri_www_ip inf: www-node1
 location loc_www_ip_node2 pri_www_ip inf: www-node2
 location loc_www_ip_node3 pri_www_ip inf: www-node3
 location loc_www_srv_node1 res_apache inf: www-node1
 location loc_www_srv_node2 res_apache inf: www-node2
 location loc_www_srv_node3 res_apache inf: www-node3
 property $id=cib-bootstrap-options \
 dc-version=1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff \
 cluster-infrastructurFailed actions:

 Why do i see in crm_mon the following output?

 res_pgsql_start_0 (node=www-node1, call=16, rc=5, status=complete):
 not installed
 res_pgsql_start_0 (node=www-node2, call=13, rc=5, status=complete):
 not installed
 pri_www_ip_monitor_1 (node=www-node3, call=22, rc=7,
 status=complete): not running
 res_pgsql_start_0 (node=www-node3, call=13, rc=5, status=complete):
 not installed
 res_apache_start_0 (node=sql-node2, call=18, rc=5, status=complete):
 not installed
 res_pgsql_start_0 (node=sql-node2, call=12, rc=5, status=complete):
 not installed
 res_apache_start_0 (node=sql-node3, call=12, rc=5, status=complete):
 not installed
 res_pgsql_start_0 (node=sql-node3, call=10, rc=5, status=complete):
 not installed
 res_apache_start_0 (node=kvm-node1, call=12, rc=5, status=complete):
 not installed
 res_pgsql_start_0 (node=kvm-node1, call=20, rc=5, status=complete):
 not installede=openais \
 expected-quorum-votes=7 \
 stonith-enabled=false


 I set the infinity for pgsql on all 3 sql nodes, but not! on the www
 nodes. Why tries Pacemaker to start the Postgres SQL Server on the www
 Node? In example?

 Thank for your Help

 greetings

 Hauke

 ___
 Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
 http://oss.clusterlabs.org/mailman/listinfo/pacemaker

 Project Home: http://www.clusterlabs.org
 Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
 Bugs: http://bugs.clusterlabs.org

___
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org


Re: [Pacemaker] Daemon Start attempt on wrong Server

2014-11-11 Thread Hauke Homburg

Am 11.11.2014 13:34, schrieb Alexandre:


You should use an opt out cluster. Set the cluster option  
symmetrical=false. This will tell corosync not to place a resource 
anywhere on the cluster, unless a location rule explicitly tell the 
cluster where it should run.


Corosync will still monitor sql resources on www hosts and return rc 5 
but this is expected and works.


Le 11 nov. 2014 13:22, Hauke Homburg hhomb...@w3-creative.de 
mailto:hhomb...@w3-creative.de a écrit :


Hello,

I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3
Nodes for Postgres.

My Cluster Config is

node kvm-node1
node sql-node1
node sql-node2
node sql-node3
node www-node1
node www-node2
node www-node3
primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
params ip=10.0.6.41 cidr_netmask=255.255.255.0 \
op monitor interval=10s timeout=20s
primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
params ip=10.0.6.31 cidr_netmask=255.255.255.0 \
op monitor interval=10s timeout=20s
primitive pri_www_ip ocf:heartbeat:IPaddr2 \
params ip=10.0.6.21 cidr_netmask=255.255.255.0 \
op monitor interval=10s timeout=20s
primitive res_apache ocf:heartbeat:apache \
params configfile=/etc/apache2/apache2.conf \
op start interval=0 timeout=40 \
op stop interval=0 timeout=60 \
op monitor interval=60 timeout=120 start-delay=0 \
meta target-role=Started
primitive res_pgsql ocf:heartbeat:pgsql \
params pgctl=/usr/lib/postgresql/9.1/bin/pg_ctl
psql=/usr/bin/psql start_opt=
pgdata=/var/lib/postgresql/9.1/main
config=/etc/postgresql/9.1/main/postgresql.conf pgdba=postgres \
op start interval=0 timeout=120s \
op stop interval=0 timeout=120s \
op monitor interval=30s timeout=30s depth=0
location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
location loc_sql_srv_node1 res_pgsql inf: sql-node1
location loc_sql_srv_node2 res_pgsql inf: sql-node2
location loc_sql_srv_node3 res_pgsql inf: sql-node3
location loc_www_ip_node1 pri_www_ip inf: www-node1
location loc_www_ip_node2 pri_www_ip inf: www-node2
location loc_www_ip_node3 pri_www_ip inf: www-node3
location loc_www_srv_node1 res_apache inf: www-node1
location loc_www_srv_node2 res_apache inf: www-node2
location loc_www_srv_node3 res_apache inf: www-node3
property $id=cib-bootstrap-options \
dc-version=1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff \
cluster-infrastructurFailed actions:

Why do i see in crm_mon the following output?

res_pgsql_start_0 (node=www-node1, call=16, rc=5,
status=complete): not installed
res_pgsql_start_0 (node=www-node2, call=13, rc=5,
status=complete): not installed
pri_www_ip_monitor_1 (node=www-node3, call=22, rc=7,
status=complete): not running
res_pgsql_start_0 (node=www-node3, call=13, rc=5,
status=complete): not installed
res_apache_start_0 (node=sql-node2, call=18, rc=5,
status=complete): not installed
res_pgsql_start_0 (node=sql-node2, call=12, rc=5,
status=complete): not installed
res_apache_start_0 (node=sql-node3, call=12, rc=5,
status=complete): not installed
res_pgsql_start_0 (node=sql-node3, call=10, rc=5,
status=complete): not installed
res_apache_start_0 (node=kvm-node1, call=12, rc=5,
status=complete): not installed
res_pgsql_start_0 (node=kvm-node1, call=20, rc=5,
status=complete): not installede=openais \
expected-quorum-votes=7 \
stonith-enabled=false


I set the infinity for pgsql on all 3 sql nodes, but not! on the
www nodes. Why tries Pacemaker to start the Postgres SQL Server on
the www Node? In example?

Thank for your Help

greetings

Hauke

___
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
mailto:Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started:
http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org



___
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org

Hello Alexandre,

Why can't i set the infinity for the SQL servernodes to start the SQL 
Daemon only on the sql-nodes? I thought that has to be all?


Greetings

Hauke

Re: [Pacemaker] Daemon Start attempt on wrong Server

2014-11-11 Thread Andrei Borzenkov
В Tue, 11 Nov 2014 16:19:56 +0100
Hauke Homburg hhomb...@w3-creative.de пишет:

 Am 11.11.2014 13:34, schrieb Alexandre:
 
  You should use an opt out cluster. Set the cluster option  
  symmetrical=false. This will tell corosync not to place a resource 
  anywhere on the cluster, unless a location rule explicitly tell the 
  cluster where it should run.
 
  Corosync will still monitor sql resources on www hosts and return rc 5 
  but this is expected and works.
 
  Le 11 nov. 2014 13:22, Hauke Homburg hhomb...@w3-creative.de 
  mailto:hhomb...@w3-creative.de a écrit :
 
  Hello,
 
  I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3
  Nodes for Postgres.
 
  My Cluster Config is
 
  node kvm-node1
  node sql-node1
  node sql-node2
  node sql-node3
  node www-node1
  node www-node2
  node www-node3
  primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
  params ip=10.0.6.41 cidr_netmask=255.255.255.0 \
  op monitor interval=10s timeout=20s
  primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
  params ip=10.0.6.31 cidr_netmask=255.255.255.0 \
  op monitor interval=10s timeout=20s
  primitive pri_www_ip ocf:heartbeat:IPaddr2 \
  params ip=10.0.6.21 cidr_netmask=255.255.255.0 \
  op monitor interval=10s timeout=20s
  primitive res_apache ocf:heartbeat:apache \
  params configfile=/etc/apache2/apache2.conf \
  op start interval=0 timeout=40 \
  op stop interval=0 timeout=60 \
  op monitor interval=60 timeout=120 start-delay=0 \
  meta target-role=Started
  primitive res_pgsql ocf:heartbeat:pgsql \
  params pgctl=/usr/lib/postgresql/9.1/bin/pg_ctl
  psql=/usr/bin/psql start_opt=
  pgdata=/var/lib/postgresql/9.1/main
  config=/etc/postgresql/9.1/main/postgresql.conf pgdba=postgres \
  op start interval=0 timeout=120s \
  op stop interval=0 timeout=120s \
  op monitor interval=30s timeout=30s depth=0
  location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
  location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
  location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
  location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
  location loc_sql_srv_node1 res_pgsql inf: sql-node1
  location loc_sql_srv_node2 res_pgsql inf: sql-node2
  location loc_sql_srv_node3 res_pgsql inf: sql-node3
  location loc_www_ip_node1 pri_www_ip inf: www-node1
  location loc_www_ip_node2 pri_www_ip inf: www-node2
  location loc_www_ip_node3 pri_www_ip inf: www-node3
  location loc_www_srv_node1 res_apache inf: www-node1
  location loc_www_srv_node2 res_apache inf: www-node2
  location loc_www_srv_node3 res_apache inf: www-node3
  property $id=cib-bootstrap-options \
  dc-version=1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff \
  cluster-infrastructurFailed actions:
 
  Why do i see in crm_mon the following output?
 
  res_pgsql_start_0 (node=www-node1, call=16, rc=5,
  status=complete): not installed
  res_pgsql_start_0 (node=www-node2, call=13, rc=5,
  status=complete): not installed
  pri_www_ip_monitor_1 (node=www-node3, call=22, rc=7,
  status=complete): not running
  res_pgsql_start_0 (node=www-node3, call=13, rc=5,
  status=complete): not installed
  res_apache_start_0 (node=sql-node2, call=18, rc=5,
  status=complete): not installed
  res_pgsql_start_0 (node=sql-node2, call=12, rc=5,
  status=complete): not installed
  res_apache_start_0 (node=sql-node3, call=12, rc=5,
  status=complete): not installed
  res_pgsql_start_0 (node=sql-node3, call=10, rc=5,
  status=complete): not installed
  res_apache_start_0 (node=kvm-node1, call=12, rc=5,
  status=complete): not installed
  res_pgsql_start_0 (node=kvm-node1, call=20, rc=5,
  status=complete): not installede=openais \
  expected-quorum-votes=7 \
  stonith-enabled=false
 
 
  I set the infinity for pgsql on all 3 sql nodes, but not! on the
  www nodes. Why tries Pacemaker to start the Postgres SQL Server on
  the www Node? In example?
 
  Thank for your Help
 
  greetings
 
  Hauke
 
  ___
  Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
  mailto:Pacemaker@oss.clusterlabs.org
  http://oss.clusterlabs.org/mailman/listinfo/pacemaker
 
  Project Home: http://www.clusterlabs.org
  Getting started:
  http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
  Bugs: http://bugs.clusterlabs.org
 
 
 
  ___
  Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
  http://oss.clusterlabs.org/mailman/listinfo/pacemaker
 
  Project Home: http://www.clusterlabs.org
  Getting 

Re: [Pacemaker] Daemon Start attempt on wrong Server

2014-11-11 Thread Hauke Homburg

Am 11.11.2014 16:25, schrieb Andrei Borzenkov:

В Tue, 11 Nov 2014 16:19:56 +0100
Hauke Homburghhomb...@w3-creative.de  пишет:


Am 11.11.2014 13:34, schrieb Alexandre:

You should use an opt out cluster. Set the cluster option
symmetrical=false. This will tell corosync not to place a resource
anywhere on the cluster, unless a location rule explicitly tell the
cluster where it should run.

Corosync will still monitor sql resources on www hosts and return rc 5
but this is expected and works.

Le 11 nov. 2014 13:22, Hauke Homburghhomb...@w3-creative.de
mailto:hhomb...@w3-creative.de  a écrit :

 Hello,

 I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3
 Nodes for Postgres.

 My Cluster Config is

 node kvm-node1
 node sql-node1
 node sql-node2
 node sql-node3
 node www-node1
 node www-node2
 node www-node3
 primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.41 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.31 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive pri_www_ip ocf:heartbeat:IPaddr2 \
 params ip=10.0.6.21 cidr_netmask=255.255.255.0 \
 op monitor interval=10s timeout=20s
 primitive res_apache ocf:heartbeat:apache \
 params configfile=/etc/apache2/apache2.conf \
 op start interval=0 timeout=40 \
 op stop interval=0 timeout=60 \
 op monitor interval=60 timeout=120 start-delay=0 \
 meta target-role=Started
 primitive res_pgsql ocf:heartbeat:pgsql \
 params pgctl=/usr/lib/postgresql/9.1/bin/pg_ctl
 psql=/usr/bin/psql start_opt=
 pgdata=/var/lib/postgresql/9.1/main
 config=/etc/postgresql/9.1/main/postgresql.conf pgdba=postgres \
 op start interval=0 timeout=120s \
 op stop interval=0 timeout=120s \
 op monitor interval=30s timeout=30s depth=0
 location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
 location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
 location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
 location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
 location loc_sql_srv_node1 res_pgsql inf: sql-node1
 location loc_sql_srv_node2 res_pgsql inf: sql-node2
 location loc_sql_srv_node3 res_pgsql inf: sql-node3
 location loc_www_ip_node1 pri_www_ip inf: www-node1
 location loc_www_ip_node2 pri_www_ip inf: www-node2
 location loc_www_ip_node3 pri_www_ip inf: www-node3
 location loc_www_srv_node1 res_apache inf: www-node1
 location loc_www_srv_node2 res_apache inf: www-node2
 location loc_www_srv_node3 res_apache inf: www-node3
 property $id=cib-bootstrap-options \
 dc-version=1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff \
 cluster-infrastructurFailed actions:

 Why do i see in crm_mon the following output?

 res_pgsql_start_0 (node=www-node1, call=16, rc=5,
 status=complete): not installed
 res_pgsql_start_0 (node=www-node2, call=13, rc=5,
 status=complete): not installed
 pri_www_ip_monitor_1 (node=www-node3, call=22, rc=7,
 status=complete): not running
 res_pgsql_start_0 (node=www-node3, call=13, rc=5,
 status=complete): not installed
 res_apache_start_0 (node=sql-node2, call=18, rc=5,
 status=complete): not installed
 res_pgsql_start_0 (node=sql-node2, call=12, rc=5,
 status=complete): not installed
 res_apache_start_0 (node=sql-node3, call=12, rc=5,
 status=complete): not installed
 res_pgsql_start_0 (node=sql-node3, call=10, rc=5,
 status=complete): not installed
 res_apache_start_0 (node=kvm-node1, call=12, rc=5,
 status=complete): not installed
 res_pgsql_start_0 (node=kvm-node1, call=20, rc=5,
 status=complete): not installede=openais \
 expected-quorum-votes=7 \
 stonith-enabled=false


 I set the infinity for pgsql on all 3 sql nodes, but not! on the
 www nodes. Why tries Pacemaker to start the Postgres SQL Server on
 the www Node? In example?

 Thank for your Help

 greetings

 Hauke

 ___
 Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
 mailto:Pacemaker@oss.clusterlabs.org
 http://oss.clusterlabs.org/mailman/listinfo/pacemaker

 Project Home: http://www.clusterlabs.org
 Getting started:
 http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
 Bugs: http://bugs.clusterlabs.org



___
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: