[ClusterLabs] Interacting with Pacemaker from my code

2019-07-15 Thread Nishant Nakate
Hi All, I am new to this community and HA tools. Need some guidance on my current handling pacemaker. For one of my projects, I am using pacekmaker for high availability. Following the instructions provided in setup document, I am able to create a new cluster with three nodes. Tested the

Re: [ClusterLabs] pacemaker geo redundancy - 2 nodes

2019-07-15 Thread Ken Gaillot
On Mon, 2019-07-15 at 12:10 +0530, Rohit Saini wrote: > Hi All, > > I know pacemaker booth is being used for geographical redundancy. > Currently I am using pacemaker/corosync for my local two-node > redundancy. > As I understand, booth needs atleast 3 nodes to work correctly to do > the

Re: [ClusterLabs] Add Resource Environment Variables

2019-07-15 Thread Tiemen Ruiten
The pgsql resource agent uses /bin/sh. I think it doesn't work because on RH/CentOS, /bin/sh is linked to bash, whereas on Ubuntu it's linked to dash, which doesn't source .bash_profile (which in turn sources .pgsql_profile on my system). You could try putting it in .profile? I don't currently

Re: [ClusterLabs] Add Resource Environment Variables

2019-07-15 Thread Tiemen Ruiten
You could just export the variables in .pgsql_profile in the home directory of the user running PostgreSQL (usually /var/lib/pgsql). This is what I have in there for oracle_fdw: export PATH=$PATH:/usr/pgsql-11/bin > ORACLE_HOME=/usr/lib/oracle/12.1/client64 > export

[ClusterLabs] Add Resource Environment Variables

2019-07-15 Thread Patrick
​Hi, I successfully set up a pacemaker cluster serving PostgreSQL. I now have to pass some Oracle specific environment variables (i.e. ORACLE_HOME, TNS_ADMIN) to the PostgreSQL resource. I tried this by editing the resource ocf script "/usr/lib/ocf/resource.d/heartbeat/pgsql" without success.

Re: [ClusterLabs] Adding HAProxy as a Resource

2019-07-15 Thread Tomas Jelinek
Hi, Do you have a systemd unit file for haproxy installed? Does 'crm_resource --list-standards' print 'systemd'? Does 'crm_resource --list-agents systemd' print 'haproxy'? Note that when you use full agent name (that is including : ) it is case sensitive in pcs. Regards, Tomas Dne 11. 07.

Re: [ClusterLabs] [EXTERNAL] What's the best practice to scale-out/increase the cluster size?

2019-07-15 Thread Tomas Jelinek
Dne 11. 07. 19 v 16:01 Michael Powell napsal(a): Thanks again for the feedback. As a novice to Pacemaker, I am learning a great deal and have a great deal more to learn. I'm afraid I was not precise in my choice of the term "stand-alone". As you point out, our situation is really case b)

Re: [ClusterLabs] "node is unclean" leads to gratuitous reboot

2019-07-15 Thread Tomas Jelinek
Dne 09. 07. 19 v 14:54 Michael Powell napsal(a): ... Here’s the configuration, from the first node – [root@mgraid-16201289RN00023-0 bin]# pcs config Cluster Name: Corosync Nodes: mgraid-16201289RN00023-0 mgraid-16201289RN00023-1 Pacemaker Nodes: mgraid-16201289RN00023-0