Re: [Pacemaker] Problems settings up MySQL failover

2010-02-19 Thread Angie T. Muhammad
On Fri, Feb 19, 2010 at 7:19 PM, Lior Marantenboim wrote: > Hello everyone > > I've having trouble trying to set up a simple MySQL failover (make > Pacemaker start it on one node, and if it shuts down, start it on the > other). CRM shows as if MySQL is not running but it actually is, and since > i

Re: [Pacemaker] Frustrating fun with Pacemaker / CentOS / Apache

2010-02-19 Thread Paul Graydon
On 2/19/2010 12:01 AM, Tom Weber wrote: I've looked into this with fresh eyes this morning and managed to track down the problem to this addition to the related to meta target-role="Started" Not sure quite where I picked that up from, presumably one of the configurations I used as a template? W

Re: [Pacemaker] Problems settings up MySQL failover

2010-02-19 Thread Lior Marantenboim
I actually tried doing that, but I don't seem to have lsb installed (it says that I don't have the script installed), even though a "crm ra list lsb" shows that I supposedly do: hpblade02:~# crm ra list lsb acpid atdbootlogd bootmisc.shcheckfs.sh

Re: [Pacemaker] Problems settings up MySQL failover

2010-02-19 Thread Javier Charne
Lior Marantenboim escribió: Hello everyone I've having trouble trying to set up a simple MySQL failover (make Pacemaker start it on one node, and if it shuts down, start it on the other). CRM shows as if MySQL is not running but it actually is, and since it doesn't see it that way, it tries t

[Pacemaker] Problems settings up MySQL failover

2010-02-19 Thread Lior Marantenboim
Hello everyone I've having trouble trying to set up a simple MySQL failover (make Pacemaker start it on one node, and if it shuts down, start it on the other). CRM shows as if MySQL is not running but it actually is, and since it doesn't see it that way, it tries to start it on the other node as w

Re: [Pacemaker] cli configuration and resource sets

2010-02-19 Thread Cristian Mammoli - Apra Sistemi
Andrew Beekhof wrote: On Fri, Feb 19, 2010 at 1:06 PM, Cristian Mammoli - Apra Sistemi wrote: Dejan Muhamedagic wrote: Sorry, didn't read careful enough, was distracted by the actions in the description. Yes, you need both the order and the collocation. Basically what I want to achieve is th

Re: [Pacemaker] cli configuration and resource sets

2010-02-19 Thread Andrew Beekhof
On Fri, Feb 19, 2010 at 1:06 PM, Cristian Mammoli - Apra Sistemi wrote: > Dejan Muhamedagic wrote: > >> Sorry, didn't read careful enough, was distracted by the actions >> in the description. Yes, you need both the order and the >> collocation. > >>> Basically what I want to achieve is the same be

Re: [Pacemaker] postgresql monitoring- "incomplete startup packet"- getting filled in log

2010-02-19 Thread Joe Healy
Hopefully not going too far of topic, the code (in perl) that is doing this is: # Check whether a postmaster server is running at the specified port. # Arguments: sub cluster_port_running { die "port_running: invalid port $_[2]" if $_[2] !~ /\d+/; my $socketdir = get_cluster_socketdir $

Re: [Pacemaker] cli configuration and resource sets

2010-02-19 Thread Dejan Muhamedagic
Hi, On Fri, Feb 19, 2010 at 01:06:38PM +0100, Cristian Mammoli - Apra Sistemi wrote: > Dejan Muhamedagic wrote: > > >Sorry, didn't read careful enough, was distracted by the actions > >in the description. Yes, you need both the order and the > >collocation. > > >>Basically what I want to achieve

Re: [Pacemaker] cli configuration and resource sets

2010-02-19 Thread Cristian Mammoli - Apra Sistemi
Dejan Muhamedagic wrote: Sorry, didn't read careful enough, was distracted by the actions in the description. Yes, you need both the order and the collocation. Basically what I want to achieve is the same behaviour of an unordered group of heartbeat 2.1.4. Why don't you keep the unordered g

Re: [Pacemaker] postgresql monitoring- "incomplete startup packet"- getting filled in log

2010-02-19 Thread Andrew Beekhof
On Fri, Feb 19, 2010 at 9:22 AM, Jayakrishnan wrote: > But the issues is that my postgresql log file is getting filled > with > > 2010-02-19 13:19:30 IST LOG:  incomplete startup packet > 2010-02-19 13:19:45 IST LOG:  incomplete startup packet > 2010-02-19 13:20:00 IST LOG:  incomplete startup pac

Re: [Pacemaker] Frustrating fun with Pacemaker / CentOS / Apache

2010-02-19 Thread Tom Weber
Am Donnerstag, den 18.02.2010, 15:25 -0700 schrieb Tim Serong: > On 2/19/2010 at 08:40 AM, Paul Graydon wrote: > > >> I started looking into this today to find out whether it was > > >> possible to use another URL for testing. According to the heartbeat > > >> script you can specify the parame

Re: [Pacemaker] on fail standby with migration-threshold

2010-02-19 Thread rvm
Hello, > Oups sorry... In fact, I want : > * After two failures on a resource, move the resource away and _never_ > go back even if the new node fails. => ok with > migration-threshold="2" > * if my node crash, move my resource and set infinite score on this > fail node to never return on this

[Pacemaker] postgresql monitoring- "incomplete startup packet"- getting filled in log

2010-02-19 Thread Jayakrishnan
Sir, I am using heartbeat-pacemaker for my two node postgresql cluster with slony database replication. I am using the init script for the postgresql coz my ocf script is not working. Somehow I manage with my init script. My packages are: heartbeat2.99.2+sles11r9-5ubu